Re: BPCS 6.04 Invoice Release and Billing Automation Technical Question

We have automated our invoicing at V6.1.01, which is pretty much the same 
as at V6.0.04 (I believe).

Our process is set to process ALL orders that are in a Ready to Invoice 
status, and we do not do anything to update the BBH/BBK etc tables before 
we run. We do ensure that ECH/HINUSE is set off before the job runs to 
avoid missing orders that someone left locked.

The batch job we run simply mimics using BIL500D, by setting the 
parameters and calling BIL500B.

I do not think you can get this to work by calling BIL501B as BIL500B does 
a lot of updates to BBH/BBL - setting totals etc, and going by your 
symptoms, that is what you are missing.


If you need to control what orders can or cannot be invoiced, try setting 
ECH/HINUSE to 'Y' for orders you do not want to invoice before running 
your billing job.


Doug McLauchlan






washburnccinc@xxxxxxx 
Sent by: bpcs-l-bounces+doug_mclauchlan=planar.com@xxxxxxxxxxxx
01/17/2006 12:46 PM
Please respond to
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>


To
bpcs-l@xxxxxxxxxxxx
cc

Subject
[BPCS-L] BPCS 6.04 Invoice Release and Billing Automation Technical 
Question






I am trying to automate the Billing Process so that it can run at night 
all invoices.  I have created a RPGLE program that selects the Orders that 
we deem to be ready for invoicing and then it Calls BIL501B with the parms 
BIL501B needs. 
 
    It updates the fields in the BBH, BBL, and ECH file as if they were 
selected through the regular billing selection program BIL501D1. 
 
File/Field     Description                  Value needed
BBH/BHWSID     Workstation Name           AUTOBILL 
BBH/BHCTRL     Document Control#          Sequential Number 1,2,3, etc
 
BBL/BLWSID     Workstation Name           AUTOBILL 
BBL/BLCTRL     Document Control#          Sequential Number 1,2,3, etc
 
ECH/HINUSE    In Use Flag                 Y
 
 
The problem I am encountering is that it generates all the reports, 
invoices, and updates the needed files, but they come out with Zero 
dollars on all of them and it does not get rid of the BBH & BBL reocrds. 
 
Has anyone else run into this? 
 
Thanks in advance for any help offered.   Kevin W.