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.