Increase inventory when PO is approved

Ask for Help
1

I have an inventory table (products, quantity, LastPurchasePrice)

I then have a PurchaseOrder table where I create new purchase orders, and a third table which contains the actual line items linked back to the PurchaseOrder.

Purchase order is created, line items added and then it needs to be approved.

At approval, I want to update the inventory and increase the quantity field by the approved PO and also update the lastPurchase price in the inventory table.

2

So you would need to adjust the values in multiple rows of the Inventory table?

Right now, the only practical way to do that is via the Glide API.

3

Yes.

So call a webhook and pass it the data so it can then make the API call to do the update ?

4

Yes. Glide just released a new JSON Template column that makes that pretty easy.

Have a look at the below, will give you the general idea…

2 Likes
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.