Allo,

Can you tell me if I can create a GL Trial Balance via GView where I can see the various balances @ the end of each period in seperate columns???

If so what is the best way?

Is there a reason why you don't want to do this in the Financial Reporter? It would be far easier to do...

Balances as of the end of periods are not stored values in the database. The Net Changes are stored for each account. To accomplish this in GridView, you would need to create Calculated Columns to subtract the appropriate period net changes from the current balance to get the balances ending for each particular period. This could get tricky as the formulas would have to be created in such as way as when the next month happens, the balances continue to point to the correct months.

If you can guarantee that the Opening Balances for the accounts are correct, it might be easier to start with the opening balance and sum Net Changes for each balance formula. For example,
Bal End period 1 = Opening + net changes period 1
Bal End period 2 = Opening + net changes period 1 + period 2
etc.

I would say it's likely possible to get this, but the formulas would be quite complex. You would be far better off doing this in the Financial Reporter if possible.

Ok...Didn't Remember it was possible to do this via FR...
Will do....Thanks Much!