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

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

account_financial_report_webkit - modify to include Opening Balances all the time?

Re: Maintaining multiple inventory GL Accounts

Avatar

Re: Maintaining multiple inventory GL Accounts

by
ForgeFlow, S.L., Jordi Ballester Alomar
- 09/12/2015 06:46:03


El dia 09/12/2015 0:52, "Jonathan Wilson" <jon@willowit.com.au> va escriure:
>
> 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.
>
Agreed.
> 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.
Thanks! I will be sending an invitation for a webinar to explain in detail.
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.

Well, of course that's paid work! And YOU help me reduce the costs and risk. What I'm learning from OCA is that the more you work collaboratively from day 1 of your project the better. Start sharing the specs, share ideas and progress. Share the code to get it reviewed, tested and improved. The results come themselves.

Feedback from you guys is invaluable, believe me. It is worth sharing my experience and work in exchange of your insights.

I have not yet mastered this art, though. Mostly I learned this from Pedro Baeza and Ana Juaristi.

Still I have much work pending to move to OCA. Hopefully by next year I wilk be able to make more progress.

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.
>
Well, I think that just having the code available in some public repository is a good start. People like us can start evaluating it, and if we find it useful, even help you to move it to OCA.
>
>
>
> Jonathan Wilson
> www.willowit.com.au
> 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
>>> www.willowit.com.au
>>> 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 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?
>>>>
>>>> --
>>>> Jordi Ballester Alomar
>>>> Founder | Eficent
>>>> (+34) 629530707 | jordi.ballester@eficent.com | http://www.eficent.com
>>>> Twitter: https://twitter.com/jbeficent_erp | Linkedin: https://www.linkedin.com/in/jordiballesteralomar
>>>>
>>>> _______________________________________________
>>>>
>>>> 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
>>
>>
>>
>>
>> --
>> Jordi Ballester Alomar
>> Founder | Eficent
>> (+34) 629530707 | jordi.ballester@eficent.com | http://www.eficent.com
>> Twitter: https://twitter.com/jbeficent_erp | Linkedin: https://www.linkedin.com/in/jordiballesteralomar
>>
>> _______________________________________________
>>
>> 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