In this article, we will look into how to blank out value for a field using HSDL.
We use #NULL in the HDL template to blank out value for a field. However, it doesn’t work for HSDL templates for all business objects.
Consider a case of trying to update the federal tax card that has been loaded using the US Federal Tax Withholding Card 2020. If there are a few values that were loaded as 0 to a few columns like Supplemental Amount, Regular Rate, etc.
Passing blank value on the HSDL will not override the 0 values to blank value.
If we have to update these values to BLANK, then we need to set the value on the HSDL template to -999999999 and load it. Once loaded, the field values will turn to blank instead of the 0 which was loaded earlier.
