I couldn’t see this listed anywhere else, I think I have spotted a bug with the date stored in the database in the
AccountTransactionValues table when working with PreOrder tickets. It seems that the transaction DateTime is set to the time of creating the preorder ticket, rather than when the ticket is finally converted to a regular ticket, settled and closed.
To recreate this issue…
- Create two ticket types:
- Reservations (Preorder ticket)
- Create a reservation ticket and add some items to it
- Wait a day or so (open and closed work periods in-between)
- Open the reservation ticket and use an Automation Command to fire a “Change Ticket Properties” action to convert the ticket from a reservation in to a sales ticket:
- Ticket Type Name: Sales Ticket
- Is Pre Order: False
- Change Ticket Date: True
- Close and re-open this ticket (which is now a sales ticket)
- Settle the sales ticket using cash (or any other payment)
For all the items list with a check-mark the date is correctly updated to reflect the date on which the pre-order ticket was converted in to the Sales Ticket and settled. The item with the red cross shows that the database entry for that table and field for some reason inherits the original date of the pre-order ticket, and not the DateTime for when the ticket was converted and the transaction was really made.
The problem with this is (at least) two fold…
- In reports to list transactions for “today” (the day on which the ticket was converted), the payment for the ticket will not be listed.
- In the accounts screens the payment will be listed as having occurred in the past (the date the reservation was made) and not on the actual date the payment was made.
Have I done something wrong in my set-up? I can’t believe I’m the first person to experience this?