Macola ES Invoice table needed

[ERPSkills]

I am looking for a table that will contain invoice header detail in Macola ES (invoice number,invoice date,invoice amount,vendor_no).
Where can i find this information?

 

[crystalreporting]

You say vendor_no so I presume you're talking AP vouchers/invoices. You can get those details from BankTransactions (payables view) or gbkmut (card view). To see the SQL query Macola ES uses to return results, simply highlight any entry on a vendors (or customers) account card and enter CTRL-Q.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com