21

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.

Category: Inventory
STATUS DETAILS
New