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!

  • Congratulations Mike Lewis 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

IS-IT--Management
Nov 15, 2005
53
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.
 
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
 
Forgot...use the actindx field to link the gl00100 to the gl00105 to the gl20000
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top