Another question: Does the Tree provide all the silver that is necessary to make the leafs? Or do you add additional silver sheets or ingots or whatever?
Another question (these two questions are not related to each other): When the tree is scrapped to be recycled, though the tree is made of Silver and Wax, you are mostly worried about reclaiming the silver, right? Or is reclaiming the wax super important for you also?
The tree is actually made out of wax, after it is done the technician will put casting gypsum to take the shape of the wax, and then put it in an oven for the wax to be drained out of the cast and then add the silver.
The wax cannot be reclaimed, and the silver is going to the scrap warehouse anyway, but the issue is how to make a bom for this or any other type of documents that will result in products (leafs) going into stock and maintaining it there for another use.
Okay, since you are suspicious that I’m just trying to get details about your business, let me give you my suggested approach with the level of detail I have with me.
First a few statements:
A BOM is only useful for you for material planning purposes.
You cannot use a BOM to make manufacturing entries (which is why No. 1 above)
Here’s what I would do:
I would create an Expense Account called Silver Molding Consumption and Yield.
The silver that I’d issue for molding, I would issue out using Stock Entry Purpose Material Issue and charge it to Silver Molding Consumption and Yield Account.
Now as I make silver leafs, I will use Stock Entry Purpose: Material Receipt and charge it to Silver Molding Consumption and Yield Account.
As I reclaim Silver Scrap, I would charge it again to Silver Molding Consumption and Yield Account.
A general ledger report of the Silver Molding Consumption and Yield Account would give me the imbalance in this account. The imbalance would be because of better or worse than expected yields of Silver Leafs and Recovery of Silver Scrap.
You need to watch this account, build a valuation model that sets the valuation for the next period of watch (you can begin with a weekly period and then move it to Fortnightly and Monthly). Steady state you can keep the period at Monthly or if your yields are steady even quarterly.
Another approach would be to build the BOM to resolve into Silver for everything - Like Each Silver Leaf (and you could be making dozens of different types of silver leafs) translates in the BOM into X Grams or Kgs of raw silver. Similarly Silver resolves into X Grams of raw (recoverable in this case) silver. In this approach,instead of using Stock Entry Material Receipts and Issues, you’d drop the Silver into a Virtual warehouse (say Silver Molding Warehouse) and then you’d pull out each item separately using a BOM. So, let’s say you dropped 1000 Grams of Raw Silver into this virtual warehouse. And you pulled Silver Leads out of this warehouse that accounted for 835 Grams of raw silver. And you recovered scrap that translates into 140 grams of raw silver. Now at the end of the cycle, the stock balance report of Silver Molding Warehouse will show 25 Grams of Raw Silver. You take it out of the warehouse by making a Material Transfer into a Unrecoverable Silver warehouse or you make a Material Issue and charge an account called Unrecoverable Silver. Keeping a tab of this account will tell you whats the wastage of silver in your process so that you can add that as a percentage into your costing.
You deal with a precious metal. Chances are you have very good controls on the floor. But ensuring that the data is captured into a structured data solution such as ERPNext will help you analyze the yields and ensure that you can optimize the yield while ensuring that you are costing your products appropriately.
Anybody that’s lasted this long reading this piece: two messages:
Think out of the box
It’s possible to hack ERPNext to make it fit for almost every business and every vertical. But you need to start with business goals first. Else you end up agonizing over Item Masters and BOMs.
So, you have multiple leafs that are made. With each batch the Leafs that are made and the quantity varies, right? All of them use Raw Silver (or some for of Silver).
If what I described is correct, you have 1 raw material that could make multiple items. Plus there is scrap that is generated. And the whole thing depends on the orders you get. Like Product A that you sell might need P Nos. of Leaf X & Q Nos of Leaf Y and Product B that you sell might need R Nos of Leaf X and S Nos of Leaf Y.
Plus you decide which leafs to make depending on the demand, right?
Please let me know if all of this is right. If I drone on, I might confuse you and waste your time.
If this is your situation, it’s a bit complicated process and a BOM cannot work for you. You can still make manufacturing entries another way, but please respond so that I can provide appropriate inputs.
You got it. But maybe you don’t have to create a new document. You can use an existing one, like say a Sales Order (if you make the Leafs on Make to Order) or a Material Request (if you make the Leafs on Make to Stock).
Do you decide which Leafs to make for every tree? Or does the Technician decide based on what’s the optimum mix for that tree?
So is this Silver Plating of Leafs? Or making the molds for leafs?
Either ways, let’s say you know what Leafs you are making. And what raw material you are consuming to make those Leafs. Since there is variability in the throughput, and the generation of scrap and since you deal with precious metals you want to track the actual consumption on the shop floor (or whatever else you call it).
Now, is it known before the process as to what Leafs are being made on a Tree? Or you know partially? Or is it all very uncertain?
If you know before hand a document such as Material Request can be populated with the Leafs. You can (with scripting/coding) convert the document (Material Request) into a Stock Entry Purpose Manufacture where the Leafs and quantities are all populated with a Target Warehouse (In the Stock Entry Purpose Manufacture document, the finished/transformed item needs to have a target warehouse). Now this document can also have a line item for the Silver Scrap that was recovered and the Technician (or whoever else) enters this quantity. The scrap again has a Target Warehouse meaning that it is an output item. This document also has a line item for the Silver that is consumed. Again the operator of the process (or whoever) enters the quantity of silver consumed for this tree/transaction. You Save/Submit and everybody is super happy.
Now, if you don’t know what Leafs are being made and it’s situational/opportunistic, you have no document that you cna create before hand, so you can enter that directly into ERPNext as a Stock Entry Purpose: Manufacture.
You da man! I like to use Stock Entry Purpose Material Issue (to consume input Materials) and Stock Entry Purpose Material Receipt (to Produce output materials) a lot too. But the only trouble with that is that, if you want to value the output materials based on the value of the input materials consumed, you will need to link up the Material Issue and Material Receipt together, which is more code.
All the attributes / operations for this Doctype will be the same as the BOM (in some way), which means it can be populated from sales order and work order (although i think sales order is not efficient).
From the DocType it will be linked to Scrap warehouse, Stok Entries and Material Issue.
I will also create a report for this to make sure it is not confused with other orders.
The only issue for me now is learning how to actually link these together, which I will have time for after new year, and should make a pull request or at least an app repo in a 3 weeks or so after beginning.
Although, This whole doctype project might go away as my GF ( a developer as well ) wants to help me in it and create a full Jewelry module based on ERPnext, so still in the talks