VI Import Job update field based on 0

Question

Hello Everyone, 
 
 I am trying to updated the "Hold Payment" field for our Vendors with an import file that will contain Vendor code and a number. The number will act as a switch for the Hold Payment field, so if it's a 0 then N, if greater than 0 then Yes. 
 
 I've tried using a Tempfield to read the column and the Hold Payment to read the temp and set either Y or N but have gotten no success. Any tips is greatly appreciated.

David Speck · Accepted Answer

Make sure your temp field's data type is set to "Number", assign temp on "Key Assigns Only", and check the "Clear on each Record" option. 
 Add the hold payment field twice. Set each operation to "Assign". 
 In one, set the operation to "Assign", set the default to "N", and the condition set to "Temp001=0". 
 In the other, set the operation to "Assign", set the default to "Y", and the condition set to "Temp001>0".

Sage 100

VI Import Job update field based on 0

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING