A/P Positive Pay

We are looking to start positive pay in Co-existent A/P. JDE help line
says they don't currently have a procedure. Does anyone create this file
for a bank, and if so, how (ie: what file(s) do you use)?

We did a simple data extract which seems to have met client requirements.

An interface which runs daily. Records are extracted from the payments file (F0413)if check date OR Void Date are equal to run date AND check is not a wire transfer (RMPYIT <> 'T')

Table used F0030, F0413

OutputFile JDE Mapping
PCACCT - Bank Account F0030.AYCBNK
PCCHKN - Check Number F0413.RMDOCM
PCAMT - Amount F0413.RMPAAP
PCCDAT - Check Date F0413.RMDMTJ
PCPGM - Job Program Name Text Variable
PCPDAT - Job Run Date Extraction Date Variable
PCPTIM
PCUSR
PCTDAT
PCFIL1
PCVCOD - Void Code 'V' if RMVDGL = Extraction Date
PCVCD2

This created a flat file which they then uploaded to the bank.
Hope this helps a little.

Sean

XE SP17.1_H1, AIX, Oracle8.1.7, JAS(17.1_H1) AIX, WebSphere3.5

Susan,

You should go with what Sean suggested. I had two clients that wanted to use it. One did go with Optio and the other one did a data extract from F0413 and did not cost much except to run a report that gave us a csv file submitted to the bank and boom you have you CH(Positive Pay file)




OWman
XE, Oracle, SP16, Sun