Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Not Able To Add or Remove Components from Configured BOMs

Posted on by 10

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:
  • RE: Not Able To Add or Remove Components from Configured BOMs

    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

    If this does not resolve your issue, please let me know

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans