We make cable assemblies for a customer, to do so we purchase a pre-made cable and cut it in 1/2 to make a male or female version of the customer's request... when they order in pairs it's easy but recently they have been ordering one more than another.
here is my question... when we receive "item 1(Full)" I want there to be an operation that cuts item 1 into a male and a female item so Item 1(full) - 1X item 1(male) and 1X item 1(female) these can be added to stock
When customer orders cable x Male the PC would look to see if we have item 1 (male) in stock and vice versa for item 1 (female)...
if either item 1 (male) or item 1 (female) isn't in stock trigger the item 1 (full) operation to create 1 (male) and 1 (Female)
The last issue is we also want to keep item 1 (full) in stock to sell as is.
Is there any way to do this?