How to get the payment journal voucher against the Invoices selected to settle using X++

(0) Share

Report

Posted on by MSandy

Hello,

Hope you are doing great!

Could you please help me with providing the table relations or code snippet where I can find the Payment journal voucher against the marked invoice to settle?

In my case I have invoice ID, DocumentDate and InvoiceAmount and I want to know the payment journal voucher against this invoice.

The relation VendinvoiceJour.LedgerVoucher==VendTrans.lastSettledVoucher not providing the proper payment journal voucher. And it would be empty if the Payment journal is not posted.

Any suggestions would be very helpful. Thanks in advance!

Sandeep.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Alireza Eshaghzadeh Super User 2025 Season 2 on at

Like (0)

Report

RE: How to get the payment journal voucher against the Invoices selected to settle using X++

Hi MSandy,

If you mean marked transaction on payment journal, you can use "SpecTrans" table.

You can also use standard entities for payment journal line settled invoice.

Was this reply helpful? Yes No