Odoo Help

0

No stock journals generated on sales or purchase credits.

By
Geoff Kimpton
on 3/24/16, 9:40 AM 719 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. 

0

Ermin Trevisan

--Ermin Trevisan--
4467
| 6 4 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 3/24/16, 11:04 AM

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).

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

Geoff Kimpton
on 3/24/16, 1:02 PM
0

Ray Carnes

--Ray Carnes--
16601
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 3/24/16, 11:00 AM

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

Geoff Kimpton
on 3/24/16, 1:29 PM

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).

Bista Solutions US, Ray Carnes
on 3/24/16, 2:04 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 3/24/16, 9:40 AM
Seen: 719 times
Last updated: 3/24/16, 11:04 AM