RE: Check Number

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Dennis,

Have you looked in the AMH and AML files...these are the BPCS payment files.

Laura Chambers
MCFA

                -----Original Message-----
                From:   Dennis Munro [mailto:DMunro@badgerminingcorp.com]
                Sent:   Wednesday, October 31, 2001 2:37 PM
                To:     BPCS-L Mailing List (E-mail)
                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.