← Back to team overview

openerp-expert-accounting team mailing list archive

Re: Anglo-saxon accounting and average price

 

Hello,

 

OpenERP R&D fixed this 4 days ago. The fix is landing in 7 and trunk. In the
past few weeks, a deep review of inventory accounting has been done by
OpenERP R&D on the basis of US needs. Account_anglo_saxon is part of core,
so I don’t understand why you say it’s not. Most people who look at OpenERP
in North America do not come to the conclusion you mention. When everything
is open, you cannot prevent people who want to do everything by themselves
and refuse assistance to discover things late; so there will always be cases
like that. What could be a suggestion to limit this is to make sure that
account_anglo_saxon can be activated somewhere in the settings to increase
its visibility for end-users.

In another note, you might want to take a look at the recent specifications
draft [1] for the future of logistics and warehouse management and react
based on that.

 

More on accounting in the US:

- Video: https://www.youtube.com/watch?v=Hb5wTW_w4tE 

- Slides:
http://www.slideshare.net/raycarnes/ursa-openerp-accounting-webinar-slides 

 

Best,

 

[1] https://t.co/JnP1CJ5ygz 

__
 <http://opendays.openerp.com/> OpenERP Open Days, July 1-5 2013 in
Brussels, Belgium

Fabrice Henrion
Director Americas

OpenERP Inc.
260 Main Street – Suite 203
Redwood City, CA 94063
Tel: +1 (650) 307-6736

 <http://www.openerp.com/> http://www.openerp.com

 

From: Openerp-expert-accounting
[mailto:openerp-expert-accounting-bounces+fhe=openerp.com@xxxxxxxxxxxxxxxxxx
t] On Behalf Of fred blauer
Sent: Thursday, June 20, 2013 7:22 AM
To: ferdinand; Maxime Chambreuil
Cc: openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Openerp-expert-accounting] Anglo-saxon accounting and average
price

 

I don't understand why this function wouldn't be included in the core
system. Wouldn't it apply to most companies outside of Belgium? I suspect
that there are many companies not using this module that really should and
are not aware that they are not doing the inventory accounting properly.
This is bound to give Openerp a bad reputation, especially among
accountants. I was talking to someone is the US who was evaluating Openerp
and came to the conclusion that it didn't handle inventory transactions
properly because they were not aware of this obscure module. I suspect that
most people who look at the system in North America would come to the same
conclusion. Even worse if they discover this after they are live. Modules
that affect integrity of the accounting should be in the core of the system,
in my opinion. 

 

On Thu, Jun 20, 2013 at 9:27 AM, ferdinand <office@xxxxxxxxxx> wrote:

On 06/18/2013 12:32 PM, Graeme Gellatly wrote:

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.

please let me know where I can find the module





 

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_st
ock_accounting/
<http://bazaar.launchpad.net/%7Ecamptocamp/c2c-rd-addons/7.0/files/head:/c2c
_stock_accounting/> 
http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/c2c_pr
oduct_price_unit/
<http://bazaar.launchpad.net/%7Ecamptocamp/c2c-rd-addons/7.0/files/head:/c2c
_product_price_unit/> 
http://bazaar.launchpad.net/~camptocamp/c2c-rd-addons/7.0/files/head:/c2c_pr
oduct_price_unit_anglosaxon/
<http://bazaar.launchpad.net/%7Ecamptocamp/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 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
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
<https://launchpad.net/%7Eopenerp-expert-accounting> 
Post to     : 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
<https://launchpad.net/%7Eopenerp-expert-accounting> 
Post to     : 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




-- 
Fred Blauer CA, CA.IT, CISA
http://openacct.ca
fred@xxxxxxxxxxx
514-667-1555 


Follow ups