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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.