web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manual Payments Lockbo...
Microsoft Dynamics GP (Archived)

Manual Payments Lockbox type process for AP

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans