Skip to main content
Solved

How to generate P&L based on item class

  • July 3, 2026
  • 4 replies
  • 54 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. 

Best answer by Harry

hi ​@sangland , ​@meganfriesen37 ,

At last I had to great a separate report using a report design out of it.

Thank you all for your help.

4 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 III
  • 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.


Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • Answer
  • July 9, 2026

hi ​@sangland , ​@meganfriesen37 ,

At last I had to great a separate report using a report design out of it.

Thank you all for your help.