on 10-18-2008 2:36 AM
Hi,
We created several Assembly BOM's back in 2005A. We have since upgraded to 2007A and would like to change these BOM's to Sales type. Currently there are no open sales orders for these BOM items.
When I try to change the type and update, I get the error, "BOM Cannot be changed, open work orders were found." I assume this is referring the the old terminology for production orders (for which there is also nothing currently open). Is it possible to change the BOM type?
Hi Allen,
Kindly go through the Note no 974631. This delas with this error message.
Regards,
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon,
We have actually never posted any production orders. So, not suprisingly, running 'Select * from OWOR T0' does not return any results.
Hi Varun,
Even running the query mentioned in the SAP note does not retrieve any results. Yet I am still unable to change the BOM type. Any other ideas?
Another possiblity could be locked by Sales Order. Even though you have no open orders, you may have closed order locked them up. Check the RDR1 table by:
Select * from RDR1 T0 Where T0.ItemCode = '[%0\]'
If you can not find this item used anywhere, it could be a bug. Log to SAP support will be your only choice then.
Thanks,
Gordon
Fortunately for us (maybe), we only have about 3 months of history for these parts. What would you recommend is the best way to go about managing the old BOMs after the new ones are created?
The first thing that comes to mind is making them inactive from the item master, and then changing the item description so end users are not confused by duplicate items when choosing from any item list. I believe doing so will not affect the descriptions in any previously posted documents. Any other suggestions on how to keep the records as clean as possible?
Hi Allen,
The error message means you need to query OWOR table to fund any work orders associated with those items.
You can use very simple query as:
Select * from OWOR T0 Where T0.ItemCode = '[%0\]'
You have to cancel those order in order to change BOM type.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.