In the Item Maintenance History grid, you can select to view history information by quantity, sales, or receipts by selecting the Quantities, Sales, or Receipts option. By selecting the Compare Prior Year button, you can view additional information with prior year comparisons.
There are six different views of calculated columns total that can be used to compare current and prior year history information.
Calculations may vary based on the option selected. Quantities are calculated as net, and Sales and Receipts are calculated as gross.
The table below indicates what information is displayed based on the option selected.
History Selection Option
Columns Displayed with Compare PY (Prior Year) not selected
Columns Displayed with Compare PY (Prior Year) selected
Quantities
Period
Ending
Beginning Qty
Qty Sold (net)*
Qty Received (net)**
Qty Issued
Qty Transfer
Qty Adjusted
Ending Qty
Period
Ending
Qty Sold (net)*
Qty Sold PY (net)*
Var % (for Qty Sold)
Qty Received (net)**
Qty Received PY (net)**
Var % (for Qty Received)
Sales
Period
Ending
Qty Sold (gross)
Sales $
Cost of Sales
Qty Returned (customer)
Period
Ending
Sales $
Sales $ PY
Cost of Sales
Cost of Sales PY
Profit %
Profit % PY
Receipts
Period
Ending
Qty Received (gross)
Qty Produced
Cost of Sales
Qty Returned (vendor)
Period
Ending
Qty Received (gross)
Qty Rec PY (gross)
Qty Produced
Qty Prod PY
Cost of Sales
Cost of Sales PY
*Qty Sold (net) = quantity sold - quantity returned (customer)
**Qty Received (net) = quantity received - quantity returned (vendor) + quantity produced