Adjust Cost Entries Problem???

kish2007

Hi,
Iam using NAV4.0SP3 with SQLServer DB. Iam running Adjust Cost - Item Entries report. but one item it going to infinite loop. for example Item1 has 4 ILE's (like 100,200,300,400). when i run this report it shows in th dialog box first entry as 100 and second as 200 and next 300 and next 400.after completing 400 again it is coming to 100,200,300 etc.

why this is happnd???

Thanks & Regards,
Kish...

kwalker0412

We have seen this happen when the item no. has special characters in it. Unfortunately, NAV allows the characters when creating the item, but when trying to filter it causes issues. So check all the item #'s

We tell our clients not to use !@#$%^&*()'"? in the item no. value...

Hope this helps!
Kelly

darshanm

Namaste!

Check below things

1. If there is any item with blank No. in Item table

2. if you are using Avg. costing method then you need to delete
the data in T 5804 for the item, where costing Batch goes in endless
loop

3. Note the entry no. where costing batch goes in endless loop

4. Go to Item ledger entry(T32) and find the item no.

5. delete the rows from T5804 for that item

Note : Try this in TEST DB first.

kish2007

Hi Guys,
Thanks for your replies. I checked the all items.
There is no blank record in item table.
I face the problem with Item Number: P27904102
and also there is no special characters in all items.
I deleted the Item number(P27904102) in T5804.
Again iam getting same problem(Endless loop). We are using Average costing method.

how can i solve this problem???


Thanks in Advance,
Kish....

darshanm

Namaste!

There is one workaround.

Ask your technical consultant to put the Item OR Category filter
in Adjust Cost batch job. So that time bein you can skip that item
and complete the batch run for other items.

Normally in case of Avg. Costin method this problem comes.
After deleting the records from T 5804 for that item it should have worked,
becuase this solution has been given by Microsoft to me.

if still problem comes post the incident on Microsoft website.

kish2007

ThankQ Darshan,
I will try...




Regards,
Kish...