RE: How to identify profitability of items from sales order on purchased items? Is it possible functionally or technically

Required solution would be greatly appreciated

saaho25 Rookie Asked on November 5, 2019 in Accounting.
Add Comment
1 Answers

If you want it simply based on a field like purchase price, you could run a saved search with a formula field along the lines of:

 

{effectiverate} – {item.cost}

 

In this event, you’d be using the purchase price as your cost. You can also replace that with average cost, last purchase price, etc.

You can then group by item, and sum over these values or average to get an average margin. All kinds of options in terms of reporting different values. A few more to consider:

  • Get total margins by location or some type of item grouping
  • Modify the formula to return percentages and get average margins by a grouping
  • Use CASE WHEN SQL statements in the formula to bucket the margins by month/quarter/year and show totals in different time buckets and changes over time

Just some ideas.

Beginner Answered on November 5, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.