Check Number

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

Ver. 6.0.02 plf, Mar'98 cum, full C/S

Trying to be proactive for a "Sales & Use Tax" audit, I was looking through
the A/P files & could not find where the A/P check number is written to any
file except the ABR & in the ABR invoice number is not part of the data.

So I have not found a way to join the GLH with any other file that would
contain the check number.

The reason I need the check number is because our A/P checks are filed
numerically & not by vendor number.

This is not to say that it might not be written to some other file/field but
the field text does not say "Check Number" hence I didn't find a match.

Any other suggestions or ways to get the following report or is the
accounting team stuck?  Another thing is the purchase price variance creates
a GLH entry that makes it tough to match dollar amounts.

Check Number || Vendor Name || Invoice Number || Invoice Date || PO Number
|| PO Amount || Date Paid || Check Amount || Account Number ||

Most of the info can be found in the GLH or a join from it to another table.
The only data I can't seem to find is the check number.

Any ideas?

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388