There have been many posts regarding Costing errors in Navision & we ourselves have had our NSC impliment the “Costing Hotfix/Upgrade” or whatever you would like to call it 2 yrs ago. for those not familiar we are talking about the Valutation not matching the g/l & so forth.’ We rarely run the valuation. 1)because it’s 900 pages when it’s done 2)it takes forever! it’s easier to use Crystal or create a new report that simply multiplies Qty on Hand * Cost. But the Valutaion allows you to go back in time an pick a specific date. Which is what the bank is looking for right now for their yearly audit. Problem is, now that I see this Valuation report i see it mentioning AVERAGE COST. When the update/upgrade/hot fix was installed we were told to simply “HIDE” the “Average cost” field on the item card because it was not giving the correct value but to use the “Unit Cost” instead. So can assume this report is not giving us the accurate info we are looking for? During the “Fix” was a new Valuation report part of the fix that we just never got? …Thoughts…? Thanks.
Average cost can always be an issue in Navision and probably other systems. If you go into negative stock then you can get problems. As far as the UK system is concerned the Inventory Valuation report doesn’t even consider average cost unless your item is set up to use it; it works from the method for which the item is set up. In my view if you want to produce a report that can be back-dated then you must run it from the Value Entries table where the real costs and values are held and which shows the date of any changes to the stock value. In this way you can produce a report that shows the value of an item at any point in time. This does assume that you are on V3+. Your point about reporting value as Qty on Hand * Cost is pretty simplistic and would only give you the value as at this point in time and will definitely not match to the value in the GL.
quote:
Your point about reporting value as Qty on Hand * Cost is pretty simplistic and would only give you the value as at this point in time and will definitely not match to the value in the GL.
Originally posted by paul crinson - 2005 Oct 12 : 04:42:48
It is simple, but we need to know what we have “right now” 99.9% of the time. It’s the auditors[}:)] that like to go month by month once a year. We use FIFO on our item card.