Filter
Top Products
Mapped Queries
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