Re: Orders not Invoicing

["Certz" <certz@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rick,

When we upgraded from V4R1 to V4R4  on BPCS 6.0.02, We had a similar
problem, IBM discovered that they had a problem with the select in SQL.
They created PTFs for this problem. Since then we have not had any more
selection problems.

I do not know it this is the same problem you are having. Because in 6.0.02
the record id of the ECH does not matter if it is a CZ or a CH when it
comes to billing. All of my BBH records are BH, all of my BBL records are
BL.

Sincerely,

Chris Ertz


Order the Data Base PTF's for the version of OS/400 you are on.





RickCarter@holley.com on 08/23/2000 02:14:17 PM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:
Subject:  Orders not Invoicing

BPCS 6.1 Mixmode
Just recently and with no BMR's applied, our billing job has been skipping
some invoices during the normal run.
We have discovered 5 orders in the BBL and BBH files with record Id's of
'BZ' and in the ECH file the in use flag is on.  It appears that since
these orders have been in the status their in, it skips them, but also all
other invoices after those.
We've not seen these 'BZ' records before in these files and once we changed
the record ID's to the appropriate ID, those 5 orders invoiced and the
other invoices after them also invoiced properly.
Anyone else seen this type of happening.  Thanks
+---
| 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
+---