Standard cost with Periodic Activities

Morilen

Using Nav 5.0.

I am trying to delve into how Navision is determining costs. I have an item which was initially populated with a cost of $26.62. It lists that as its Standard cost (Costing Method: Standard). Now when I drill into the Standard cost its has a whole list of entries at $21.02. This seems to be Average cost, as it is clearly not the standard of $26.62. It also does not seem to be actual as I calculated the actual outside the system and came up with $14.40 using the BOM and a list of the current Last direct costs for those items. The disparity should just represent labor, freight, storage and all those other little things that make up actual cost, but that we do not attach to items in the system. What I don't understand is if the 21.02 is average why it hasn't shifted in a year and a half. It continually uses the 21.02 to represent the cost of the item on our Finished goods account, but it is a Standard Cost item and its standard cost is $26.62. Shouldn't it always force the total item cost to that number by how many units?

The way we do production is in two stages. We have a Formula Bom and a Production Bom. Formula Bom has FIFO items that roll into an Intermediate Fifo item. Which is then joined to Packaging Fifo Items and rolled into the Standard cost Finished Good on the Prod Bom.

As my subject states we do run the 'Adjust Cost Item Entries' periodic activity everyday. I am wondering if that may have something to do with this. Will running that override standard costs and force an average or soem other cost to be used?

Any help would be much appreciated.

kapil4dynamics

Morilen wrote:

Will running that override standard costs and force an average or soem other cost to be used?

No running that never does anything on standard cost (I mean does not change it) but will check if there is any variance to be posted against the standard cost, after running this when u will post Inventory Costs to G/L it will post the variance to the respective Variance accounts.

Kowa

Did you post revaluations?

Morilen wrote:

Shouldn't it always force the total item cost to that number by how many units?

If you have a "standard" item which is only purchased and may also have item charges applied to it, then this is true. Any deviation between the purchase price and the standard cost is posted to the variance account, and the item's inventory valuation and the COGS (if the item is sold) remains to be based on the standard cost. But if you apply a revaluation to this purchase, then you will the see a change in the periodic average in the drilldown, and the COGS will change accordingly if the cost adjustment is run. In manufacturing, instead of the purchase variance you'll have the other variances types (material, capacity, capacity overhead, production overhead,subcontracted). The standard cost is used as the expected cost, and any difference will be posted to the variance accounts when the prod order is finished so that the actual cost matches.

As my subject states we do run the 'Adjust Cost Item Entries' periodic activity everyday.

Don't stop doing that . You might even consider to switch it to automatic. The posting may take somewhat longer then , but you'll get all necessary postings done as soon as possible.