web
You’re offline. This is a read only version of the page.
close
  • Rounding error in Reserved Quantity on sales line

    Reserved quantity in sales order line incorrect by using different sales unit


    If an item is recorded in a different sales unit in a sales order and an automatic reservation is triggered, the value in the "Reserved Quantity" field will be calculated incorrectly - rounding differences obviously occur here.

    b. This error occurs when the total quantity is reserved against several different item lots.

     

    Reserved quantity in sales line incorrect with different sales unit:

    Create an item with base UoM = pcs and alternate UoM = box. 1 box = 15 pcs.

    Post three item journal lines for 38 pcs, 20 pcs, 2 pcs.

    Create a sales order for 4 boxes.

    Reserve

    ERROR: Reserved Quantity = 3.99999

    The current calculation is as follows:

     

    38 pcs/15 = 2.53333 boxes (rounded to 5 digits)

     

    20 pcs/15 = 1.33333 boxes

     

    2 pcs/15 = 0.13333 boxes

     

    That makes 60 pcs and 2.53333 + 1.33333 + 0.13333 = 3.99999 boxes.