Use this screen to update the Bank G/L Cash Accounts table with the cash acct/org/ref1/ref2 combination data stored with the transaction detail for historical Accounts Payable, Cash Receipts, and/or Payroll transactions.
During the update process, the system reads all of the cash account/organization/ref1/ref2 combinations that have been previously used and stored with the detail transactions from A/P, Cash Receipts, and/or Payroll. If additional cash account combinations are found, the new data will be added to the Bank G/L Cash Accounts table, but existing data in that table will not be overwritten.
To view all the cash account combinations for which detail data is stored in Costpoint Accounts Payable, Accounts Receivable, and/or Payroll, you must access the View Cash Accounts subtask of the Maintain Company Bank Accounts screen. (The data in the subtask table window is non-editable.)
You must run this process before you can view information in the View Cash Accounts subtask of the Maintain Company Bank Accounts screen.
You must also run this process before you create bank transaction history records.
To ensure that the appropriate records are included, you should select time periods for all fiscal years and periods in which there are A/P, Cash Receipts, and/or Payroll transactions to be used for the desired bank reconciliations.
In this group box, enter or select the desired bank abbreviation for which the cash accounts will be updated. The description for the bank abbreviation that was set up in the Maintain Company Bank Accounts screen automatically displays.
Enter a valid bank abbreviation or select a bank abbreviation from the drop-down list in this required field. The cash account(s) linked with this bank abbreviation will be added to the table (if they do not already exist) when you run the Update process. The bank abbreviation description that was set up for the bank abbreviation in the Maintain Company Bank Accounts screen automatically displays in the field to the right.
Use this required group box to perform the update from Accounts Payable, Cash Receipts, and/or Payroll detail records. The process cannot be run unless you have checked at least one selection.
For companies that use a combined bank account for both payroll and non-payroll activities, the same cash accounts will have been used for A/P, Cash Receipts, and Payroll transactions. Select one, two, or three check boxes for the update process, as desired.
Select this check box to update the cash accounts from the Accounts Payable transactions. If you select this check box, the process reads records from the Vendor Check table that qualify for the timing parameters specified. The process then writes each new cash account/organization combination to the Bank G/L Cash Accounts table if it does not already exist there.
Select this check box to update the Cash Accounts from Payroll transactions. If you select this checkbox, the process reads records from the Employee Earnings table that qualify for the timing parameters specified. The process then writes each new cash account/organization combination to the Bank G/L Cash Accounts table if it does not already exist there.
Select this check box to update the Cash Accounts from Cash Receipts (A/R) transactions. If you select this check box, the process reads records from the Cash Receipt Transactions History table that qualify for the timing parameters specified. The process then writes each new cash account/organization combination to the Bank G/L Cash Accounts table if it does not already exist there.
Use this group box to specify the timing parameters for the Update Cash Accounts process.
Enter the desired range or select a range from the drop-down list to indicate the timing parameter(s) to include for the Update Cash Accounts process. The default for this field is set to One, which you can change to All, Range, From Beginning, or To End, as needed.
Enter the starting fiscal year for the update process or use the drop-down list to select a fiscal year from those displayed. If you select All or From Beginning as the Range, this field will be inactive.
Enter the starting accounting period for the update process or use the drop-down list to select a period from those displayed. If you select All or From Beginning as the Range, this field will be inactive.
Enter the ending accounting period for the update process or use the drop-down box to select a period from those displayed. If you select All, One, or To End as the Range, this field will be inactive.
Use this button on the toolbar to activate the Update Cash Accounts process. To view the updated accounts, access the View Cash Accounts subtask in the Maintain Company Bank Accounts screen.