More Documentation for Account Receipt & Statements

[emre]

Start from here.

http://sambapos.com/wiki/doku.php/creating_custom_reports_with_sql

Try this

 Select * from Tickets

Learn how SQL Where works to filter records.

SQL WHERE Clause

Select * from Tickets where IsClosed = 0 

Learn how to use field names instead of *

Select Id,TicketNumber from Tickets where IsClosed = 0 

Check how SQL Like keyword works to make partial searches.

SQL LIKE Operator

Check how SQL Join works to create reports from two tables.

SQL Joins

Check this topic for related discussions and samples.

Help with reservation/Preorder workflow

I have a system setup where people can pay money off an item and collect the item when paid in full. I followed the simple reservation example. I also created another ticket type for this. I thought I had this ready to go but noticed one problem today. The problem is if I reserve an item and the customer pays €20 off a €100 item everything works fine. If 3 days later they pay another €20 my work period report does not show it. It will show in the original work period. So my accounts are right bu…