Error: There is an integer that is too large

Malajlo

I'm displaying inventory quantity on a list and could not determine, what is causing this error.
Value that should be displayed is 2.444.555,88 (FlowField type decimal...)
Currently to bypass error, value is divided by 1000 so it represents tons instead of kgs.
So there is no integer... Hmmmm

ara3n

Have you tried optimizing the Item Ledger entry?

Malajlo

Tried but it does not solve the problem.
Strange thing is that inventory on Item card displays normaly.
Only the flowfilter is different.
I'll leave it as it is...

Thx after all

ara3n

Disable all the enabled secondary keys.

and re enable them.

kine

Did you tried to enable debugger to see if the error is in some C/AL code? May be that somewhere the decimal is assigned into integer or rounded etc...

Malajlo

It should be a bug.
I must calculate qty on item entries with date filter (valid from-to) and linked to some kind of permission code (added field). SumIndexes are added, FlowField is decimal (what is integer doing here!?) and values are represented properly in decimal. After qty exceed some value, error apear. I havent tested the "limit" but it looks it is at 2^21 (2.097.152)

Filter on T.32 is nothing special...
Field Filter
Permission 160
Entry Type Positive Adjmt.
Item No. 070304
(Permission is new filed)

darshanm

Namaste!

1. Take the entry No. where error has occured
2. Go to ILE and take the item no.
3. Delete the entries from T 5804 for Item showing in the error.

IF STILL ERROR IS COMMING

4. Check the value entries. Identify the value entries generated frm Transfer transactions
where Posting date and Valuation date is different. change the valuation date equal to
posting date.