Hello,
I am trying to get an unbound field to populate with availability on the sales order line based on joining to the INSITESTATUS table. This works on pxdefault- however, it begins to break down when I’m updating allocations on the sales order and am pending a commit. I have a sense that there is a view that is being manipulated as the order is being input keeping things in sync before they are committed to the database and I just can’t seem to find anything written about it. Does anyone know what view is being updated to reflect the item availability information at the bottom of the grid?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/32902726-5f4d-419a-92bf-70bfaacf127d.png)
The end goal is to trigger an approval rule based on the availability. If there is any other way of doing this, I’m open to suggestions.
Thanks in advance!