Re: AP Check Reconciliation

["Peters, Brian" <PetersB@HSN.NET>]

Sorry for a late response, and I don't know if you completed this task
yet, but I have just finished implemented check reconciliation using
PAY015A and PAY015B.
Here are some highlights:
1.  PAY015A is responsible for updating check status (flagging a check
cashed), and producing a 'Bank File' error report.  Errors included
(field edits, checks on bank file that are not found in PeopleSoft
system, checked on bank file that are currently flagged as cashed).
2.  PAY015B is a report that lists current status of checks (Outstanding
or Reconciled).
3.  My first step in this process was working with my company's bank on
a workable record layout for the bank file.  I had to change some of the
legacy field lengths.  Also, in PeopleSoft, check date is the "issue
date" of a check.  My bank interpreted "check date" as the day the check
was processed.  The bank was not able to provide "issue date" on the
file.
4.  My company was also currently receiving a tape for check
reconciliation.  Our bank was able to produce this data in a flat file
and ftp this file to us.  This eliminated the tape issue completely.

I can provide some more details if needy.
Good Luck
Brian at HSN
petersb@HSN.NET

> -----Original Message-----
> From: Johnson Awumah [SMTP:johnson.awumah@CAJUNELECTRIC.COM]
> Sent: Friday, June 26, 1998 2:13 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      AP Check Reconciliation
>
>      Hi folks, I am a newbie in sqr and peoplesoft world. I have a
> task to
>      accomplish here. I need to find out how my site can read an 8mm
> tape
>      from the bank and load such data into the necessary peoplesoft
> tables
>      for AP check Reconciliation, using SQR3 Workbench.
>            We are on peoplesoft Financials 6.0.1, and also HR, Oracle
> 7.3.1
>      running on Unix(AIX).
>            I need to read the 8mm tape from the bank to create a flat
> file
>      and then load the data to the required peoplesoft/Oracle tables.
> I
>      have been on customer connection and saw some discussions about
>      PAY015A.sqr. PAY015B.sqr and PAY015C.sqr. I have a feeling these
> have
>      something to do with check reconciliation in AP, but not quite
> what I
>      am looking for. I also read something about EDI Manager, I'm not
>      really sure what that is.
>             My question is has anyone done something like this before
> or is
>      doing something similar now for check reconciliation processing.
> Could
>      you give me any tid-bits in terms of what tables in
> peoplesoft/Oracle
>      would be used for loading the data from the bank? and if there is
> any
>      other useful information that you think might be helpful would be
>      deeply appreciated.
>
>      Thanks in advance
>
>      Johnson Awumah