I want to import the unique customer records using import scenario.
I want to skip the existing records & insert only non existing records.
The record skip logic should be execute on “CustomerID”.
Best answer by mikeschmitt81
View originalI want to import the unique customer records using import scenario.
I want to skip the existing records & insert only non existing records.
The record skip logic should be execute on “CustomerID”.
Best answer by mikeschmitt81
View originalYes, Acumatica check the Key and if the record exist then it updates the record.
I don’t want to update the record instead of update it should skip the record.
On your stock item import, remove the checkbox for <ACTION: CANCEL> and see if it works, as well as the <LINE NUMBER> checkbox for the -1 value.
Is there a resolution to this? I am trying to do something similar with Project Tasks. I have tried to use target restrictions, but I have not figured out a way to not update existing records.
OK, I figured out something that works for me. I set up a target restriction. In my case I looked at the status of project task and told the system to only process records with a certain status.
I am wondering if for this topic if you set a target restriction to CustomerID is Empty which should only allow you to add new records.
This worked for skipping existing stock items by setting the Inventory ID Field Name Condition to ‘Is Empty’ on the Target Restrictions tab of the import scenario.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.