My company uses "perpetual" scheduling agreements with our suppliers, often many years old. Historically, we have kept the "unlimited" indicator on for all line items, in order to avoid errors which result from early delivery of schedule lines. Now we would like to become more disciplined and have therefore implemented a user exit which will allow receipts up to 7 days early but stop anything beyond that window. Accordingly we want to un-check "unlimited".
However, due to many years of bad practices, we find that we have a number of line items which have quantities delivered which exceed quantity ordered. Rather than re-check the "unlimited" indicator and remove our new controls, we need a way to clean up these imbalances. Essentially, we would want to set the current ordered quantity to equal delivered quantity as a "true up" and then move forward with our new controls.
Can anyone suggest a way to do this that will not drive additional requirements? Or are we forced to delete this line item and create new ones when we encounter this condition?