Income Statement

[muhaidib]

Dear all,

I am using Advantage Series v5.2.
How can I avoid display income statement for department with zero balance?

 

[Jay Converse]

From Help:

Suppressing lines that have zero values
To specify zero line suppression, you enter the letter Z in column C. Financial Reporter will check all report columns to see if the values are zeros. If all values are zero, Financial Reporter will not print the line.

If you do not want to suppress zeros on a single line, but you specified Z in the default specification, enter the letter N in column C of the line you want printed.

 

[muhaidib]

Thanks for the reply.

In my database there are depts. with all zero values. For such depts I do not want to display/print the report-page itself (skip generating the report for particular depts).

Also I do not want to delete the depts.

 

[Jay Converse]

There is a solution using the built-in Financial Reporter functions. However, you could write a simple macro to print just the departments you want.

 

[ettienne]

Do not include the department in the print range, if you do then it will print a blank page.

 

[muhaidib]

Thanks tub12007,
I searched in vain for built-in function to skip the print of undesired dept (with 0 balance). However succeded in writing a small macro to achieve the purpose.

Thanks for suggestion.