Acumatica Import Scenario

Hi ​@zaidiasim 

I tried testing without using Template Items and still got the results you expected. Meaning " if the value being imported already exists as a Template ID, the row is not imported"

Best Regards,

NNT

Hi ​@zaidiasim 

I tried testing without using Template Items and still got the results you expected. Meaning " if the value being imported already exists as a Template ID, the row is not imported"

 

Best Regards,

NNT

Thanks NNT

The template id and information thereof is being “updated” e.g. in my data file (Excel) I have Inventory ID Segment Setting values. Import scenario is adding duplicate line. Please see screenshot, I imported same file twice instead of skipping the item row Template ID is updated:
 

I have tried adding following formula in Import Scenario on Source Field Value:

=IIF([LOOKUP("InventoryItem","Template ID",[Inventory ID]) == "", [Inventory ID], NULL)'

But it is not working.

Hi ​@zaidiasim were you able to find a solution? Thank you!