web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Publish is greyed out ...
Small and medium business | Business Central, N...
Answered

Publish is greyed out in edit in excel for Assembly Lines

(3) ShareShare
ReportReport
Posted on by KellyJFrancis 76
Hi there,
 
I need to add variant codes to a very big order, so wanted to bulk add to assembly lines but publish is greyed out? Does anyone know why it would be? I am listed as a Business Manager in Settings so it shouldn't be a permissions issue, I had to filter the results by Document Type before exporting as it exceeded the excel limit. 
 
Hope someone can assist 🙏🏻
 
Kind regards
 
Kelly
Categories:
Dynamics 365 Business Central
Screenshot 2025-0...
I have the same question (0)
  • KellyJFrancis Profile Picture
    KellyJFrancis 76 on at
    Publish is greyed out in edit in excel for Assembly Lines
    Thanks so much, going for the Configuration Package route :) 
  • Verified answer
    Sumit Singh Profile Picture
    Sumit Singh 4,714 on at
    Publish is greyed out in edit in excel for Assembly Lines
     Option 1: Excel Data Connector (Publish Greyed Out)
     Root Causes:
    • Missing system fields (e.g., SystemId, RowId)
    • Read-only page or table
    • Disconnected session context
    • Page not exposed via OData V4
    • Role permissions not sufficient for write-back
     Fixes:
    • Use Edit in Excel directly from the Assembly Lines page
    • Ensure all required fields are present
    • Reconnect the Data Connector
    • Confirm page supports write-back and is editable
     Option 2: Configuration Package (Recommended for Bulk Updates)
    Steps:
    1. Create a Configuration Package
      • Go to Configuration Packages in BC
      • Create a new package and add the Assembly Line table (ID: 900 or custom if extended)
    2. Select Fields
      • Include fields like:
        • Document No.
        • Line No.
        • Variant Code
        • Any other required fields
    3. Export to Excel
      • Use Export to Excel to get the template
      • Fill in your variant codes and other data
    4. Import and Apply
      • Use Import from Excel
      • Run Apply Package to commit changes
      • Optionally run Validate Package before applying
    Notes:
    • Ensure no duplicate keys or missing mandatory fields
    • You can preview changes before applying
    • Works even if Excel connector fails


    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,227

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,866

#3
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans