You’re offline. This is a read only version of the page.
149
We get the following errors like the following trying to dispose of certain fixed assets using the FA G/L Journal:
Amount 2,560.405400109589 must be rounded in gL Journal
Notice the large number of decimal places. The VAR that migrated our FA's last December put the first depreciation record in with this value: 256.424599890411
I ventured to round the current asset value, using the FA G/L Journal. The system does not let you enter fractional pennies.
I ventured to round using the same configuration package the original VAR used. He used FA Journal Lines (not FA G/L Journal). Two issues with that: Upon package import, the Amount is now rounded to a penny. I'm not sure how he got those fractional pennies in in the first place. Second issue: Also, the system no longer let's you post depreciation or acquisition to use FA Journal, it is saying the FA G/L Journal is required. The FA G/L Journal doesn't like fractional pennies.
Efforts to cancel or correct the original high-precision deprecation only result in compensating entries that are rounded to a penny. The fractional pennies remain.
Our current VAR is having trouble getting Microsoft to respond, diagnose, and provide recommendations. It seems like everyone is too busy.
Any idea how to fix this? Or where to get help?
UPDATE: Dynamics BC 19.1 seems to have fixed a feature that cures this! This feature appeared in 19.0, but was not working.
When you open any FA Card, a message at the top of the card indicates you have the issue: 'There are Fixed Asset Entries with potential rounding issues.'
Clicking 'See more' leads to a new page 'View - FA Ledger Entries with rounding issues'. Selecting the issues of interest and choosing 'Accept Selected' rounds the desired entries
Looks like Microsoft quietly provided a solution.
If I remember correctly, the early version did not round the amount. It took whatever amount in excel to BC and that is the one causing the issue. Not sure if it's already fixed or not. After I had that issue, I always make sure to round it in excel, so I don't know if configuration package is already fixed or not.
Thanks, Teddy. We are looking into this.
The thing bugging me is that the initial high-precision depreciation entries were loaded with a configuration package for table 5621 FA Journal. For whatever reason, I cannot use the same package - or a new one with table 5621 - to import Amounts with fractional pennies. MBC always rounds the Amount to a penny.
If we could repeat what the consultant originally did, we could simply use a config package to round asset values to a penny (with either a Depreciation entry or an Acquisition Cost entry).
Maybe something changed in MBC.
You need to put the permission inside the object. Otherwise, you will not be able to update it.
Example below:
codeunit 63005 "Update FA Ledger"
{
Permissions = tabledata "FA Ledger Entry" = rm;
procedure RoundingFA()
begin
end;
}
Today, we found this warning in the top of a few FA Cards: "There are Fixed Asset Entries with potential rounding issues. See more"
Clicking on brings up this list which promises to post corrections to round off the pennies:
But when we try to 'Accept Selected', even with SUPER, we get an error stating a license restriction is in place:
I tried creating a Permission Set with direct-Modify to TableData: FA Ledger Entry, but get the same error. Examining Effective Permisisons, shows a 'Conflict' on the table, with the details "The user has been given the permision for the selected object, but their license allows them only Indirect permission."
We'd have to get our VAR to develop that.
Today, something interesting showed up...suggesting that license restrictions would not allow us to use any such custom permission. I'm replying to the main thread here with that information.
You need to do dev.
Create a codeunit to update your FA Ledger Entries. You can put a permission there to allow you to modify the table.
Upload your app and run the codeunit function.
Thanks. Yes, we need round out the FA asset value. You cannot change posted Ledger Entries though. How did you do it?
We've tried various journals (FA Journal, FA G/L Journal) both directly in the UI, as well as by importing journal lines through configuration packages. No matter which way, the line Amounts end up getting rounded to a penny. So it cannot take care of the fractional pennies.
Had the same issue a few years ago. It is due to the Fixed Asset balance not being rounded and imported correctly in the first place. Your current Fixed Asset Book Value now contains more decimal than needed.
When you try to dispose, BC try to round out the disposal amount. Because your book value (not rounded) and disposal amount (rounded) are not equal, you get that error.
What I did was check and round FA Ledger Entries amount to the rounded amount. After that, you should be able to post disposal.
#1
Sohail Ahmed
807
#2
YUN ZHU
764
Super User 2025 Season 1
#3
Mansi Soni
529
Share
Report
All responses (
Answers (
