hello everyone,
i am trying to adjust some items cost where i get this message.
Why is the batch job is filtering on this period, as i know if you adjust an item you adjust all value entries, you can not put a date filter. so where is this “specific” date range is coming from?
My BD is 5.0and using average costing
waiting for a replay.
Regards,
Waleed
What filters are / were entered for the function start?
hello,
Sorry i didn’t understand what you wrote
Regards
When you start the Adjust Cost Item Entries routine do you enter filters or values - to select the Item or Dates?
yes, i filter on some items, but i don’t filter on dates, the batch job don’t have the option to filter on dates (only Item & Item Category)
Regards
Run the debugger to see where it stops.
well, i am not a developer so i don’t know how to debug, but i have a very fresh developer i’ll see what i can do with her, but if anyone can give us an idea what to look for, please do.
Regards
Waleed
You need to try and identify which item it is stopping at. You can then analyse that items entries and see where the problem is.
Out of interest, is this a new install or is it an upgrade from an older version?
Andrew
If I may add a suggestion - when the process stops and error message appears, if you drag the error box out of the way, you should be able to see the “in progress” dialog box with the the Item No., level and maybe other data which might help you to understand where the process is stopping.
I see now that you already showed the dialogs and nothing is showed in progress box, as if the error occurred before the actual proccess started. On the other side you already know the Item No. since you filtered by it. You should check the entries in that range of dates. There might be entries out of sequence.
hello there,
Well i have checked the entries for the items that are giving the message (2 items out of 25,000 item), and the transactions seems fine.
i’d like to ask something, my “AVerage Costing Period” is set up to week, so my understanding that closing entry date will increment by week in the “Average Cost Calc. Overview” if there is entries in this week date range, if no entries it will increment by 2 weeks and so on (i mean it should always increment by week), but in this window i find sometimes increment by 3 days and sometimes by 10 days, so what is the logic behind that.
so the message is giving me a date filer of 29/12/08…31/12/08, i don’t have item ledger entries or value ledger entries or a closing entry that ends with 31/12/08 in the “Average Cost Calc. Overview”, so where is the batch job is getting this filter from, where it sees that it should adjust entries in the date range of 29/12/08…31/12/08 but it don’t find any value entries and i think that’s where the conflict is coming from.
i hope i was able to explain this in a clear way.
Regards
i want to say another thing, on a test compay i went to the value entry table and i changed the valuadion date of the last transaction in Decemeber from 27/12/08 to 31/12/08, and when i run the Adjustment batch job it was fine as it sees now value entry in the date filter 29/12/08…31/12/08 that it is asking for, but i don’t like doing that, and am not sure how it will affect my costing…any advice ?