G/L Entries For G/L Accounts

gulamdastagir

hi

Report # 6 or Trial Balance gives you the General Ledger Accounts Net Change and Balance at Date.

My Client wants to see the G/L Entries wherever The Balance at Date equals Zero

Thanks
gd

kriki

You can easily do that :
-"Date Filter" : put a filter on your date-range (e.g. "..01/01/2007")
-add field "Balance at Date" and put filter "0".

gulamdastagir

Dear Kriki,

let me state my problem more clearly,

If you run the standard report 6,Trial Balance.The section designer contains G/L Account ."No.",G/L Account."Net Change" and G/L Account."Balance at Date" fields.

So whenever the G/L Account."Balance at Date" =0 ,i would like to See the G/L Entries for that particular G/L Account

kriki

:oops: Didn't read your post well. :oops:

You have to add a new dataitem just under the G/L Account dataitem and link it to the G/L Account.
In the "OnPreDataItem"-section, you must put a test:

IF "G/L Account"."Balance at Date" <> 0 then
  CurrReport.SKIP;

This code will skip the entries if the balance at date is not 0.

But you might have a LOT of entries under it.
So it might be better to put on the request form a boolean to show or not show the entries on balance at date=0.
In this case the "OnPreDataItem"-section code becomes:

IF ("G/L Account"."Balance at Date" <> 0) OR (NOT blnShowEntries) then
  CurrReport.SKIP;