Merge prod. orders for the same item distinct end locations

Delavega

Hi All

We are working in a make to stock environment. Our production orders are calculated using our production forecast. the initial Input looks as described below:
Production Forecast:
Item A for location A, quantity of 5 where location A is a shop in New York
Item A for Location B, quantity of 7 where location B is a shop in Boston

Initialy, our finished goods are all stored in the same location, location C, which is also the location used on the production order. then, we use tranfert orders and ship them to the shops described above.
This looks as described below:
Production Orders
Prod Order 1 for Item A for location C, quantity of 5 where location C is our finished goods warehouse --> will be transfered to location A
Prod Order 2 for Item A for location C, quantity of 7 where location C is our finished goods warehouse --> will be transfered to location C

We would like to combine production orders for the same item. Yet, we would like a way to differentiate which items are meant for Shop A and which are meant for Shop B as final destinations.
the output would look like:
Production Orders
Prod Order 1 line 1 for 5 * Item A for location C and final location A
Prod Order 1 line 2 for 7 * Item A for location C and final location C

The production staff needs to know which destination is the final destination

Thanks for your help!