How do I track damaged goods in inFlow Cloud?
Depending on the industry you work in, sometimes you may want to account for wastage during the assembly of an item or perhaps track the percentage/portion of damaged goods returned by your customer that you end up having to throw away. Here are some tips on how to handle that:
Handling waste during assembly / work order
When you create a product out of raw materials, sometimes you end up using extra materials or have to throw away damaged ones. This would cause the cost of the assembled item to go up, and you’ll probably want to track that in inFlow!
- Create your work order as usual and start picking the materials you require to finish the order.
- If you find that you have picked more than what was listed in the order, you will need to add it by clicking on the assembled item in the list and then right-click > Add Component Item.
- Add the extra wasted components and then complete the work order.
The materials will deduct accordingly and its costs would contribute to the unit cost of this assembly.
Tracking wasted/ damage goods returned by customers
When you process a sales return/refund for your customer, you can choose whether or not to “Discard?” the returned goods. If you do check the discard box, this means you don’t restock them to ensure correct inventory levels. However, as inFlow doesn’t natively track the cost of returns in any reports, if you’d like to report on the number and type of goods wasted, try the following!
- Create a customer named “Waste” or “Damaged Goods”.
- Whenever you process a sales return/refund, instead of marking it as discarded, restock them.
- Open a new sales order immediately for the customer “Waste” / “Damaged Goods”. Sell the damaged item to this customer at $0 (to correctly calculate the profit loss)
- Complete the sales order.
You can then run a customer order history or sales order profit report for this customer to see the total amount of items wasted, or total cost / profit.