openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #10932
[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