Is anyone aware of a way to automate the applying of invoices to a manual payment in ap? Something similar to the Lockbox process in AR. Preferably without having to use a 3rd party product.
*This post is locked for comments
Sorry, I was totally confused with the Cash Receipt which does allow for applies.
I was checking SmartConnect and it does expose the taPMManualCheck XML node. This would allow you to get the manual check through, however, there's no apply node. You would have to create this node and setup the procedure to insert the records in the PM_Payment_Apply_WORK table (PM10201) and the PM_Apply_To_WORK_OPEN (PM10200). To create additional eConnect nodes, you can follow the steps provided by Tim Wappat in his article Custom XML nodes with eConnect for Dynamics GP to call user stored procedures (timwappat.info/.../Piggyback-your-data-on-eConnect-for-Dynamics-GP). I am sorry, but I know of no other way at this point that does not involve some customization. I did not see any third party product out there where you could simply import a lockbox-like file for payables - my assumption at this point, since you mentioned lockbox is that you are providing some sort of file for the import.
How would you use Integration Manager to process and apply invoices to a manual payment? I do not even see that option in the destination mapping.
You can use Integration Manager or SmartConnect for this. So long you have a file with the payment number, amounts, invoice number and apply amount, you should be good to go.
#1
André Arnaud de Cal...
294,273
Super User 2025 Season 1
#2
Martin Dráb
233,019
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
