Mahmoud said,
"The Highlighted line with red is missing the Sales Order No. and Line No.,
The terminology of Edit in Excel in Business Central requires a Line No. as the blank line no. the system will not understand where to add?
Also, because you're trying to publish a SO, hence also the system needs to know which SO?
To solve your issue simply fill in the missing data Sales Order No. & Line No., or just delete the red line.
Very Important note: if you're using Business Central cloud, you don't need to configure Centralized Deployment as it's made only for On-Prem.
"
Mahmoud,
I marked the Document No. and Line Number fields with the correct information. Unfortunately, when I try to Publish those entries are deleted by Microsoft. The error is that they are read-only fields and we are not allowed to edit them.
Zhu Yun replied
"
Hi, I did the same test in my test environment and had the same problem as you.
I don't know what the reason is at the moment, I will continue to look into it.
Hope other experts can give you better advice."
It seems like a Microsoft error with the Upgrade.
You mention that
"
Very Important note: if you're using Business Central cloud, you don't need to configure Centralized Deployment as it's made only for On-Prem.
"
I didn't see that in the documentation. I'll need to look into that. However, I did deploy BC Cloud/Excel as individual and still got that error. The underlying AL Code shows Document No. and Line Number as Read-Only fields.
