Our business just began manufacturing; we have always imported and distributed. However, now we are taking our raw materials and converting into a finished good. We do not have the manufacturing module. We have the distribution module and are in the process of implementing a WMS.
If I am not going to implement MFG module right now, how would I keep track of raw materials, finished goods and waste? I have outlined my original thought process below, but I am afraid it will be time consuming and opens up the possibility for mistakes. I am open to ideas and recommendations.
I have thought about creating a new “Inventory Adjustment” for every sales order. In the “Description”, I would put the SO# and the Job Name so that I could identify the order. Then I would deduct inventory from the raw material to account for the finished good and the waste. And I would add inventory to the finished good. This way, the inventory is now accounted for and we can create a shipment from the SO and invoice the final product. However, the cost of the raw material would not be associated with the final finished good, so I won’t see an accurate sales margin.
Any advice is appreciated. Thanks!