How to Add Available Qty in PartWhse Table

Kinetic ERP
,
1

Hi everyone,
We added a grid table( PartWhse table) in order entry window for our Sales department to see on hand quantities from multiple sites.
Now, they want the available qty to be added on that column which I don’t know how to accomplish.
Can someone give me an idea on how to do it please.
I am thinking of creating a UD field called Available but not really sure if that is the easiest way to do it
Thanks

2

Hi Chemuel

I’ve not looked at in full but PartWhse has a field called allocatedqty. A calculated field of QOH - allocatedqty may give you want need

3

Thanks @Matt_Belshaw …

4

Just use an BAQ to get the information and an embeded dashboard (zero custom code needed)

5

Thank you @josecgomez . It worked . For some reason it creates an extra time/lag loading the dashboard definition on the order entry window.

6

Hi everyone, we tried and added Availableqty_c UD field on the PartWhse Table.
How can I make it in such a way that it will take the difference of OnHand-Picking/AllocatedQty?

image
image1554×262 52.8 KB

7

Was able to accomplish this through setting the fields and with conditions added.