Have you ever encountered a problem with Sage X3 where a certain field that needs to be changed adds a new line to the pricing list template instead of updating for a product? The identical problem occurred to us in both the sales and purchase pricing lists; however, we were able to resolve it by… Read More: Price List Import template does not update products »
In Sage X3, we make sure of import/export templates quite often for importing huge data with ease. However sometimes the importing data templates are acquired through any external client application which might have different external data parameters which in Sage X3 are stored in different internal codes. Sage X3 provides us a Setup module that… Read More: Use of Transcribe Import/Export template in Sage X3 »
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: Error “Non-blocking difference“ Error format ZDEPCODE K:20B in Sage X3 »
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: How to export static values using template in Sage X3 »
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: How to solve error “Non – blocking difference Incorrect date… »
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: How to solve validation error while creating import/export template of… »
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: How to use record separator of import/export template in Sage… »
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: Importing and exporting data by xml file »
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: Restore your Common Data and Transactions to another Sage X3… »
