Cost Distribution of Single Workorder for Multiple Assets

Hi All,

Has anyone of you come across this type of scenario? Please share your valuable ideas.

Our scenario is sending assets out for repair and then returning the repaired assets to inventory. This process needs to be executed for multiple assets under one work order. Therefore, we are creating a work order using asset items and enabling the "Complete to Inventory" option to get back to inventory.

According to our customer's operation, they require the ability to use multiple assets at varying costs. For example, they will send 5 motors for repair and 3 motors will be repaired at a cost of $50 each and 2 motors will be rejected as they can not be repaired (No Cost). The issue arises after the work order is completed, the total cost is divided by the total asset count (e.g., $150 divided by 5).