Amount 921,840.0463902 needs to be rounded in G/L Entry Entry No.='4496558

Business Central/NAV General Discussions
1

Hello guys, A user was trying to post Fixed asset disposal transaction in the FA G/L journal this error keeps coming up.
Amount 921,840.0463902 needs to be rounded in G/L Entry Entry No.=‘4496558’.

and couldn’t find the transaction amount 921,840.0463902 in G/L Entry table
Debugger traced it CU 12 InsertGLEntry function

WITH GLEntry DO BEGIN
TESTFIELD(“G/L Account No.”);

IF Amount <> ROUND(Amount) THEN
FIELDERROR(Amount,STRSUBSTNO(NeedsRoundingErr,Amount));

UpdateCheckAmounts(
“Posting Date”,Amount,“Additional-Currency Amount”,
BalanceCheckAmount,BalanceCheckAmount2,BalanceCheckAddCurrAmount,BalanceCheckAddCurrAmount2);

UpdateDebitCredit(GenJnlLine.Correction);
END;

TempGLEntryBuf := GLEntry;
TempGLEntryBuf.INSERT;

NextEntryNo := NextEntryNo + 1;

IF CalcAddCurrResiduals THEN
HandleAddCurrResidualGLEntry(GenJnlLine,GLEntry.Amount,GLEntry.“Additional-Currency Amount”);

If anyone has seen this issue, please need a clue

Thanks in advance

2

Alemayehu,

What does Unit-Amount Rounding Precision value state?

Thanks,

Steve

3

Thanks for your reply

Unit-Amount Rounding Precision 0.001

4

Alemayehu,

My gut tells me that this Asset was loaded with multiple decimal places, maybe using Excel, and not cleaned up before posting. The only solution I know is to remove the bad Amount, in the FA Table, and reenter the correct Amount. The issue would disappear. You will need your Partner to assist.

Thanks,
Steve

1 Like
5

Steven

I couldn’t find any values with messed-up digits there. In any way, Since I have a developer license I will try to re-enter the amount on the FA table and see how it goes.

Thanks for your tip

6

Steven

I tried to tweak the code:-

IF Amount <> ROUND(Amount) THEN
Amount:= ROUND(Amount);

the transaction was posted without a problem on a test DB.

Even if I am not a dedicated developer, I think this will solve the issue. Open for suggestions and corrections.

Thanks again.