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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Business Central Copying and Pasting rows in planning lines leads to error-Version 28.0

(6) ShareShare
ReportReport
Posted on by 1,021

 

Hi All,
 
So is a fix available for the copying and pasting using Edit in excel option from the BC browser screen?
I would like to say though The pasting is possible  now with just a blue warning saying some data might be truncated.
is this like a patch that Microsoft has placed recently?
 
 
 
Regards,
Indira
I have the same question (0)
  • Suggested answer
    AndrewThomas81 Profile Picture
    2,294 on at
    Target version fix is 28.0.50510.0
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
  • Indira88 Profile Picture
    1,021 on at
    Our current version is  US Business Central 28.0 (Platform 28.0.50706.0 + Application 28.0.46665.51097)
     
    Though we are able to copy and paste we get an alert .So just checking .
    Thanks
    Indira
     
     
     
    Find answers in the Help
    Read the blog
    See which cion: US Business Central 28.0 (Platform 28.0.50706.0 + Application 28.0.46665.51097)
     
  • Suggested answer
    YUN ZHU Profile Picture
    102,389 Super User 2026 Season 1 on at
    This issue is still on the list of known issues and may not have been resolved in all regions.
     
    Thanks
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    18,239 Super User 2026 Season 1 on at
    Hello Indira,
    I don’t think Microsoft has documented this as a specific recent patch, at least not from what I have seen in the public docs. Copy/paste in the BC web client is supported on editable lists, but the page/table design can still block or limit pasting, and the blue warning about possible truncation usually means BC accepted the paste but is warning that one or more field values may exceed the allowed field length. So I would treat it as improved/changed behavior in the current client, but not assume it is fully fixed for all pages. Best practice is to test the same paste in a sandbox, check if any values were actually shortened, and if the issue is inconsistent or page-specific, raise it with Microsoft through a support ticket.
    Regards,
    Oussama Sabbouh
  • Indira88 Profile Picture
    1,021 on at
    @OussamaSabbouh@YUN ZHU , @AndrewThomas81  Thank you for your replies, appreciate it.
    So for now we are progressing with the acceptance that there is a partial fix with the blue notification leading to atleast letting us paste the data. However I would wait for the complete fix for this that is to how its behavior was before with no error or anything.
     
    Regards,
    Indira
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    17,045 Super User 2026 Season 1 on at
    Hello,

    Yes, this is likely the result of a recent Business Central platform improvement rather than a specific fix applied to your environment.

    Microsoft has enhanced the Edit in Excel experience so that users can often paste data directly while receiving a blue warning that some values may be truncated if they exceed Business Central field limits, instead of having the paste operation blocked or fail silently.

    If the data is successfully publishing back to Business Central, the warning is generally informational and indicates that the system is checking for potential field-length issues while still allowing the import to proceed.

  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    2,735 Super User 2026 Season 1 on at
    Hi,
    what you describe sounds less like a fix and more like the normal paste behaviour, the blue truncation warning is the platform telling you some pasted value is longer than the field allows and it will cut it to fit, not an error blocking you. So the paste going through now with just that info bar is expected, it is not stopping you, it is warning you a field might lose characters.
    From what I seen the hard block people used to hit was different, things like you cannot paste X rows in 1 row, or invalid value stops the paste, those are about column order or the page not being empty, not truncation. The truncation one has been there, it just lets you proceed. I have not seen a specific recent Microsoft patch announced just for this, more likely you are on a newer version where the message is friendlier than a hard stop.

    So I would not treat it as fixed, treat it as working as designed, but do check the fields that warned, if a description or code got cut you want to know before posting. Are you copying straight into a list with Ctrl V, or through Edit in Excel and publish? And which value is it warning on, because if it is a key field like a No. getting truncated that is worth catching, a long description less so. What BC version are you on?
     
    Glad to help - follow up if anything is unclear.  
    ►  If this solved it, marking it verified helps others too.      
    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

     
     
     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 653 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 414 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 394 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans