Sage Software Welding System MAS 500 User Manual

Mapped queries are used to import data from the ERP system into Sage SalesLogix tables. 
Mapped queries can be related or unrelated queries, to the Sage SalesLogix Account. 
Related queries are used to define data that is related to the Account through the Account 
Reference.  

Unrelated queries are used to import general data from the ERP System into Sage 
SalesLogix that is not related to the Account, i.e. defined available payment terms. The data 
table must be selected from the list of available tables. After the data query and the data 
table have been selected the Map button can then be used to define the field mappings of 
the data from the data query. 

 

 

The field mapping grid allows the 
user to define the field mapping of 
the data selected from the query. The 
user can also define the key fields 
which will be used to locate existing 
records for updating. The Source 
Change Field and Destination 
Change Field are used to define 
fields from SalesLogix and the ERP 
System to check for change from the 
previous execution. If the value of 
both fields has not changed, the data 
mapping will not take place, which 
can increase data query 
performance. 

 

Page 33 of 45