Skip to main content
Answer

Import Scenario - FS Equipment (Target Equipment) - Update component inventory and serial number

  • May 14, 2024
  • 3 replies
  • 123 views

debbiereed72
Varsity I
Forum|alt.badge.img

Hello Community.  Here’s my challenge to be solved:

  1. Equipment already exists (FS205000) 
  2. When importing the equipment, Component records automatically added per the model equipment configuration
  3. I need to update the components with Inventory ID and Serial number
  • I get an error because the import is trying to create new records and you can have only one per component ID.  My import scenario references the line number and the component id but still doesn’t update that row.

What am I missing?

Thank you

 

 

 

 

Best answer by Manikanta Dhulipudi

HI @debbiereed72 

Your Import scenario should contain @@component ID= [Component.ID)

 

Similar to shown below 

 

3 replies

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

HI @debbiereed72 

Your Import scenario should contain @@component ID= [Component.ID)

 

Similar to shown below 

 


debbiereed72
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • May 14, 2024

@manikantad18  Thank you for such a quick response.  This is still returning the same error “Some errors related to the quantity of the components occurred.”

 


debbiereed72
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • May 14, 2024

@manikantad18 - got it! Thank you for your help!

And.. this document was a big help as well: Acumatica Import and Export Scenarios Tips and Tricks (eis.consulting)