Hello everyone, in the last few days I have encountered a bug that I can't figure out and that is driving me crazy.
Some colleagues told us about an article that did not allow to be added to a work. I mean: You create the sales order, add that item, create the load with that item, release the load to the warehouse, create a wave, assign the load to it and process it. By following these steps and carrying out various wave, replenishment and work templates, the waveshould be done and a work created. And, in case there were no items in the picking slot, create a replenishment work to replenish this slot.
Well, the result is that, first it does not find enough quantity, which is correct, but when it creates the temporary resupply wave, it fails to resupply for some reason unknown to us, cancels the resupply, unassigns the wave's dispatch id, resets the wave and returns to an initial state without the assigned load.
We have analyzed the transactions of the item in the warehouse where these operations are being made and a priori we did not find any reason.
At this limit case, we decided to touch the transactions to see how it behaved and the following happened:
InventPhysicalOnHand
As we can see in the image, we have 150 units of physical inventory, 12 units reserved (due to this sales order) and 534 units in other orders that are not reserved, so the total available is negative.
Relating this information with the information given by the wave when processing it, it is normal to launch the replenishment, since there is no picking gap with quantity to satisfy the wave and create the work . That said, a replenishment work should be created that: picks from location 0331021D the maximum quantity it has, since for the replenishment wave we make the maximum quantity directive. In case it is not satisfied, it will lower what it can, to later, resupply the picking slot and finally, create the work. Well, analyzing the code that is in charge of this part, it is as if it did not detect the 150 of physical inventory, that is to say, as if they did not exist. And here comes the weirdest part. We made a positive adjustment by adding 2 more units, so the physical inventory went to 152, we processed again the wave and: Surprise!!! The wave created a partial work of 2 units of this item. It is as if the physical inventory on hand did not show correct information or something within the replenishment process did not do its work correctly. We are concerned because it has happened on a few items and we don't know if it may increase.