> > > >

Use this form to prepare a report about items that are outside a maximum deviation for the cost price. The deviation benchmark is based on the item cost price, item or median cost price, or median.

Example

An item contains a cost price of USD 5.00. When a purchase order invoice was posted for this item, the cost price entered was USD 15.00.

When printing this report, the maximum deviation percentage was set to 30%, and the item cost price was selected as the base. This purchase order will appear on the report because the cost of the item posted, USD 15.00, is more than 30% greater than the item cost price of USD 5.00.

Navigating the report

The following links and tables provide descriptions for the controls in this report.

Enter criteria on the General tab

Prepare batch processing on the Batch tab

Fields

Field

Description

Enter the date for which you want to check for open quantities. If you are using this report as part of the pre-inventory close checklist, the date entered will be the date of the inventory close.

Select this option if you do not want to include production receipt transactions when comparing the cost of the production receipt to the basic cost price options of item cost price, item or median cost price, and median.

Enter the value as a percentage of the maximum deviation you will allow in the cost of the receipt transaction compared to the basic cost price options of item cost price, item or median cost price, and median. Items that exceed this value will be printed on the report.

Choose which option you want to the inventory receipt transaction to be calculated against

  • – The cost price entered on the item

  • – The report factors both the item and median cost price

  • – The running average cost price of the item.

Enter the value as a percentage of the minimum deviation that you want to allow for this report. Items that fall outside the minimum and maximum deviation will appear on this report.

See Also