1. Mailing Lists
  2. Accounting
  3. Re: Maintaining multiple inventory GL Accounts

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

Re: Maintaining multiple inventory GL Accounts

Re: Maintaining multiple inventory GL Accounts

Avatar

Re: Maintaining multiple inventory GL Accounts

by
WilldooIT, Jonathan Wilson
- 09/12/2015 00:37:51
Hi Jordi

OK I better understand your proposal now and it makes sense. One very slight wrinkle which may not be worth worrying about is that if the category is changed (step 2) an the new category uses a different re-valuation account then A) that may be OK from the accountant's perspective, or B) the account will have to enter a reversing journal to balance the re-valuation accounts to zero.

I was unaware of how the master branch is handling stock cost changes, but I agree it is a better way to do it as currently we direct our users to alter the GL accounts on the generated stock journal.

An off-topic comment - your proposal for operational units is excellent and definitely needed for the larger companies. And secondly, I truly don't know where you find the time to make these excellent and very professional community contributions. Myself and our staff are working 8-12 hours a day on paid work with not a lot left over for R&D and upgrading to new versions which we obviously have to make time for. We have some good modules we would like to contribute to the OCA but the whole process seems overly time-consuming. Richard recently did an upgrade of a V8 module (multi-company per contact) to V9 and nearly gave up due to the time it was taking to fix all the previous non-compliant coding in the V8 module.



Jonathan Wilson
ph: +61 3 8506 0393
mob: +61 4 000 17 444
2013 & 2015 Odoo Best Partner Asia/Pacific
Creators of  Odoo-Pentaho integration project





On 9 December 2015 at 03:23, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:
Jonathan and Eric,

I'm not saying that a user cannot change the GL account or the category. I'm saying that the change is done following the proper procedure.

IMHO the procedure to allow a user to re-classify a stockable product into a new inventory account or new category should be:

Necessary preconditions:
- No open purchase orders for this product
- No open manufacturing orders for this product

1. The current inventory value for this product is transferred to an interim account, so that the resulting inventory value is 0. This can be achieved by changing the cost price of the product, which will produce:

In v8:
Dr. Stock Output
Cr. Inventory Valuation

In v9.
Dr. Expense 
Cr. Inventory Valuation

Master:
Dr. Account defined by the user (e.g. Inventory Re-valuation)
Cr. Inventory Valuation
 
IMHO v8 and v9 are wrong in the inventory postings resulting of cost price change. Only master is correct (see https://github.com/odoo/odoo/issues/9856)

2. The user can change the inventory valuation GL account or the product category
3. The user can apply new change of inventory cost (reverting the previous posting), resulting in the following (only if it changes to stockable)
Dr. Inventory Valuation
Cr. Inventory Re-valuation

Please let me know your thoughts. I am going to prepare a shared document with our conclusions on this topic.

Regards,
Jordi.


On Mon, Dec 7, 2015 at 10:38 PM, Jonathan Wilson <jon@willowit.com.au> wrote:
Hi Jordi

I tend to agree with Eric and use ACL's to control access to the category accounts. We have developed a module that we always install that defines critical fields that can be used by the products belonging to that category, like valuation method, product type, costing method, buy/sell flags etc. We have found this module invaluable for stock integrity.

Jon 

Jonathan Wilson
mob: +61 4 000 17 444
2013 & 2015 Odoo Best Partner Asia/Pacific
Creators of  Odoo-Pentaho integration project





On 8 December 2015 at 00:08, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:
Dear accounting experts,

We're considering maintaining multiple inventory G/L Accounts, as per common practices in manufacturing industries:

- Raw Materials
- Components (also called Semi Finished Goods or Work In Progress)
- Finished Goods
- Service Parts

While this can be achieved solely by means of using the product classification fields with a single inventory GL account, this classification would not be reflected in the Balance Sheet, where it is needed for external reporting purposes.

The problem I see with using multiple inventory GL accounts in Odoo is that it allows a user with permissions to change a product or product category to completely mess things up if they change the category to a product. 

Odoo should only allow a user to change the category of a product (or the inventory GL account of a product) if the current stock valuation for this product is 0.

What is your opinion?

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference