Hello,

Unfortunately, my results are not consistent & repeatable. The part # that resulted in the error in the initial test had a high quantity on hand (1183) and when I did the transactions with another part with only 29 on hand, the results did not repeat and everything worked as expected.

Then I restored the data to the original starting point & there was a different incorrect result for both part numbers. If 2 ft. was invoiced 2 times for each part, the "units sold to date" increased by 1.32 for each part number and if sold as 4' per part 1 time each, "units sold to date" increased by 1.33. However, the "quantity on hand" dropped by 1.00 by one method & by 0.00 by the other method instead of 1.33 each time. DIC in IC showed no errors but DIC in OE produced the following identical errors for the 2 part numbers used in OE for the tests.

Orders/Invoice headers ... Checked OK
Item UK51P ShipNotCosted at loc 1 is -1.65 calc 0.00
Item UK51S ShipNotCosted at loc 1 is -1.65 calc 0.00

The rebuild function in OE DIC did change the "quantity on hand" down by 1.65 on each part # in IC to match the increase in "units sold to date".

This is not causing any problems and it appears that OE DIC rebuild will fix any errors. This was only a test on the procedure and everything on our live data is working perfectly (but without fractional quantities).

Thanks for your help. I would like to use this feature in the future.

Rick