← Back to team overview

openerp-india team mailing list archive

[Bug 986604] Re: Stock Return accounting entries logic

 

Hello Adham,

I have given close look to your issue .But it's  working fine for me.

I am able to get right Entries for purchase and sale respectively,which
I have shown below

Purchase:

ACCOUNT                           DR       CR

Expanse journal:

creditor (partner payable)  0 100
Purchase (stock in)    100    0

Stock Journal:

Purchase(stock in)        0    100
stock valuation(stock)  100 0

Return:

Expense credit note:

creditor(partner payable)   100 0
cogs(stock output)     0 100

Stock journal:

stock valuation(stock)   0  100
cogs(partner output)    100  0

SALE:

ACCOUNT                                             DR       CR

Sale journal:

Debtor (partner rec)                         200  0
Product sales (product income)      0 200
Expense (product exp)                     100 0 
cogs (stock output)                           0 100

Stock journal:

purchase stock (stock valuation)   0   100
cogs (stock output)                         100  0

Return:

Sale credit journal

debtor(partner rec)              0    200
product stock(product in)   200  0
purchase(stock input)          100  0
expense(product exp)          0  100

Stock journal:

stock input(stock in)                        0   100
stock variation (stock valuation)   100  0

Hope this will helps you ..!!

Thanks!






** Changed in: openobject-addons
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/986604

Title:
  Stock Return accounting entries logic

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  
  Hey,

  Something seems wrong i start test with automatic stock valuation.I am
  not an accountant but i know enough. I am defined stock out (COGS) and
  stock in ( purchase expanse account)

  Below is a the journal entries created from AA) Purchasing, AB)Incoming shipment, BA)sales invoice,BB) delivery.
  CA)Purchase return invoice CB)purchase return delivery, DA)sales return invoice DB)sales return incoming shipment.
  ACCOUNT	 DR	 CR
  AA	Purchase Invoice	
  1	 120000 Creditors	 0	 60
  2	 221000 Purchases	 60	 0

  AB	Receiving Stock	
  3	 221000 Purchases	 0	 60
  4	 110100 Stocks	 60	 0

  BA	Sales Invoice	
  5	 110200 Debtors	 105	 0
  6	 200000 Sales	 0	 105

  BB	Delivery Stock	
  7	 110100 Stocks	 0	 60
  8	 210000 COGS	 60	 0

  CA	Purchase Return Invoice	
  9	 120000 Creditors	 60	 0
  10	 221000 Purchases	 0	 60

  CB	Purchase Return	
  11	 110100 Stocks	 0 60
  12	 210000 COGS	 60	 0

  DA	Sales Return Invoice	
  13	 110200 Debtors	 0	 105
  14	 200000 Sales	 105 0

  DB	Sales Return	
  15	 221000 Purchases	 0	 60
  16	 110100 Stocks	 60	 0

  My problem is in line 12 (Cost of goods sold) and 15 ( purchase). 
  Line 12- Should be Simply the purchase account not the cost of goods sold
  Line 15-should be the cost of goods sold not purchases

  I know that in the definition of stock valuation You enter stock in
  and stock out but this will not reflect correctly in my Chart of
  accounts not all stock ins are treated the same like in returns.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/986604/+subscriptions


References