QNTOW / QTYINV & U (units) in Data Dictionary
Decimals for Quantity on Work Order (QNTOW) = 5, QTYINV also = 5, so ledgers are OK, however when looking at the F0911 AU Ledger, the Units field has only 2 decimals DD "U" = 2 so we get rounding impact
Example is issue of 0.00600 NT (net tons) @ $4500.00, In F0911, Units appear as .01 and therefore the calculated amount with item cost of 4500.00 which should be $27.00 (.006x4500), shows in F0911 as $45.00 (.01 x 4500)
How can this be corrected. Change the DD for Units to 5 decimals? Sine financials already posted and differences adjusted as variances. Will changing the decimals to 5 on U only apply to future transactions or do something to prior.