Allowance to import duplicate items in SO

​@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!

Hi ​@Naveen Boga ,
I tried the below:

Still gave me the same error.

​@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.

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

hi ​@Naveen Boga , any lucks on this one?

​@Harry The key is not to use Inventory ID as the identifying/key field for the Sales Order detail line when the same item can appear more than once.

Check if line nbr can be executed here.

Hi ​@Harry  Here is the working import scenario for the Sales Orders. Can you please review and modify accoridngly?

hi ​@Naveen Boga ,

Thanks a lot for sharing the XML. Can you please confirm if the below is the mapping to be considered?

​@Harry Please modify the Source Field or Value column from your uploaded spreadsheet and verify this in the Import by Scenario screen.

Hi ​@Naveen Boga ,

Thanks for sharing, however the error still triggers. Since I’ve been trying to also add the quote# under relations tab, it is triggering the issue.

​@Harry I’m not sure which values you modified. First, could you please confirm whether you have verified this using the Import Scenario that I shared above?

hi ​@Harry ,

Can you check the below ? Hope this helps!

 

Hi ​@hsethia25, Thank you for sharing this solution. It worked!!