Struggling to Bulk Upload “Item Revaluation Entries”? Here’s What Might Be Wrong

-

Introduction

One of our clients had made some small mistakes while providing the data for their opening balances, which caused the item costs to be wrong.
After a lot of back-and-forth, we finally got a list of 100+ items with the correct costs.
We thought it would be easy to fix using Edit in Excel but then we ran into an error:
"Quantity must have a value in Item Journal Line."


But this is odd as when we are creating the entries manually, we don't need to set the Quantity from anywhere.
In fact, the Quantity field isn't even editable, it is populated when the "Applies-to Entry" field is updated.
We tried using Configuration Package.. same thing!
We tried to create an excel import, that uploads data in the journal.. same thing!
So what's going on?

Details

After a bit of debugging we found this piece of code to be the problem - 


And this ->


When you update the "Unit Cost (Revalued)" field in Business Central, it also updates the "Inventory Value (Revalued)" field automatically. This part is simple. But the system also tries to update "Unit Cost (Revalued)" again based on the value you just changed—almost like it’s going in circles.

To avoid this, the system checks which field is currently being updated. If it’s not "Unit Cost (Revalued)", the update is allowed.

When you make changes from the Business Central screen, the system knows which field you're changing, thanks to something called CurrFieldNo. But when you use Edit in Excel, Config Packages, or AL code, this info is missing. That confuses the system and can cause it to divide by zero, which leads to an error.

Also, there’s a rule that checks quantity in the "Applies-to Entry" field. This check only happens if the "Value Entry Type" is not set to "Revaluation".

This was raised back in 2018 on Github as a bug but it was closed as intended system design.

At the end, we had to bypass the validation and assign the values directly to the fields.

Conclusion

What seemed like a simple task updating revalued costs turned into a deep dive into Business Central's internal logic. 
The issue stemmed from how the system handles field updates differently depending on the entry method. 
While the manual interface sets background values like CurrFieldNo to help Business Central track changes properly, external methods like Edit in Excel or Config Packages don’t provide that context.

Comments

Post a Comment

Popular posts from this blog

Event-Driven Architecture: How to Create Custom Business Events in Business Central

-
Image
Introduction Events are notifications that signal something has happened in the system. A record getting created, updated or deleted, a sales order getting posted, etc are all examples of events. An event driven architecture provides asynchrony and decoupled communication between different components of the system supporting flexibility, scalability and modularity. In Business Central, we have two main types of events - Business and Integration. Integration Events are related to things within Business Central. They are use for extending the functionality of the Base Application without modifying it directly. Business Events are related to things outside of Business Central. They are used for notifying external systems (e.g., via Power Automate or Logic Apps) regarding any changes that happen within Business Central. Microsoft allows us to create custom Integration and Business Events based on our requirements. In this blog, we'll see how to create a custom Business Event and...
Read more

Visualizing Data: How to Add Power BI Reports to Business Central

-
Image
Introduction Power BI is a great tool for turning data into clear, interactive reports and the best part?  It works smoothly with Business Central, right out of the box.  You just need to set it up, and you can start viewing powerful reports right inside within Business Central dashboard.  Microsoft provides several ready-made reports, grouped into different apps, so you can pick and install only what you need.  Once set up, these reports help you track key business insights without switching between systems.  In this blog, we’ll walk you through how to set up and use Power BI reports in Business Central to make smarter decisions. References Introduction to Business Central and Power BI Install Power BI apps for Business Central Configuration Open your Business Central and search for "Assisted Setup". Click on "Connect to Power BI" Once the set up page opens, click on Next. Fiscal : A 12-month calendar that begins in any month and ends 12 months after. Standard ...
Read more

Know Your Users: Automated Usage Tracking for Better System Adoption

-
Image
Introduction After a new Business Central system goes live, it’s important to know if users are actually using it the way they should (Go-Live is just the beginning). Tracking usage statistics helps us understand how well the system is being adopted and where improvements might be needed. To make this easier, I’ve created a small utility that automatically collects user activity data and builds a report from it. This saves time and gives a clear picture of how the system is being used to the management. Here’s what it does: There’s a setup page where you can choose how stats are collected and skip certain users (like consultants or support team members who create test data). A configuration page lets you pick which tables to track. You can also set how often stats should be gathered using a frequency field; it even sets up the background job for you. A report which summarises the generated data in a neat matrix. With this tool, keeping an eye on system adoption becomes simple and autom...
Read more