Though both iDocs and Positive Pay transparently maintain the production, integrity, and archiving of issued and voided check data, there may be instances when the data needs to be added and/or modified. The menu items in the Positive Pay File Maintenance section address most of the necessary types of file manipulation to correct data anomalies.
The manual check entry enables a check to be entered directly into the generic checks issued file. Such would be the case if a check had been written that iChecks had not processed, like a hand written check. A hand written check would not only need to be recorded in the company’s accounting system but also in the Positive Pay400 Manual check entry.
Selecting option 10 from the menu brings up the manual check entry screen as shown in the figure below. Simply enter the necessary Positive Pay ID, and account number associated with the manual checks. Both of the preceding fields are prompt enabled, displaying a list of existing account numbers and positive pay ids from the existing file.
8/11/07 Positive Pay400 PP0450
16:01:42 Manual Check Entry QSECOFR
Positive Pay ID F4 for list
Account Number F4 for list
Check Check Check
Number Date Amount Payee
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
More...
F1=Help F3=Exit F4=Prompt F10=Update F12=Cancel
F15=Report F23=Confirm
Manual entry of voided checks may be entered in to the Positive Pay400 system using this menu item. The prompts and information are nearly identical to that of the manual check entry program.
8/11/07 iSeries Positive Pay PP0452
16:11:34 Manual Void Entry QSECOFR
Positive Pay ID F4 for list
Account Number F4 for list
Check Check Check
Number Date Amount Payee
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
2007-08-11 $.00
More...
F1=Help F3=Exit F4=Prompt F10=Update F12=Cancel
This selection offers a query-like selection of data from the file that contains issued checks. One or more of the fields described on the input screen may used to select records.
8/11/07 iSeries Positive Pay PP0600
16:16:57 Check Register File Manipulation QSECOFR
Set Process Flag to: Blank=Process 1=Previously Sent P=Pending
Based on the criteria below
Positive Pay ID: F4=List
Account#: F4=List
Payee name like:
Check date range YYYY-MM-DD: 1-01-01 to 1-01-01
Processed date YYYY-MM-DD: 1-01-01 to 1-01-01
Check number range: to
Check amount: than .00 (<, >, =)
F3=Exit F4=Prompt F10=Select F12=Cancel F21=Clear All
To retransmit a Positive Pay Application: Spacebar through the set process flag to field (blank) Press F4 on the Positive Pay ID field to bring up a list and select the appropriate number (usually the account number) Press F4 again in the account number field and select the same account number Drop down to the Date Processed range field and enter the appropriate dates in the CCYY-MM-DD format Alternatively, instead of entering the Date Processed Range, you may enter the check number range for the low number and the high number and leave the default dates of 0001-01-01 Once this is finished Press F10 twice to process Go back to the Positive Pay Menu and select option 1 to Define Positive Pay Applications Here you will: Locate the application to be used and first put an 8 to Extract and hit Enter This will bring up a Positive Pay defintion Hit Enter to process On the Application Screen select the application with option 11 to view the transmission file After you have verified the information press F3 to exit Once again it will bring you to the application screen This time select the application with an option 9 to transmit and press Enter
The complement to manipulating the check register file is to manipulate the process flag in the void file. The screen for this program is essentially the same. Once the records are selected, use the displayed function key to reset the processed flag.
8/11/07 iSeries Positive Pay PP0600
16:29:36 Void File Register Manipulation QSECOFR
Set Process Flag to: Blank=Process 1=Previously Sent P=Pending
Based on the criteria below
Positive Pay ID: F4=List
Account#: F4=List
Payee name like:
Check date range YYYY-MM-DD: 1-01-01 to 1-01-01
Processed date YYYY-MM-DD: 1-01-01 to 1-01-01
Check number range: to
Check amount: than .00 (<, >, =)
F3=Exit F4=Prompt F10=Select F12=Cancel F21=Clear All
Option 14 is specifically for Computer Guidance Customers.
Outlined previously in this section were two ways to populate the void file with check records: Manual Void Check Entry, and Check Manipulation. Specific to Computer Guidance customers there is yet a third way. That of processing a Cash Disbursements Check register spool file and using the check reversal data from the spool file to populate the void file. The shortcoming in implementing this is that the report does not contain an account number. It does however contain a GL account number.
Therefore in order to utilize the spool file, an association between a GL account number and a bank account number needs to be established.
The screen below displays the resulting associations.
8/11/07 PP0603
16:39:31 Bank and General Ledger QSECOFR
Relationship
Positive Bank General
Pay Application Account Ledger
+
Option 15, Define Company, Div, GL, Bank Relationships is an obvious extention to the prior menu item. Likewise, this table is specific to Computer Guidance customers.
8/11/07 iSeries Positive Pay PP0604
16:45:03 Company Division Bank Account and GL QSECOFR
Relationship
Library Positive Bank General
Environment Pay Application Comp Div Account Ledger
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000
00 000 +
F3=Exit F10=Save F12=Cancel
This menu selection 16 is specific to Computer Guidance customers. Choosing this option will enable new voided payroll records to be added and/or refreshed from the computer guidance records into the inFORM Decisions records. In this way the voided checks may be imported and used for inclusion within the next positive pay transmission.
Retrieve PR Voids (RTVPRPVOD)
Type choices, press Enter.
Starting Date (CCYYMMDD) . . . . Character value
Ending Date (CCYYMMDD) . . . . . Character value
Company Number . . . . . . . . . Value, or F4 for list
Division Number . . . . . . . . Value, or F4 for list
Bank Account . . . . . . . . . .
Positive Pay ID . . . . . . . .
GL Account . . . . . . . . . . .
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
This menu selection 17 is specific to Computer Guidance customers. Choosing this option will enable new voided AP records to be added and/or refreshed from the computer guidance records into the inFORM Decisions records. In this way the voided checks may be imported and used for inclusion within the next positive pay transmission.
This menu selection 18 is specific to Computer Guidance customers. Choosing this option will enable new payroll check records to be added and/or refreshed from the computer guidance records into the inFORM Decisions records. In this way the voided checks may be imported and used for inclusion within the next positive pay transmission.
This menu selection 19 is specific to Computer Guidance customers. Choosing this option will enable new AP check records to be added and/or refreshed from the computer guidance records into the inFORM Decisions records. In this way the voided checks may be imported and used for inclusion within the next positive pay transmission.