A short question:
I have an online e-commerce site integrating with RMS. I would like to insert orders closed online into the DB (and close the transaction) without having to go through the POS. (ctrl-shift-f10 - internet orders).
What would be the best way to do that? Just insert the relevant values into the transaction & transactionentry table, or use some sort of API?
Many thanks,
ephy250
*This post is locked for comments
you could just add the entries to [transaction], [transactionentry] tables. These fields affect sales reports, but not totals on X,Z,ZZ reports. Also just adding the entries to [transactionentry] does not update inventory quantites. If you need those updated then you would have to update the [item].quantity field for that item.
If you want the sales to reflect on X,Z,ZZ reports, then you have to manually update the totals in the [Batch] table.
There could be other tables needed to be updated if your integration or items or more complex.
You could also create a single macro button and then just press that button. This would have to be created on each register.
There really isn't a simple API or function call to accomplish this.
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,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156