GL lines not needed in custom report

1

Hello all.

Please someone assist me on how i can create a custom report in omitting the GL LINES in a custom report. I do not need them in this custom report.

See attached image. The lines underlined in red are the ones to be ommitted. The one underlined in orange is the one i need to be in the report.

Thanks

Mr. Parts Limited (Report Transformation) - Supplier Listing - For the period from 01_09_22 to 30_09_22_page-0001
Mr. Parts Limited (Report Transformation) - Supplier Listing - For the period from 01_09_22 to 30_09_22_page-00011240×640 109 KB

2

Show the edit screen of your custom report.

1 Like
3

You need to include Where… filters to eliminate postings to the unwanted accounts. Exactly how to construct the filter depends on what you are trying to include and exclude.

1 Like
4

@eko,

Here it is

Edit_Custom Report (Supplier Listing)
Edit_Custom Report (Supplier Listing)1872×950 69 KB

5

@Tut ,
Thank you. I’ll try to work on that.

6

Thanks for the screenshot, as @Tut indicated you need to add a …Where filter for the Account to contain Tax payable.

1 Like