Skip to main content
Answer

Change ID Import Scenario off by one line item

  • May 8, 2024
  • 4 replies
  • 226 views

dguild
Freshman I

I’m trying to change all of my Non-Stock Item Inventory ID Numbers to have “NS-” in front of them.  When I run my Import Scenario the first inventory Item does not get changed at all.  The second inventory item gets renamed with the New Inventory ID I had for the FIRST item.  All subsequent items get similarly renamed with the next Inventory ID in the Data Provider - all off by one record.     

Any ideas? 

Best answer by Laura03

Hello,

Did you notice this previous post with an example of how to change Non-Stock Item ID’s?

The Original Poster states they originally encountered the same problem as you:  the next item ID changed. They later posted their solution:

Laura

4 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • May 8, 2024

Hello,

Did you notice this previous post with an example of how to change Non-Stock Item ID’s?

The Original Poster states they originally encountered the same problem as you:  the next item ID changed. They later posted their solution:

Laura


dguild
Freshman I
  • Author
  • Freshman I
  • May 8, 2024

I had not seen that post, thank you!  It works now!


ed.goodman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • May 10, 2024

@dguild 

I was able to update non-stock item IDs with the following scenario mapping.

Hope this helps.

Ed


dguild
Freshman I
  • Author
  • Freshman I
  • May 13, 2024

Thanks, Ed - That’s very similar to how I ended up solving it.  Thanks for the confirmation!