Copying Bank Information to the Payroll System

Typically, the bank sends you a tape that includes information about reconciled payments. The system stores the information from the bank in F075611. Before you can reconcile payments automatically, you must copy the bank information (the information in the F075611 table) to the F06561 table in the JD Edwards EnterpriseOne Payroll system.

You use the Custom Reformat program (R8907561) to perform the copy process. This program is a table conversion program that creates the F06561 table and copies the bank information, including interim payment status, to that table. This program is designed to be used with fixed-width, space-delimited information. If the information from the bank is in a different format, you can configure the program to meet your specific needs.

Before you copy bank information to the JD Edwards EnterpriseOne Payroll system, load the bank tape to the F075611 table. The F075611 file is a fixed-width, space-delimitated file that follows the format of the F06561 table with regard to length and starting positions. The F075611 table is left-justified with trailing blanks. Contact the system administrator for assistance.