Issue Description - Item List page is opened using Edit in Excel and the Standard Cost for Items with Costing Method = Standard are changed. On clicking 'Publish' to update the modified Standard Cost in the database, the Standard Cost reverts to its original value.
No error message is displayed. Message to user = Publish been successful!! Serious limitation when you intend to use the Edit in Excel tool to mass upload changes to standard costs without knowing that all changes were reverted but Excel telling Publish was successful.
When the Standard Cost of an Item (having Costing Method = Standard) is updated from the front end a Confirmation window will pop up to confirm the changes: The Cursor is by default is placed on 'No' Tab in the Confirmation window. To implement the changes the User has to move to 'Yes' Tab and press enter. So when the modified Standard Cost is Published from Excel, the system encounters this Confirmation message and as there is no confirmation of the change, it reverts to the original value.
This is one field in this table but there might be others where user expects their changes got published (message received published successful) when clearly this was not the case.
Suggestion to provide solution to trigger message, bypass validation or remove fields that cannot be updated using Edit in Excel.
Comments
This really needs to be addressed. Apparently this is due to a Confirmation message that would normally pop up when the change is manually done requiring a Yes/No response that the user does not have the opportunity to respond to. It just assumes a No response, but then informs at the conclusion of the publication that Publish has been successful. This is terribly dangerous. At the very least, it should error and stop the process, and indicate it as such. Please vote for this.
Category: Office Integration
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team