Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Manual Payments Lockbox type process for AP

Posted on by Microsoft Employee

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. 

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Manual Payments Lockbox type process for AP

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Manual Payments Lockbox type process for AP

    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.

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Manual Payments Lockbox type process for AP

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans