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

[Sonny Kim <Sonny.Kim@xxxxxxxxxxxxx>]

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.