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

Notifications

Announcements

No record found.

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

I have the same question (0)
  • 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

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans