RE: URGENT !! Big problem in 'INVOICE RELEASE'

Victor,
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.


 
   
                    "Victor Chan" 
   
                    <atohkvc@netvig        To:     "BPCS List" 
<BPCS-L@midrange.com>
                    ator.com>              cc:     "SSA Pacific Helpline" 
<helpline@ssa.com.au>, "Arlindo
                    Sent by:               Berca" <atoarlindo@yahoo.com.hk> 
                    owner-bpcs-l@mi        Subject:     URGENT !! Big 
problem in 'INVOICE RELEASE'
                    drange.com 
   
 
   
 
   
                    07/31/00 12:17 
   
                    PM 
   
                    Please respond 
   
                    to BPCS-L 
   
 
   
 
   



We are having a big problem for Order Processing in our BPCS system
(V6.0.02 Mar98 Cum Full C/S).  When our colleagues try to perform the
"Biling - Invoice Release (BIL500D)" after they have completed the Pick
Release and Pick Confirm steps, they receive the message "No records found
starting at entered search argument"

They are now in month-end peak interval and there are nearly 100 orders
pending for Invoicing !!

I've tried to perform the Invoice Release in our TEST environment and this
is no problem for processing.

I've already compare lots of tables between LIVE and TEST environment and
still do not find anything unusual.  I've examine the tables : BBH, BBL,
ECH, ECL, ZPD, IPP, EIL.

Thanks to giving me some advices.

Victor Chan




+---
| 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
+---


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| 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
+---