Prev
Next
Forums Lawson S3 Financials

AP10.2 Contact Account Number

Sort:
You are not authorized to post a reply.
Author
Messages
pglibra
Veteran Member
Posts: 76
Veteran Member
8/22/2017 12:34 PM
    Hello,
    I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number.
    What tables do I need and how do I link them in Access?

    Thank you
    Randy
    Veteran Member
    Posts: 50
    Veteran Member
    8/22/2017 12:49 PM
      Everything appears to be in APVENLOC Table.
      pglibra
      Veteran Member
      Posts: 76
      Veteran Member
      8/22/2017 12:52 PM
        Got it.
        Was making it more difficult than it was.
        Thanks
        JimY
        Veteran Member
        Posts: 510
        Veteran Member
        8/22/2017 1:34 PM
          If you also want vendor address information you will want APVENADDR. Make sure you get the current address.
          You are not authorized to post a reply.