Pareto Product Report Legacy

Back to Warehouse Management

Introduction

Starting from MP13 there is a new Cost Engine Available This report is based on the legacy cost engine. If you are a new user starting on MP13 and followings or have migrated to the new engine, please go to the Costing Server document for further information. If you are a user of a previous release it is recommended to migrate to the new engine, refer to Costing Migration Process for more information.

Pareto Product Report Legacy distributes products into three classes (A, B or C) according to the cost value that each product inventory has in the warehouse. Based on this classification the frequency of counting cycle can be decided (e.g. A products are counted weekly, B products monthly and C products yearly).

Following distribution is used: A products represent 80% value of the warehouse, B - 15% and C- 5%.

• Note. The classification is based on the Legacy Average Cost of the product and the legacy Generate Average Costs process has been properly run to make sure that the Average Cost used is up-to-date.

Parameters window

Currency field defines currency in which all monetary values (like Cost, Value) of the report are shown. Field is defaulted to the system currency. Please note that Conversion Rate to the report Currency should be specified for the report to work.

Update ABC button fills in ABC field (updates value if the record exists or creates new record otherwise) of Manufacturing tab of the Product window for the organizations of the report output.

Sample Report Output

Columns to note:

• Quantity: that is the current stock of the product (Quantity on Hand).
• Cost: that is the Legacy Average Cost of the product
• Value: that is the Quantity x Cost.
• Percentage: that is a ratio between the product value and the total value of the warehouse (which is the sum of all report lines).

Back to Warehouse Management