Notifications
Clear all

3451548 - Different warehouses in transactions of Assembly BoM components

1 Posts
1 Users
0 Likes
32 Views
admin
Posts: 341
Admin
Topic starter
(@admin)
Prominent Member
Joined: 3 years ago

Symptom

Assembly Bill of Materials (BoM) is used in a document, the component's warehouse differs from the parent item's warehouse displayed in the document line.

Reproducing the Issue

Scenario 1:

  1. Create 3 new items as below:
    S1000: Sales item (only Sales Item is ticked on Item Master Dada header), no default warehouse (whse).
    S2000 and S2001: Inventory item, sales item, purchasing item (Inventory ItemSales Item and Purchasing Item are ticked on Item Master Dada header), set whse 01 as default in Item Master Data > Inventory Data tab.
  2. Create a new Assembly BoM: S1000 is the parent item, items S2000 and S2001 are the components. Note, the whse in the component rows is 01.
  3. Create a Sales Order, select the BoM S1000, default whse in row is 01, change it to 02 then system message shows: Do you want to set this warehouse for component items as well? Choose "No" to keep the component items' default warehouses defined in the BoM, choose Yes and the committed transaction will use whse 02.
  4. Now go to Administration > Setup > General > User Defaults, create a new User Defaults, go to Defaults tab, set Warehouse as 02 (under the Defaults tab). Then go to Administration > Setup > General > Users, locate user 'manager'  and choose the newly created user defaults in the Defaults field, then click Update.
  5. Log in as 'manager', create a new Sales Order and select the Assembly BoM S1000. The default whse in row is now 02 (as we set default whse 02 for the user). Add the document and see that the committed transaction used whse 01 for the component items. 

Scenario 2:

  1. In continuation of the previous scenario, go to the Item Master Data of item S1000 (the parent item of Assembly BoM). Set whse 05 as default and update the item.
    • Just a reminder:
    • Assembly BoM default whse for component items is 01.
    • Parent item default whse in Item Master Data is 05.
    • Default whse set in the User Defaults is 02.
  2. Create a Sales Order and select the Assembly BoM S1000.
  3. The default whse in row is 05 (as set in the Item Master Data of S1000).
  4. The committed transaction for the component items used whse 01 (as set in the Assembly BoM for the component items' rows).

Scenario 3:

  1. Create an Assembly BoM with one component, set the whse of the component as whse 01.
  2. Create a Sales Order for the BoM with whse 01.
  3. Create Goods Receipt for the component to receive quantity 6 to whse 01 and quantity 12 to whse 03.
  4. Go to Pick Pack and Production Manager - Open drawer, the Avail. To Release field for the Sales Order is 6.
  5. Open the Sales Order and change the whse of the BoM to 03.
  6. A system message will appear: Do you want to set this warehouse for component items as well? Choose "No" to keep the component items' default warehouses defined in the BoM. Choose Yes.
  7. Check the Avail. To Release field in the Pick Pack and Production Manager again, the quantity is now 12.

Resolution

This is correct system behavior.

By default, the warehouse that is used for any kind of inventory transactions for component items of an Assembly BoM (committed/posting), is the warehouse that is set in the Bill of Material window - component items' rows.

The warehouse represented in the document row by default does not affect the warehouse used by the components in the transaction.

In order to change the warehouse of component items, either:

  1. Change the warehouse of component items in the Assembly BoM window
    OR
  2. Update the parent item's warehouse in document line. System will ask Do you want to set this warehouse for component items as well? Choose "No" to keep the component items' default warehouses defined in the BoM, choose Yes.
Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security