Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import Template for Pr...
Small and medium business | Business Central, N...
Suggested answer

Import Template for Production Bills of Material

(0) ShareShare
ReportReport
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

  • KellyJFrancis Profile Picture
    KellyJFrancis 57 on at
    Import Template for Production Bills of Material
    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
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Import Template for Production Bills of Material

    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.

    pastedimage1626897944933v1.png

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

    Thanks,

    Steve

  • CMTang Profile Picture
    CMTang 60 on at
    RE: Import Template for Production Bills of Material

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

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Import Template for Production Bills of Material

    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.

    pastedimage1609768027787v1.png

    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

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Import Template for Production Bills of Material

    Hello,

    Happy New Year.

    Maybe this helps.

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

    Thanks.

  • Community Member Profile Picture
    Community Member on at
    RE: Import Template for Production Bills of Material

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

  • Suggested answer
    darcnus Profile Picture
    darcnus 235 on at
    RE: Import Template for Production Bills of Material

    UseDynamics has a video:

    usedynamics.com/.../

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,110 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,886 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans