D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Missed Cash Discount Reporting (D365)

  • 1.  Missed Cash Discount Reporting (D365)

    Posted Mar 28, 2019 06:40 PM
    Does anyone have any information on how to get a report on missed cash discounts by for all vendors by invoice out of D365? I would like to see all potential cash discounts compared to what was actually taken (by invoice and vendor). I have not found any report that that is able to report this, but I could be looking in the wrong place.

    Marie Walters
    GSP Marketing Technologies
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Missed Cash Discount Reporting (D365)

    Posted Apr 02, 2019 11:26 AM
    Hi Marie, we had the same requirement for reporting on missed cash discounts for Accounts Payable.  I'm not sure if any new reports might exist in D365, but we couldn't find anything already existing in our Dynamics AX 2012 R2 environment.  So we had an internal developer create a SQL report from the AP invoice table with calculated columns to quantify "potential discount" and "missed discount."  It has a row for every vendor invoice that our AP department posts for the fiscal period, so that if the total missed discount amount needs researching, they can quickly get to the detail of the invoices with large missed discounts.

    We came across couple of minor "gotchas" that we had with the report after we started using it.  The report logic also calculated a negative cash discount for credit memos.  I still need to talk to our developer on whether he can update the report to calculate a "potential discount" of zero for the vendor credit memos, but for the meantime they're easy to remove when prepping the report for publication.  The other problem is somewhat self-inflicted.  We have a couple of vendors that only allow cash discounts on certain invoices but not all.  We set those vendors up with terms to take the discount, but our AP department must review the invoices and manually remove the discount from the non-qualifying invoices.  For the sake of reporting simplicity, we set up a filter to exclude those vendors from the missed discount calculation because of the manual workarounds.

    Josiah Schlender
    Sr. Business Analyst
    Newberg OR

    Academy - Online Interactive Learning from Experts

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