D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AP Invoice Terms Calculating Incorrectly

  • 1.  AP Invoice Terms Calculating Incorrectly

    Posted 19 days ago
    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
    ------------------------------


  • 2.  RE: AP Invoice Terms Calculating Incorrectly

    TOP CONTRIBUTOR
    Posted 19 days ago
    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
    ------------------------------



  • 3.  RE: AP Invoice Terms Calculating Incorrectly

    Posted 19 days ago
    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
    ------------------------------



  • 4.  RE: AP Invoice Terms Calculating Incorrectly

    Posted 14 days ago
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role