Report Profit and loss based on item class?

Hi @cherlene 

How are the GL transactions segregated based on Item class? 

Are you using any specific Sub account/ Subaccount segment value per Item class? You can build the report based on how you have setup to separate the numbers to identify Item class at document /transaction level ( Say Invoices in this case ).

• One approach would be, using sub accounts / sub account segment to separate the transactions per Item class
• You can setup separate Sub account on Item profile of specific item class ( set it up at item class as well, as it carries over on creating new item )

GL batch generated for sales will use specific sub account for specific item class 

On ARM report, column set, you can specify the subaccount on data source. 

Hope this helps,

Regards,

Hi @vkumar and @ChandrasekharM, thank you so much for the replies. Unfortunately we don’t have subaccount set up yet. The posting class for our inventory is currently based on inventory item. 

In Netsuite, we are able to give a customer attribute or item class to every transactions and analyse the P&L based on item class and attributes. But in Acumatica I had difficulties in setting this up.

Hi @cherlene Here are the Parameters and “Details” report format of the “Sales Profitability by Item Class and Item” , for your reference.

Thanks

Hi @cherlene were you able to figure this out? Thanks!