Cannot dispose of fixed asset due to 12 decimal precision asset value

(0) Share

Report

Posted on by Len C

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?

I have the same question (0)

All responses (11)

Answers (1)

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Are you running any customization in your installation or is it a clean BC online you are running?

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Len C 149 on at

Like (0)

Report

There are a few customizations, but nothing related to the GL or Fixed Assets, only Jobs and Sales Invoices

Was this reply helpful? Yes No
Len C 149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Len C 149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Len C 149 on at

Like (0)

Report

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."

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

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;

}

Was this reply helpful? Yes No
Len C 149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No