You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Clearing DFF and Numeric Values and Updating Existing Bank Account Data

Hi team,

I would like to clarify the following points regarding supplier FBDI imports. My main requirement is to clear existing field values and set them to NULL, rather than replace them with another value.

1. Clearing existing DFF and numeric values
The following documentation states that #NULL can be used, wherever applicable, to update an attribute value to blank:


Does this also apply to:

  • Character DFF attributes, such as ATTRIBUTE1
  • Numeric DFF attributes, such as ATTRIBUTE_NUMBER1
  • Other numeric fields in the supplier import templates

Are there any exceptions or specific requirements for clearing these existing values to NULL?

2. Supported updates using SupplierBankAccountImportTemplate.xlsm

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!