Script to automatically refresh/update Inventory quantities

[mrswombat]

Hello,

I'm sure this topic has been covered but I was unable to find it. I have a list of Inventory parts and each part is a separate record showing its quantity. I also have a layout called "Inventory Log" in which the data from each record can be seen in columns and rows.

Is it possible to create a script such that when I'm in my Inventory Log layout, I can update the inventory quantities in multiple records without having to manually update these fields?

Specifically, say I have several Inventory items I need to deliver one day with the following fields:

Part number: 24568 Widget

Qty. on hand: 54

Qty. delivered: 36

I would like to be able to type in the Qty. Delivered information on several records on the Inventory Log layout and then click a button that triggers a script to automatically update/refresh my qty. on hand totals and then clear the qty. delivered fields, while retaining the new qty. on hand totals for the next time I have to make deliveries.

Hope this makes sense and thank you!

[dansmith65]

Here is one way the script could work - this is an easy to create version, which you may not want to use if you have auto-enter modification fields (date/time/user/etc.)...

• commit record (to un-lock the current record so you can edit it later in the script)
  
• replace field contents of "Qty. on Hand" field to equal "Qty. on Hand" - "Qty. Delivered"
  
• replace field contents of "Qty. Delivered" field to equal "" (empty string)
  

[bcooney]

Where's your PartsSold table where each LI has a date delivered? Typically, inventory quantities are calcs based on line item records in transactions. So, Qty Received would be calc'd from a ReceiptLineItem (which, of course, refers back to PO Line Items). Qty Delivered is calc'd from the fulfillment of an Invoice.

Your structure does not seem to have the proper tables.