Inventory is the Odoo module where early decisions matter most.<\/p>\n
Get sales pricing wrong and you fix it in an afternoon. Get your unit of measure or your valuation method wrong and you will be living with it, because both become very hard to change once you have transaction history.<\/p>\n
So this article spends more time on setup than on daily use. That is deliberate.<\/p>\n
The first idea to understand: in Odoo, stock does not simply exist. It is always in a location<\/strong>, and it only moves between locations.<\/p>\n Your warehouse is a location. So is a shelf inside it. So is your customer. So is your vendor. So is a virtual place called Inventory Adjustment.<\/p>\n Every stock movement is a transfer from one location to another:<\/p>\n This is why Odoo’s stock figures always balance. Nothing is created or destroyed; it only moves. If your numbers look wrong, something moved somewhere you did not expect, and you can trace it.<\/p>\n FIGURE 1: EVERY STOCK CHANGE IS A MOVE BETWEEN LOCATIONS<\/p>\n Vendor<\/p>\n Your Stock<\/p>\n Customer<\/p>\n Design this before you enter a single product.<\/p>\n Keep it as flat as you can.<\/strong> A structure with six levels looks thorough and becomes a burden. Every extra level is extra work on every transaction.<\/p>\n Model what you actually manage.<\/strong> If your team never picks by shelf, do not create shelf locations. You will just get a lot of “where is this item” questions with no useful answer.<\/p>\n Separate stock that behaves differently.<\/strong> Goods you own and goods you hold for a customer should be in different locations, because they are valued differently and one of them is not yours.<\/p>\n A workable structure for most small warehouses is simply: Stock, Input if you inspect before putting away, and Output if you stage before shipping. That is often enough.<\/p>\n Decide this before you import products, and get it right.<\/strong><\/p>\n Every product has a unit of measure. Pieces, kilograms, metres, litres, boxes. This is the unit that all your stock, costs and reports are expressed in.<\/p>\n Odoo also supports a purchase unit different from the stock unit \u2014 buy in boxes, hold in pieces \u2014 with a conversion factor.<\/p>\n The reason this matters so much: changing the base unit of measure on a product that already has stock moves and order lines is blocked by Odoo, and getting around it means clearing transaction history. That is a serious operation on a live system.<\/p>\n Spend the time on this at the start.<\/p>\n FIGURE 2: THE FOUR SETUP DECISIONS THAT ARE EXPENSIVE TO REVERSE<\/p>\n Location structure<\/p>\n Units of measure<\/p>\n Costing method<\/p>\n Valuation posting<\/p>\n Two decisions here, and both have accounting consequences.<\/p>\n Standard price.<\/strong> You set a fixed cost per product. Simple and predictable. Differences from actual purchase price go to a price difference account.<\/p>\n Average cost (AVCO).<\/strong> The cost updates as a weighted average each time you buy. Reflects reality well, and is the most common choice.<\/p>\n FIFO.<\/strong> First in, first out. Each unit keeps the cost it came in at. Most accurate, and needed in some industries and jurisdictions.<\/p>\n Manual.<\/strong> Stock moves do not create accounting entries. Your accountant posts inventory adjustments periodically.<\/p>\n Automatic.<\/strong> Every stock move posts an accounting entry immediately. Your balance sheet inventory value always matches your stock on hand.<\/p>\n Automatic is usually the right answer<\/strong> if you are serious about accounting, but it means every stock move has an accounting consequence \u2014 so bad stock data becomes bad financial data instantly. There is no buffer.<\/p>\n Talk to your accountant about both choices before deciding. This is not a technical decision.<\/p>\n The purchase order creates the receipt. The warehouse validates it with actual quantities.<\/p>\n Count before validating.<\/strong> This is the habit that everything downstream depends on. Validating the ordered quantity without counting turns your entire three-way match control into theatre.<\/p>\n The sales order creates the delivery. The team picks and validates.<\/p>\n If you can only send part of it, enter what you are sending. Odoo asks whether to keep a backorder for the rest.<\/p>\n Moving stock between your own locations. Also used for stock going out to a subcontractor and coming back.<\/p>\n Physical counts. Enter what you actually counted, and Odoo posts the difference.<\/p>\n Two approaches: count everything once a year, or cycle count<\/strong> \u2014 count a small group of items every week on rotation. Cycle counting is far better. It finds problems while they are small and does not require shutting the warehouse.<\/p>\n A rule on a product says: keep at least this much, and when it drops below, order up to this level.<\/p>\n Three things to get right:<\/p>\n Minimum.<\/strong> Must cover demand during the vendor’s lead time, plus a buffer. A minimum that ignores lead time guarantees stockouts.<\/p>\n Maximum.<\/strong> Too high and you have cash sitting on a shelf. Too low and you are ordering constantly.<\/p>\n Review them.<\/strong> Demand changes. Rules do not update themselves. Look at them a few times a year.<\/p>\n If you need to know exactly which unit went to which customer, enable tracking per product.<\/p>\n By lot.<\/strong> A batch of items shares a lot number. Standard for food, chemicals and pharmaceuticals, usually with an expiry date.<\/p>\n By serial number.<\/strong> Every single unit has its own number. For equipment, electronics and anything with a warranty.<\/p>\n Only enable this where you need it.<\/strong> Tracking adds a step to every single transaction. On products that do not need it, you are taxing your warehouse team for no benefit.<\/p>\n Stock on hand.<\/strong> Quantity and value, by location. Your starting point.<\/p>\n Stock moves history.<\/strong> Every movement of an item. This is your audit trail \u2014 when a number looks wrong, this report tells you why.<\/p>\n Inventory valuation.<\/strong> The value of your stock, and how it changed. Should agree with your balance sheet.<\/p>\n Forecasted inventory.<\/strong> Current stock plus incoming, minus committed outgoing. What you will actually have available.<\/p>\n Wrong unit of measure at setup.<\/strong> The most expensive mistake in the module, because fixing it means clearing history.<\/p>\n Locations too detailed.<\/strong> A structure nobody maintains, producing stock figures that are technically precise and practically useless.<\/p>\n Validating without counting.<\/strong> Everything depends on this and it is a human habit, not a setting.<\/p>\n Negative stock.<\/strong> Odoo can allow it, and sometimes it is legitimate. Persistent negative stock is a sign that goods are physically moving before anyone records it.<\/p>\n Tracking enabled everywhere.<\/strong> Slows every transaction and produces resentment. Enable it only where it earns its place.<\/p>\n Then test in a test database: receive short, deliver partially, transfer internally, and run an adjustment. Check the accounting entries after each one. If those four work correctly, your setup is sound.<\/p>\n Setting up inventory in Odoo?<\/p>\n Get in touch. Units of measure and valuation are the two decisions worth getting right first, and they are where we start.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":" The module that punishes bad setup Inventory is the Odoo module where early decisions matter most. Get sales pricing wrong and you fix it in an afternoon. Get your unit of measure or your valuation method wrong and you will be living with it, because both become very hard to change once you have transaction […]<\/p>\n","protected":false},"author":3,"featured_media":9003,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-8971","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odoo"],"yoast_head":"\n\n
\n
\n
\n
Setting up your locations<\/h2>\n
Units of measure<\/h2>\n
\n
\n
\n
\n
Valuation<\/h2>\n
Costing method<\/h3>\n
Inventory valuation<\/h3>\n
Daily operations<\/h2>\n
Receiving<\/h3>\n
Delivering<\/h3>\n
Internal transfers<\/h3>\n
Inventory adjustments<\/h3>\n
Reordering rules<\/h2>\n
Tracking<\/h2>\n
Reports worth using<\/h2>\n
What usually goes wrong<\/h2>\n
Getting started<\/h2>\n
\n