Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4773 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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!

Posted

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)

Posted

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.

This topic is 4773 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.