Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Inserting an online order as a closed transaction

Posted on by 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inserting an online order as a closed transaction

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans