web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Adding a Purchase Orde...
Microsoft Dynamics RMS (Archived)

Adding a Purchase Order via SQL

(0) ShareShare
ReportReport
Posted on by SpeedJet 110

I'd like to be able add Purchase Orders to RMS 1.3 via our own vb.NET application.

 

The purchase orders would be in a 'non-received' state (ie. not sent to the supplier yet)

 

Not that familiar with RMS database so just wanted to check first.

 

I would first create an entry in the [PurchaseOrder] table with details about the order. Then I would add each item in the order to the [PurchaseOrderEntry] table using the  [PurchaseOrder].[ID] for [PurchaseOrderEntry].[PurchaseOrderID] and obviously each items details ie. ItemID, ItemDescription

 

Is it that straightforward or am I missing something?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dustin Hanson Profile Picture
    Dustin Hanson 45 on at

    Its that straight forward. We've created something similar for a liquor store customer.

  • SpeedJet Profile Picture
    SpeedJet 110 on at

    Thanks Dustin, appreciate the confirmation

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at

    I'm trying to do this too, but from an ODBC connection. I am also creating the corresponding 'worksheets'. I don't see how/where the Worksheet Numbers and PO Numbers are to be set. Just using a MAX + 1 doesn't sem to work.  Any help would be appreciated.  

    My application is 'linking' two different Purchaing systems for companies that are merging.  

    Cheers.

    d

  • Community Member Profile Picture
    Community Member on at

    We have an import utility that can allow you to bring the PO into RMS. The import utility has ther features too.  Contact me for more info.

    Afshin Alikhani - Retail Realm Distribution

    afshin@rrdisti.com

    PLEASE NOTE IF YOU ARE AN END USER, WE ARE A DISTRIBUTOR AND SELL ONLY THROUGH YOUR CERTIFIED RMS RESELLER.

  • Reddy S Profile Picture
    Reddy S 40 on at

    Have you finished this app ? I am looking into developing similar utility.

    Thanks,

    Reddy

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at

    I have not. I'm still working on it. I'm waiting for my client to try the POs i created and pushed to their test instance.

  • Community Member Profile Picture
    Community Member on at

    Thanks for the email you sent me.  As stated there is an Import Utility you can try.

    Afshin

  • Reddy S Profile Picture
    Reddy S 40 on at

    Afshin,

    Where do I get it ?

    Thx in advance.

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at

    I'm not looking for an Import tool unless i can't get the direct insert to work. It would add a third system interchange to an already cumbersome process. Thanks.

    d

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans