Sales Order Allocation Issues

SOLVED

Problem Statement:

In our business we produce spools of material that do not always weigh exactly the same all the time. When we sell a certain number of spools there is a total weight (Let's say 500Lbs) the customer wants. On the Sales Order Line, the quantity to allocate will be 500Lbs. We may have spools that add up to 510Lbs. When doing the detailed selection of product Sage will limit the allocation to 500Lbs. What ends up happening, if a user doesn't go in and manually update it, is that we will end up with a "partial" spool for say 10Lbs due to Sage limiting the allocation. Is there a way to turn this off so when the user selects the detailed product Sage will update the qty to allocate accordingly?

Any insight into a possible solution would be greatly appreciated!