Hey guys. I'm trying to build an invoicing and customer database for my small sheet metal business. I don't need inventory functions. Any ideas of basic templates to get me started? I used to be fairly literate in this stuff but it's been a while.
Also. One of my main issues is that I need items priced on the invoice based on a "multiplier" from a table and the size (2W x 2H x L Factor). That's what's really stumping me at this point.
Example. I input item #. It looks that up and inserts item from list. Then asks for H, W, and L. The L is linked from a "factor table" based on the length I input. So maybe 10" is .23 in the price formula.
Any help us greatly appreciated!
Also. One of my main issues is that I need items priced on the invoice based on a "multiplier" from a table and the size (2W x 2H x L Factor). That's what's really stumping me at this point.
Example. I input item #. It looks that up and inserts item from list. Then asks for H, W, and L. The L is linked from a "factor table" based on the length I input. So maybe 10" is .23 in the price formula.
Any help us greatly appreciated!
Last edited: