AX / D365FO – Data Entity to extract Invoices and related Payment vouchers

If you need to extract invoices and related payment voucher numbers you can use 2 Data entities :

• “Customer payment journal line”
• or alternatively use “Customer payment journal line settled invoice”

Access Data management > Export

“Customer payment journal line” Data Entity

Select “Customer payment journal line”

Click “Export now”

When completed click on “Download file”

In the resulted excel file you will see 2 columns :

• Marked invoice (Invoice number)
• Voucher (Payment Voucher number)

“Customer payment journal line settled invoice” Data Entity

Alternatively you can use “Customer payment journal line settled invoice” which has Invoice number and Journal Baych number