Link to home
Start Free TrialLog in
Avatar of Juan Acevedo
Juan Acevedo

asked on

Need to create a GL Trial Balance using raw GL data from MS Sql

I am looking to create a GL TrialBalance report using raw GL data in MS SQL using the parameters of GLYEar and GLPeriod
I need the following;

these are the needed columns for the report,
DeptNum, GLAccount, GL Desc, Begining Balance Debit, Begining Balance Credit, Current Period Debit, Current Period Credit, Ending Balance Debit, Ending Balance Credit

Keep in mind I will also have Balance Sheet accounts that have running balances as part of the report and are identified by the column called BALANCESHEET (Y\N)

Sample of the raw data
User generated image
ASKER CERTIFIED SOLUTION
Avatar of yo_bee
yo_bee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Juan Acevedo
Juan Acevedo

ASKER

There are no other tables. I have to build it from scratch in terms of  getting all beg balances etc..
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is the report that I need to re-produce. When a user requests a trial balance they input the GL year and GL Period. The returned data should have the beginning balance for the gl account, the current period activity and the ending balance information


User generated image
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The project was put on hold however some valuable insight given by yo_bee