190
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.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
