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'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
Afshin,
Where do I get it ?
Thx in advance.
Thanks for the email you sent me. As stated there is an Import Utility you can try.
Afshin
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.
Have you finished this app ? I am looking into developing similar utility.
Thanks,
Reddy
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.
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
Thanks Dustin, appreciate the confirmation
Its that straight forward. We've created something similar for a liquor store customer.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,912 Super User 2024 Season 2
Martin Dráb 229,355 Most Valuable Professional
nmaenpaa 101,156