Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Checkbook Reconciliation
Def - Checkbook Reconciliation
nopaneltrue

The purpose of the Checkbook Reconciliations List View is to show open reconciliation transactions in a Status of ‘New’ or ‘Approved’ and create new transactions to balance a checkbook. From here, users can add new reconciliations, edit existing reconciliations or delete unposted reconciliations. When a reconciliation is Posted, the checkbook balance may be updated and the Checkbook Transaction Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete - LV
Delete - LV
nopaneltrue

Edit
Insert excerpt
Edit - RV Header
Edit - RV Header
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Mass Update
Insert excerpt
Mass Update - Global
Mass Update - Global
nopaneltrue
Status
New
Insert excerpt
New - Global
New - Global
nopaneltrue
Print
Insert excerpt
Print - Global
Print - Global
nopaneltrue
FieldsDescription
Balance as of

Identifies the date that the 'Bank Balance' was calculated thru for the reconciliation. This would be the statement date if reconciling from a bank statement. This defaults to blank but is required before any transactions can be added to the Grid. This date must be <= the 'Transaction Cutoff' date but it is not required to be in an open fiscal period.

Linked Database Field: ERPx_MFCheckbookReconciliation.BankBalanceDate

Checkbook

Insert excerpt
Checkbook
Checkbook
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK

Checkbook Currency

The Currency ID of the Checkbook. 

Linked Database Field: ERPx_MFCheckbook.CurrencySK

Checkbook Description
Insert excerpt
Checkbook Description - LV
Checkbook Description - LV
nopaneltrue
Cleared AdjustmentsIdentifies the sum of all the Adjustment transactions that are included on the reconciliationin the checkbook's currency, displayed in the currency format. This is a calculated field and not stored in the database.
Cleared Deposits

Identifies the sum of all the deposit transactions (Deposits and Transfer: Receipt transactions) that are included on the reconciliationin the checkbook's currency, displayed in the currency format.This is a calculated field and not stored in the database.

Cleared Payments

Identifies the sum of all the payment transactions (Payments and Transfer: Sent transactions) that are included on the reconciliationin the checkbook's currency, displayed in the currency format.This is a calculated field and not stored in the database.

Created

Insert excerpt
Created
Created
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.LastUser

Reconcile to Balance

Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation is targeting.

Linked Database Field: ERPx_MFCheckbookReconciliation.Amount

Status

Insert excerpt
Status
Status
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID

Related Topics



Expand
titlePage Definitions

Page Definitions


...