Appreciate help on Reservation module / Reservation Ticket. If the reservation ticket is settled on a different Workperiod, the settled amount is not reflected in the workperiod. Please help on this matter.
for eg. Reservation was made on 8/9/2024 for 10/9/2024 and total amount was 2000.00. A deposit of 500.00 was made on the same day. This 500 reflects in the work period report of 8/9/2024
on 10/9/2024 this reservation ticket was reopened as the party is on this date. Once the party is over balance 1500 was paid (on 10/9/2024 work period). This 1500 is settled as Cash
However on the workperiod report of 10/9/2024 the amount (1500) is not showing
This is causing confusion in the cash settlement for 10/09/2024.
You will need to run an SQL report to get the correct numbers for payments that involve pre-order payments.
Use this for Cash:
Individual Cash payments {REPORT SQL DETAILS:SELECT Amount, Date, Name FROM dbo.Payments WHERE Name = 'Cash' AND Date > '{Start}' AND Date < '{End}':F.Amount}
Total Cash Payments: {REPORT SQL DETAILS:SELECT Amount, Date, Name FROM dbo.Payments WHERE Name = 'Cash' AND Date > '{Start}' AND Date < '{End}':F.Amount.sum}
Credit Cards
Individual Payments: {REPORT SQL DETAILS:SELECT Amount, Date, Name FROM dbo.Payments WHERE Name = 'Credit Card' AND Date > '{Start}' AND Date < '{End}':F.Amount}
Total Payments {REPORT SQL DETAILS:SELECT Amount, Date, Name FROM dbo.Payments WHERE Name = 'Credit Card' AND Date > '{Start}' AND Date < '{End}':F.Amount.sum}
If you have any other payment types just replace Cash/Credit in the quoted part behind the WHERE = .
If you want other fields in the report, let us know.
Thank you for the Help. This can create report as mentioned. However i wonder why this payment received in a work period does not show in that work period. We rely on the Work Period report which gives a summary of all the transactions during that work period. Amount shouwn in the report and actual varies do to this.
You can add the reports(s) to the workperiod reports. If you do not want to change the original workperiod report, you can clone the report, rename the report and add the sql reports where you would like.
The payment information is recorded in the database correctly. However when using the payment reports it reports out the payment information as ticket creation date/time. This will also appear in the accounts screen as well. The payment will show up in the workperiod the ticket was created. As far as I can tell, support is aware of the situation. It maybe a situation where if they fix the issue as best they can, there maybe a case where it breaks some systems because of certain customization. In that case, what is worse, a wrong report date or a broken system. This is simply by guess. This issue has been discussed before.
There is an action to update a tickets date and time. You can use that in a rule event of your choice / flow to change the ticket date and time to correspond with when it becomes a real ticket putting it in the correct work period.