Tuesday, April 5, 2011

Calculate Cost Price & Sales Price of BOM item.


To calculate Cost and Sales Price of BOM item we have two options as explain below.
      1) Use Cost specified in cost field on Item Details card. 
         2)     Use “Active cost” specified using costing version.

Let’s go with 1st approach first.
  • To use Cost price specified on Item Details Card use Costing Version of type “Planned Cost” also specify fallback = Active or particular version.
Let’s have one example.
> Create one item 005, type = BOM, Costing Version = TestCost(Planned Cost Type)
> Create two item to use as bom line for 005,
> Which are 005Line1 & 005Line2, type = item, Costing Version = TestCost(Planned Cost Type).
> Attach this two item to 005 as bom lines, Activate & Approve BOM.
> Now, for item 005 press “Price” button it pops up window, then press “Calculate” button it again pops up another window select Costing Version TestCost, Site, BOM Version. Also select Fallback version = Active.
Press ok button, this calculates Cost Price & Sales Price as you wanted.

Now here is the way to calculate price with 2nd approach.
  • To use Costing Version of type “Standard Cost” first Active price of (components) which are used to make BOM item. Then select the cost version in which you have activated price while calculating price. In this case fallback is not necessary.
Let’s have one example.
> Create one item 006, type = BOM, Costing Version = StdCost(Standard Cost Type)
> Create two item to use as bom line for 006,
   Which are 006Line1 & 006Line2, type = item, Costing Version = StdCost(Standard Cost Type).
> Attach this two item to 006 as bom lines, Activate & Approve BOM.
> Now press “Price” button for 006Line1 & Active cost value for StdCost Version.
> Again press “Price” button for 006Line2 & Active cost value for StdCost Version.

> Finally press “Price” button for 006 it pops up window, on that window press “Calculate” button. It pops up another window select Costing Version StdCost, Site, BOM Version. Also select Fallback version = None.
> Press ok button, this calculates Cost Price & Sales Price as you wanted.