Trial Balance not suppressing zeros

HI @Malinda278 

Has the Trial Balance report been modified? Are there any additional sort and filters on?

Thanks very much Laura

So if I want to see the balance on all accounts YTD for any given period regardless if any activity has taken place is there standard report do you think that does this?

I have tried to write my own reports within Acumatica  but I can’t get the column set up correct to do month and YTD whereas in excel it is very easy for me. I have no experience in writing computer language and I feel it is beyond me to be honest. 

Best Regards

Malinda

Hi Malinda,

If I can create financial reports with ARM, you can do it too!  (I don’t write code.) 

Look for videos on Y ou T ube and Acumatica Open University, or  ask your partner for training.

For the Columns, I recommend starting by copying one of the demo Columns. The Demo reports that come with Acumatica show us the most common total formulas, like this example where I highlighted yellow:

Look at the Standard P & L and Balance Sheet.  Acumatica standard reports probably are hiding lines with no activity or with $0 but it is simple to show all lines: Clear the Suppress Empty column:

Laura

Hello Laura

I managed to get the Rows in OK just using trial and error , it was the column headings which could show the month and YTD for the Financial year and with the Balance Sheet bringing forward opening balances as well. This was a while ago when I first starting working with the system, the company and me were new to this software. However we never had demo reports for me to look at for help with the columns. I think I just got a bit frustrated which is why I just decided to map my TB to a excel sheet to solve my problem. I think I should chase the demo reports really and try and find out why I did not have them to use as a prompt, and try and keep some momentum going with getting the system to do the work.

Thanks again

Malinda

I’m just here to rant!   

I’m having this same issue.  I uncheck “suppress zero balances”.  Seems like that should give me a trial balance with EVERY account in my chart of accounts.  Cool, that would make spreadsheet manipulation easy as you move from month to month.  But no.  Acumatica doesn’t act that way.  

The trial balance appears to be based on a data table called GLHistory and that table only contains data if there is activity in a period.  

What garbage.  

Sure this minimizes the data in that table but the result is reports like the trial balance that are incredible difficult to work with.

I’ve worked with other systems (Peoplesoft, SAB, Dynamics) and they all have a configuration option to have the history table populated with EVERY element regardless of if there is activity.

Like I said, I don’t have a resolution but maybe if enough people yell about this Acumatica will do something about it.

Hello @Malinda278 ,

Your VAR can load the Demo reports for you. If any of your tenants shows the demo reports, they can be copied from one tenant to another using Clipboard functions Export/Import to XML.  Its also possible that Roles/Access rights are preventing you from seeing the Demo reports on the menu, or possibly the menu was modified to move the demo reports from the menu. (In this last case they can be added back with [...] Menu Edit in lower left corner (administrators role only).

@Malinda278, please consider adding your idea to the Ideas section of this community so that people may vote for its inclusion in future versions. Thank you.

Laura

Hello there

I’m not sure the rant will make a difference, but I empathise and it’s always helpful to know someone else is in rant mood :)

Malinda

R Harrison

I have you shared the idea of having the TB work in the way we want in the ideas area? I have not yet done so but wonder if it’s a good idea?

Malinda