owxe
Member
HI GUYS,
I HAVE A QUESTION.
I AM TALKING ABOUT THE PRINT INVOICE PROGRAM(R42565).
I WOULD LIKE TO ASSIGN THE NEW INVOICE NUMBER IF BILL OF LADING NUMBER
CHANGES.
FOR EXAMPLE.. IF THERE IS AN ORDER WITH 5 LINES WITH SAME ORDER TYPE, LINE
TYPE, COMPANY, ALSO SHIP TO.BUT THE ONLY DIFFERENCE IS BILL OF LADING NUMBER
I.E SDCNID in F4211.
Each line may has different bill of lading number. Then I need different
invoice number for each line and it should page break.
Is there any way of getting this..
I hope you got my point.
would like to assign the new invoice number whenever the bill of lading
number changes..Right now this program is giving the new invoice number if
order number changes or company changes or order type changes..
I appreciate your help on this.
thanks
>From: RAMMEDJR <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: F43199 Full Table Scans ~~0:4870
>Date: Wed, 31 Jan 2001 11:28:20 -0800 (PST)
>
>During the past two weeks monitoring the Oracle database I have noticed
>that
>some application is doing periodic full table scans of the F43199. Is
>there
>someway I can tell which app is causing this.
>
>Thanks.
>
>Dave Rammer
>Sheboygan County IS
>
>
>OW B7331 SP11.2 / HP-UX11.0 / Oracle 8.0.6
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4870
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
I HAVE A QUESTION.
I AM TALKING ABOUT THE PRINT INVOICE PROGRAM(R42565).
I WOULD LIKE TO ASSIGN THE NEW INVOICE NUMBER IF BILL OF LADING NUMBER
CHANGES.
FOR EXAMPLE.. IF THERE IS AN ORDER WITH 5 LINES WITH SAME ORDER TYPE, LINE
TYPE, COMPANY, ALSO SHIP TO.BUT THE ONLY DIFFERENCE IS BILL OF LADING NUMBER
I.E SDCNID in F4211.
Each line may has different bill of lading number. Then I need different
invoice number for each line and it should page break.
Is there any way of getting this..
I hope you got my point.
would like to assign the new invoice number whenever the bill of lading
number changes..Right now this program is giving the new invoice number if
order number changes or company changes or order type changes..
I appreciate your help on this.
thanks
>From: RAMMEDJR <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: F43199 Full Table Scans ~~0:4870
>Date: Wed, 31 Jan 2001 11:28:20 -0800 (PST)
>
>During the past two weeks monitoring the Oracle database I have noticed
>that
>some application is doing periodic full table scans of the F43199. Is
>there
>someway I can tell which app is causing this.
>
>Thanks.
>
>Dave Rammer
>Sheboygan County IS
>
>
>OW B7331 SP11.2 / HP-UX11.0 / Oracle 8.0.6
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4870
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com