One of our customers, asked us for a report that I believe can be generated by ERPNext. Report should include
1- For all sales items, provide
A. Average selling price
B. Total quantity sold
C. Total sold amount
D. Average purchase price
E. Total purchase amount
F. Total quantity purchased
G. Total selling amount - Total purchase amount
H. (Total selling amount - Total purchase amount) / Total selling amount
2- Report can be filtered by date. where average & totals are calculated for date period specified.
3- Only show items with total quantity sold greater than zero.