Hi,
We've been having a recurring problem with some MOs recently.
Some semi-finished products do not seem to be moved into virtual locations when closing MOs. In the following screenshots, the problematic product is CPP2005. In this case, we produced a full 2755kg of the product, and consumed the same amount between 3 MOs. I'm using a single MO as an example, but the same problem arises whether we consume the full amount in a single MO or across multiple MOs.
We're consuming them the same way we do the other components (they are all purchased components), selecting the lot and quantity from the hamburger menu on each line. The BoM quantities are estimates, since our process has a lot of variations in yield, hence the different number on the component screen.
The problem arises when validating the MO. The Product Moves view shows a correct move for the component, from the correct location to the Virtual Location: Production.
The product correctly appear as consumed in the component list in MO view (although, the problematic components sometimes get a duplicated component line, see screenshot directly following):
When checking the current stock for the component on the product page, the full quantity is available.
The forecast screen shows similar info:
But clicking on the On Hand button, we see the full quantity still in the physical location (Usine/Usine/PROD) with an equal reservation on the quant.
When checking the stock for the specific lot ( in this case, the only lot in stock), we see the full quantity in a physical location (Usine/Usine/PROD), with the full quantity reserved. We also see the same quantity, but negative, in the Virtual Location: Production.
So clearly, the stock was not moved by the MO into the Virtual Location: Production when validated. When looking at the stock moves across the Virtual Location with this product and lot, the sum adds up to 0, which is the behavior I would expect:
Furthermore, those problematic components sometimes appear in the traceability report, sometimes they do not. In this case, it does not, but it appears correctly in the MO Overview and the valuation report for this MO.
Some initial theories that were tested and seemed not to be the cause:
- The components sometimes were past their lot's expiration date:
- We have disabled expiration dates (but kept lot tracking) but the problem still exist.
- The physical location Usine/Usine/PROD is configured in a problematic way:
- I have checked the location's configuration. It's a physical/internal location. No storage category is set. It is not a scrap location, return location, replenish location nor subcontracting location. It is configured with a FIFO removal strategy.
- A putaway rule was interfering with the stock move:
- A putaway rule was taking stock from Usine/Usine to Usine/Usine/PROD when the semi-finished products were produced. I removed that rule to make sure that the Usine/Usine/PROD location wasn't the source of the problem, as new MOs consume directly from the Usine/Usine location (same as the other components). The problem still happens on MOs using that location.
Has this happened to anyone else? I am starting to run out of theories as to why this behavior occurs other than a bug in Odoo's programming, which to me would be the least likely source of the problem.
Thank you