Trial balance

[Former Member]

Hello,

Even though I check the option "Hide account with no postings" in the trial balance, the report shows the accounts that have no postings.

SAP Business One 8.8 PL 16

Please I need your help. Thank you.

[Former Member]

Hi,

Balance is 0 will not equal to account with no postings. Check if those accounts have posting or not. It is easy to check by query.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Please, how can I check by query that the accounts have posting or not. Thanks

[Former Member]

Here you are:

SELECT T0.AcctCode, T0.AcctName

FROM OACT T0

LEFT JOIN JDT1 T1 ON T1.Account=T0.AcctCode

WHERE T1.Account is NULL AND T0.Postable = 'Y'

[Former Member]

Hi Nadia......

Are you using Customized Financial Report Template for Trial Balance?

If yes then try with system standard.....

Regards,

Rahul

[Former Member]

Hi Rahul, thanks for the reply

I tried with system standard, but the problem remains the same. Any other idea please?