|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.