Inventory Bill of Materials

(0) Share

Report

Posted on by Community Member

Hi Everyone,

I'm fairly new to Microsoft Dynamics GP and hope to get some help around here. My question regards to Inventory Bill of Materials. My organization has a lot of BOM and the contents/components happen to be changed/updated frequently based on inventory availability as well as current incentive promotion. The current process I was trained is delete any old items and add new ones as needed. We have been doing fine with that. But what I'm concerned is we don't have the BOM history as we removed all the old components. I have tried to set obsolete date on the old components but they still show when I attempt to run BOM Smartlist.

I have been researching quite a while but have not find any proper related source/information/instruction. Is there any of you have expertise on this area? P

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Bill Campbell 12 on at

Like (0)

Report

Hello - just wanted to be clear - are you having a problem with the BOMs or do you want assistance in a different way to manage what you are doing?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bill,

That is what I was trained. I don't know if it is a problem or not. It seems fine as it shows what included in components. However, I don't feel very comfortable to delete old SKUs and add new SKUs like that, which essentially we don't have history of the BOM.

I am seeking advises to see if our current way is right or is there any better way.

Thanks,

Christina

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

There is no such thing as an historical bill of materials. The closest you come is reprinting the assembly transaction postings. One thing you could try is to create an SSIS job that runs once a day and copies the current BOM on that day to another table with a date stamp. What exactly are you doing? Are you leaving the original components on the bill but marking them as inactive? If you have Smartlist Builder you could create a SQL view to not include those inactive items.

Was this reply helpful? Yes No