Customer prepayment information on Sales Invoice

D365FO 10.0.44 added the support for the Customer prepayment invoice in Accounts receivable. It is maintained in a dedicated form and printed as ER report.

Docentric supports printing this report by providing a new SSRS report, accessible through an additional menu item on the same dedicated Customer prepayment invoice form. You can find the setup and implementation details here: Use D365FO Customer Prepayment Invoice with Docentric

There is another change worth knowing about. Microsoft also extended the standard Sales Invoice report with customer prepayment information.

The standard Sales Invoice report now contains a dedicated Prepayment invoice details section, implemented as a separate subreport. It shows information such as the prepayment invoice number, date, sales category, currency, prepayment amount, and status.

The standard Sales Invoice report data source provides the data for this section.

Customer prepayments also affect the amounts shown on the final invoice. The invoice still represents the full invoiced amount, while the open amount reflects the prepayment that has already been applied.

What does this mean for your Docentric Sales invoice template?

The existing Sales Invoice DSP automatically includes the RDP table data exposed by the standard SSRS report. As a result, you can already find the Microsoft prepayment data under the CustPrepaymentInvoiceTmp record.

Note: The current Docentric SalesInvoice.Report replica template (v3.5.1.6) does not contain the corresponding Prepayment invoice details layout section and field bindings.

Need the prepayment details now? You can modify the template layout and use this data in your custom Docentric template.

Planned changes to the Sales invoice replica (v3.6.0)

WIth Docentric v3.6.0 we will deliver the updated Sales Invoice replica to align it with the standard Microsoft report.

Replica data source: the prepayment data will be processed by DocSalesInvoiceReportDSP and renamed into SalesInvoicePrepaymentDetails.

Replica template: will be updated with the Prepayment invoice details section and the corresponding field bindings.

These changes will be included in Docentric AX 3.6.0.