Re: Hung Invoices

The answer to both of your questions is yes . . . both can and have been 
done many times by many clients.

#1 - I would not recommend writing a program to just update records to the 
condition you think they should be in unless it would be called by order and 
updates only that order based on the full logic you listed plus a little 
more (ecl statuses, for example).  It's pretty dangerous to go "fixing" 
records before you're sure the extent of what's wrong because there can be 
MANY flavors of "hung" invoices (this makes a program tricky to write).  If 
you have enough orders in this state to need a program run every day, you 
need to address the causes of this.  This shouldn't be an every day 
occurrence.  BPCS invoicing does have its moments, but 99% of your invoices 
99% of the time should be processed correctly, if you're on a recent version 
with BMRs applied.  My advice on the program question is to get VERY 
familiar with

A.  what the proper updates in the billing-related files look like

B.  what various levels of corruption look like and track down the causes

before even considering an automated solution.



#2 You've just listed the criteria for your own report.  You just need to 
use a tool (like SQL or a third-party query/report writer) to write it.  BBH 
and BBL are the primary files - with ecl, ech, llm, llh, lll, llx, sih and 
sil as supporting.

You didn't mention it, but I have seen cases where there are records (both 
normal and "funny" looking) in bbh/bbl but records in sih/sil as well 
(meaning the invoice was created - just that the billing work file records 
were not removed).  This is an example of a case where a far different 
solution is necessary (you can simply remove the unneeded bbh/bbl) than to 
prepare the records for invoicing.  I've seen people go messing around with 
bbh/bbl without the full picture and end up with duplicate invoice records 
after all is said and done.

A hammer can be used to cut glass, but it's not very precise.


Hope this helps,

Devin

Devin Bowen
Enterprise Application Solutions (eAS)
dbowen@easolutions.net
www.eASolutions.net
(360) 607-1642 (Voice)
(419) 730-5522 (Fax)


>From: cmassoglia@voyager.net
>Reply-To: BPCS-L@midrange.com
>To: BPCS-L@midrange.com
>CC: vaneeb@gte.net
>Subject: Hung Invoices
>Date: Sat, 27 Jan 2001 19:52:21 -0600 (CST)
>
>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
>+---




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.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
+---