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

["Devin Bowen" <devinbowen@xxxxxxxx>]

Victor,

 

Some questions that may help you resolve your problem:

 

1.  Do you have BBH / BBL for the orders in question?  (If no, BIL500 will never show you any records and the lines are either already invoiced or NOT ready for invoicing). 

2.  Do you have EWR for the orders in question (pick confirm workfile records - would probably prevent BIL500 from finding these records)?

3.  Do orders that you believe are ready for invoicing have CLSTS4 = 1 (that is, are they actually confirmed)?

4.  Do your orders have an order class that requires SHIP CONFIRM (that is, are your orders CLASS 002 or CLASS 005 - if they are, you must complete ship confirm before invoicing can occur!)?

5.  Are orders that you believe are ready for invoicing in use (HINUSE in ECH = 'Y')

 

Hope these questions help (sorry if you have already checked all of the above and I am providing info you don't need!)!

 

Devin

 

Devin Bowen
Enterprise Application Solutions
360-607-1642
419-730-5522 eFAX
devinbowen@home.com
 

----- Original Message -----

From: Victor Chan

To: BPCS List

Cc: SSA Pacific Helpline ; Arlindo Berca

Sent: Monday, July 31, 2000 9:17 AM

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

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