Adjust Cost - Item Entries Error

sendoh

Hi all,


when I run adjust cost in Financial Mngt -> Costing -> Adjust Cost - Item Entries it blows me an error
"There's an integer is too large 801,010,000,000,000,000". any idea why this happen?

easabangan

Ricky boi,

Costing problem.... aheemmmmmm....

Try to disable all the keys in the value entries table. Then re-enable it one by one.... maybe the problem is in the SIFT.

girish.joshi

The root cause can be one of two things:

SIFT problem as mentioned above.

Some kind of infinite loop.

Either way, depending on your version of Navision, it may already be fixed. What version are you on?

sendoh

Try to disable all the keys in the value entries table. Then re-enable it one by one.....

I do this but the same error i've mentioned above occurs again...
we're using SQL2000 and NAV4.0SP3..any idea?tnx...

easabangan

Have you been through debugging the program? Look for the second cause mentioned by girish.joshi.

sendoh

yes I run it...
it stop in the calculation of the "Actual cost" in table(5802 cost element buffer) because the value of "actual cost" field is too large -98,231,748,291,487,285,900,000,000,000,000,000,000,000,000,000,000,000,000,000,000
is this is a standard bugs? other idea plz.. #-o

easabangan

Look for the history of the item, then figure out what triggers that figure. It is a time consuming thing but it is just one of your choices actually....

ar4ijs

I have run in to the same problem! Sendoh, did you find any solution?

sendoh

on our scenario they did'nt post the purchase order so that when you run that batch job the calculation will be wrong.

take a look of there orders if did they post it....

girish.joshi

That should not cause this problem. What makes you think that is what caused the issue?

darshanm

I am also facing the same problem. Did u find the solution for
this?

darshanm

any updates

darshanm

have anybody found solution on this problem?
Please reply

](*,)

darshanm

Hye Guys,

I got the solution for this. This error normally comes in case
of Costing Method = Average

Solution=> Got to T5804, filter on item No. and delete the entries
for that particular item.

You should first try this in test database and keep the copy of
record from T5804 in excel sheet.

Cristina

Hi,
I had the same problem for the average cost method.
I think I found how to resolve but I'm not so sure if is 100% correct.
The procedure enter into a cycle because it never return TRUE when check EarlierEntryPointExists in function AdjustInventoryCost.
So, I did the following modification:

In table 5804 in function EarlierEntryPointExists
instead of

EXIT(
GET(
AvgCostAdjmtPoint."Item No.",
AvgCostAdjmtPoint."Variant Code",
AvgCostAdjmtPoint."Location Code") AND
("Valuation Date" < AvgCostAdjmtPoint."Valuation Date"));

I put

EXIT(
(AvgCostAdjmtPoint."Valuation Date" < "Valuation Date")
AND
GET(
AvgCostAdjmtPoint."Item No.",
AvgCostAdjmtPoint."Variant Code",
AvgCostAdjmtPoint."Location Code"));

And in codeunit 5895 in function AdjustItemAvgCost I add the command DELETE if not SkipLoop is TRUE

IF NOT SkipLoop THEN BEGIN
.............................
.............................
the standard code

END ELSE
DELETE;

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.