Adjust Cost Batch Error "This interger is too long&quot

anoo

I'm facing an error "This interger is too long" while running Adjust Cost Item Entries batch job.

Does anybody have any clue about it....i have been trying to solve this problem for too long but no luck

Please help

Regds
Anoop

ovicash

Have you used the debuger? Where does it stop?

Waldo

Have there been some modifications on this functionality?
Which version are you working on?
Did you try the debugger?

Miklos_Hollender

It does not really look like an error in the standard. Go to Codeunit Inventory Adjustment in Tools, Object Designer and look at the Modified flag. Maybe also for Codeunit Item Jnl - Post Line. If it is checked, try to find the guy who modified it.

ssingla

I am receiving the following error while running the adjust cost batch job:

The following SQL server error occured while accessing the GL Entry Table:
8115,"22003",[Microsoft][ODBC Sql server driver]{Sql Server}
Arithmatic overflow eror converting expression to data type numeric.

Any help will be appreciated.

Waldo

Have there been some modifications on this functionality?
Which version are you working on?
Did you try the debugger?

ssingla

No modification exist in this functionality. The entry number on which the error appears is a transfer shipment. While adjusting it runs in a loop where the same entry number appears more than couple of times.
We are using Navision 3.7 with SQL server 2000.

Waldo

Strange ... I did a test in a default database without problems ...

Did you try it in a native environment? Take a backup, restore in a fbk (native) and run it again?

ssingla

Thanks Waldo.

Will restore in Native DB and check.
Database size is 6 gb I have no idea how much time it will take to restore. [-o<

Waldo

Does the debugger give you more info on what's going wrong?
When you restored in native, is the debugger pointing to the same issue?

... if all of this is standard NAV, I think you'll have to post a support request to Microsoft through partnersource.

ssingla

Thanks Waldo.

I will see if I get any additional info in the debugger, once the database is restored.
This is weekend, Does MS works on weekends.

Waldo

If you have a very good contract with Microsoft, they do.

We have got a PABS contract (Partner Advantage Business Solutions), and that makes them available 24/7

ssingla

Thanks for your help.
I guess we also have that kind of contract.
Anyway the problem is solved. It was due to exchange rate precision which was set to 0.01. Now it has been changed to 1.00.

Waldo

Perfect =D> .

How did you find this solution?

ssingla

The techie sitting in the head office found it =D> . I will ask him and then explain it here.
May be it help others

abhaydalal8722

please help i am facing the same problem in Navision 4.0.
it will be very beneficial if somebody posts how the solution was found

Savatage

ssingla wrote:

Thanks for your help.
I guess we also have that kind of contract.
Anyway the problem is solved. It was due to exchange rate precision which was set to 0.01. Now it has been changed to 1.00.

abhaydalal8722

i saw the solution but i dont think, that is the problem at my end.

The functionality of Adjust Item cost Entries is now using Cost Element Buffer table and its in this buffer that actual cost is going too long which cannot happen due to exchange rate precision. I am new to navision and finding it very hard to trace if its a data error or code error that is causing this problem ](*,) Please help