Beginng and Ending balance in GL Trail Balance

[brendasql]

Can someone tell me where the beginning and ending balances come from that are display in the GL Trail Balance report. I am trying to create a short version of this report that can be pulled using Crystal as a daily Cash Report. I have located my journal entries, but I am totally lost trying to figure out how to retrieve these balances. Does anyone know what table would hold this information?
Thanks!
Brenda

 

[LyleU]

Hi Brenda,

Most GP reports, like the G/L Trial Balance, obtain their underlying data from a temporary table that is created upon running the report and which is destroyed after the report is complete. You cannot easily access things like the beginning balance field in a typical trial balance report as the table does not exist anywhere. To convert this to Crystal, you will have to take care of those calculations yourself during the running of the report. :-(

If you are proficient with SQL, you may be able to find the underlying stored procedures that are kicked off during report creation and use those to populate your new report. Hopefully, someone with more experience in that area will chime in with some more detailed information for you.

Lyle

 

[brendasql]

Thanks Lyle! It is not the greatest news but it definitely points me in the right directions.

 

[Dukester0122]

That's true you definitely need to do some calculations or roll-up in Crystal. Here's what might help, look at GL10111. This table shows summary of each account so in Crystal you can put a parameter where the user enter a data range or a period/year.