How to use Average Price Formula in OpenERP

Below is the method of calculating the Average Pricing in OpenERP

Formula

NP = (AP * QS + PP * QP) / (QS + QP)

Example: NP = [AP(13.42)*QS(733)+PP(15)*QP(10)] / [QS(733)+QP(10)]

NP = 13.44

Abbreviations:

  • NP (New Price): New Average Price once product have been received in the warehouse.
  • AP (Average Price): Old Average Price before product received in the warehouse.
  • QS (Quantity Stock): Quantity stock before product received in the warehouse.
  • PP (Purchased Price): Purchase Price(Unit Price) in Purchase order.
  • QP (Quantity Purchased): New Quantity received in Purchase order.

Contact Us

    Our Clients Reviews

    “We chose Bista because they had some expertise in manufacturing, and they also had some expertise in the accounting side and making sure that our financials were spot on at the end of every quarter.”

    EKO Contract
    Duff Jones

    “The level of consistency and dedication Bista has shown towards our project is the driving force behind the project and all that is to come!
    We, at Reliance, are so thankful to have you as our partners in this endeavor. We’ve grown together and learned a lot from each other over the last few months. I am Sure that will only continue as we progress on our journey of innovation together.”

    Reliance Partners
    Sahej Singh

    “Upon the end of the implementation, Camille sent out an appreciative email stating: “I wanted to let you know how much I appreciate you team for all the help and custom work that they have done on our behalf. Priyesh and Pratik, and the entire offshore team have been really responsive to our operational needs. Thank you again for the hard work”.

    SilencerCo
    Camille Thompson