To replace values which are not null with a null value, you need to use the special case: [BLANK] in the appropriate column of your worksheet.
Note - You need to include the square brackets as well as the word BLANK in capitals.
This is particularly useful when some fields if populated, require other fields to be populated, and you want to change these fields to ‘No’ or a Null value. For example, when the ‘Gapless Invoice Numbering’ is set to ‘Yes’ then the ‘Selling Company’ field is required.
In the following example the ‘Gapless Invoice Numbering’ is set to ‘Yes’ with a ‘Selling Company’ populated of ‘Company A’.
To change the ‘Gapless Invoice Numbering’ to ‘No’ the ‘Selling Company’ must be null. To do this, populate the ‘Selling Company’ field with a [BLANK] value.
There is also functionality on the ‘Supplier’ form to enable you to do this. To use this functionality, open the Supplier form and place your cursor on the field which is required to be Null. Select the button and the field will be populated with [BLANK].
Before
After
Notes:
1.If the value is say a date and you use the [BLANK] functionality the field will display with red background as this is not a valid value (e.g. a date value is required). The Wizard will however ignore this when uploading to Oracle.
2.[BLANK] functionality is not available for the following fields:
-Start Date Supplier Bank Acc
-Start Date Site Bank Acc
-End Date Supplier Acc Owner
-End Date Site Acc Owner
This is due to API issues when passing the data (validates but populates field with 01-JAN-4712) and will return a rejected message into the worksheet. These fields can be manually cleared in Oracle forms as required.
button and the field will be populated with [BLANK].
