In Sage X3, We can import data to the table through an Import/Export template feature. Here we can create Import/Export template with table fields which we have to update or enter in the table and import the text file which contain data and after successfully import of text file, table get affected. Through Import/Export template feature we can import or export data for single transaction or bulk of transaction.
While importing, we may get an error “Non – blocking difference Incorrect date ACCDAT 20210210”. as shown in the below screenshot.
Error – “Non-blocking difference Incorrect date ACCDAT 20210210”
Above error appears due to different date format of date field in a text file (which we were importing) and template date format.
Date Format selected in Template
Earlier we had selected the date format as (DDMMYYYY) in template as shown in above screenshot and date format of text file field was (YYYYMMDD), because of this, we were facing an error “Non – blocking difference Incorrect date ACCDAT 20210210” while importing text file.
Date Format selected in Template to solve error
Then we changed date format to 4th value (YYYYMMDD), same as the date format of field in a text file which we were importing earlier as shown in above screenshot. After this we fixed