Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to GP Table help

Status
Not open for further replies.
ehojr

ehojr

IS-IT--Management
Nov 15, 2005
53
0
0
US
What is teh best table to use to generate expense data that would contain the g/l account number, amount, db/cr, vendor, descr.. for a selected g/l account code.
 
Sort by date Sort by votes
Use the GL20000 (YTD Transactions..use the fields that start with or%...ORMSTRID is the Verndor ID, to get Vendor Info)..GL00100 for Account Description,GL00105 for Account String. If you need to look at Past Years Data then just replace the GL20000 with the GL30000
 
Upvote 0 Downvote
Forgot...use the actindx field to link the gl00100 to the gl00105 to the gl20000
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
167
appelq
appelq
kgeorge71
  • Locked
  • Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
222
kgeorge71
kgeorge71
ACCT PDC
  • Locked
  • Question
Switched to DirectDeposit Payroll and now entries not carrying through to bank reconciliation
Replies
1
Views
154
ACCT PDC
ACCT PDC
C.MtZ
  • Locked
  • Question
How to create a menu Item on Dynamics Gp menu
Replies
0
Views
152
C.MtZ
C.MtZ
xdude101
  • Locked
  • Question
GP2013 MASS RETURN PROCESS
Replies
0
Views
132
xdude101
xdude101

Part and Inventory Search

Sponsor

Back
Top