Solved

How to Automatically add an item to an order when a specific item is ordered.


Hello, I’m looking to automatically add an item to an order when a certain item is entered on a sales order.

An example would be: User enters item ‘X’ on the sales order, and item ‘Y’ is automatically entered after it.

This is useful for promotions or when we’re trying to sell certain products together. It’s easier for our sales team if there could be some automation, instead of manually entering these items each time.

 

Thanks

icon

Best answer by Naveen Boga 14 May 2021, 18:14

View original

13 replies

Userlevel 6
Badge

I have a similar need.  This would be a very helpful feature for us. 

Userlevel 4
Badge +2

I would go at accomplishing this using a new screen/DAC/table to keep track of the items and what needs to be added, and then a graph extension that extends SOOrderEntry to trigger on SOLIne_InventoryID_FieldUpdated to check for the item, and then add it if it does not exist. I can whip up a customization project/video example.

@krichardson If you have an example or video I could see an example of the set up, that would be wonderfully appreciated. Thank You!

Userlevel 3
Badge +1

We have done this with a business event that triggers an import scenario

Userlevel 7
Badge +17

Hi @bimckenzie,

There are 2 cases here.

In the above-provided example, If the “Y” item is a free item, then you can configure the discounts (Discount by Free Item) as per your requirement so that Acumatica will take care of adding the Y adding as soon as you add the X item. Attached screenshot for reference.

 

If the above option does not work, then we need to come up with the below customization.

-- In the Stock Items screen, create a new field “Add Item” with the Inventory Selector field. 

-- For the X product, you can select the newly created field as “Y”

-- In the Sales Order screen, we need to have logic/customization in place, like when the user is adding the X item then the “Y” item has to add.

-- Also, we need to have customization is in place for the X item deletion also.

 

Hope this helps!! 

Userlevel 7
Badge +11

Hi @bimckenzie 

In addition to the suggestions given above, 

  • You can explore the Non stock Kit item setup to bundle the items you would want to sell. Here is relevant documentation link:
  • This does have limitation to dispaly the components at document level. You may explore customization to display the components in required format at document level.

https://help-2021r1.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=56813a1a-d769-48f9-a4fc-1041e81dbfad

 

  • You can use Promotional discount option to add free item, if the item is a free item. 

Here is relevant documentation reference :

https://help-2021r1.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=78b11114-4206-48a5-8d7a-f86d257730c5

Hope this helps,

Regards,

Userlevel 6
Badge +4

Is there a way to limit shipping the free item if the regular item is not in stock? 

 

We do not want to use the Ship Complete option since the order may contain other items that need to ship first

Userlevel 4
Badge +1

@Naveen Boga In 22R1 we do not have this option of “Free Item”. We only see “Percent” and “Amount”
Is there a particular version this was introduced? Or is it part of a specifc module?
 

 

Userlevel 7
Badge +10

@Ellie  I believe that you just need to enable the Free Items in the Enable/Disable Features screen.

Best,

David Eichner, CPA

Userlevel 4
Badge +1

@DavidEichner That option does not exist as far as i can see.
 

Userlevel 7
Badge +10

My apologies.  It is part of the Related Items feature.  You should be able see that one under inventory.

Best,

David Eichner, CPA

Userlevel 4
Badge +1

@DavidEichner That was it! Thank you very much.

Userlevel 3
Badge +1

Discount must be set as Group

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