Skip to Content
Menu
This question has been flagged
2 Replies
8603 Views

When i create a sales invoice or purchase credit no stock journal is created.

The stock journals are created for goods received ( purchase order > receive products)

The net effect is that my stock continues to increase & stock valuation is wrong.

I have tried all possible routes of invoicing (accounting > customer invoice & Sales > quotations) both collection & delivery routes.

In Purchases > Products > Accounting > Inventory valuation , it is configured as follows: Real Time (automated),
Stock input account 500000 Cost of sales

Stock output account 400000 Sales Category 1

Income account  400000 Sales Category 1

Expense account 500000 Cost of sales

The default UK chart of accounts is installed 

In Settings > Warehouse > Accounting "Generate accounting entries per stock movement" is checked.

Any suggestions on how to correct this please. 

Avatar
Discard
Best Answer

Your accounts are not setup correctly.

Review these links:

https://www.odoo.com/documentation/user/9.0/inventory/overview/concepts/double-entry.html

https://www.odoo.com/documentation/user/9.0/inventory/management/reporting/valuation_methods_anglo_saxon.html

https://www.odoo.com/forum/help-1/question/incorrect-stock-journal-stj-for-receipt-of-goods-from-supplier-99079#answer-99147


These will help you understand what SHOULD happen - what you can expect to see as far as stock journal entries - during different operations.


Avatar
Discard
Author

Thank you. I now have a better understanding. Now I need to try & discover how to trigger the stock movement from a sales invoice.

It may be better to see if you can adapt to the way Odoo works. The Sales Order represents the agreement you have with a Customer to buy items from you (so does not affect stock until you fulfill this agreement - or not). Similarly, a Purchase Order represents the agreement you have with a Vendor to receive items from them (so does not affect stock until they fulfull this agreement - or not). If what you want is a single step that affects stock, you should work with a Delivery Order (customer side) or Receipt/Incoming Shipment (vendor side). As Ermin has already said, these documents don't involve money, just record the movement (increase or decreased) in stock valuation. Sales Orders and Purchase Orders don't affect income or liabilities either - as nothing happens until the agreements are fulfilled (or not).

Best Answer

This is on purpose. Accounting invoices and refunds are only monetary movements and have no influence on stock. Only physical movements such as deliveries and receipts do generate stock movements. If you want to have proper stock movements, you should adapt to the standard workflow (for example starting with a Sales Order).

Avatar
Discard
Author

Thank you. I just tried the sales order route & it worked. I would NEVER have guessed that!

Related Posts Replies Views Activity
1
Jun 25
1047
3
May 23
14903
0
Feb 25
3474
3
May 25
7205
3
May 16
3379