Solved

Combining Duplicate Line Items on SO Import


Userlevel 2
Badge

Hello Everyone,

I am working on a SO Import and ideally I would like to have the least amount of lines possible on the sales order. For instance, let’s say my data provider has 8 lines for a cheeseburger, is it possible to combine those 8 lines into one?

For instance combine the asparagus and cheeseburger lines into one:

 

icon

Best answer by vkumar 16 May 2022, 05:38

View original

5 replies

Userlevel 7
Badge +12

Hi, @podonnell11  You can add the @@InventoryID before the <Line Number> in your import scenario as shown below.

which will check for the InventoryID, and if it already exists it will go and update the same line and pass the proper qty for the line.

 

 

Userlevel 3
Badge

What type is your data provider?  If it perchance is SQL, then you could create a view in SQL to combine items before your import scenario runs.  Just a thought.

Userlevel 2
Badge

Hi, @podonnell11  You can add the @@InventoryID before the <Line Number> in your import scenario as shown below.

which will check for the InventoryID, and if it already exists it will go and update the same line and pass the proper qty for the line.

 

 

This does not seem to add the 2 lines together, it just takes the second line.

 

What type is your data provider?  If it perchance is SQL, then you could create a view in SQL to combine items before your import scenario runs.  Just a thought.

CSV File.

 

 

 

Userlevel 7
Badge +8

Hi @podonnell11 

I don't see an option to achieve this on import scenario. You may find a way to get the data merged at database provider / source file level. 

The option @Naveen Boga suggested does help overwrite a line if the item code is same. But it wont add the quantity to the existing line, instead overwrites with new line with same item code. So post import, it will keep the last line with that item code. 

Hope this clarifies,

Regards,

 

Userlevel 2
Badge

Hi @podonnell11 

I don't see an option to achieve this on import scenario. You may find a way to get the data merged at database provider / source file level. 

The option @Naveen Boga suggested does help overwrite a line if the item code is same. But it wont add the quantity to the existing line, instead overwrites with new line with same item code. So post import, it will keep the last line with that item code. 

Hope this clarifies,

Regards,

 

Thank you for the confirmation!

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 — 2020  Acumatica, Inc. All rights reserved