• JDELIST is celebrating its 20 year anniversary today!
  • 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!

AP Check info is stored where?

davidbryant

Active Member
Hello - I'm having some trouble finding the file, (if any?) that stores the
information on the a/p checks. I can find many bits and pieces in various
places, but not one file that has it all.

I'm looking for check #, check date, check amount, payee #, special payee #,
remit to #, and possibly the names associated with the vendor numbers. I'm
trying to do an ODBC lookup for a scanning project, and I don't want to have to
manually key all this information.


Thanks in advance

David Bryant
Maxco Supply, Inc.
 

Robert Robinson

Reputable Poster
David -

Have you tried the F0411JD? It is the sum of the F0411, F0413 and F0414
files (the last two being the check information header and detail files).

I replied to an e-mail request (about a month ago) with a World Writer
which provides as much A/P check information (check and invoice) as anyone
would want. If you'd like, I can send you a copy.

Robert Robinson, CPA/CNE
Senior Business Systems Analyst
Durr, Inc.
734.459.6800
fax # 734.459.5837
e-mail address: rrobinson@durr-usa.com




davidbryant
<davidbryant@mx2co To: jdeworldml@jdelist.com
.com> cc:
Sent by: Subject: AP Check info is stored where? ~~0:54
owner-jdeworldml@j
delist.com


10/19/2000 02:56
PM
Please respond to
jdeworld







Hello - I'm having some trouble finding the file, (if any?) that stores the
information on the a/p checks. I can find many bits and pieces in various
places, but not one file that has it all.

I'm looking for check #, check date, check amount, payee #, special payee
#,
remit to #, and possibly the names associated with the vendor numbers. I'm
trying to do an ODBC lookup for a scanning project, and I don't want to
have to
manually key all this information.


Thanks in advance

David Bryant
Maxco Supply, Inc.





--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=54

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
G

Guest

Guest
You best bet is to use the F0411 file - A/P ledger file. Another option
would be to capture F04572 during a check run and copy the data off to
another file and use that file for you link.






Rae Lynne Smith



davidbryant
<davidbryant@mx2co To: jdeworldml@jdelist.com
.com> cc:
Sent by: Subject: AP Check info is stored where? ~~0:54
owner-jdeworldml@j
delist.com


10/19/00 02:56 PM
Please respond to
jdeworld







Hello - I'm having some trouble finding the file, (if any?) that stores the
information on the a/p checks. I can find many bits and pieces in various
places, but not one file that has it all.

I'm looking for check #, check date, check amount, payee #, special payee
#,
remit to #, and possibly the names associated with the vendor numbers. I'm
trying to do an ODBC lookup for a scanning project, and I don't want to
have to
manually key all this information.


Thanks in advance

David Bryant
Maxco Supply, Inc.





--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=54

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
G

Guest

Guest
The file is F0413, Accounts Payable Matching Document - there are also a
number of logicals created from this physical file that you can use as well.
Think you'll need to join with F0101 in order to obtain the names associated
with the vendor numbers.




"davidbryant" <davidbryant@mx2co.com> on 10/19/2000 11:56:33 AM

Please respond to jdeworld@jdelist.com

To: jdeworldml@jdelist.com
cc: (bcc: Alissa Allard/CSM)
Subject: AP Check info is stored where? ~~0:54





Hello - I'm having some trouble finding the file, (if any?) that stores the
information on the a/p checks. I can find many bits and pieces in various
places, but not one file that has it all.

I'm looking for check #, check date, check amount, payee #, special payee #,
remit to #, and possibly the names associated with the vendor numbers. I'm
trying to do an ODBC lookup for a scanning project, and I don't want to have to
manually key all this information.


Thanks in advance

David Bryant
Maxco Supply, Inc.





--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=54
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Top