it appears the custom amount mapping yields a string value in some cases and throws an error on the bc api. workaround is to multiply it by 1 to force a numeric value and set data type to number.
take note that SKU should match. When there are matrix child items, use the following formula for the SKU column in the search. CASE NVL({parent},'0') WHEN '0' THEN{displayname} ELSE SUBSTR({itemi...