Does anybody know if 3.6 manufacturing has a periodic activity that allows you to perform the Item Calc Standard Cost function on a batch basis (i.e. lots of items at once)? A previous posting to this forum suggested such a periodic activity option did exist in 2.x Manufacturing but I cant find anything similar in the current 3.6. Thanks in advance, Chris.
Hi Chris The update standard cost routine, as I understand it, is from the item card where you have a BOM, and can be run for one or all levels. I believe this only does it for the item you are in, and no filtering exists to open this up. Of course you could find the routine and remove the filter, but if you run the routine for all items it could potentially loop for ages updating the costs of structures already updated as it finds each one in turn. Sorry I think this is controlled on an item-by-item basis. The update unit cost routine in manufacturing only updates the open produciton lines I think.
No, it does not… but it was not hard to create one. The only thing you’ve to take care are the errors, so you have to make your code to skip the generic errors on an item and if it’s having an error just jump to the next one. I was having to create such functionality for a customer on 3.10 a few weeks ago. Regards,
Hi Alfonso Not it does not me or no it does not him? [:D]
Sorry, Steven… when i was starting my reply yours was not yet on my screen…[:D].So answering your question: his one.
Hi Alfonso I thought as much from the timing - thought I would chreck though! Have a good weekend.
The standard cost calculation can also be run for all items by running teh revaluation journal in 3.6. Choose the Calculate inventory with the option of calculate per item with Update Standard cost
oops clicked submit too early continuing on… Update standard cost turned on. And the Standard Cost Manufacturing as the calculation base. This will calculate for all items. Using the item card to calc standard cost when there is inventory for the item can be problematic resulting in item ledgers with mixed standard costs. While I have been told by Navision this is a feature (which it is) the porblem is now that when you finish production orders you can not assume your production variance is from a qty variance it may be from consuming an item ledger at an old standard cost. If you use the item revaluation journal to recalculate the standard cost the system will update all of the item ledgers with the old standard costs.
Hi Steve, It is both good and Bad. Some companies would not want to revalue their old transaction but only want to have a new cost from the point of calculation. Yes it is true that Navision Variance does not split between Cost and Qty. It is cumulative. But good thing is atleast calculates correctly. I remember there was a lot of problem in the earlier versions.