Category: Payments

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

Posted on by Marco Saad

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 … Continue reading AX / D365FO – Data Entity to extract Invoices and related Payment vouchers →

AX – D365FO – X++ Code to Unsettle Payment and Invoice

Posted on by Marco Saad

This is small utility code if we need to unsettle payments and invoice Reference article : https://community.dynamics.com/ax/b/amirsaxspace/posts/x-code-to-unsettle-payment-and-invoice select firstonly * from findCustTrans where findCustTrans.Voucher == voucher; if (findCustTrans.RecId) { balanceAmount = findCustTrans.remainAmountCur(); if (balanceAmount == 0) { custTable = custTable::find(findCustTrans.AccountNum); select firstonly custSettlement where custSettlement.TransCompany == findCustTrans.dataAreaId && custSettlement.TransRecId == findCustTrans.RecId && custSettlement.AccountNum == findCustTrans.AccountNum; … Continue reading AX – D365FO – X++ Code to Unsettle Payment and Invoice →