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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The project was put on hold however some valuable insight given by yo_bee
ASKER