Khue Trinh: Adjust Standard Cost of Item

[Blog bot]

Источник: http://khue.spaces.live.com/Blog/cns...A0C2!426.entry
==============


 
If you are sunning standard cost for an item, recalculation needs to be run after adjustment of item std cost.
Test:
Go to Inventory Management/Items, select item OL-TrainCost_STD, make sure that Inventory Model Group is set up with STD, which is standard cost price.

Make sure that you don't have anything in stock, this is just not to confuse the test result.
Go to tab Price/Discount, make sure Cost Price is set to 30.

Now create 1 purchase order of 10 items. Post PO invoice and check the cost amount of the transaction by go to purchase line, Inventory/Transaction. The cost amount is 30*10 = 300.
Go to Item Master, select item OL-TrainCost_STD, change the standard cost price from 30 to 32.
Create another PO with of 10 items. Post PO invoice and check the cost amount of the transaction by go to purchase line, Inventory/Transaction. The cost amount is 32*10 = 320.
Now you have on-hand quantity as 20 in stock and the value of your stock is (10*30)+(10*32) = 620
Create a Sales order with 5 items. Post Sales Invoice and check the cost amount of the transaction by to to sales line, Inventory/Transaction. The cost amount is 32*5 = 160. So you can see AX takes the current standard cost to manipulate the cost price of issued items. But in this case, it is not true because you have 10 items with $30 and 10 items with $32 in your stock.
Create another sales order with 7 items. Post sales invoice and check the cost amount of the transaction by to to sales line, Inventory/Transaction. The cost amount is 32*7 = 224
Now, what we need to do is to run RECALCULATION by go to Inventory Management/Periodic/Closing and Adjustment/Recalculation.
After running Recalculation, if you go to item master, check transactions of the 2 sales order above. Expected result are:
SO1- Cost Amount = 30*5 = 150
SO2- Cost Amount = (30*5) + (32*2) = 150 + 64 = 214
 
AX does recalculation base on the FIFO principle to settle between Receipt and Issue transactions in the stock.
 
 


Источник: http://khue.spaces.live.com/Blog/cns...A0C2!426.entry

[glibs]

Еще один Колумб. Он бы еще через пару лет додумался. В 5.0 уже все по-другому (пересчет запускается автоматически, а закрытие standard cost не трогает).