Service order with inventory mod

[Justin Dalton]

Working on a service order database with a live inventory. I am new too scripting and am just starting to do the basics. I have created this database without scraping, I wouldn’t mind adding it but just don’t know enough. So… with that said if the answer to my question lies within scripting than I will have a bunch of questions. I currently have 2 issues that I am sorting out at the current moment, any help would be greatly appreciated.

First issue,

I have created a form called “Inventory Parts” that I have entered information on an Item. Things like: Part #, Name, Price, Qty in stock. then I have created another form called “Service Order” which has a table that copies records from “Inventory Parts” form. I have created another field in the table that has the copied data that I have named QTY. Then I created another field that I called “Sub Total” that contains a formula (Qty*List). When using the copied data in the field and using the formula the copied List price turns to $0.00 and I am unable to use the expression to fill the sub total.

Second issue,

I can’t for the life of me figure out how to reduce the inventory qty after the part is added to a service order.

Thanks in advance, I have tried paid programs and can’t seam to find what I want. This is why I have moved to building my own through tap forms.

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Justin,

Can you please include your Inventory Parts and Customer forms too? They weren’t included within the Service-Order form.

When I look at the List formula, all I am seeing is: /(1-.30). Perhaps it didn’t come through in the archive or maybe it was just like that in the original. Not sure.

I would also prefix the .30 with 0. So (1 - 0.3). The trailing 0 is insignificant and not required.

For reducing the inventory quantity you would have to add a Field Script that gets the value of the Qty field and then looks up the part from the Inventory Parts form and then subtracts the value from there. It would take a bit of work.

Thanks,

Brendan

[Sam Moffatt]

I did a tutorial on managing balances with Tap Forms using yarn balls as an example and products like hats. There are two videos, the first video sets the ground work forms and has a simple script for setting the balance whilst the second video walks through building the scripting to add and remove entries maintaining the balance. These should help you handle reducing the inventory quantity when applying new parts but it does rely upon form scripts to work properly.

[Author]

Posts