How to exclude cancelled and reverse journal entries while generating GL reports

[esleonardo]

Hi,

I need to generate GL but without the cancelled and reverse journal entries. Is there a way to exclude them in the report? Crystal report or using UDF. Thank you!

[kenan_jaddeny]

Hi,

in a simple way, you may execute a query, and exclude the cancelled or any other an wanted parameters from your report, it's easy to start and at once can be there, Modules > Tools > Query > Query Generator > and use these tables: OJDT and JDT1

Hope this was helpful,
KENAN

[former_member993530]

Tables OJDT and JDT1 are tables with many transactions, as a precaution it is advised to differentiate information required by transaction IDs/Object Codes. To remove cancelled and reverse transaction specify on the were condition. Below is a sample condition for the main table OJDT. For the case of report you may just paste your complete query in the command section of crystal reports.

SELECT * FROM OJDT T0 WHERE T0."RefDate" >[%0] and T0."BtfStatus" ='O' and T0."AutoStorno" ='N'

Regards