Settled vendor invoices

(0) Share

Report

Posted on by Community Member

I am looking for a way to see all vendor invoices who have been settled (partially or completely) in a journal of payment. Is there a table or anything else that contains these invoices?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

You can try usinig the vendor transactions report in AP under Transactions-vendor-vendor transactions.

If you filter only on closed transactions and include the settlement details you should get the information you are looking for.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

You mean you want to see only the invoices that were settled using a specific payment journal?

Was this reply helpful? Yes No
Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report

Clicking the Closed transaction editing button from the Vendor record show only transactions that have been settled at least partially.

You asked about a table, so if you're interested in the underlying data, you can identify VendTrans records that have been partially settled in a few ways.

If on the VendTrans records, the Closed date is non-null (not 1900/01/01), AmountCur equals SettleAmountCur, or AmountMST equals SettleAmountMST, then the transaction is fully settled. If the LastSettleDate is non-null (not 1900/01/01), or the SettleAmountCur or SettleAmountMST is not 0, then it is partially settled.

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Useful information.

Was this reply helpful? Yes No