We developed import scenario for Stock Item. We need to add entry for Cross Reference as well.
This works fine when we are adding new record.
When we try to update entry by providing same data it update stock item without any error.
But not cross reference.
Import scenario is design like this.
Best answer by lauraj46
Hi
In that case, it might be simplest to split this into three different scenarios (one for each different alternate ID type).
Laura
+8Hi
Since you’re changing the Alternate ID, you need to do a lookup based on the old id. Use <Line Number> = -2 to delete that existing row. Then insert the new entry. If nothing is found, it should just insert the new row.
In the scenario below you would change ‘OldID’ and ‘NewID’ to be fields from your data source.
Hope this helps!
Laura
+8Hi
See corrected scenario below. You don’t need the line with <Line Number> = 0.
Hope this helps!
Laura
Hi
See corrected scenario below. You don’t need the line with <Line Number> = 0.
Hope this helps!
Laura
We do not have old and new id in excel.
We have value only. If same it should be updated else insert. (Alternate ID is primary key).
If we have same inventory id then it will automatically update but not this cross reference.
+8Hi
Sorry, I’m not quite following. If you are not changing the Alternate ID, then which field are you trying to update? I don’t see any other fields in your import scenario.
Hi
Sorry, I’m not quite following. If you are not changing the Alternate ID, then which field are you trying to update? I don’t see any other fields in your import scenario.
We have three columns for different alternate type. Some have value some are blank.
So blank value need to skip.
+8Hi
In that case, it might be simplest to split this into three different scenarios (one for each different alternate ID type).
Laura
Hi
In that case, it might be simplest to split this into three different scenarios (one for each different alternate ID type).
Laura
I added checking condition in custom data provider. I cannot find any way for “upsert” operation in Acumatica.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
