Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Adding a Purchase Order via SQL

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

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at
    Re: Adding a Purchase Order via SQL

    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

  • Reddy S Profile Picture
    Reddy S 40 on at
    Re: Adding a Purchase Order via SQL

    Afshin,

    Where do I get it ?

    Thx in advance.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Adding a Purchase Order via SQL

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

    Afshin

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at
    Re: Adding a Purchase Order via SQL

    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.

  • Reddy S Profile Picture
    Reddy S 40 on at
    Re: Adding a Purchase Order via SQL

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

    Thanks,

    Reddy

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Adding a Purchase Order via SQL

    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.

  • Daniel Galvin Profile Picture
    Daniel Galvin 30 on at
    Re: Adding a Purchase Order via SQL

    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

  • SpeedJet Profile Picture
    SpeedJet 110 on at
    Re: Adding a Purchase Order via SQL

    Thanks Dustin, appreciate the confirmation

  • Verified answer
    Dustin Hanson Profile Picture
    Dustin Hanson 45 on at
    Re: Adding a Purchase Order via SQL

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

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,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans