Aarto
Reputable Poster
Hi
I have entered following call to JDE as we're struggling with sales for kit items using different Unit of Measures as Tansaction UOM
Any ideas and comments are welcome
ERP8
NT / Citrix / MS SQL Server
----- snip ----
Following scenario is causing a red error in ship confirm
Primary UOM is one kilo (KG) for all items but sales can be done for Gallons (GA) as transaction and pricing UOM. Kits are used extensively. Normally there is only one component to each kit but there are cases where multiple components are used (blends)
ECS flag is turned ON, there are 3 decimals in the quantity fields of F4211 and 4 decimals in QNTY data dictionary item (F3002 Component Quantity)
The conversion factor is "1 GA = 3.4107 KG"
Enter an order in Gallons for a kit item (Example: 21764.000 GA). (Full gallons, no decimals) Parent line is created with "GA" as UOM, component line is created with converted quantity 74230.475 KG (rounded, as real result would be 74230.4748 KG)
- Ship confirm the order changing the quantity (i.e original quantity was 21764.000 GA, new quantity is 21753.000 GA. (remainder is cancelled) You receive red error "Quantities must balance"
The problem is that, due to (lack of?) rounding and the conversion factor, the quantities do not balance exactly
The system IS set up with the smallest UOM as primary BUT there are decimals in conversion from GA to KG. The items are set up as packaged, NOT bulk items.
In my opinion, the error should not appear if the difference is so small it can not be represented using the available decimal positions in F4211 table
Regards..
Aarto Reponen
I have entered following call to JDE as we're struggling with sales for kit items using different Unit of Measures as Tansaction UOM
Any ideas and comments are welcome
ERP8
NT / Citrix / MS SQL Server
----- snip ----
Following scenario is causing a red error in ship confirm
Primary UOM is one kilo (KG) for all items but sales can be done for Gallons (GA) as transaction and pricing UOM. Kits are used extensively. Normally there is only one component to each kit but there are cases where multiple components are used (blends)
ECS flag is turned ON, there are 3 decimals in the quantity fields of F4211 and 4 decimals in QNTY data dictionary item (F3002 Component Quantity)
The conversion factor is "1 GA = 3.4107 KG"
Enter an order in Gallons for a kit item (Example: 21764.000 GA). (Full gallons, no decimals) Parent line is created with "GA" as UOM, component line is created with converted quantity 74230.475 KG (rounded, as real result would be 74230.4748 KG)
- Ship confirm the order changing the quantity (i.e original quantity was 21764.000 GA, new quantity is 21753.000 GA. (remainder is cancelled) You receive red error "Quantities must balance"
The problem is that, due to (lack of?) rounding and the conversion factor, the quantities do not balance exactly
The system IS set up with the smallest UOM as primary BUT there are decimals in conversion from GA to KG. The items are set up as packaged, NOT bulk items.
In my opinion, the error should not appear if the difference is so small it can not be represented using the available decimal positions in F4211 table
Regards..
Aarto Reponen