• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

A/P WorldWriter

dale_draper

Well Known Member
I want to attempt to make a WW based on the A/P files F0411, F0413 and
F0414. But because of their structure and different levels of detail, I know
this will not be easy to reduce duplication of data on the output etc. All
of the normal trials when doing something like this.
Before I bang my head on this one, does anyone have a successful WW with
these files joined? If so, how are they joined?
Are there additional joins in the data selection?

Very great thanks in advance,

Dale
7.3c9
v4r4
 

LDiMarco

Member
What are trying to write? Voided pymts? Payment instrument? You can use doc
co to join or even batch #. If its pymts you don't need the 3 files.
 

ssolberg

VIP Member
I recall going down this path once but can't remember my results. Take a look at file F0411JD. It is a join logical on these 3 files already, even though the description of the file says something about being an "As Of" file. I looked at the source and appears to be just what you might be looking for?

Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, SP14.2 V4R5 (not happy)
 
The join(s) are: F0411-RPDOC to F0414-RNDOC (Document number), then
F0414-RNPYID to F0413-RMPYID (Payment ID). You can't go directly from the
F0411 to the F0413, you always have to go through the F0414 between them.
Don't forget that the payment ID is an internally generated number and is
NOT the check number. Hope this helps.

Tim Miller
Gentiva Health Services
7.3 c10
 
RPDCT F01 EQ RNDCT F02
RPDOC F01 EQ RNDOC F02
RPKCO F01 EQ RNKCO F02
RPSFX F01 EQ RNSFX F02
RPSFXE F01 EQ RNSFXE F02
RPAN8 F01 EQ ABAN8 F04
RNPYID F02 EQ RMPYID F03


File 01 =f0411
file 02=f0414
file 03=f0413
file 04=f0101
I had included the address book file but it is not necessary.
 

dale_draper

Well Known Member
Thanks you all, the F0411JD looks like just the ticket. I've a list of all
JDE data files "PF's" but this was overlooked as it's an "LF".


Thank you Tim, that is exactly why I was asking this question. I've got a
speadsheet arranged so that matching fields for these three files sort
together, very few fields are valid across all three, none of which would be
usable for a report:
CRCD Currency Code
CRRM Mode (F)
JOBN Workstation ID

Heck even AN8 wasn't across all three, though I was planning to join the
F0414's AB# with the other file's "Payee Address Number" as the values would
be the same.

Thanks to all again, saved me from some self inflicted bruising. <BG>

Dale
 
s (in JDE versions after 7.1) If you try to link these files separately, th=
ere will be a lot of processing overhead and unpredictable results may occu=
Analyst
Durr, Inc.
734.459.6800
fax # 734.459.5837
e-mail add=
ress: rrobinson@durr-usa.com
</P>


<FONT SIZE=3D2>dale_dra=
per <dale.draper@seu.sega.com>
</FONT>
<FONT SIZE=3D2>Sent by: =
SIZE=3D2>To:</FONT> <FONT SIZE=3D2>jdeworldml@jdelist.com</FONT>
<FONT=
SIZE=3D2>cc:</FONT>
<FONT SIZE=3D2>bcc:</FONT>
<FONT SIZE=3D2>Su=
T FACE=3D"Monospace,Courier">I want to attempt to make a WW based on the A/=
P files F0411, F0413 and
F0414. But because of their structure and diffe=
rent levels of detail, I know
this will not be easy to reduce duplicatio=
n of data on the output etc. All
of the normal trials when doing somethi=
ng like this.
Before I bang my head on this one, does anyone have a succ=
essful WW with
these files joined? If so, how are they joined?
Are th=
ere additional joins in the data selection?
</FONT>
<FONT FACE=3D"Mon=
visit the JDEList forum at:
<A HREF=3Dhttp://198.144.193.139/cgi-bin/www=
/cgi-bin/wwwthreads/showflat.pl?Cat=3D0&Board=3DW&Number=3D19366</A=
is the JDEList World Mailing List.
Archives and information on how to &n=
bsp;SUBSCRIBE, and
UNSUBSCRIBE can be found at <A HREF=3Dhttp://www.JDEL=
- - - - - - - - - - - +</FONT></P><CODE><FONT SIZE=3D3>

This email is confidential and intended for the use of the

individual to whom it is addressed. If you have received this

email in error please notify the system manager.

This message has been checked for viruses.
 
Dale, this is from a query, but I also had F0911, F0901 and 3 x F00365 file
for dates, as this was done in Query400.

GLAID EQ GMAID
GLDCT EQ RPDCT
GLDOC EQ RPDOC
GLDCT EQ RNDCT
GLDOC EQ RNDOC
GLDOC EQ RNDOC
RNPYID EQ RMPYID
T06.ONDTEJ EQ GLUPMJ
T07.ONDTEJ EQ RPDIVJ
T08.ONDTEJ EQ RMDMTJ


Regards

Ian Newman
Project Manager
(JDE-A7.3c12)
Dreamworld
www.dreamworld.com.au

Never Had So Much Fun!

Ph: +61 7 55881163
Fx: +61 7 55881108
Mb: +61 413 437594
Em: ian_newman@dreamworld.com.au

The information contained in this email is confidential. If you are not
the intended recipient you may not disclose or use the information in this
email in any way.



"Draper, Dale"
<dale.draper@seu.s To: "'jdeworld@jdelist.com'" <jdeworld@jdelist.com>,
ega.com> jdeworldml@jdelist.com
Sent by: cc:
owner-jdeworldml@j Subject: A/P WorldWriter
delist.com


22/08/2001 03:12
AM
Please respond to
jdeworld







I want to attempt to make a WW based on the A/P files F0411, F0413 and
F0414. But because of their structure and different levels of detail, I
know
this will not be easy to reduce duplication of data on the output etc. All
of the normal trials when doing something like this.
Before I bang my head on this one, does anyone have a successful WW with
these files joined? If so, how are they joined?
Are there additional joins in the data selection?

Very great thanks in advance,

Dale
7.3c9
v4r4
 
Top