125
I have an external system where I close the PO through the registration of invoices. I'm using Dynamics to manage the purchase orders but I dont have the account payable module configured to close the po thgough invoices.
I'm loking for an internal mechanism is GP to close po from a csv file from the external system. Is there a Stored Procedure that can be used for this? I need a seemless solution that does not require end user interaction.
*This post is locked for comments
Waldemar,
I don't want to speak for Mariano, but I am pretty sure he is saying that you need to be in GP to complete the purchase order transaction. I agree. I don't think you want to try to "mess" with the GP business logic by hitting the stored procedures on the back end. Can I ask why you are using the purchasing module in GP but not the payables module?
Ron
Mariano:
Thanks for your reply. I was trying to find a solution in the backend side of the fence..something like stored procedures or something that could do the trick in the database. The user does not was not get involved in the process or do anything at all in GP. They just want to import the transactions from a text file and automatically close all the open purchase orders in GP. Is there anything in the Database that could be used for this?
Mr. Pabon,
To close a PO in GP you will have to create a receipt transaction then match with an invoice or you will have to create a Receipt with Invoice. From your description, it sounds like you will want to do the latter -- receipt with Invoice. Depending on a number of factors including transaction volume, you will want to check into Integration Manager or eConnect.
You cannot forgo the process of posting in GP. That's something your users will still have to do once you close out the POs with an invoice.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (