Hi there, I have a factory and I get orders for both single units and packets.
For example, I get orders for 1 packet of apple vinegar (12 bottles packed in cardboard) which is the Item name I used in production.
My concerns start when I sell 1 bottle of apple vinegar
How does Manager calculate the cost of that bottle without the cardboard?
Is there a way to set the unit price and packet price? and use that in invoices?
Edit: attaching a picture
have you considered using Inventory Kits ? Use inventory kits | Manager
you just need two inventory items Apple Vinegar and Cardboard and then make a inventory kit which includes both.
That works but it has a flow.
The Cardboard is consumed in production and the final product is the complete package.
When I use Inventory Kits the Cardboard will be deducted from the inventory when the sales invoice is made. This results in showing a higher amount of available Cardboard in inventory even though most of it is already used.
as per your example, when you sell one packet, the inventory kit should contain 12 bottles and one cardboard.
when you are selling just one bottle you do not need inventory kit because you are not using the cardboard.
Exactly. But then how do I keep count of available Cardboard in inventory?
I have empty Cardboards (Which I need to track to make purchases before running out)
and I also have it used for packaging in production in real life. The Cardboard is used for more than one product.
You need to create a separate inventory item for the packet of 12 and use production orders to make using 12 bottles plus 1 cardboard box
This will keep track of the boxes, packets and single bottles
Yes but then I will have to create production orders for each invoice containing a packet.
inventory kits reduce inventory quantity just the same way as a production order does. so I am not sure what is your difficulty here.
if you include cardboard quantity as 1 in the inventory kit, the inventory item quantity for cardboard will be reduced by 1 when you make a sales invoice using the inventory kit.
if your workflow is different, then post relevant screenshots of the inventory item, production order and inventory kit to understand better.
Alright, I have attached a picture.
Now I can easily sell packets with no problem. But how do I sell units?
You might say use single units in Production Order and then use Inventory Kits to sell 12units + box
But then how do I know how much empty boxes I have left?
since you have provided screenshots to understand things better, I will provide answers to your initial questions.
Manager will not. because the cost of cardboard is already included in the finished item Apple Vinegar packet 12 when creating the production order.
what you should do is make production order for just one bottle of apple vinegar and not packet.
create an inventory item for one bottle of apple vinegar.
the production order is created without cardboards for one unit each of apple vinegar (606 numbers).
then create an inventory kit for packet which includes 12 apple vinegar and 1 cardboard.
when you are selling one apple vinegar you can select the inventory item and when you are selling a packet you can select the inventory kit.
yes that is the option available.
just because you have taken out one bottle from a packet, Manager will not know that the cardboard is available for reuse. this would be possible when Production Orders are improved to handle multiple finished items which is still in the ideas category.
The real question should be - how do you organise your production?
Do you produce individual bottles from the bulk Apple Vinegar and then make up boxes as and when you sell a box of 12?
Or do you make up stocks of boxes which are available to sell as a box?
It isn’t clear from your description how you manage the process so the suggestions so far are only guessing at what actually happens and trying to adapt the accounting to that
Got it. For now, my only option is to sum all produced bottles and divide it by 12 to get a rough estimate of consumed cardboards and unconsumed ones in inventory. Are there reports to get the sum of currently available items based on a custom field which is the bottle category? right?
edit: typos
We produce them as boxes and we sell both units and boxes but mostly boxes.
So do you remove bottles from a full box to sell single bottles, or when you produce boxes do you have single bottles left over?
If there wasn’t any left of overs or sales returns we open full boxes take the bottles and reuse the box.
If you are reusing inventory items previously consumed by production, you will need to write-on periodically to adjust your physical counts. See Write on inventory | Manager.
that is just an example. you need to create a suitable income or expense account first.
Oh my bad, I thought it was predefined.
