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

I have the same question (0)

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

Was this reply helpful? Yes No
Reddy S 40 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

Afshin,

Where do I get it ?

Thx in advance.

Was this reply helpful? Yes No
Community Member 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
SpeedJet 110 on at

Like (0)

Report

Re: Adding a Purchase Order via SQL

Thanks Dustin, appreciate the confirmation

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No

Community site session details

Adding a Purchase Order via SQL

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Featured topics

Product updates

Community site session details

Adding a Purchase Order via SQL

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Featured topics

Product updates