AP Check History Report

[lrousey]

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

 

[cheryl03]

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.

 

[crystalreporting]

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.

http://www.srhconsulting.com

 

[lrousey]

Thanks to you both for the info.