These statements seem contradictory:
I purchased a box of 100 for $10.00. I dont need to differentiate a unit cost and unit price becasue I am not reselling the items, I am only dispensing them. So what I would like to have is another filed which will yield a cost per piece, in other words 100 count band aids at $10 results in a $0.10 cost per piece.
When I enter values into the transaction I would like the 10 band aids show up as the Units on hand, with a value of $1.00
How did a 10 cent bandaid become a 1 dollar band aide?
Do you mean 10 groups of 10 bandaids at a dollar for each 10 bandaid group?
Calculation fields can certainly be added or modified to divide total price by item count to give you a unit cost.
In most cases, you can delete unused fields from your layout and a fileMaker database will still function correctly with the remaining fields. Always make a backup copy just before making such a change so that you can revert if you find that you removed items that you really needed. You can also open Manage | Database | Fields and delete fields directly from the table. This deletes the fields from all layouts, but script steps that reference any of those fields will be "broken" and if any calculation fields reference the field you are deleting, you get an error message telling you that you can't delete the field. (Fields used in scripts and as match fields in relationships also throw up a warning, but you are permitted to override it.
PhilModJunk, Thank you for the reply. Sorry I was not clear on the band-aid description. I would purchase 100 band aids for a total cost of $10.00. I would only stock 10 of then as inventory in the kit. Stock Value would show as $1.00. Great idea about making acopy to the database each time I try something new or unfamiliar.
Any sugestions how I might set this up to arrive at my final result?
In Your Stock Transactions table, you can add fields for:
cItemCost can be a calculation field with this expression:
Cost / ( Quantity * CountPerItem )
In your band aid example, you'd enter 1 as the quantity (1 box of 100), 100 as the CountPerItemPurch and then $`10 as the cost. You'd enter 10 into the "Units In" field. If you need to show the number of items per inventory (10 bandaids) you can use
Quantity * CountPerItemPurch / Units In