[Feature Request]: A better way to add quantity to consumables and track costs for them.

[DrekiDegga]

Is your feature request related to a problem? Please describe.

We would like to be able to track what we paid for consumables given out to users based on what order it was purchased on. Currently when we place a new order to replenish our stock of an item, if we want to track the new cost of the item, we have to create a new consumable and add the order number and cost of the new order. This also means we have to keep them in a different location on the shelves as if they were a completely different item.

Describe the solution you'd like

I'm not 100% sure what the best solution would be but I have put some thought into one possible solution. Perhaps we could add functionality to add orders for the same consumable/accessory.

For example, When you order more of a consumable you already stock, SnipeIT could have an "add order" button(or something similar) on that consumable's presenter that lets you add the latest order number and the cost per unit of the new items.

In the background, Snipe could maintain a table of the individual items and their cost. when a new item was checked out, it could be checked out from the oldest item on the table and the cost that was paid for that item. So it's First in, First out. When the as items are depleted from older orders, the cost billed to a user when the next item is checked out will be from the later purchase.

Describe alternatives you've considered

Alternatively, a more straightforward solution could be developed that doesn't involve the complexity of a FIFO system. This would revolve around an "Add Order" button for each consumable item within SnipeIT. When new stock is ordered, clicking this button would allow us to add to the total quantity and update the current price of the item directly. Additionally, incorporating a notes field would provide an opportunity to log relevant details pertaining to the order—such as supplier information or specific terms of purchase. This method simplifies the updating process by avoiding the creation of new consumable entries or the need for extensive edits on existing ones every time a new order is placed. While it may lack some of the granularity that comes with individual item tracking, it still greatly enhances our ability to keep accurate records of inventory levels and associated costs with minimal procedural change.

Additional context

Something like this could also be useful for accessories.