In Sage X3, while importing data through one of the custom import templates we came across an error of “Non-blocking difference Error format ZDEPCODE K:20B” in the log: We’ll be referencing the following screen from Sage X3 for this: Import/Export template: All -> Setup/Parameters -> Usage -> Import/Export template (GESAOE) Refer the screenshots for reference:… Read More »
As we know, Sage X3 provides special functionality to export/import data from/to X3 respectively. The import/export functionality is basically used to create or update transactions in X3. However, data export is the extraction and conversion of raw data from their existing format into a format required by another application. We export data either as a… Read More »
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… Read More »
While creating or modifying the template of xml file type you may come across some validation errors, this blog will guide you to overcome this error. While creating the template you may get the error as ‘indicator is mandatory’ to resolve this error you have to add the table in the ‘Identifiers’ tab. New Stuff:… Read More »
While trying to import a file into X3 using import/export template you may come across a situation where data gets truncated and incomplete value gets imported. The reason may be the file you are trying to import contains the ‘CR’ (carriage return)’and ‘LF’ (line feed) at the last record of the line. To import this… Read More »
X3 provides the functionality of creating\updating the transactions using import\export template even with the XML format. New Stuff: Creation of Dynamic selection list in Sage ERP X3 For creating XML template you just need to follow below steps: Step 1: Move to: Setup > Usage > Imports / Exports > Import/ Export template. Step 2:… Read More »
In our last blog, we saw how to create a Setup Template to copy/extract data from a (source) X3 folder. Now we will see how to integrate this template into another (target) folder. The integration of the setup template can be done from the source folder itself provided you have appropriate privileges. The Setup Copy… Read More »