Skip to main content
Solved

Issue: The Ending there is an Beggining Balance on Report but not in Account Details

  • March 28, 2025
  • 9 replies
  • 165 views
  • Translate All

Forum|alt.badge.img

I'm having an issue with my report because there's no Beginning Balance in the Account Details, yet the report is showing an amount. I'm trying to consolidate the two branch, but its showing an amount even though it has no balance. the others is correct 

 

this must be 0 

 

 

Best answer by jhoncandare04

it okay already fix my filter the problem is the bracket 😅
 

 

View original

9 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@jhoncandare04 

Please re-attach your report file as .rpx. Do this by > in the Acumatica Report Designer screen > File > Click “Save As”

 

 

Best Regards,

NNT

Translate

Forum|alt.badge.img

sorry mybad ​@nhatnghetinh 

Translate

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@jhoncandare04 

What is your purpose of creating a second "Company/Branch" compared to the original report?

This may be the reason for the error.

 

 

Best Regards,

NNT

Translate

Forum|alt.badge.img

for consolidating two branches ​@nhatnghetinh 

Translate

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@jhoncandare04 

If you want to create a "Trial Balance Summary" report with multiple Company/Branch > Please use the ARM tool (financial reports). Currently, the "Trial Balance Summary" standard report of Acumatica created with Report Designer is only correct under the condition of having only 1 Company/Branch.

Please refer to the post below with the same question as you.

 

Best Regards,

NNT

Translate

Forum|alt.badge.img

is it not possible here? ​@nhatnghetinh 

Translate

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@jhoncandare04 

How many Companies/Branch do you have in Acumatica? If you only have 2 Companies/Branch, you can consolidate the data of the 2 Companies/Branch by removing "Company/Branch" in the Trial Balance Summary report.

 

Best Regards,

NNT

Translate

Forum|alt.badge.img

i have more than 15 branches

 

Translate

Forum|alt.badge.img

it okay already fix my filter the problem is the bracket 😅
 

 

Translate