Solved

Adding Operation ID line to import scenario creates Key: OperationCD when I want Line Number=-1

  • 25 January 2024
  • 3 replies
  • 63 views

Userlevel 5
Badge

Setting up import scenario similar to out of the box ACU Import BOM. But I can’t seem to add the Operation ID → Operation ID line without it adding the <Key: OperationCD> field. I need the <Line Number> = -1 field, same as ACU Import BOM.

 

What am I doing wrong here? I want to add lines for these operations, not key on them to add materials.

 

ACU Import BOM - Out of the Box

 

Me - unable to add Operation ID line without the Key line above.

 

icon

Best answer by jwarren 26 January 2024, 20:24

View original

3 replies

Userlevel 6
Badge +6

What exactly are you trying to accomplish?  Inactivating the OperationCD as a key in an import scenario could potentially resolve the issue if OperationCD is not necessary for the operation you are trying to perform. In Acumatica, the key fields are used to identify unique records for updates. If your intent is to insert new records rather than update existing ones, then OperationCD might not need to be a key field.

Userlevel 5
Badge

I’m just trying to add four operations/Work Centres, with associated line details (run units, run time), to the BOM. 

 

001 - Work Centre A

002 - Work Centre B

003 - Work Centre C

004 - Work Centre D

 

I don’t believe that OperationCD needs to be a key field (because I’m trying to add these lines) but I’m unable to delete it or prevent the row <Key: OperationCD> from being included when adding the line below it Operation ID = Operation ID.

 

And I’m scratching my head because I can see the out of box scenario ACU Import BOM is able to add the operation ID = operation ID without the <key> field without any issues.

 

I’ve tried inactivating the <Key> line but import by scenario giving error.

 

 

 

Userlevel 5
Badge

Looks like this worked just fine - not sure I was getting the error originally

 

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved