Currently we upgraded one of our client from 4.0 to SP3. Everything seems to work fine but the Adjust Cost - Item entries seems to take a considerably longer time than it did in 4.0. Database is SQL 2000.
Previously when they used to run adjust cost - item entries in 4.0 at the end of the day, it took round about 15 - 20 mins to complete the job. Currently it takes 40 - 45 mins. There is no significant increase in the number of transactions it is more or less the same. Is it because of changes in codeunit - Inventory Adjustment or due to something else?
Is it possible to filter by item and then run Adjust Cost - Item entries report?
Thanks.
0
Answers
are u using manufacturing? BOM?
Yes it's possible to filter on items, but you have to write the report.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
can you provide some hint on how to go about filtering Items? Thanks.
There is still a bug in it, we ran into it with a client. The adjust cost runs into infinite loop. You get an overflow error in native client, and sql insert statement on sql because the amount field greater than 2^32-1 value.
I will post an example on how to filter on items.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Looking forward for your example on Item filter. Thanks.
Add a new function
Modify function InvtToAdjustExist(VAR ToItem : Record Item) : Boolean
as follows. The SETCURRENTKEY("Cost is Adjusted","Allow Online Adjustment"); can be also change for performance if you are running on native. The key would depend on filters you are setting.
Modify report 795 Adjust Cost - Item Entries.
Add a new dataitem Item table.
Add the following code to the onprereport trigger
Enjoy
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Thank you so much. =D> =D>
[/quote]
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I am new bee to navision and technical. I want know that process. I tried what u mentioned above. But i could not solve. Totally this is my mistake, because i am fresher. Please explain the process detail what are variables i need to define and what functiones i have to write and where to write.Please give some detail explanation. While u put solutions please think about freshers like me.I hope u can explain.......
I will be waiting u r valuable solution to me........
thanks and regards
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
We migrated from Navision SP1 TO SP3
We also faced the problem,adjust cost item entries is running more than 2 days still it is running.There is no end at all.
After seeing the Mibuso i got the solution of running for the particular item.
Now we suggested our client to run for the Particular FG or Inventory Posting Group.
Because in the Fresh Sp3 we are ACIE for all item in the master.
In this case
For example only i am running Adjust Cost Item Entries for my Finishgoods,in this my doubt is system will only consider the finish good only or under the all sfg and rawmaterial.
Under the Finishgood i have so many Simifinish good items and rawmaterial also. I selected Costing method as Average cost ,Then my average cost will vary means how the system will consider.
Pls guide me .... ](*,)
This mod is similar to modification in 5.0. I would run the adjust cost for components first and then for finished goods.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
hi thin, i've read your post about adjust costing,
i want to know, whether the long process time (that you mention) of AC is solved by running AC per item?
or is there a particular item that caused an AC seems to take forever?
cos right know i have this issue, one particular item is causing a problem in AC, cos it takes a very long time (havent finished in two days).
i use the solution here to exclude that item. it works wonderfully
but the problem still exist. i cannot AC this "troubled" item.
any suggestion, how to deal with this issue?
err yeah, i used NAV4.0 SP2.. and already upgrade the CU5895 to SP3
Here I have faced the long process time for running the ACIE for all items and after seen the solution from the mibuso now we are running for the particular item only.It is working fine,we are not facing any problem at all.
Now we are running for the particular item and also the Inventory posting group wise.
Regards,
AN.THINAKARAN.
hix, so you're not in the same boat with me
so, nobody've been thru dat before in NAV4?
I have applied this modification to 3 clients. It works fine on each.
Two of them are running Mfg.
You need to run and filter by raw material first. Once you've run adjust cost for all raw material, then you need to filter by sub-component if you have multi level BOMS.
Last you'll run adjust for finished goods. Now if an particular item is running adjust for 2 days, it could be related to sp2 having adjust running into infinite loop.
You have to debug that. Or at least look partner source knowledge base.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
seems like i have to bite the bullet by debugging it
but many thks for the suggestion ara3n:D
Still i am facing the problem while running the ACIE(Adjust cost item entries).I selected the particular finishgood item in item filter.Then i run the report,But it is considering all the item while running and also the process it is not at all completing.
What is the problem i didn't know.
Pls throw some suggestion.
I am also facing two probs in Costing batch job. We have added
the filters in Adjust Cost batch job.
1. runs into endless loop
=> For a specific item.
2. Error "There is an integer that is too large 130,38900......."
=> For a specific Items.
If anybody has got the solution on this, then please reply
Senior Consultan
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
in request filter of item dataitem.
Var Name DataType Subtype Length
Yes L_Item Record Item
Is this correct that this L_Item should have the Checkmark for the Var column?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Sorry. I've forgot adding Item as a dataitem. I can select an item now.
But It works for all items still even I select a specific Item.
Any idea?
I think the problem is about vairable declaration.
Concerning the following code block;
SetupItemFilter(VAR L_Item : Record Item)
//T001 Start
gRunItemFilter := true;
gItem.copyfilters(L_Item);
//T001 End
What should I declare gItem and gRunItemFilter as? I declared gItem as a RECORD and gRunItemFilter as a BOOLEAN.
Am I wrong?
I put a thick on VAR column for function parameter L_Item. Now It works.
Thanks goes to ara3n.