Re: Check Number

match the GLH to the GXR using the Journal Entry Field
match the GXR to the APO using the Vendor, Invoice, and Invoice Line fields
match the APO to the AML using the Invoice number for the check number





Dennis Munro <DMunro@badgerminingcorp.com>@midrange.com on 10/31/2001
02:37:24 PM

Please respond to bpcs-l@midrange.com

Sent by:  bpcs-l-admin@midrange.com


To:   "BPCS-L Mailing List (E-mail)" <BPCS-L@midrange.com>
cc:
Subject:  Check Number


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

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.