We are in the metals industry, and one of the somewhat unique aspects of our business from an ERP perspective is that sometimes we will cut pieces of material that we sell into smaller pieces, per our customer’s request. So as a simple example, let’s say you have a 20ft x 20 ft piece of aluminum plate, and the customer asks for a piece that is 16ft x 18ft. We will cut that plate to size, and then have a remainder (what we call a remnant or a piece) that is left over. Sometimes we will directly scrap this remainder (not keep it around), and other times we will keep it on hand and sell it to another customer, or use it to cut another piece for a customer who may require a size smaller than that previously cut piece. We need to maintain heat/lot tracking of these pieces from the parent item.
Does anyone have any clever ideas about the best way to program this in Acumatica? You could obviously create a new item every time you create one of these pieces, that is the exact dimensions of the piece. And you could have some sort of reference system to link back to the parent item.
Since these are all one-offs, should they be stock or non-stock items in Acumatica? We will still need to track them in the warehouse.
I’m mostly interested in how to model this as a data problem in Acumatica (versus UI concerns), but any creative ideas on how to handle it up and down the stack would be appreciated.
Keep in mind that while MRP is probably an answer to this problem, it may be overkill. We are literally just taking one thing, and making it two (or three or four), with all the same characteristics as the parent (except its new size/shape).
Best answer by Doug JohnsonView original