Skip to main content
Question

How to generate P&L based on item class

  • July 3, 2026
  • 3 replies
  • 35 views

Forum|alt.badge.img

Hello all,

I want to design a P&L based on the item class as in the below screenshot. Now the only thing I am stuck is the . Is there a way we can design the same under ARM report?

 


If not then under my report designer how can I design to include the COGS ? Because i need to calculate cogs based on COGS account class. 

3 replies

sangland
Varsity I
Forum|alt.badge.img
  • Varsity I
  • July 3, 2026

If you have posting classes aligned with item classes and also account classes per posting class then you can add columns for each account class in your column set. 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • July 6, 2026

If you have posting classes aligned with item classes and also account classes per posting class then you can add columns for each account class in your column set. 

However some of the posting classes are being used for one item then other with another. And then both ofthe posting classes are being used for the 3rd item class, however the item under that class uses the other and many similar scenario exist.


meganfriesen37
Captain II
Forum|alt.badge.img+13

It would require some manual input on a monthly basis, but you could use a statistical ledger to record the units sold which would keep everything in the ARM reports.  Otherwise, you would likely be looking at a report designer file likely with an embedded subreport to track the units and some variable so that you could pull the units back to do the math.