Validate item price during SO import

Importing Sales Orders (MAS 90 4.4 PU6) and need to compare item price from source file against the price MAS 90 is using (based upon established price levels). Can't use File Assign for numeric temp fields, and trying to use a string temp field for this purpose always yields zero. Goal is to put order on hold if unit price in source file is not same as what MAS 90 is calculating. Last resort is to import source value into UDF and write script to compare actual price to UDF, but I'd rather perform this task during the initial import. Any ideas on accomplishing this in VI? TIA.

  • I believe you can do a Calculate though to grab the UnitPrice after you have assigned Division, Customer, Order Date, Price Level, Unit of Measure Conversion Factor and Order Quantity.  You have to go into the Expression Builder.  On the left should be listed the available tables you can pull fields from.  Find the Sales Order Detail and get the UnitPrice.

  • Thought I tried that, but guess not. Thanks.