Product Turnover Analysis Report ranges and options

Ranges

See Reports - Ranges overview.

Options

(P)roduct, (V)endor #, or Prod (C)at Order

Specify P to sort by product and then by warehouse.

Specify V to sort by vendor number and then by product. If you sort by vendor, only those products with an Authorized Replenishment Path (ARP) of vendor are included in the report.

Specify C to sort by product category and then by product.

Turnover (G) >= or (L) <= To

Specify G to include products with a turnover that is greater than or equal to the amount that is specified in the Turnover Amount option.

Specify L to include products with a turnover amount that is less than or equal to the amount that is specified in the Turnover Amount option.

Turnover Amount (0 for all)

Specify a turnover amount to define turnover parameters in conjunction with the Turnover (G) >= or (L) <= To option.

If you accept the default, the report does not check against turnover.

Number of Months of History

Specify a value between 1 and 99. We recommend a value between 1 and 24.

If the number of months of available history is less than the specified number of months, turnover is calculated with the available history.

Starting Period (blnk deflts most recent)

If you leave this option blank, the report starts with the most recent fiscal period from Product Warehouse Product Setup for each product. It then rolls backwards the number of months in the Number of Months of History field.

Specifying -1 yields the same results as leaving the field blank because the previous month is the most recent period available to report on.

Totals Only?

Select Yes to include only product totals and grand totals.

Select No to generate product detail, totals, and grand totals. The report can become lengthy, depending on the ranges and options that you specified.