report issue

Asked by Fahad on 2012-09-24

I have stock and I created new product after that I purchase (100 piece by 30$ for a piece) and again I purchased for the same product (200 piece by 10$ for a piece)
my problim is

I can just see the old price in the product list and also in report( I can see 30$ for all piece iam enable to see the new price 15$ also in report).

the collection came as 900 for all the products not 3000$ for the first product
and 2000$ for the second

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Addons (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
2012-09-29
Last reply:
2012-10-15

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.

Fahad (f-n-xx-f) said : #2

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

Ferdinand (office-chricar) said : #4

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.

Can you help with this problem?

Provide an answer of your own, or ask Fahad for more information if necessary.

To post a message you must log in.