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

Pick Confirm in ver6.00* will send the orders to be ready for billing...
(run a query over bbh and bbl and see if the bhwsid or blwsid fields are
populated with data.....if they are use billing reset is sys reorgs or run
the following sql statements....
update bbh set bhwsid='    ' where bhwsid �='     '
and
update bbl set blwsid='    ' where bhwsid �='       '
also check hinuse field on ech...
(a failed billing run will leave workstation fields populated)
to update ech hinuse run following statement
update ech set hinuse='   ' where hinuse �='     '
    run when no one using customer orders.

-----Original Message-----
From: MacWheel99@aol.com <MacWheel99@aol.com>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: 31 July 2000 19:05
Subject: Re: URGENT !! Big problem in 'INVOICE RELEASE'


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


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