Changing the Inventory template
Hi experts, hoping someone can help! I own a small business importing electric guitars and have previously used a spreadsheet to track orders and sales but that has proven to be an inefficient solution over time. I have purchased and played around with Ninox but am whatever the exact opposite of an expert is. Fortunately, the built in template for Inventory is almost exactly what I need as it tracks purchase orders, sales, stock levels and customers. Apart from obviously customising the fields to what I need, the one big thing I need to change is that I need to record the serial numbers of the guitars for warranty purposes.
I know that I will need to make a new table specifically for the serial numbers, what I don't know is how I need to connect it to the rest of the template or which references will need to be changed. Is this something that will be relatively easy to do or am I better off sticking to my current system? I've incliuded the current data model.
4 replies
-
Actually, you only need the serial number when selling?
Then I would only put an extra field for the serial number in the child table of 1_Client Orders (Sales in your data model)
No need for an extra table.Steven
-
Of course Steven is correct that you don't need a new table.
I would think that serial number is a characteristic of guitar, so I would create a serial number field in that table. I'm guessing that the Article table stores guitar data.
Just my 2 cents.
-
Well I don't totally agree Fred (no offense), from a seller point of view, I would only put the serial number when selling the guitar. Because when you purchases 100 of the same model of guitars, you need to put all the serial numbers when receiving them(also open all the packaging) and use 100 different articles with the same data except for the serial number. My solution also connects the serial number with the client and with the guitar sold.
Steven
-
Those are good points. If you have 100s of the same item then you would have to create 100's of records, thus making the article table combersome.
If you do want to track serial number per item, from an inventory point of view, then you would need to create a serial number table and set Composition to Yes to the Article table thus making it a child.
Content aside
- 3 yrs agoLast active
- 4Replies
- 430Views