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 »
In Sage X3 People for uploading and updating records a user should use the Import functions to either add a new record or update an existing records. Below is the navigation for import functionality.Navigate: – Usage -> Imports/Exports -> Imports Usage Screen To upload employee data by using standard functionality below are the steps to… Read More »
A serial number is a series of characters that have been assigned to each product in the warehouse so that it remains separate and are identified in the warehouse system. Using serial numbers, you can easily track the location of goods in the warehouse. While trying to import file for creating miscellaneous receipt for serial… Read More »
We might know how to create new sales order transaction using Import/Export Template.Let us see how to invoke template through web services to create new sales order. STEP I: Create Import/Export Template for Sales order. Navigational Path:Setup->Usage->Import/Export templates.Example:ZSOH template created copy of SOH. STEP II: Create Import/Export Template for Sales order. Navigational Path:Setup->Usage->Import/Export templates.Example:ZSOH template… Read More »
We might come across the scenario to find template name through the mask. We can also access using standard table name(AOBJEXTD) with abbrevation[AOD] and field name EXT. Refer to the screenshot below: Write code below in specific script ‘YPEIMPBIS’ of import/export template. Example: $Action Case Action When “IMP_OUVRE”:infbox “Script Name:”+num$([F:AOD]EXT) EndCase return The result is:… Read More »