report issue

Hello Fahad,

I think you need configure the product in following manner.

When create the product. At that time add supplier at supplier tab. and configure the supplier with following "Pricelist".
Quantity ---- Unit Price
  100 30$
  200 10$

So, here take price form the supplier Pricelist. If quantity under 100 pc than it's take cost price.

Hope this will help for you.

Thanks.

give me the same

Hello Fahad,

I think you need an exact stock value based on the product and its cost price.
You need following configuration to achieve the feature.

Set costing method = Average price in product form so that whenever we will purchase that product it will calculate average cost of the produce and update the cost price field.

Ex:
Transaction 1 : Purchase product qty 10 in 50$ : cost price = 50$
Transaction 2 : Purchase product qty 10 in 60$ : cost price = 55$
When ever you will check list of product you will get 55$ cost price and on report you will get value = 1100$

This will not show you the lot with its cost price.
To get the information like you have 10 PCE with 50$ and 10 PCE with 60$ you need to use production lot number while receiving product in incoming shipment.
You can activate "Track incoming lot" checkbox in product form to force the user to assign production lot number everytime they receive the products.

You can always check lot number wise product list and its price using traceability menu.

Hope this will solve your issue.

Regards,
Serpent Consulting Services,
<email address hidden>
http://www.serpentcs.com

Hello
we have create a module
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/files/head:/c2c_stock_accounting/
which stores the move_value_cost in stock_move
this allows to calculate the value of stock per lot/location and for every point of time.