Repacking Promotion Product - Community Edition

Example: 1 blood test machine comes with 1 test strip as a set. But supplier is having a promotion and gave you additional 2 test strips in 1 set. You wants to sell the 2 test strips separately as normal items, which means they need to unpack from 1 promotion set to 1 normal set + 2 test strips and decide the cost for each item,

User can create a repack form manually in backend and provide all needed inputs:

• Location: location that they're using products to repack (only can see internal locations
• Products (uom, qty, lot number) used to unpack and products and repacked products (uom, qty).
• Cost Difference (difference between original product and repacked product)
• Cost of "source" product is real-time average cost of that product.
• Cost of "repacked" product is calculated when user create this repack form and the value is distributed from cost of "source product" with the proportion of its current average cost over total cost of all "repacked" products

Example: Unpack from A to B + C
B's total cost = (B's qty * B's average cost)/[(B's qty * B's average cost)+(C's qty * C's average cost)] * (A's qty * A's average cost)
B's unit cost = B's total cost / B's qty