Suppress Field on Blank or Zero

Previous  Top  Next

One can perform “Suppress field on Zero”, “Suppress field on Blank” or “Suppress field on Blank or Zero”. For our convenience, we will take “Suppress field on Blank or Zero” to cover both the cases.

Instead of entire Row if we want to suppress only selected fields, we can use this DS type.

Like before, let’s suppress only the amount field if either 0 or blank.

For amount field in Mapper select “Suppress field on Blank or Zero” in Dynamic Skip column from the drop down. (Refer the screens below)

suppress-field-on-blank-or-zerob1

 

 

suppress-field-on-blank-or-zerob2

 

suppress-field-on-blank-or-zerob3

Click on Run button in toolbar.

On successful Run, It will show the error like “Document does not contain any valid line items”.

That is because we suppressed only the amount field & not the others & this transaction requires all line items for successful document posting.