--- On Mon, 10/10/11, mohammed gaafer <[email protected]> wrote:
From: mohammed gaafer <[email protected]> Subject: Re: [Openerp-expert-accounting] Stock valuation and related configuration To: "Laurie Chrostowski" <[email protected]> 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 <[email protected]> wrote: From: Laurie Chrostowski <[email protected]> Subject: Re: [Openerp-expert-accounting] Stock valuation and related configuration To: "mohammed gaafer" <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: From: Laurie Chrostowski <[email protected]> Subject: Re: [Openerp-expert-accounting] Stock valuation and related configuration To: "mohammed gaafer" <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: From: Laurie Chrostowski <[email protected]> Subject: [Openerp-expert-accounting] Stock valuation and related configuration To: "OpenERP Accounting Experts" <[email protected]> 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 : [email protected] 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
_______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
