Sage 100

End user contacted me about wanting to use conditional If/Then logic to import a SALES ORDER NUMBER into Sales Order Entry field based on the value in a temp field. Similar to: ifTemp003$=""ipad"" then ""P""+Temp002$ else ""W""+Temp002$ Where Temp002$ is the Sales Order number he has read in Usually I just do two conditionals and import twice to the field with the last time being the more specific import. However I don't think I can import to the key field here - - SO Number -- two times. At least the end user is saying it's not working. Anyone have to tackle this type of thing?

make sure on the temp value you have it set to Key assigns only I'm not sure that you can't import twice (it seems like I have done that before) but if that is the issue, then you can still use 2 lines on the import, just make sure only one of the two conditions succeed so that your not importing twice first sales order number action Calculate ""P""+Temp002$ - Set this condition to If Temp003$=""ipad"" second sales order number action Calculate ""W""+Temp002$ Set this condition to ""if Temp003$<>""Ipad

Thanks ! The ""Key Assigns Only"" was the trick that made this work.