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) / Payables Invoices and ...
Microsoft Dynamics GP (Archived)

Payables Invoices and Current Document Amount

(0) ShareShare
ReportReport
Posted on by Mohammed Noureldine

We use the GP web services to get the current amount for both Payables and Receivables invoices. For the receivables invoice, we could get the current document amount using a XML node/property in the document called: "CurrentDocumentAmount". However, for the payable invoices we couldn't find a similar property that we can use to retrieve the current document amount of the invoice.

Can anybody tell us how we can retrieve the current document amount value for the payables documents/invoices? Thanks for your help.

*This post is locked for comments

  • Verified answer
    Mohammed Noureldine Profile Picture
    Mohammed Noureldine on at
    Re: Payables Invoices and Current Document Amount

    Thanks Mohammed for your help. I could find the value I want in PM20000. The current remaining amount of the invoice exists in a column called: "CURTRXAM". In case there is no other way to have it through the web services, then I think I will go for your solution.

    Thanks!

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Payables Invoices and Current Document Amount

    Mohammad,

    Have you tried to retrieve such data directly from the database? Use PM10000 from WORK invoices and PM20000 for OPEN invoices.

  • Mohammed Noureldine Profile Picture
    Mohammed Noureldine on at
    Re: Payables Invoices and Current Document Amount

    Thanks for the reply but this is not what I actually want. I use the GP web services methods to retrieve the invoices data for integration purpose with other system (CRM). The main concern is that the current paid amount can be retrieved for receivables transactions through an XML node in the "ReceivableInvoice" XML response element called: "CurrentDocumentAmount:". For the payables invoices, there is no such property. My question is that do we have a similar property or even any other way to retrieve such value for the payable invoices.

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at
    Re: Payables Invoices and Current Document Amount

    You can go to GP > Tools > Utilities > Sales > Reconcile - Remove Sales Documents to move fully completed transactions to history.  Check the Option to Remove Completed Documents and select your transaction in the From and To fields or leave them blank to evaluate all transactions. 


    Backup your database before you start.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans