Mass Items Change ID with Import Scenerio

Hi @john25 

The Change ID action, I have done for the Customers screen and was working as expected.  Could you please try for the Stock Items screen and verify.

Please find the screenshot below and let me know if you have any queries.

Hi @john25 

Here is one for Inventory Item code change :

Hope this helps,

Regards,

Hola @Terry65 ,

Thank you so much for your answer, I did the Client import as explained in this treat, and also got results incorrect, here is my Customer ID change:

Thank you for your import, as I base the customer import on yours. 

Can we change the marked answer dated 1/20/2022 please? It does not work with the current builds and actually wrecks your system. It processes the NEXT record as your New ID:

For example:
OLD ID  -  NEW ID

       1     -      2

       A     -      B

The marked answer ends up changing A to 2 instead of 1 to 2 and A to B. The 6/9/2022 answer from Terry65 is the right answer.

I get the error: “object reference not set to an instance of an object”. Does anyone know why?

​@angelacmagnumtool - You’ll need to paste a snippet of your import scenario friend! It’s likely some seemingly trivial box that isn’t checked or field that’s missing in the import. If you post your import rows as shown above, we can look into it with you!

Here it is, thank you. I attached the Data Provider too. It might not be the issue, but I can’t see why it doesn’t work when I used the same logic. I also tried it with the Action at the end like the examples in this post and it gave the same error. 

Actions and responses feel very backward in Acumatica and you have that problem here.

in your import it should be ordered as followed:
OLD ID
NEW ID
DIALOG = OK
ACTION - CHANGE ID

When an action gets called, it looks for pre-stored data. You called your action before storing an ID and a repsonse to be passed over to that action. So if you can drop your action call down two lines, you should see better results.

Sorry, I just saw you mentioning that you’ve put it in the order above. Let’s assume you matched Terry65 perfectly. The other issues could be one of the following:

1. Your OLD ID is invalid, has a whitespace in front of it or something
2. Your NEW ID is an ID that has been used previously (The NEW ID has to have never existed in your tenant before)

I’ve goofed on both of those before...

Is anyone able to share their import excel file and XML for this import scenario?

Have this sorted and working using the screenshots above & a bit of trial and error. Thank you