Forums
Lawson S3 Financials
AP10.2 Contact Account Number
Author
Messages
pglibra
Veteran Member
Posts: 76
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
8/22/2017 12:49 PM
Everything appears to be in APVENLOC Table.
pglibra
Veteran Member
Posts: 76
8/22/2017 12:52 PM
Got it.
Was making it more difficult than it was.
Thanks
JimY
Veteran Member
Posts: 510
8/22/2017 1:34 PM
If you also want vendor address information you will want APVENADDR. Make sure you get the current address.