Results 1 to 4 of 4

Thread: AP Check info is stored where?

  1. #1

    AP Check info is stored where?



    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.







  2. #2
    Senior Member Robert Robinson's Avatar
    Join Date
    Oct 2000
    Location
    Toledo, OH
    Posts
    471

    Re: AP Check info is stored where?


    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/wwwth...rd=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
    ************************************************** ***********







    Robert Robinson
    JD Edwards Business Systems Manager
    Health Care REIT, Inc.
    E1 900, Tools 9.1.3.3
    Oracle 11g, WebLogic 10.3.6.0
    Quest Business Intelligence SIG
    Toledo, Ohio, USA
    Viva la Devolution!

  3. #3
    Guest

    Re: AP Check info is stored where?


    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/wwwth...rd=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
    ************************************************** ***********








  4. #4
    Guest

    Re: AP Check info is stored where?

    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/wwwth...rd=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
    ************************************************** ***********












Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.