AP tables data when a partial payment is made

(0) Share

Report

Posted on by Community Member

Hoping to communicate this correctly... I'd like to know how to recognize a partial payment in the AP tables? I looked for CRTRXAMT < DOCAMNT, and CRTRXAMT < PRCHAMT but could not find an instance. Is this the correct method? I do not have the luxury of asking an end-user, nor do I have access to the front-end (if either of these would help), so I'm rooting around in the tables. Is there a document that depicts the data flow as the transactions are processed through the front-end? That would be a godsend!

Thanks for any help.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: AP tables data when a partial payment is made

Thank you, Mick. Quick and helpful. So, I was on the right track. From here I have to find the remainder of the transaction. Is it pending? Is there a credit memo?
Verified answer

Mick Egan 3,561 on at

Like (0)

Report

RE: AP tables data when a partial payment is made

RJO,

You could filter this query to assist in looking at partial payments against Invoices.

SELECT VENDORID, DOCDATE, DOCNUMBR AS Invocie_Number, DOCAMNT AS Invoice_Amount, CURTRXAM AS Amount_Outstanding, (DOCAMNT - CURTRXAM) AS Amount_Invoiced FROM PM20000 WHERE DOCTYPE = 1

AND CURTRXAM <> 0 AND (DOCAMNT <> CURTRXAM)

Mick