Microsoft Dynamics GP (Archived)

How to import BOMS into GP?

(0) Share

Report

Posted on by Raymond Damphousse

165

How to load BOMs into GP - other tthan manually entering?

Seeing Integration Manager does not integrate to BOMS, does anyone have any experience with using DTS to import these?

What should I be aware of?

Thanks

Ray

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Please review my answers in this post

community.dynamics.com/.../92889.aspx

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Raymond,

If you are speaking of regular BOMs (vs manufacturing), I use the Table Import function within GP. There are only two tables involved - BM00101, the header and BM00111, the components.

Table import is the 'data slam' method (no validation), but it's quick and easy :).

Kind regards,

Leslie

Was this reply helpful? Yes No
Raymond Damphousse 165 on at

Like (0)

Report

Thank-you both,

Both answers are relevant. To begin with, it will be to BM00101 and BM00111.

But then to MFG BOM, when we go down that path.

Thanks

Was this reply helpful? Yes No
Raymond Damphousse 165 on at

Like (0)

Report

Leslie,

After using import import, I have noticed that the status needs to be changed before the "View Indented Bill" function is available. Do you experience the same thing?

Ray

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Ray we are on the same page here. Just did a upload of 3,000 records - created table for header and then for components - got good results I think from the import.

No errors on the header

Several from the Components due to missing comp items for the BOM - so my error

However issue - like Ray - is that when I go to BOM Maintenance I do not see any new records.

I tried Checklinks and this only kicked out some of the header records that did not have comp items and noted several Active BOM's with out UofM attached.

Suggestion on what we need to do to see the records.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi all,

I'll take a look at this tomorrow. We had thousands of these things and i know they have been using the BOMs for over a year so i will need to revisit it. Are the four status fields being populated properly?

Kind regards,

Leslie

Was this reply helpful? Yes No
Raymond Damphousse 165 on at

Like (0)

Report

Bill, i thought the records were not there either because when using the lookup, the imported BOMS don't show up, however if you use the VCR buttons at the bottom left, the records do show up..

Leslie, the only field I am not populating in the import is the Note Index.

Thanks

Ray

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

So are we good, or are there still some issues?

Was this reply helpful? Yes No
Raymond Damphousse 165 on at

Like (0)

Report

if the only thing I need to do is activate all the BOMS I am okay. But if you did not have to activate the BOMS, I would be interested to find out what I am missing.

Thanks

Ray

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Ray when I did the import (table) I set the status to 1 - Active rather than pending - since I thought that if needed I would simply in SQL use the delete and get rid of them on mass if there was a problem.

Even when entered Active it does not change the Lookup.

My question is why is that they do not populate the Lookup? I did the VCR button and that in fact brought into view the 3200 BOM's forced on the system. Any idea how to get the Lookup to show?

Was this reply helpful? Yes No