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!

AP Check History Report

Status
Not open for further replies.

lrousey

IS-IT--Management
Nov 14, 2006
22
US
Does anyone know what tables the AP Check History Report uses? It's a crystal report, but it seems that Exact has created a temp table to house that info, therefore I can't use that table.

What I'm trying to do is create a sql statement (to use in Event Manager) to notify vendors (via email) when their invoice is payed.

Any help would be greatly appreciated.

Thanks!

Laura
 
APDISFIL_SQL

This is the file I run to my check register in crystal. However, I use Progression 7.6.300c. I can't be sure the same tables apply to newer/older versions.
 
Looking at your previous posts, it looks like you are on Macola ES. The table you need to base your report on is the BankTransactions table.

Peter Shirley
Macola Consultant, PA and surrounding states.
 
Thanks to you both for the info.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top