Navision 4.0 Sp3 - There is an Integer that is too large

parthiv

When our client try to run Adjust Cost - Item Entries in 4.0 Sp3 they get the error message

"There is an Integer that is too large" 554,136,842,413,086, 924 (followed by more than 3 dozen zeroes).

Using Debugger , able to find out the Item causing the issue.

Item Detail
The Item uses Average Cost , Replenishment >> Purchase.
In the Inventory Setup , Automatic Cost Posting >> true , Expected Cost Posting >> true and Average Cost Calc Type >> Item & Location & Variant

Anybody encountered this issue earlier? Do you know what is the cause of the issue and how to rectify it?

Thanks.

Zephyr

If value is going to more then its data size(4 bytes) then you have to use BIGINTEGER Data Type (8 bytes).


For more details ::
http://msdn.microsoft.com/en-us/library/dd338759.aspx
http://dynamicsuser.net/wikis/navdev/what-field-types-can-i-use-in-navision.aspx

parthiv

Hi Zephyr,

Thanks for the reply.

I haven't customised any thing in the Adjust Cost - Item Entries, I think the program goes through infinite loop and assigns a huge value to "Actual Cost" field in Tbl 5820 (Cost Element Buffer). I guess it's not an issue with datatype, it's the infinite loop that is causing the issue.