I am currently working with support on an issue regarding incorrect
critical ratios for some of our MO's. It is given CR = 0 for several
orders that are not late and in no danger of being late. For example,
one order has 1.25 hours of time remaining and is due on 12/15/11 and
shows a critical ratio = 0.
I am curous if anyone else has the same or similar issue. If anyone has
time to run the following SQL, it will show any orders that have
critical ratio = 0 and the due date is not in the past.
select * from amflib.momast where ratio = 0 and
date(digits(dec(19000000+odudt,8,0))||'000000') > current_date and acrec
<> 'X' and orlcd <> 8
Thanks for any help and input into this problem.
California Fine Wire
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.