Product Exception Report

The Product Exception report (Products / Reports / Product Exception) has been improved to be more specific, to filter to only certain types of errors and allow better reporting. 

It has the product code and product group as selection parameter ranges.

It can be sorted by product code - or by the error / exception code in which case each error will start on a new page.

The Margin check for each price level will check that the price is not zero;  that the margin is within the parameter range;  and if there are quantity breaks, that they are logically incremental.

The GL Account Link Checks confirm that the sales, purchases and closing inventory general ledger accounts exist and are valid; that they match the product group setting if it exists and that they are of the appropriate GL type/function.

The Cost Price Checks confirms that a latest cost exists and where average costing is used that the average cost exists.

The Type Classification Checks confirms that the product type exists and is valid and matches the product group setting if it exists. It will display two numbers, the first is the current type, and the second the type that matches the group setting.

The Group Classification Checks confirms that the product group exists and is valid.

The Sub-Group Classification Checks confirms that the product sub-group exists and is valid, and the product group matches the setting if it exists. Note: do not run this including groups that do not use Sub Groups.

The Customer Item Type confirms that the customer item exists and matches any product type, group or sub-group setting that is entered; currently NONE or DEFAULT can be accepted.

The Quantity Checks confirms that non-tracked items and inactive items do not have stock quantities and that serial tracked items have serial number quantities that match the on-hand quantities. Also see Product Exception Report - Serial Quantity not the same as the Total Qty.

The Settings Checks confirms that the settings related to serial tracking and multiple serial tracking numbers match the product group setting.

It also checks that no product codes are duplicated.