Eliminating or Hiding GL Accounts (No more further transaction)

(0) Share

Report

Posted on by Fah777

we are using Navision 2009 SP1

My issue is I need to close or hide some accounts in chart of accounts which was nil balances,

how can we do those accounts to be eliminate or hide

Note: When I took the trial balance report it's appear so many accounts which is not using and nil balance too

so this reason our chart of accounts printed many pages

please waiting for prompt solution this regards

thanks

(attached photo for your easy understanding)

1273.Untitled.jpg

*This post is locked for comments

All responses (12)

Answers (0)

Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Please add

IF "Account Type" = "Account Type"::Posting THEN BEGIN before above code. otherwise you will miss begin end total rows..
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Open the report in designer mode and write code on OnAfterGetRecord Trigger

"G/L Account".CALCFIELDS("G/L Account".Balance);

If "G/L Account".Balance=0 THEN

CurrReport.SKIP

If you are not developer then take help of developer to customize this
Fah777 50 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

I'm not a partner,
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Are you a partner?

you need to customize for this.
Fah777 50 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Please see the my trial balance report as attached

my requirement is which highlighted blank account to be hidden or eliminated
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

detailed trial balance report?

dont you have any options in request page?
Fah777 50 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Mainly I need for Trial balance reort
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

which report are you running?
Fah777 50 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

I didn't get you sir, (what is the report Id?)
Fah777 50 on at

Like (0)

Report

RE: Eliminating or Hiding GL Accounts (No more further transaction)

Good, but once I filter that way begin-total also hided

actually I need this should be reflect to only posting accounts

otherwise is their way hide or (enable/disable) option in setup?