Skip to main content
Solved

Mass Items Change ID with Import Scenerio


Forum|alt.badge.img

Can someone share with me a import scenerio screen shot to mass update item ID?

 

Thanks in advance

Best answer by Terry65

We tried the configuration provided by vkumar, but the results were wrong. The items code that was changed was actually the next record, so verify your results!

Here is our final working configuration using the Change ID action:

 

Thanks.

Terry

View original
Did this topic help you find an answer to your question?

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • January 20, 2022

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.

 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • January 20, 2022

Hi @john25 

Here is one for Inventory Item code change :

Hope this helps,

Regards,


  • Freshman II
  • 3 replies
  • Answer
  • June 9, 2022

We tried the configuration provided by vkumar, but the results were wrong. The items code that was changed was actually the next record, so verify your results!

Here is our final working configuration using the Change ID action:

 

Thanks.

Terry


martingaxiola
Varsity I
Forum|alt.badge.img

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. 


Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 185 replies
  • June 28, 2023

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings