Payables Invoices and Current Document Amount

(0) Share

Report

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

I have the same question (0)

All responses (4)

Answers (2)

Hossam Fathy 2,611 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mohammed Noureldine on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Mohammed Noureldine on at

Like (0)

Report

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!

Was this reply helpful? Yes No