F-Suppress Field on Blank or Zero

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)

Steps to be follow to suppress amount field:

  1. Go to Mapper tab.
  2. Switch to Advanced View as shown in below screenshot.
  3. Select Suppress Field on Blank or Zero or Space(s) option from the drop down menu in Dynamic skip column for amount field. (Refer the screens below).

Click 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.

For information about how to leave multiple data values unchanged, see Expert Excel Controls.