When configuring certain Blocks in a TIBCO Scribe® Online Map, you can use the Matching Criteria tab to specify one or more fields in your Source and Target data to be used by TIBCO Scribe® Online for a one-to-one record match.  For example, Delete, Update, and Update/Insert Blocks require Matching Criteria to find the record in the target data, if any, that corresponds to the current source record.  If a match is found, the data in the target is updated or deleted.  If no match is found, either nothing is done or a new record is created in the target depending on the Block being used.

When using Dynamics GP as a target, to use a percent field as a match criteria field , the value passed to the percent match field must be in the format that the percent is stored in the Dynamics GP database.  For example, the Dynamics GP UI shows 1.25%.  It is stored in the Dynamics GP database as 125.  You need to pass 125 to find a matching record.

However, if you insert a percent into Dynamics GP and want it to be 1.25%, you must pass a value of .0125 because the web service multiplies the value you pass by 100 as it inserts it into Dynamics GP.  If you pass 125 to the web service, an error is generated indicating that you have passed an invalid value and it must be between 0 and 100.  If you pass it .0125, the Dynamics GP UI displays 1.25% and the Dynamic GP database  stores it as 125.

How to use percent values in match criteria for or updates to Dynamics GP.