Stores and in/out

[alex005]

Hi,

I'm a basic user of FM pro and would like to know how to achieve the following.

I have a store room. In it are boxes. Inside the boxes are cables. I receive boxes to put into the store room and I take cables out of the store room (I actually take them out and have them in a holding area until they are used). When I use the cabels I would like them removed from the stores count.

My problems are that I can't see how the relationship would work in FM, but I'm sure FM can do it. I also can't see how to have it setup so that the boxes are added to the stores tab (I was thinking to have a stores tab and a floor tab) and the total number of boxes for each cable type is shown and then when using the floor tab the total number of cables for each cable type is shown.

I've perhaps not explained it to well but it seems a simple enough stores database. I have 5 boxes of cable A, and 3 boxes of cable B. Thats 500 type A cables (100 in a box) and 150 type B cables (50 in a box). Each time I use a cable I would like to see the cable count come down by one in the Stores tab.

I was also hoping to take this onto the FM Go platform and use barcode scanning. Talking about running before I can walk ...

Thanks for any help.

[mr_vodka]

This seems like a simple inventory system. You should find a bunch of threads on it. I dont think that the boxes are really relevant as the only thing that you really care about is the number of cables you add to the inventory each time you purchase a new box of something.

[alex005]

Hi,

I would like to create an inventory database that will allow to stock check cables. I have attached the included Inventory template that I have changed a little but what I'd like to is be able to search for a cable from using the barcode box and then be able to decrease the count by one (because I have used that cable), also be able to record the time and date at which that cable was used. The only bit I'd like to do manually is pressing the button.

Can anyone point me in the right direction?

Most of the work I have changed is on the iPad layout as this is the one which will be used to take cables from the stores and book them into the stores.

Thanks

Inventory5.fmp12.zip

[eos]

What exactly does “use” mean in this context? Is it “in use”? And can it be “put back” at a later point, then “used“ again etc., or is this a one-off?

btw, are you planning to manage the same item for different stores? At the moment the store/location is an attribute of the item, which means that to stock the item in another store, you'd have to create it again with a different store. I guess you can see where that would be problematic …

[alex005]

Hi,

I have three store rooms and an engineer can use a cable from each store for a task.

The tasks are either A,B or C and they will come off the stock from rooms 1,2 or 3.

When the engineer uses the cable they press a button and a script adds one unit to the "units out" field of the inventory template, effectively removing one from the stores. This works fine if I have one store room.

But having three I though I could have 3 inventory tables and 3 stock transaction tables and 3 tabs showing the same layout with a portal and the button.

I have 3 separate scripts for each of the store rooms, but when the button is pressed for room 2 it adds one to the "units out" of it's store room (good) and one to the "units out" of room 1 (bad) I haven't put the button on the last tab.

I thought it may be a relationship issue, so I removed the relationships. Now they are related via "ITEM ID Match Field" between the relevant Inventory table and the associated Stock Transaction table, but rooms 2 and 3 say <Unrelated Table>.

Any ideas???

[Lee Smith]

I have merged your topics and sent you private message.

Lee