Inventory Items w/ Unique ID's Viewed Together
Just going to go ahead and apologize now if this is a DUH issue. I am super new and know enough to be dangerous.
I am building an app for my home staging business. I have to track items that I purchase to use in my rental inventory, which gets moved between properties. I also occasionally sell these items to clients. So the app includes recording inventory additions (have a searchable list of inventory), cost tracking for resale/tax purposes, and assigning "locations" so that I can keep track of what items are where.
The heart is an "Add Inventory Item" form with the following fields:
Date of Purchase (autofills current date)
Item Name (single text line - "Brass Table Lamp")
Category (from dropdown - "Lighting")
Qty (# field - "2")
Cost ($ field - "$30.00" - this is per item)
Current Location (defaults to "Storage" but dropdown links to Job Sites form in my app)
Vendor (from dropdown - linked to a Vendor form in the app)
Tax Paid? (radio button - "Yes or No" - for tax calc purposes)
Tax Rate (autofills based on Vendor field, above - store's tax rate)
Item Photo (I snap a photo with my cell phone)
Receipt SKU (I scan bar code on sales receipt)
Item SKU (autofills with the Zoho ID - someday will print as a barcode sticker)
**MY QUESTION**
There are a few items that I purchase at various times of the year - sometimes at different prices, sometimes different vendors, etc. In addition, I often buy an item in pairs, but I don't always USE it in pairs.
EX: I buy Parsons Chairs at IKEA whenever they are on sale. The price, purchase date, vendor location, and tax paid may vary...but it's the exact same chair. Or, I buy a pair of table lamps at HomeGoods, but only put one in a property.
If I use my "Add Inventory" form, I think I have to enter EACH ITEM INDIVIDUALLY, even if purchased at the same time for the same price, to create an individual Item SKU for each one. Which is a pain in the ass when I buy 2 or more of the same item.
- On my Inventory List report, I have a view set up that shows ALL items that I own, grouped by Category, with a photo. But if I add each item individually, the list is HUGE and full of repeats.
- On my Location report, I have a view set up that groups all items by Current Location. I use the edit and bulk edit functions to "move" items to and from job sites and storage. If I enter each item individually, the lists are still huge and I have to check each item ONE AT A TIME. Not a huge deal with the Bulk Edit feature, but....
- On my Receipts report, I can query a Receipt SKU to see all of the info on the items purchased on that receipt. (Cost, Vendor, Tax, date, etc.) - don't see a problem here.
I played with the free Inventory Management 6.0 but I feel like it is overkill. I could copy some of the coding but it's all based on selling items and restocking the same item, with no apparent price or vendor history?
Anyone have a simple solution they can throw out there???
Thank you!!!
Kristen
Pencil Sketch Staging & Design