Average Payment Days All Customers

(2) Share

Report

Posted on by DynamixAU

Hi All,

Just wondering if anyone knows of a way to export all customers along with average payment days? I can see it in the fast tab in the customer statistics section but require this to be exported for all customers periodically.

Cheers,

Ash

Categories:

Dynamics 365 Finance

All responses (2)

Answers (1)

DynamixAU 16 on at

Like (0)

Report

Average Payment Days All Customers

Thanks Andre, I suspected as much.
Verified answer

André Arnaud de Cal... 292,575 Super User 2025 Season 1 on at

Like (1)

Report

Average Payment Days All Customers

Hi Ash,

The average payment days is not directly stored in a table, but is calculated by the application. You can export invoice and payment details (customer transactions) and perform a calculation yourself for reporting.

You can also create or extend a data entity with help of development. Using X++ logic, the field can be calculated during export. Note that this will most likely cause a row by row calculation which affects the performance of an export job.