openerp-expert-accounting team mailing list archive

[mohammed gaafer <gaafer5@xxxxxxxxx>]

--- On Mon, 10/10/11, mohammed gaafer <gaafer5@xxxxxxxxx> wrote:

From: mohammed gaafer <gaafer5@xxxxxxxxx>
Subject: Re: [Openerp-expert-accounting] Stock valuation and related configuration
To: "Laurie Chrostowski" <lchrostowski@xxxxxxxxxxxxxxxxxx>
Date: Monday, October 10, 2011, 2:56 AM

Dear Laurie,

Thank you for your great and enlightening collaboration, what I am asking from is journal entries while doing internal move between internal stock locations, where I see openerp is not satisfying and it is missing and I can assure that from this part of code where entries got generated :

""" # Outgoing moves (or cross-company output part)
            if move.location_id.company_id \
                and (move.location_id.usage == 'internal' and move.location_dest_id.usage != 'internal'\
                     or move.location_id.company_id !=
 move.location_dest_id.company_id):
                journal_id, acc_src, acc_dest, acc_variation = self._get_accounting_data_for_valuation(cr, uid, move, src_company_ctx)
                reference_amount, reference_currency_id = self._get_reference_accounting_values_for_valuation(cr, uid, move, src_company_ctx)
                account_moves += [(journal_id, self._create_account_move_line(cr, uid, move, acc_variation, acc_dest, reference_amount, reference_currency_id, context))]

            # Incoming moves (or cross-company input part)
            if move.location_dest_id.company_id
 \
                and (move.location_id.usage != 'internal' and move.location_dest_id.usage == 'internal'\
                     or move.location_id.company_id != move.location_dest_id.company_id):
                journal_id, acc_src, acc_dest, acc_variation = self._get_accounting_data_for_valuation(cr, uid, move, dest_company_ctx)
                reference_amount, reference_currency_id = self._get_reference_accounting_values_for_valuation(cr, uid, move, src_company_ctx)
                account_moves += [(journal_id,
 self._create_account_move_line(cr, uid, move, acc_src, acc_variation, reference_amount, reference_currency_id, context))]"""

Having said that Laurie, I see openerp just generate entries from incoming and outgoing moves and don't for internal moves where 

move.location_id.usage == 'internal' and move.location_dest_id.usage == 'internal'

Thanks,

Gaafer




--- On Thu, 10/6/11, Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx> wrote:

From: Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx>
Subject: Re: [Openerp-expert-accounting] Stock valuation and related configuration
To: "mohammed gaafer" <gaafer5@xxxxxxxxx>
Date: Thursday, October 6, 2011, 7:48 AM

Attached is a "map" I created to help me understand the
 flow of the entries (double entries).
For starters, I have everything configured on the product category as opposed to the location or product itself.

As I see it the expense account and stock input account need to be the same - once the purchase order is verified the account is flat and the remaining balances are in inventory (valuation account) and accounts payable.  We are using an asset account called 1340 Inventory Purchases and I would classify this account as a holding account which becomes flat and should be flat (kind of like an audit item that can be verified/red flag that something is incomplete).

For the stock output account - I have used cost of goods sold account.  This account records the expense of the product sold.
For the stock variation account (which should read valuation, I saw a bug report on this) - I used the actual inventory account...the account where the value of the inventory will remain.  This account receives an entry on the purchase of inventory and the sale of the inventory.

For the database I am working in the sales journal seems to produce the "accounting" entries on the purchase while in version 5 it was the purchase journal.
For you situation I think if you configure the stock input/output and variation you will see the stock entries you are missing.  I find it easiest to look at the stock journal and sales journal on the journal items screen.

I hope this helps.  Feel free to contact me with any other questions.  I'm learning this too so this kind of conversation is great for me.  Once I get my document final I will post to the experts.

Laurie

On Thu, Oct 6, 2011 at 1:52 AM, mohammed gaafer <gaafer5@xxxxxxxxx> wrote:

Hi Laurie,

Thank you for your response, I managed to configure , after your useful guidance, the income account and the expense account and it generates account moves correctly.


However, I am asking about how can I generate account move while doing internal moves between stocks in order to affect stocks valuation.

Another question, what stock input and stock output account used for, I did not need to configure them despite the fact transactions created correctly


cheers,


--- On Wed, 10/5/11, Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx> wrote:


From: Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx>
Subject: Re: [Openerp-expert-accounting] Stock valuation and related
 configuration
To: "mohammed gaafer" <gaafer5@xxxxxxxxx>
Date: Wednesday, October 5, 2011, 7:05 AM


Gaafer,
I'm working with a customer to get their confirguation correct.  The OERP documention as I expressed is not very clear.  I will help however I can.  What information would be helpful for you?


Laurie

On Wed, Sep 28, 2011 at 5:08 AM, mohammed gaafer <gaafer5@xxxxxxxxx> wrote:



Dear Laurie ,

first of all, I would like to thank you for this precious contribution. It is really hard to find any documentation about this topic in openerp books so that we are really in need to have the right configuration from the community.



Any assistance will be highly appreciated.

Thanks,

Gaafer


--- On Tue, 9/20/11, Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx> wrote:



From: Laurie Chrostowski <lchrostowski@xxxxxxxxxxxxxxxxxx>


Subject: [Openerp-expert-accounting] Stock valuation and related configuration
To: "OpenERP Accounting Experts" <openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx>


Date: Tuesday, September 20, 2011, 11:38 AM

I have
 spent a bit of time learning the double entry workflow related to
stock within OpenERP and would like to validate with the group the set
up for valuing stock in my existing database.  We are not using the
anglo-saxon module and are in version 6.0.3.



Stock Journal - in the database I am working in I have Accounting Stock
Accounts configured on the product category for use with the stock
journal.  The stock input account is Inventory Purchases (an asset
account) stock output account is Cost of Goods Sold (P&L account) and


stock variation account is Inventory (an asset account).  Journal is
Stock Journal.  When a purchase order is created and the products are
received I see entries in Inventory Purchases (CR) and Inventory (DR).



The Accounting Accounts set up in the product category is the Income
account = Revenue/Income and the Expense account is set to Inventory
Purchases.  I
 have found this is necessary to have the purchase journal
post the DR to offset the CR posted by the Stock Journal.

Purchase Journal - when the supplier invoice is created the entries are
Inventory Purchases (DR) and Accounts Payable (CR).



Finally with the Sales Journal - when a sale is made and the items are
picked there is a DR to Cost of Goods Sold and a CR to Inventory.

I would like to confirm that this is the best way to handle the
configuration.  The Inventory Purchases account is something I had not


experienced previously (it was already set up in the db I am working in)
and I am wondering if the group has seen the double entry stock
accounting accomplished in a different way.

Thank you in advance for your time.


-- 
This message was sent from Launchpad by
Laurie Chrostowski (https://launchpad.net/~lchrostowski)
using the "Contact this team" link on the OpenERP Accounting Experts team


page (https://launchpad.net/~openerp-expert-accounting).
For more information see
https://help.launchpad.net/YourAccount/ContactingPeople



_______________________________________________
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





-- 
Laurie Chrostowski
Business Analyst
NovaPoint Group, LLC
(586) 330-9170

skype: lchrostowski








-- 
Laurie Chrostowski
Business Analyst
NovaPoint Group, LLC
(586) 330-9170
skype: lchrostowski