Hi all,
In the sales demo test environment, there is a report of “Profit and Loss by Product”, of which the column set has been confirued to differentiate each column by “start sub”. It only defines the first 3 letters here.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1e35772c-f08f-408f-9560-06d2fc2e3c11.png)
And if we take a look at the subaccounts, the logic here is to define products by the first 3 letters and define departments by the last 3 letters.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d69b1716-ad01-47cb-ad8f-0461e9794d6c.png)
That makes me wonder if we can design a report called “Profit and Loss by Department”, and differentiate each column by “end sub”, for example in the column of Finance department, the data source would be like this:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f94ef5ee-ca02-4810-b627-aca18c609ca8.png)
But when I tried to generate a report, en error occurred. So do I misunderstand the logic of “end sub” here? And how should I design a report of “Profit and Loss by Department”? Thanks a lot.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f9be8001-3f2f-4308-ae91-f626b94cc966.png)
Best answer by Laura02
View original