Hung Invoices

We have a number of invoices which appear to be hung.  From looking in
the BPCS Midrange-L digest, we found the following:

Check all the following fields, if you have plenty of orders that do
not show up for billing then the cause could be in a load shared for
all these orders. Check also the loads for the orders.

 ECH record:
    HINUSE field should be blank.

 BBH record:
    1) BHID field (Record ID) should be in BH status.
    2) BHDOCN field(Document Number) should be blank.
    3) BHWSID (Workstation ID) should be blank.

 BBL record.
    1) BLID (Record Status) should be BL.
    2) BSTAT field (Invoice Status) should be blank.
    3) BLLOAD (Load Number) should be the correct load number that the
order is currently attached to.
    5) BLSTS3 (Ready for Ship Confirm)field should have a value of 0.
    6) The BLSTS4 (Ready for Invoicing) field should have a value of
1.
    7) BLWSID (Workstation ID) field should be blank.

 LLM Record :
    LMSTAT (Load Status) should have a value of 3.

 LLH Record :
    LHSTAT (Load Status) should have a value of 3.

 LLX Record:
    LXSTAT (Load Staus) should have a value of 3.

Is there a way we can just write a program to fix records using logic
as shown above or should we only attempt to fix the invoices records
we know are hung?  Also, is there a report we can run to provide us a
list of the invoices which appear to be hung?

Thanks in advance.


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---