ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Report ABC analisys (aka Pareto Principle)

Hi there,

is there any out of the box report showing ABC analisys (aka Pareto Principle)?

Any help appreciated.

Thx in advance

ABC Analysis of what?

@rmehta ABC Analysis of Sales

@rmehta if can help, we use following t-sql code for the last year analysis:

DECLARE @running_sales MONEY
DECLARE @code VARCHAR(30)
DECLARE @sales MONEY

DECLARE @t TABLE 
(
	code VARCHAR(30),
	sales MONEY,
	running_sales MONEY
)


SET @running_sales = 0

DECLARE s_cursor CURSOR FOR
	SELECT ItemCode, SUM(TotalSoldNoTax) AS sales FROM OrderDetail
	GROUP BY ItemCode
	HAVING MIN(data) <= DATEADD(WEEK, -52, CONVERT(datetime, CONVERT(varchar, CURRENT_TIMESTAMP, 101)))
	ORDER BY SUM(TotalSoldNoTax) DESC

OPEN s_cursor

FETCH NEXT FROM s_cursor INTO @code, @sales

WHILE @@FETCH_STATUS = 0
BEGIN
	SET @running_sales = @running_sales + @sales
	INSERT @t VALUES (@code, @sales, @running_sales)

	FETCH NEXT FROM s_cursor INTO @code, @sales
END

CLOSE s_cursor
DEALLOCATE s_cursor

SELECT code, sales, running_sales, running_sales_pct,
CASE WHEN running_sales_pct <= 0.8 THEN 'A' ELSE (CASE WHEN running_sales_pct <= 0.95 THEN 'B' ELSE 'C' END) END AS [ABC]
FROM
(SELECT *, running_sales/(SUM(sales) OVER()) AS running_sales_pct FROM @t) AS RunningSales;	

Is possible to implement in ERPNext?

Thx

Is something like the ABC analysis in the meanwhile available or has anyone built it him/herself? This report is rather a basic tool used for inventory optimization.
See https://en.m.wikipedia.org/wiki/ABC_analysis