Is there something I can do to limit a product to one order at a time?
For example - Product A is already associated with Order 1.
I create order 2 and try to select Product A but it will not let me. I have to select a different product.
If this can be done I also need to be able to close Order 1 once complete and Product A then becomes available for selection again...
I can't work out if my brain isn't working properly or I'm trying to get blood out of a stone!
Hi,
Sorry for taking so long to reply. No I don't think this helps as we're not using quotes, just orders. Unless I need to implement another step to create what I'm trying to do. I think my problem lies within the product itself.
To create the order you need to select a product - I want this product to be only associated with this order whilst the order is in progress. Once the order is complete, I want to be able to select the same product again (but only once the first is complete and not in progress).
Eventually I need to be able to run a report to see 'All Products' and 'All products available/not available' (available meaning they are not associated with a live order.
Hope this explains a bit more what I'm trying to achieve.
