RE: User controlled Printer file in ASSET (Amitava Banerjee)

["Charlie J. Borill" <CJBORIL@xxxxxxxxxxxxxxxx>]

How many customers do you have to do this for??

>>> Sonny.Kim@mail.cone.com 05/16/02 03:34PM >>>
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Amitava,
This is what I would do:
1.      Create a separate batch program call ACR22AB - Accounts Receivable
group by customer.
2.      At subroutine A0RUN of  ACR220D replace call ACR220B to ACR22AB.
Program ACR22AB keep all parameters same as ACR220B.
3.      Primary driver SQL for ACR22AB would be as below:
 T8LCMP = W1LCMP        ; copy lower limit customer to temp field
 T8UCMP = W1UCMP        ; copy upper limit customer to temp field

DECLARE C1 CURSOR FOR DISTINCT SELECT RCUST FROM RAR

WHERE RCOMP BETWEEN :T8LCMP AND :T8UCMP AND RCTYP BETWEEN :W1LTYP

 AND :W1UTYP AND RCCUS BETWEEN :W1LCUS AND :W1UCUS

 AND RCURR BETWEEN :W1LCUR AND :W1UCUR AND RRID NOT IN ('ZI','ZP','ZC','ZD')


4.      Per each customer pass all parameters from ACR220D with W1LCUS and
W1UCUS change to same customer number than call new CL program -ACR220AC.
Create a reference table to pass outq name for customers.
5.      Create ACR220AC - CL which will override outq of ACR220O. Override
ACR220O with new outq than pass parms with single customer number range to
ACR220B.

I would do it this way because it would be a minimal change to BPCS program.


Good luck!


Sonny Kim
Information Service
Cone Mills Corporation
804 Green Valley Road, Suite 300
Greensboro, NC 27408
336.379.6120


-----Original Message-----
From: Amitava Banerjee [mailto:Amitava.Banerjee@trin.net]
Sent: Thursday, May 16, 2002 2:41 PM
To: bpcs-l@midrange.com; bpcs-l-request@midrange.com
Subject: User controlled Printer file in ASSET (Amitava Banerjee)


Hi Sonny
It is ACR220D in 6.0.04 version.
Amitava


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.




-------------------------------------------------------------------------------------------
Note:  Please update your email address for this user to reflect the
new MeadWestvaco Corporation.  MeadWestvaco employee
email addresses are in the format of  user@MeadWestvaco.com

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure.  The
information is intended to be used solely by the recipient(s)
named.  If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited.  If you have
received this transmission in error, please notify MeadWestvaco
immediately at postmaster@MeadWestvaco.com.
-------------------------------------------------------------------------------------------