Report ABC analisys (aka Pareto Principle)

ERPNext Reports
1

Hi there,

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

Any help appreciated.

Thx in advance

2

ABC Analysis of what?

3

@rmehta ABC Analysis of Sales

4

@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

5

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 ABC analysis - Wikipedia

1 Like