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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP apply transactions

(0) ShareShare
ReportReport
Posted on by 14

Is anyone aware of an automated solution to apply POSTED AP transactions?  I am aware that Precipio has a solution but base on my understanding it only applies to unposted transactions.

*This post is locked for comments

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

    So, are you saying you have a number of unapplied vendor payments and want to get these applied to invoices in mass? Or can you clarify exactly what you mean?

  • DynamikGP Profile Picture
    14 on at

    We have unapplied credit memos that we want to apply to invoices in mass.  Both the credit memo and the invoice are posted.  A brief background on the process we are implementing.  We will be extracting the open AP transactions on a monthly basis and uploading to another application that matches (applies) the documents based on a series of rules.  That application then generates a file that contains which documents have been matched together.  The goal is to use this matched data to automatically update GP.  I haven't been able to find any existing solutions for applying posted transactions .  I am aware that Steven Endow has a solution but I reached out to him and he confirmed this only works for unposted transactions.  I have since analyzed the SQL execution plan for the AP apply process and think I have an understanding of the database impact.  I am going to attempt to build a stored procedure that mimics the internal process.  I would appreciate any recommendations or insights.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans