A hyperlink for the (Field Name). Clicking on the hyperlink opens the (what does it open) page. This field is not editable. Linked Database Field: ERPx_#####.#####.

A label to show (describe what this shows). This (defaults or is calculated from or to) (describe what it defaults/calculates from). This is (always, never, or conditionally(required to Save or Approve and/or Post)) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is never editable. Linked Database Field: ERPx_#####.#####.

A non editable text box that calculates the adjustment that would be needed to balance the checkbook based on the the current information, in the checkbook's currency, displayed in the currency format. This label and field are only visible for transactions in the status of "New" or "Approved" once values have been entered for:

• Checkbook
• Reconcile to Balance
• Bank Balance as of
• Transaction Cutoff

This is calculated by taking the amount entered in the 'Reconcile to Balance' and subtracting the balance in the 'Rec. + Cleared' field. This amount must be be 0.00 to Approve and/or Post the transaction. How do alert users that they should fix it but not required them to?

• If this is 0.00 then no further action is necessary.
• If this is a positive amount then a positive adjustment is necessary
• If this is a negative amount then a positive adjustment is necessary

This is a calculated field that is not stored in the database.

An editable date field to enter the date that the 'Bank Balance as of' is calculated thru. 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_#####.#####.

This lookup contains all the values in the (EnumerationClassName) Enumeration Class. 

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####

A non editable text box that shows the data from the 'Reconcile to Balance' field, in the checkbook's currency, displayed in the currency format. This label and field are only visible for transactions in the status of "New" or "Approved" once values have been entered for:

• Checkbook
• Reconcile to Balance
• Bank Balance as of
• Transaction Cutoff

This is a calculated field that is not stored in the database.

A multi-select lookup to select the Checkbook(s) that are being reconciled. This defaults to blank but is required before transactions can be assigned to the reconciliation transaction. This is only editable for transactions in a Status of "New". If the checkbook(s) is changed, any transactions currently "Included" on the reconciliation will be removed and the contents of the grid will refresh to reflect transactions for the updated checkbook(s). 

The lookup contains a blank value, the current assigned value(s), and

all

'Active'

A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. 

A value of "Yes" means that...

A value of "No" means that...

checkbooks. The values in the lookup are displayed as:

[Checkbook ID] - [Cash Account] and if the checkbook is a foreign currency then "- [Checkbook Currency]" sorted by Checkbook ID and Cash Account.

 In most instances, only a single checkbook will be selected. However, if more than one checkbook is selected then they must all be assigned the same 'Cash Account' and must all be in the same currency. If not, the message "All selected Checkbooks must be assigned to the same Cash Account and must be in the same currency." will be displayed on update.

A non editable calculated field that adds the current checkbook balance of all reconciled transactions to the cleared transactions from this transaction. This is the amount in the checkbook's currency, displayed in the currency format. This label and field are only visible for transactions in the status of "New" or "Approved" once values have been entered for:

• Checkbook
• Reconcile to Balance
• Bank Balance as of
• Transaction Cutoff

This is a calculated field that is not stored in the database.

An editable text box to enter the bank balance, in the checkbook's currency, displayed in the currency format. This defaults to 0.00 and is required to Approve and/or Post. If not, the message "Reconcile to Balance is required." will appear on Save.

Linked Database Field: ERPx_#####.#####

Transaction Cutoff

A date field that identifies the 'date thru' used to select un-reconciled transactions in the grid. This is automatically updated anytime the 'Bank Balance as of' changes by adding the # of days from the '#Cutoff Days Preference' to the 'Bank Balance as of' date. Once this value has been assigned, it can be changed to any date >= 'Bank Balance as of' date. If not, the message, 'The Transaction Cuttoff date must be >= the Bank Balances as of date.' will be displayed on save.

This is a calculated field that is not stored in the database.

Comment

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. 

A value of "Yes" means that...