I want to nullify my Suspense Account Balance(it contains opening entries balances which i don't want to show in my Trial Balance Report).Plz suggest me the safest solution.
to nullify you have to put it somewhere so it will always haunt you (double entry system)
best will be to filter is out on the report itself with either standard filters e.g. where blocked = not true or add code on the report itself to not show certain account.
The second option is not so much recommended
If field blocked is not going to work then maybe add an extra field on the G/L account table and form "Hide Account" and then build in a filter on the report to hide the G/L account if set to "HIDE"
this way the users can hide and show G/L accounts with certain permission as they wish.
to nullify you have to put it somewhere so it will always haunt you (double entry system)
best will be to filter is out on the report itself with either standard filters e.g. where blocked = not true or add code on the report itself to not show certain account.
The second option is not so much recommended
If field blocked is not going to work then maybe add an extra field on the G/L account table and form "Hide Account" and then build in a filter on the report to hide the G/L account if set to "HIDE"
this way the users can hide and show G/L accounts with certain permission as they wish.
On second through,what you can also do if it is small rounding caused by die take-on process is to consult with your auditors and simple write the rounding off against an expense account "discount allowed" or "discount occurred"
Comments
best will be to filter is out on the report itself with either standard filters e.g. where blocked = not true or add code on the report itself to not show certain account.
The second option is not so much recommended
If field blocked is not going to work then maybe add an extra field on the G/L account table and form "Hide Account" and then build in a filter on the report to hide the G/L account if set to "HIDE"
this way the users can hide and show G/L accounts with certain permission as they wish.
Thanku
Rinki