Tag Archives: export

How to Install Microsoft Excel add-in in Sage X3

Sage X3 has an accompanying Excel add-in that you can use to export data from grids in Sage X3 into a Microsoft Excel spreadsheet. In this blog, we will run through the steps involved in installing the add-in and using it for a simple export. Integrating an Excel add-in with Sage X3 can be a… Read More »

Use of Transcribe Import/Export template in Sage X3

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 »

Inter-Site Sales Delivery Export with EDI in Sage X3

In the context of the sales order process in Sage X3, this implementation focuses on creating an outbound process for sales orders. Specifically, we aim to enhance the functionality by introducing a new button on the Sales Delivery Screen. This button will be selectively enabled only for inter-site deliveries, which involve transferring stock between different… Read More »

Error “Non-blocking difference“ Error format ZDEPCODE K:20B 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 »

How to export and import landing pages in Sage X3 V12

Sage X3 provides an excellent feature called landing pages or home pages which are very useful for the end-users to set up visual process flows, a visual representation of data for various screens and processes. The data represented on the landing pages helps the user see the overall performance of functionalities and customizations with real-time… Read More »

How to solve warning “Non-blocking difference Warning format PLICRDIDX K10c Sage X3” while importing data through template

Sage X3 has feature to import data to X3 tables through Import/Export template. Users can create template by adding table fields which user has to enter or modify through file which contains data import/export template. Once file imported successfully then file data will inserted in particular table/screen. With the help of this fabulous feature of… Read More »

How to solve error “Non – blocking difference Incorrect date ACCDAT 20210210” while importing data through template

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 »