Skip to main content
Solved

Import scenario to change Alternate Type in Cross-Reference

  • 29 December 2022
  • 4 replies
  • 367 views

Forum|alt.badge.img

I have several hundred products where the Alternate Type should be set to Vendor Part Number but it is incorrectly set to Barcode. I’m trying to create an Import Scenario to correct these in bulk but when I attempt to import it is adding a new line instead of altering the line:

 

Here’s a screenshot of my Import Scenario:

 

Any suggestions how to fix this so it doesn’t add a new line?

Best answer by mikeho

Thanks, @manikantad18

After some trial and error I was able to combine the delete/reimport cross reference processes into a single import scenario:

 

Still would have preferred to be able to just change the Alternate Type (rather than delete the line and reimport) but this will have to suffice.

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

4 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • 76 replies
  • December 29, 2022

Hello @mikeho ,

Could you please send a screenshot of Import By Scenario screen and the values you have in the data provider or export the scenario to XML and attach it here?


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • December 29, 2022

@riglesias,

Is this what you need?

 

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @mikeho 

Here is the my thoughts.

Delete the Incorrect Cross reference date using import scenario and re import the cross reference data using another import scenario.

Attaching both  import scenario for reference


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • Answer
  • December 30, 2022

Thanks, @manikantad18

After some trial and error I was able to combine the delete/reimport cross reference processes into a single import scenario:

 

Still would have preferred to be able to just change the Alternate Type (rather than delete the line and reimport) but this will have to suffice.


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