Community mailing list archives

community@mail.odoo.com

RE: stock input account balance with Anglo-Saxon accounting

by
Rooms For (Hong Kong) Limited, Yoshi Tashiro
- 03/01/2015 10:21:02

Hi Jordi,

 

While I haven't fully understood the design of your module, here is what I have tried.

 

As I checked account_anglo_saxon for 8.0, it appears that the problem case I mentioned for 7.0 has been handled appropriately - in case of average costing, it compares the prices between invoice line and associated stock move (when available).

https://github.com/odoo/odoo/blob/8.0/addons/account_anglo_saxon/invoice.py#L160

 

So, one approach we could take is to backport this logic to 7.0.  To do this, you need to have purchase line id in invoice line model which is not the case by default.

 

I have prepared a module to add purchase line id in invoice line.  This should work for any Invoicing Control selection.

https://github.com/rfhk/rfhk-odoo-addons/tree/7.0/purchase_invoice_link

 

Installing this module + backporting account_anglo_saxon worked for my case.  You might also want to consider this approach if is is compatible with your module.

 

----------------------------
Yoshi Tashiro

 

From: Jordi Ballester Alomar [mailto:jordi.ballester@eficent.com]
Sent: Sunday, March 01, 2015 2:34 PM
To: Community
Subject: RE: stock input account balance with Anglo-Saxon accounting

 

Hi Yoshi,

Please use the following module instead of the previous:

https://github.com/Eficent/eficent-odoo-addons/tree/7.0/real_time_inventory_account_determination

And follow the instructions defined in __openerp.py__

This module aims to replace the Anglo Saxon Accounting module, and use correct postings in real-time stock valuation.

Still pending to introduce the COGS deferral to the sale invoice. We're planning define a company-wise setting that makes it possible to choose if COGS deferral should apply.

Regards
Jordi.

El dia 01/03/2015 5:48, "Yoshi Tashiro" <tashiro@roomsfor.hk> va escriure:

Hello Jordi,

 

Thanks for your replies and sorry about my late response.

 

>>>

 

 

In a scenario where the purchasing value of goods received is 10 USD, irrespective of the product's average price, at the time of validating the invoice the 10 USD are debited.

In case that the invoice amount differs with the purchasing value, the differences are posted to a Purchase Price Variance expense account.

<<<

 

 

 

This scenario sounds correct but it somehow does not work in my environment after installing your module.

 

What I don't quite get in your code is the part highlighted in below image.  line['price'] and i_line.price_subtotal are always the same in my environment even when invoice price is different from PO price.  As a result, price difference is never posted in my environment, leaving balance in GRNI account. 

<img width=727 height=178 id="Picture_x0020_1" src="cid:image001.png@01D0541D.46CF7450">

https://github.com/Eficent/purchase-workflow/blob/7.0-account_creditor_price_difference/account_creditor_price_difference/model/invoice.py#L107

 

Am I missing something?

 

----------------------------
Yoshi Tashiro

 

From: Jordi Ballester Alomar [mailto:jordi.ballester@eficent.com]
Sent: Tuesday, February 17, 2015 10:13 PM
To: Community
Subject: Re: stock input account balance with Anglo-Saxon accounting

 

Hi Tashiro,

 

This is now fixed in the following branch, pending to merge into OCA/purchase-workflow repository:

 

The module is 'account_creditor_price_difference'.

 

In a scenario where the purchasing value of goods received is 10 USD, irrespective of the product's average price, at the time of validating the invoice the 10 USD are debited.

In case that the invoice amount differs with the purchasing value, the differences are posted to a Purchase Price Variance expense account.

 

 

 

 

 

 

Regards,

 

On Tue, Feb 17, 2015 at 7:52 AM, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:

And this is how SAP ByDesign handles price differences with Moving Average Cost Method:

http://help.sap.com/saphelp_byd1302/en/KTP/Software-Components/01200615320100003379/WEKTRA_for_Work_Centers/FIN/Ess/ESS_INV/ESS_CON_GRIRClRunMovAvCoVal.html

El dia 17/02/2015 7:48, "Jordi Ballester Alomar" <jordi.ballester@eficent.com> va escriure:

 

Oh, and by the way, I am not using the anglo_saxon module, but this separate module instead.

El dia 17/02/2015 7:47, "Jordi Ballester Alomar" <jordi.ballester@eficent.com> va escriure:

You are right Yoshi,

Since I found some other issues with the Anglo-Saxon module I developed a separate module that handled the posting of price differences. I will be fixing this issue in that module 'account_creditor_price_difference'.

https://github.com/Eficent/eficent-odoo-addons?files=1

I will keep you updated when it's fixed.

I will also raise Issues to Odoo regarding the other problems I found in the anglo saxon module, described in my post. Hopefully Odoo will fix them in future releases.

El dia 17/02/2015 5:13, "Yoshi Tashiro" <tashiro@roomsfor.hk> va escriure:

Hi Jordi,

 

Thanks for your comment.  I think, however, my point is different to your case - while your case is based on "standard" costing method, my case is "average" costing method.

 

I understand that usng "standard" costing, "price difference" should be posted when PO price is different to the product cost, which should not be the case when you use "average" costing.  Since the stock input amount (or what you call GRNI amount) at receipt should always equals to the PO amount using "average" costing (except for some return cases dependng on the scenario), if you take the stock input amount at the supplier invoice from the product cost, it inherently leaves some balance in the stock input account as the purchase price fluctuates.  As I understand, in Anglo-Saxon context, there should be no balance left in the stock input account after supplier invoice has been processed.

 

So, I have been wondering the rationale behind this design.  Is this just the wrong design and we should just not use Anglo-Saxon + average costing, or do I have some fundamental misunderstanding about the usage of stock input/price difference account?

 

----------------------------
Yoshi Tashiro

 

From: Jordi Ballester Alomar [mailto:jordi.ballester@eficent.com]
Sent: Monday, February 16, 2015 6:53 PM
To: Community
Subject: Re: stock input account balance with Anglo-Saxon accounting

 

Hello Tashiro,

 

It should work as you describe it. See the summary of postings using anglo-saxon module and real time account valuation:

 

 

For more information, read the following post:

 

Regards,

Jordi.

 

On Mon, Feb 16, 2015 at 11:13 AM, Yoshi Tashiro <tashiro@roomsfor.hk> wrote:

Hello,

 

Just curious how people in the community are handling this case.

 

Conditions:

- v7

- Anglo-Saxon accounting, Real Time stock valuation, Costing Method = Average

 

With this setting, the system cannot cancel out the stock input account balance coming from receipt and supplier invoice when PO price (=receipt price) is different to the cost in product master, which I think is incorrect.  Stock input account balance should not remain in the system after supplier invoice has been processed.

 

My questions are:

1. Is my above understanding valid or do I have some misunderstanding?

2. If my above understanding is valid, is there a solution (a module or setting/operation workaround) out there to fix the issue?

 

----------------------------
Yoshi Tashiro

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



 

--

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



 

--

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe