News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get the payment...

Finance | Project Operations, Human Resources, ...

Suggested answer

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

(0) Share

Report

Report

Posted on by MSandy

215

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.

Categories:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Alireza Eshaghzadeh 10,829 Moderator 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 283,860 Test role Public

#2

Ludwig Reinhard Microsoft Employee

#3

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans