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

UseDynamics has a video:

usedynamics.com/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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 on at

Like (0)

Report

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

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

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

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

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