Hi - is there a report that details which items have had their standard cost modified or updated for the entire year? If NAV does not have a canned report, anyone know if the information can be extracted from SQL? What table should I be looking at to write a query.
Thanks!
Phil
Hi Phil,
There are no canned standard reports, which will show you this.
Changing the standard cost field on the item card is not different from any other changes to an item. If you like to register changes, then you could enable the change log for the item table. This would allow you to register both all changes, or just changes to the standard cost field.
Also notice that there used to be an issue, where changes done by functions (like updating standard costs from the standard cost journal) would not be registered in the change. I think this issue was solved in NAV 2009, but maybe someone else remembers if it still was an issue in NAV 2013.
But then you could do a report based on the change log entry table. Have a few clients, who have an audit report based on multiple change logs.
Unfortunately Navision doesn’t really support Standard Cost. If you want to correctly use Standard cost you need to create your own code to do so. You would need to create a Standard Cost register that tracks when the Standard Cost is updated. You need to look at Codeunit 8512 for calculating std cost and 5804 for updating. Then you would also need to look at whether you need to create a Cost adjust routine to apply the revaluations. and then track them.
We did implement Standard Cost for a client once, but it was a lot of work. After that where a customer needed standard costing, we simply set Navision to FIFO and then ran a standard costing routine in parallel that maintained the standard cost by date and then linked this to the Item ledger entry by date and calculated the cost based on this and manually posted to the G/L.
It is quite annoying that they finally fixed Average cost, but completely ignored Standard.