Skip to main content
Question

Allowance to import duplicate items in SO

  • August 21, 2026
  • 5 replies
  • 48 views

Forum|alt.badge.img

Hello all,

I have an import scenario to create SOs from quotes and there are scenarios where the same item might exist in the quote before converting to an SO. Now upon running the import, since Acumatica would find duplicate values (Item IDs), it stops the routine. Any ideas how can I allow the routine to import the duplicate Item IDs in the single order?

 

 

Kindly suggest.

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • August 21, 2026

@Harry The import scenario uses <Key: OrderType> and <Key: OrderNbr> as the document keys, but for the line level there is no explicit line key defined. Acumatica defaults to using InventoryID as the line identifier, so when the same item appears twice, it thinks it is the same line.

Fix: Add a key field for the line using the quote line number to uniquely identify each line:

<Key: LineNbr> (Transactions.LineNbr)

Place this key before the InventoryID field in the line section. This tells Acumatica to match lines by line number, not by item,  so duplicate items are treated as separate lines.

Hope this helps!


Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • August 21, 2026

Hi ​@Naveen Boga ,
I tried the below:

 

 

Still gave me the same error.


Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • August 21, 2026

@Harry  Can you please share the XML format of import scenario here, so that I will review from my side and will get back to you.


Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • August 21, 2026

@Harry  Can you please share the XML format of import scenario here, so that I will review from my side and will get back to you.

HI ​@Naveen Boga ,

here is the XML of the import.


Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • August 21, 2026

Thanks for sharing ​@Harry  I will take a look and let you know.