Skip to main content
Answer

Trial Balance Summary with Branches not showing all branches

  • December 6, 2023
  • 4 replies
  • 156 views

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.

4 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • 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
  • 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
  • December 6, 2023

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
  • December 11, 2023

Team,

 

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