How to remove/hide/suppress blank lines in SAP B1 Ageing Report

[former_member741904]

SAP Version: SAP Business One 10.0 FP 2011

User: I’m using a superuser, full authorization, and a professional license.

Document and Module: Business Partner Ageing Report

Concern: When I run an ageing report, there's a blank space between the name and the transaction details. So the blank space is because of the Blanket Agreement column. Even though I tried to hide this using the Form Settings, there'll still be a row allocated for it. I checked some of the settings, but none seem to fit or work. Does anyone know how to hide/remove/suppress this? It kind of messes up my Excel File.

[jitin_chawla]

If all are N/A in Blanket Agreement, then from Form Settings, you can remove the it from visible. If otherwise, can check option of Filter in upper menu. Not sure it will help much but can evaluate. KR, Jitin

[former_member741904]

Even with disabling it in Form Settings, the blank lines still show up.

[jitin_chawla · Accepted solution]

You can use filter as well alongside it.

Click on Filter(funnel icon) from menu bar above after making blanket agreement not visible. Select Is not Empty option for Original amount row and see if it works.

KR,

Jitin

[former_member741904 · Accepted solution]

Looks like it works, I'll have the concerned department take a look. Thanks!