Microsoft Dynamics RMS (Archived)

Adding a Purchase Order via SQL

(0) Share

Report

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

All responses (9)

Answers (1)

Daniel Galvin 30 on at

Like (0)

Report

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 40 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

Afshin,

Where do I get it ?

Thx in advance.
Community Member Microsoft Employee on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 40 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

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

Thanks,

Reddy
Community Member Microsoft Employee on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 110 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

Thanks Dustin, appreciate the confirmation
Verified answer

Dustin Hanson 45 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

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