Hi André, first of all, thank you very much for responding, and happy holidays.
I will try to explain it with a series of tags on the same images, since the situation in question has been resolved, but as I mentioned, I would like to understand why this happens.
The form I am using to display all the images is InventOnHandItem, and the rest is adding or removing hierarchy levels to filter.
The main problem is, as can be seen in the first images, that the availPhysical column is empty, even though the availOrdered column shows us that there is stock available. However, because of this, we have found ourselves in a situation where, in a sales order, when we wanted to reserve this item, we got an error because the quantity was 0 (in relation to the availPhysical column). And it's strange because, as I said a couple of lines earlier, there is quantity available in the warehouse.
I will show the same images again but add their corresponding English field to try to improve understanding of them. I will keep this in mind for next time.
Site, Warehouse, Inventory Status
Site, Warehouse, Inventory Status and WMSLocation
Site, Warehouse, BatchId, WMSLocationId, Status and LicensePlateId
Most recent transactions for this item in this store (I have highlighted the one we are interested in below in red)
At this point, a couple of hours later, we detect that physical stock is available again
We look at the transactions and see that a work related to the purchase order we saw earlier without a date has been carried out
Now, look again the transaction that i mencioned before:
Status changed due to this work, and if we check inventOnHandItem again:
Now, availPhysical is available.
The problem is that, throughout the entire process, there has always been stock available in the warehouse, but due to something I am unaware of, until the status of this purchase order was changed, the inventOnHandItem form showed us an availPhysical quantity of 0, and therefore, when making a reservation for the item in sales orders, it would not let us do so. I hope this has helped to clarify my problem a little, which is basically that I want to understand why Dynamics has acted in this way. Thank you very much for your time and happy holidays!
Jesús
