Small and medium business | Business Central, N...

Import Template for Production Bills of Material

(0) Share

Report

Posted on by Community Member

Hello:

Is there a " template" that can be used for importing production bills of material including line items into Business Central?

John

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

darcnus 247 on at

Like (0)

Report
Copy link

Link copied!

UseDynamics has a video:

usedynamics.com/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, but I need to know how to create such import templates - not just import them.

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Happy New Year.

Maybe this helps.

docs.microsoft.com/.../production-how-to-create-production-boms

Thanks.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

John Ellis,

Happy New Year. Try a Configuration Package. Below are some screen shots of one I always use. I have attached the actual configuration package so you can import.

Now, you can remove the extra fields you are not populating to make the No. of Fields less. I always do. After you have the fields set, use the Export to Excel so you can populate and then import back. REMEMBER to Import the Header first, then Lines.

https://1drv.ms/u/s!AmRbkPn9LCQZnkqihp4BsdMhkc1k?e=Qb5vCv

If you need a sample excel sheet, write back.

Thanks,

Steve

Was this reply helpful? Yes No
CMTang 60 on at

Like (0)

Report
Copy link

Link copied!

Hi .. I am new to D365, how could i get the Production BOM import template in excel?

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (2)

Report
Copy link

Link copied!

Hello,

You can create a Configuration Package that includes the Production BOM Header and Lines. This can be exported, off the Configuration Package page, to Excel. Each Table (Header and Lines) will be a tab in the spreadsheet.

Do you need a sample of one? Feel free to answer back and I can send a sample one.

Thanks,

Steve

Was this reply helpful? Yes No
KellyJFrancis 84 on at

Like (0)

Report
Copy link

Link copied!

I know this is an old post but can I please have a sample excel with the two tabs so I can see how it looks? :)

Kind regards

Kelly

Was this reply helpful? Yes No