Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jennifer Vanselow]

We have hundreds of invoices that are posted to the system with defined terms however, the Aging report is reporting them incorrectly.  This has resulted in late payments to vendors.  Has anyone else experienced this?

——————————
Jennifer Vanselow
Augeo Affinity Marketing
St. Paul MN
——————————

[Christopher Ho Yee]

Hi Jennifer,

Just for clarity, have you confirmed if the due dates themselves are incorrect or is the Aging report not aging them as desired?

——————————
Christopher Ho Yee
Altius Consulting
Richmond BC
——————————
——————————————-

[Jennifer Vanselow]

The terms (due dates) are set up correctly.  It is that the aging report is not calculating them correctly.

——————————
Jennifer Vanselow
Augeo Affinity Marketing
St. Paul MN
——————————
——————————————-

[Donald Jenkins]

Jennifer; if the ‘due date’ on the invoice is correct, then I would suspect you are using an ‘Aging Period Definition’ when you generate the report, and it is setup incorrectly.  Go to Accounts Payable –> Setup –> Aging Period Definitions, and look at the setup.  The setup in there determines the buckets, but there are a number of parameters on the report screen that could impact the output.

However the aging report would not prevent the invoices from being paid on-time.  The invoices selection criteria in the payment proposal process is determining that.  Are you sure that the user generating the payment proposal has the correct settings in those parameters?

——————————
Donald Jenkins
Avanade, Inc.
Maryville TN
——————————
——————————————-