Can some one please help me create a template spreadsheet or database for an inventory. I want it to have a change log that shows when stuff was entered or pulled. Also it would be nice if had. Macro so that you could select items and it would add them to a pull ticket. Additionally a barcode integration would be great! They won’t let me buy inventory software but I have hundreds of different types is screws o-rings and dowel pins etc. plz help I need a template
Thanks
Can we add a current qty to the input and output pages? And can we add category for item type and size diameter and length?
What are the dimensions of diameter and lenght? Integer numbers? decimal fractions? inches? which maximum sizes and lengths? Are size and length properties of an article or properties of the booking?
I would guess that size (diameter) is a property of the product, whereas the lenght, like the quantity, is a property of the booking. You may add or remove cut pieces of 3 inch items. The length may vary, but the diameter is a fixed property of the items, right?
Both length and diameter are fixed properties of the articles
OK, which are the dimensions? Do we store integer numbers or fractions? How big are the numbers? How many decimals are required for the fractions? Or do sizes refer to something like “Construction timber”, size= “2x3”? The “2x3” would be stored as text.
A database requires precisely defined data types, as large as necessary, as small as possible. It will not store any text in numeric columns. It will not store any fractions in integer columns. If in doubt, I would store the sizes as text, so you can enter arbitrary info describing the sizes, whereas any lenght can be stored as a number (positive integers or fractions with some given maximum). This way you may multiply quantities and lenghts while not being able to calculate with the diameters.
Am I right, that each article belongs to one distinct type?
Do we need some optional description field for the articles, in addition to the names?
1/8” to 1” all different diameters and lengths from 1/2” to 12” if you create an example with any diameter and length then I can copy and add the other sizes
SimpleInventory2_embedded.odb (60.7 KB)
This next version of a draft stores the sizes as text and the lengths as decimals between 0 and 999,999.999.
The new article types are just A,B,C,D for now with all sample products in group A.
When you open one of the forms for input or output, there is a button labeled “Show —>” which stores the current input before showing the stored statistics Sum(In), Sum(Out) and balance.
The total sums calculate the sums of quantity * length, which may not be what you want. I don’t know.
Max. lenght of article name is 50 as indicated in the form’s column label.
Max. lenght of type name is 30 as indicated in the form’s column label.
Max. lenght of size string is 12 as indicated in the form’s column label.