Open Forum

Expand all | Collapse all

Report for Lost vendor discounts

  • 1.  Report for Lost vendor discounts

    Posted Jul 02, 2019 11:41 AM
    Is there a smart list out there that will give me discounts lost on vendor invoices?  I have Smart List Builder but don't know how to use it yet.  Also, what is the best report/smartlist to use to get # of invoices processed in a month?


    Heidi Love
    Industrial Metal Supply Co
    Sun Valley CA

  • 2.  RE: Report for Lost vendor discounts

    Posted Jul 09, 2019 09:09 AM
    Hi @Heidi Love
    If this is something you really need to track, you should look into turning on the Track Discounts Available option in the Payables Setup window.

    When invoices are entered with payment terms, it will track the discount available in a separate account.  You'll need to remember that when reconciling AP to GL because you'll need to look at both the AP and discount available accts to tie to the aging report.

    Also make sure to populate the Terms Discount Available and Terms Discount Taken accounts at the vendor or posting account setup levels.

    Beyond that, creating a SmartList to pull this would be tricky because you'd need to do it based on the distributions to figure out if a discount was taken and then reverse engineer into discounts not taken.


    Windi Epperson
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    norman OK
    405-946-1774 ext. 102


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