This chapter contains these topics:
Section 85.1, "Bank Statement Entry - Default Options (P09160)"
Section 85.2, "Review Bank Statement - Default Options (P09181)"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT TRANSACTION TYPES: | |
| 1. Enter the default transaction type for deposit amounts. | |
| 2. Enter the default transaction type for withdrawal amounts. | |
| DEFAULT BANK ACCOUNT: | |
| 3. Enter the short account id for the default bank account. | |
| DEFAULT EXPENSE ACCOUNT: | |
| 4. Enter the short account id for the expense account to be defaulted for P09161 - JE transactions. | |
| DEFAULT TRANSIT ACCOUNTS: | |
| 5. Enter the short account id for the transit account to be defaulted:
P03160 - Automatic Receipts Entry P03161 - Receipts Clear P03103 - Manual Receipts Entry P04161 - Payment Clear |
|
| ENTRY MODE OPTION (WHEN ADDING LINES): | |
| 6. Enter a '0' and the windows will not be displayed and editing will be off.
Enter a '1' and the windows will be displayed with editing off. Enter a '2' and the windows will be displayed with full editing. |
|
| DISPLAY OPTIONS: | |
| 7. Enter a '1' to restrict access to the Home Business Unit.
Enter a '2' to remove the field from the video. The default of blank will allow regular access to the field. |
|
| 8. Each of the following fields may have access restricted by entering a '1' next to the field name.
A default of blank will allow regular access to the field: Gross Amount (GDAG) Remark (GDRMK) Account Number (GDCBNK) Bank Transit (GDTNST) Cleared/Value Date (GDVLDT) Reference (GDR1) Explanation (GDEXA) Transit Account (GDANI) G/L Date (GDDGJ) |
|
| DW VERSION FOR RECEIPTS PROCESSING: | |
| 9. To override Manual Receipts Entry processing (DREAM Writer P03103, version ZJDE0001), enter an override version number. | |
| DW VERSION FOR PAYMENTS PROCESSING: | |
| 10. To override Manual Payments with Voucher Match processing (DREAM Writer P04102, version ZJDE0001), enter an override version number. | |
| DW VERSION FOR PAYMENTS PROCESSING: | |
| 11. To override Manual Payments without Voucher Match processing (DREAM Writer P04106, version ZJDE0001), enter an override version number. | |
| DEFAULT DATES: | |
| 12. Enter a '1' to default the Statement Date into the subfile field.
A value of '0' or blank will default the G/L Date : Value Date (GDVLDT) G/L Date (GLDGJ) |
|
| DEFAULT PREVIOUS BALANCE: | |
| 13. Enter a '1' to load the ending balance from the previous statement into the beginning balance of the current statement. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SELECTION CRITERIA DEFAULTS: | |
| 1. Enter the Short Account ID for the default bank account.
Blank will not preload the field. |
|
| 2. Enter a '1' to preload the User ID selection criteria field.
Blank will not preload the field. |
|
| 3. Enter a default Statement Posted code to preload the Statement Posted code field.
Blank will not preload the field. |
|
| 4. Enter a '1' to preload all detail records when no selection criteria defaults are specified.
Blank will not load detail until Enter is pressed. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| BEGINNING AND ENDING DATE RANGE: | |
| 1. Enter the date you want to use as a Beginning date for the build of the reconciliation file. | |
| 2. Enter the date you want to use as an Ending date for the build of the reconciliation file. | |
| RECONCILED STATUS: | |
| 3. Enter a '1' to see both reconciled and unreconciled records.
Default of blank will include unreconciled only. |
|
| LEDGER TYPE FILTER: | |
| 4. Enter a valid ledger type to see F0911 transactions in only that ledger type.
If left blank and the following multi-currency option is blank, all ledger types will be used. - OR - If doing multi-currency processing, enter a '1' to select all 'CA' ledger type transactions, and domestic only 'AA' ledger type transactions (where the transaction currency is the same as the company currency) |
|
| DOCUMENT TYPE FILTER: | |
| 5. Enter a '1' to include 'AE' document type transactions.
If left blank (the default) 'AE' document type transactions will not be written to the file |
|
| MULTIPLE MEMBERS: | |
| 6. Enter a '1' to create or refresh a specific member of file F0911R.
The name of the member will be the version ID. Leave blank to use a single member only (F0911R). The version ID must start with an alpha character and can be a maximum of ten characters. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROOF OR FINAL MODE: | |
| 1. Enter a '1' to process the Bank Journal transactions in Final mode.
If left blank, the Bank Journal processing will occur in Proof mode and no file updates will occur. |
|
| DW VERSION FOR JOURNAL ENTRY PROCESSOR: | |
| 2. To override standard Journal Entry processing (DREAM Writer XT0911Z1, Version ZJDE0001), enter an override version number. | |
| RECONCILIATION FILE MEMBER: | |
| 3. If using multi-member processing of F0911R, enter the version name of the Refresh Reconciliation File program (P09130) to be used for reconciliation. | |
| JOURNAL ENTRY CREATION OPTIONS: | |
| 4. Enter a value to be used as the G/L date when automatically creating journal entries.
'0' - System Run Date (Default) '1' - G/L Date '2' - Clear Date |
|
| 5. Enter the document type to be used when automatically creating journal entries. This value should begin with a 'U' and must exist in User Defined Code table 00/DT. If left blank the default 'JE' will be used.
Note: If a document type other than 'JE' is specified, the journal entries will be created using Bank Journal Next Numbers (system 09, line 5). If the default of 'JE' is specified, Journal Entry next numbers will be used (system 09, line 2). |
|
| REALIZED GAIN/LOSS PROCESSING: | |
| 6. Enter a '1' to create realized gain/loss journal entries.
If left blank, only variance journal entries will be created if amounts do not balance. |
|
| RECONCILIATION VARIANCE OPTIONS: | |
| 7. Enter a value to be used to calculate the variance tolerance limit for reporting an automatic write-off.
If left blank, a variance tolerance limit will not be calculated. Note: Percentages are entered as whole numbers. For example, to use 3%, enter 3. |
|
| 8. If you entered a value in option 7, enter a '1' here if it is to be treated as a percentage.
Leave blank to use it as a currency amount. |
|
| 9. If you entered a value in option 7, enter a '1' here to automatically create journal entries to write off variances that are equal to or below the calculated tolerance limit.
Leave blank to list these amounts separately on reconciliation reports, but bypass journal entry creation. |
|
| 10. If you entered a '1' in option 7, enter the G/L account for the journal entry.
Leave Business Unit blank to retrieve it from the Business Unit field on the Bank Statement record. Business Unit (optional) Object Subsidiary |
|
| RECONCILIATION DATE DISCREPENCIES: | |
| 11. Enter a value to specify how to handle transactions where the Value Date (Cleared Date) from the Bank Statement file (F0917) is earlier than the G/L Date from the Account Ledger file (F0911).
' ' = Do not reconcile. Print item on report. '1' = Reconcile. Print item on report. '2' = Reconcile. Do not print item on report. |
|
| RECONCILIATION CODES: | |
| 12. Enter codes to be used to mark transactions as reconciled in the F0917, F0911, and F0911R.
If any of the condition values are left blank then the value will be defaulted from the first condition. Exact one for one match without consolidation or use of tolerance rule. (Default 'R') Consolidated items where the General Ledger transactions balance to zero and there is no Bank record. |
|
| Consolidated items where the Bank Statement transactions balance to zero and there is no G/L amount.
The consolidation process was used to achieve the match of the transactions (There are G/L and Bank Statement transactions.) The transactions were for different values but fell within the tolerances allowed. This transaction only exists in the Bank Statement file and is a self reconciling item. Note: All values entered will be validated against UDC table 09/RC. |
|
| REPORT CONTROL: | |
| 13. Enter a '1' to disable the print of selected reports.
Create Bank Statement Batches Bank Reconciliation Items Cleared But Not Issued Items Cleared Before G/L Date Amounts Not Equal Unreconciled Items |
|
| DW VERSION FOR RECEIPTS PROCESSING: | |
| 14. To override standard Automatic Receipts processing (DREAM Writer P03550, version ZJDE0001), enter an override version number. |