Information Displayed in the Item Maintenance History Grid

 

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