Share
ReportNot sure how to look up items charged to a certain account and its po number? Trying to find the tables to do this, so that I can report on this
*This post is locked for comments
You’re offline. This is a read only version of the page.
220
Not sure how to look up items charged to a certain account and its po number? Trying to find the tables to do this, so that I can report on this
*This post is locked for comments
ACTINDX is the key field that is used accross most other GP tables where the GL is involved ... You'll find it in Purchasing, Sales, Project Accounting, Inventory, etc... the table GL00105 has a concatanated field already for each GL #, so if you don't care about the individual segements, take it from there. You still need the Acct description from the GL00100...
Thank you for your response it really help me but how do you join those tables to the GL00100. Don't see the relationship on the tables to GL00100?
Hi Wesley,
On Mark Polino's blog you'll find in the Download section a reference file (XLS) that provides all the table names for GP2010...
Basically you're looking for the POP live and history tables, which are POP10100 & POP10110 (live) and POP30100/POP30110 (history). Join them with the GL00100 table and you'll get something that should fit your needs.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (