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
- 02/28/2015 23:44:29

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.

 

 

Inline image 2

 

Inline image 3

 

 

 

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