Skip to main content
Solved

Trial Balance Summary with Branches not showing all branches


martingaxiola
Varsity I
Forum|alt.badge.img

Team, I made this report worked up to show 1 branch (client has around 150 branches or more), and shows one account, but I need to show account by branch example 10100 by each branch it exist, I also modify a Trial Balance Detail by Branch, but i could not make the report to group by Account, as it would also group by subaccount (removed all subaccount grouppings and nothing), I dont know if somebody can help has worked something like this or can direct me on what I am doing wrong. Attached is the Report.

Best answer by ChandraM

Hi @martingaxiola You should consider building ARM tool (financial reports) of Acumatica with the Report Definition with Rowset, Columnset and Unitset. Let me know if you have any queries or assistance on this.

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

4 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • December 6, 2023

Hi @martingaxiola Assuming that you are looking for a report - Trial Balance by Branch. Please confirm.


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • Answer
  • December 6, 2023

Hi @martingaxiola You should consider building ARM tool (financial reports) of Acumatica with the Report Definition with Rowset, Columnset and Unitset. Let me know if you have any queries or assistance on this.


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 109 replies
  • December 6, 2023
ChandraM wrote:

Hi @martingaxiola Assuming that you are looking for a report - Trial Balance by Branch. Please confirm.

Yes, but is on my clients as Trial Balance Detail by Branch (GL), wich groups by Branch, Account and Subaccount, that report would be great if I could removed the subaccount grouping to have only Branch / Account combinations. I tried that (TB Summary and Detail have similar report designer settings), but cant make it where the subaccounts will stop segregating the report.  And on the one that I have attached, i cant make where the data from all branches subaccounts will show up.


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 109 replies
  • December 11, 2023

Team,

 

We end up using Velixo (our client has it) to do the report. Thank you for your help. 


Reply


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