Wikiadmin: Created page with "'''Pareto Product Report''' 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 cla..."

2021-11-19T07:13:45Z

Created page with "'''Pareto Product Report''' 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 cla..."

New page

'''Pareto Product Report''' 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 cost of the product. That is why it is needed to have a [[Costing_Rules|Costing Rule]] validated and the [[Product#Transaction|Material Transaction]] costs of the product calculated up-to-date.

=== Parameters window ===

[[File:PS75F83D534E764C7C8781FFA6C08E87ED.png| border]]

'''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 [[Currency | '''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 [[Product#Org_Specific | Org. Specific]] tab of the '''Product''' window for the organizations of the report output.

=== Sample Report Output ===

[[File:ParetoProductOutput.png| border | 800px]]

Columns to note:
*'''Quantity:''' is the current stock of the product (Quantity on Hand) in the warehouse selected.
*'''Value:''' that is the sum of all the material transaction costs of the product.
*'''Cost:''' this cost is calculated as the ratio between the product value and the product quantity above
*'''Percentage:''' that percentage is the ratio between the product value and the Total Value of the warehouse (which is the sum of all report lines).

=== Persisted Information===
{{AvailableFrom|3.0PR17Q2}}
As part of Openbravo 3.0PR17Q2 release, the Pareto Product Report includes many features that drastically improves the performance.

One of these features is the possibility to use the aggregated data calculated for the Valued Stock Report. Please refer to the [[ Valued_Stock_Report#Persisted_Information_.28Introduced_since_PR17Q1_Release.29 | Valued Stock Report]] documentation for more details about how to generate the aggregated information.

Note that, exactly the same as for the Valued Stock Report, the Pareto Product Report can also be launched without aggregated data. However this feature is specially useful in high volume environments when you experience performance issues launching the report.

Template:ManualDoc:P75F83D534E764C7C8781FFA6C08E87ED - Revision history

Wikiadmin: Created page with "'''Pareto Product Report''' 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 cla..."