Tag Archives: Import Export Template

How to upload employee records using txt file in Sage X3 People

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 »

How to increase the range of product serial numbers while creating Miscellaneous Receipt through import/export template

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 »

How to invoke Import/Export Template through Webservices

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 »

How to get template name through coding while using Import/Export Template

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 »