Re: URGENT !! Big problem in 'INVOICE RELEASE' -- BPCS-L

Is your company new to BPCS or are you personally new to BPCS because it 
appears to me that you are glaringly missing at least one step in the process 
... SHIPPING ... Pick Confirm is done before shipping, then ORD590 generates 
the shipping documents & updates the shipping status to show that you are now 
ready to bill, then you check the shipping documents & if they are not 
perfect, use ORD600 to make corrections, then proceed with BIL500.  I am on 
V405CD which has some differences with V6*, but it is evident to people 
experienced in doing BPCS at this level that you cannot invoice until you 
have shipped, unless you are going the post-ship billing BIL600 route.

This is what leads me to suspect that either your company is a beginner at 
the BPCS game or that you are a new hire who did not get full education in 
what the process is.  You might also like to take a look at the ES* 
(shipping) files.

Our steps are
1. Customer Service enters the order.
2. MRP every nite
3. Production Control releases shop orders & builds the parts & various other 
departments contribute like Purchasing raw materials.
4. Shipping department runs query list what is due to be shipped to day.
5. They go the Pick Confirm route, making adjustments in case Production has 
made the part but not caught up on labor & inventory transactions.
6. Shipping documents are printed & updated via ORD590 ... the step you seem 
to be missing.
7. They run queries to help verify no oops in the last steps ... like 
identifying wrong number of cartons or other typo & make any corrections & 
ORD600 corrected output & double check that, then inform accounting that it 
is Ok to go ahead & do the billing
8. Billing confirms no concurrent users who might have locked out access to 
any customer orders involved, then proceeds.

>  From:    atohkvc@netvigator.com (Victor Chan)
>  
>  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

Al Macintyre  ���
MIS Manager Green Screen Programmer & Computer Janitor of BPCS 405 CD Rel-02 
running on AS/400 V4R3 http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies
+---
| 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
+---