Dynamics Community Forum Thread Details

Not Able To Add or Remove Components from Configured BOMs

Hello Fellow GP Folks,

I really hope someone is able to help me solve this problem. This problem has been going on for 2 weeks now. I am presently running GP 2016 R2. All my engineering folks are having issues working with configured BOMs and this occurs only with Config BOMs. The issue is that, no one is able to delete or add components to any of the Config BOMs. Each time a users attempts to do either of the actions, GP stops responding and they must Ctrl+Alt+Delete to exit. I have searched the database for issues such as "Recursive BOMs" or "Division by Zero" issues and also been through the BMS10000 table and cleared all the BOMs. Found one recursive BOM, fixed it, but the issues still continues. I really don't know what else to try here. Any help, and I mean any help will be greatly appreciated as no help is coming for our consultants.

Categories:

Microsoft Dynamics GP

Hello,

Thank you for using Community Forums. My name is Becky and I will assist you.

This still sounds like some sort of recursive BOM.

1) Run the following 2 scripts and let me know if either return results.

Select * from BM010115 where CPN_I=PPN_I

select PPN_I,CPN_I,BOMSEQ_I from BM010115
where (BOMCAT_I = 1) and (ALTERNATE_I = 0) and ('2006.10.05' >= EFFECTIVEINDATE_I)
and (FLOORSTOCK_I=0) and PPN_I in (select ITEMNMBR from IV00101 where VCTNMTHD > 3)
and (((EFFECTIVEOUTDATE_I > '2006.10.05') and EFFECTIVEOUTDATE_I<>'') or EFFECTIVEOUTDATE_I='') group by PPN_I,CPN_I,BOMSEQ_I having count (*) > 1

2) I'd like to run low level codes. You need to run this in query analyzer against the company database.

exec mbomLLCUtility 110

Then to make sure there are no recursive BOMs check the LLC in IVR10015 with the following script.

Select * from IVR10015 where LLC =’110’

If you get results you have a recursive BOM where the finished good is listed under itself in the BOM and that needs to be corrected.

3) Run the following scripts against the company database and let me know if you receive results.

select * from BM010115 where BOMCAT_I ='1' and BOMNAME_I <> ''

select * from BM010415 where BOMCAT_I ='1' and BOMNAME_I <> ''

4) We can also check to make sure the position numbers and BOM sequence numbers are not duplicated.

select POSITION_NUMBER, PPN_I from BM010115 where BOMCAT_I ='1'
group by POSITION_NUMBER, PPN_I having count (*) >1

select BOMSEQ_I, PPN_I from BM010115 where BOMCAT_I ='1'
group by BOMSEQ_I, PPN_I having count (*) >1