← Back to team overview

openerp-expert-accounting team mailing list archive

Re: Anglo-saxon accounting and average price

 

On 06/11/2013 08:23 PM, Graeme Gellatly wrote:

Hello!

the avg price calculation and anglo saxon methods are not working correctly
you may find some solutions here

http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/c2c_stock_accounting/
http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/c2c_product_price_unit/
http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/c2c_product_price_unit_anglosaxon/

However the reporter has it wrong with their statement in 3.1. There can be a price difference entry with average cost but generally only if the invoice cost differs from the received cost.

On 11/06/2013 11:37 PM, "Martin Trigaux" <mat@xxxxxxxxxxx <mailto:mat@xxxxxxxxxxx>> wrote:

    Hello folks,

    I have a question related to anglo-saxon accounting with price
    differences and average price.

    This is related to the following bug report
    https://bugs.launchpad.net/openobject-addons/+bug/1154190 (demo
    video attached)

    In the current scenario when we have have account_anglo_saxon
    module installed in the db and create a product with the following
    configuration:

    Product Type: Stockable Product
    Costing Method: Average Price
    Inventory Valuation: Real Time (automated)
    Assign product category: All Products
    Modify product category All Products to make sure you have an
    account specified for each category (including Price Difference)

    Now When I Create first purchase order for this product, quantity
    10 and Unit Price 10, select Invoicing Control: Based on incoming
    shipments, I process the order, create an invoice and validate it.
    I create another purchase order for this same product also with
    quantity 10 but this time Unit Price is 15. Again, select Invoice
    Based on incoming shipments, I process and I validate the invoice..

    We observe that the first journal entry of the invoice is normal,
    but the second invoice journal entry has another entry in the
    Price difference account.

    On the completion of the first PO with quantity 10 with a unit
    price of 10, the product price will be 10. When we complete second
    PO at the unit cost of 15 with 10 qty, the total purchase will be 150.
    After the reception for the second PO, the system will update the
    product price as (100+150)/20=12.50. There is a difference between
    the product price and the purchase price of 15 - 12.50 = 2.50. In
    the purchase journal we have an accounting entry for the price
    difference account of 25.

    This is the current behavior of account_anglo_saxon module in
    OpenERP. My question is, Is this correct ? The perso who reported
    this believes there should not have any price difference.

    I need your views to understand more on Anglo Saxon Accounting in
    terms of price difference calculation and current behaviour of
    this module.

    Thank you in advance


-- Martin Trigaux
    OpenERP Enterprise Services

    Join us at the OpenERP Open Days 2013, July 1-5 in Brussels, Belgium

    OpenERP sa
    Chaussée de Namur, 40
    1367 Grand-Rosière
    Tel:+32 81 81 37 00  <tel:%2B32%2081%2081%2037%2000>
    http://openerp.com


    _______________________________________________
    Mailing list: https://launchpad.net/~openerp-expert-accounting
    <https://launchpad.net/%7Eopenerp-expert-accounting>
    Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
    <mailto:openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~openerp-expert-accounting
    <https://launchpad.net/%7Eopenerp-expert-accounting>
    More help   : https://help.launchpad.net/ListHelp



_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-accounting
Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-expert-accounting
More help   : https://help.launchpad.net/ListHelp


Follow ups

References