1. One View Reporting User Guide
  2. Special Processing

Special Processing

This section explains some functionality for the One View Average Cost Analysis from Item Ledger Inquiry application.

Document Company is a required filter field. The processing option for this field can be blank, but if you tab out of this field in the application without entering a valid company, you will receive the error "Required Filter Criteria Not Entered."

F4111 records with a blank G/L date are not included in the average cost calculation. These records are:

  • Sales orders that have been ship confirmed but not run through Sales Update

  • Work orders that have been issued materials or completed but not run through the post program.

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 secondary transaction UOM is converted to secondary UOM of the item. The quantity in secondary UOM appears in the Primary Quantity Secondary field.

When there is no conversion defined for an item, either in the item UOM conversion table or standard UOM conversion table, then the columns "Primary Quantity, UOM, Primary Quantity Secondary" and "Primary UOM Secondary" are shown in red.

The month corresponding to the G/L date is displayed in the G/L month field. For example, if the G/L date is 01/15/2011 then the G/L month column contains "1."