Hi guys,
Help!
How can I show the column in the sales report in which the Serial Number of the last Official Receipt/Invoice number issued for the month being reported?
Here in the Philippines, transaction number and the official receipt or invoice number should also be shown in the sales report.
Any feedback is greatly appreciated.
Thank you.
*This post is locked for comments
I believe this is a government requirement to have their own series of transaction number per POS. RMS only has one series of transaction number for all POS installed. Gene, I suggest you contact one of your RMS partner in the Philippines. to do the customizations. I already gave you our contact number. Let us know if you want us to do it for you. Thanks.
Ok, I don't know where Heidi is going with the MAX thing at all. The serial number is recorded in a table called, oddly enough, 'Serial'. It can be joined to the transactionentry table via the transactionentryID to attach the serial number of the item sold to the item sale in the report this way.. Please explain.
As far as the Official Receipt Number thing, I still don't quite get that. An I to understand that is another number for the sale along with the invoice number? If so, where are you typing it in?
Hi Gene,
You would need to write a report that selected MAX(TransactionNumber) that was grouped by month and year.
If you're not sure, let me know and I can provide more information.
Hi Gerald,
My question is, does it need to create a custom table for the Official Receipt #s? if so, what other tables are inter-related to it. I haven't done any customization in the tables, just in the receipt template.
Any response is greatly appreciated.
Thank you.
Hi. Now I see where you are going with this.
Where is your official receipt number kept?
You have to do a join to that table and then add the column in the report qrp to expose it and/or add it to your report.
-Jerry
jerry@jrdata.us
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156