Skip to main content
Solved

Layout of Profit & Loss with subaccounts

  • 11 February 2022
  • 3 replies
  • 677 views

Newbie question here.  We are currently in the process of having our Acumatica partner build our database.  I’m looking at the P&L report and the format seems weird to me.  Below is an example.  I’m definitely not used to, and do not like, that their is a line amount for the the GL account and then additional lines amounts for each subaccount, which results in duplicate line item amounts.  What I should be able to see is what is in the second screenshot (from our current accounting system).  Our partner tells us there is no way to format the report in Acumatica in the same was it’s formatted in our current accounting system.  Can someone tell me if that is true?  Because the way it looks now seems very illogical.  

 

Best answer by Kandy Beatty

HI @angie 

The way to adjust the P&L, is edit the row sets on the ARM reports. This is under Finance > Preferences, On the Row Sets, you would expand from the Data Source. The below shows with the Subaccount. 

 

 

If you do not want to go that granualar, then you can do the same with just the Account:

 

 

This article should help as well:

https://help-2021r2.acumatica.com/(W(15))/Help?ScreenId=ShowWiki&pageid=1c797d96-f6d9-49d2-8d19-e4f3b56a476d

View original
Did this topic help you find an answer to your question?

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2158 replies
  • Answer
  • February 11, 2022

HI @angie 

The way to adjust the P&L, is edit the row sets on the ARM reports. This is under Finance > Preferences, On the Row Sets, you would expand from the Data Source. The below shows with the Subaccount. 

 

 

If you do not want to go that granualar, then you can do the same with just the Account:

 

 

This article should help as well:

https://help-2021r2.acumatica.com/(W(15))/Help?ScreenId=ShowWiki&pageid=1c797d96-f6d9-49d2-8d19-e4f3b56a476d


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • February 12, 2022

Hi @angie 

Looks like you have not enabled the expand option to expand by sub account, but instead have added separate lines for sub account amount. 

Please send a screenshot of your rowset reflecting above section. Do send the screenshot reflecting data source for above highlighted lines. 

Regards,

 


  • Author
  • Freshman I
  • 2 replies
  • February 14, 2022

@vkumar, thanks...I’ll share this with the company that is building our company in Acumatica.  I wouldn’t even know where to find that information to screenshot for you.  


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings