Disabling Zero Suppression (NZP)
The NZP
expression is used to disable zero suppression during the data-load
process. By default, the system bypasses accounts in the trial balance that have
zero balances. In certain circumstances, you may want to load all accounts, to
ensure that values that should be zero are replaced. You enter NZP
in the Expression column of the Amount field to disable zero suppression.
The parameter is NZP
.
Note:
Blank rows cannot be processed in Data Integration. You need to replace the blank with "0" in your source file and then use the NZP expression in the Import format for the Amount column to load 0s to your target.