Special Processing
The quantity in the transaction UOM is converted to primary UOM based on the conversion factor specified in the item UOM conversion table or standard UOM conversion table. The system uses the flag Standard Unit of measure conversion (IFLA) to retrieve the conversion. The quantity in primary UOM appears in the Primary Quantity field. When an item with dual unit of measure is processed, the quantity in the secondary transaction UOM is converted to the secondary UOM of the item. The quantity in secondary UOM appears in the Primary Quantity Secondary field.
The month corresponding to the transaction date appears in the Trans month field. For example, if the transaction date is 01/15/2011, then the Trans month column contains "1."
The following quantities are shown only once per Item, Branch Plant, Location and Lot combination:
Quantity backordered
Quantity on hand
Quantity hard committed to work order
Primary quantity on project hard commit
Secondary quantity on project hard Commit
Quantity on loan to manufacturing
Quantity soft committed
Quantity hard committed
Quantity in inspection
Quantity in operation 1
Quantity in operation 2
Quantity in transit
Quantity inbound
Quantity on future
Quantity on other 1
Quantity on other 2
Quantity on other purchase order
Quantity on purchase order
Quantity on WO/RC
Quantity outbound
Secondary quantity hard committed
Secondary quantity inbound
Secondary quantity on hand
Secondary quantity on purchase order
Secondary quantity on WO/RC
Secondary quantity outbound
Secondary quantity soft committed
Secondary work order hard committed
Secondary work order soft commit
This is necessary to ensure that the system can use the columns to display proper data in the reports.