Open Forum

Expand all | Collapse all

Sales Discount Rounding

  • 1.  Sales Discount Rounding

    Posted Jan 04, 2020 12:22 PM
    Hi All

    We're just setting up our pricing in BC130 and would like to use Item Special Discounts; however, we have customers who will order the same item on multiple lines (as they want different delivery dates or references for each line and others who will put whole qty on one line

    Here's a example:

    Item:                     Widget1

    List Price:            13.95

    Disc of 5%:          13.2525


    In Dynamics, if I order 10 lines of Qty 1, I get a price of 10 x 13.25 = $132.50

    If I order a single line of Qty 10, I get a price of $132.52

    I looked at all the rounding stuff I found, but can't see a way to say calculated discounted price and then multiple by Qty

    Anyone know if this is piossivble?



    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Sales Discount Rounding

    Posted Jan 06, 2020 09:07 AM
    Hi Mark,

    That would be an enhancement.  NAV calculates Line Discounts for the specific line, but there isn't a way in the product to search all the lines.  It shouldn't be a hard enhancement, but it's not something that you can accomplish thru the base product.

    Munir Latif
    Independent Consultant/Developer
    Homer Glen, IL

    Academy - Online Interactive Learning from Experts

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