openerp-expert-accounting team mailing list archive

[Graeme Gellatly <gdgellatly@xxxxxxxxx>]

Ferdinand we should compare notes,

I still use your picking_invoice_rel module to correctly price anglosaxon
transactions and have done a 100% rewrite of the anglo_saxon module to make
it work better.


On Tue, Jun 18, 2013 at 10:26 PM, ferdinand <office@xxxxxxxxxx> wrote:

>  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> 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 00http://openerp.com
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
>
>