Versions Compared

Key

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

The purpose of the Checkbook Deposit Record View is to assign 'Payment Receipts' that make up a bank deposit. From here, users can create a new deposit, assign one or more Payment Receipts to it, remove payments receipts prior to posting, or delete the deposit. Deleting a deposit transaction does not delete the payment receipts that were assigned to it, it just puts them back in a status of open. When Checkbook Deposits are posted, the Checkbook Balances are updated. Deposits only have the potential of making a 'Currency Gain/Loss' Journal Entry (as the Cash / AR Journal Entry was made from the Receipt). The 'Currency Gain/Loss' Journal Entry is the summarized totals from each individual Receipts' Gain/Loss amount. A Receipt will have a Currency Gain/Loss if the Receipt was in a foreign currency AND the 'Exchange Rate' is different for the date of the Receipt and the date of the Deposit. The Currency Gain/Loss Journal Entry is always created as a manual journal entry since it must be in the Home Currency.

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete RV - Global
Delete RV - Global
nopaneltrue

When a Deposit is deleted, all tagged Receipts are untagged (released) so they can be used on a different deposit.

Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
Journal Details

Insert excerpt
Journal Details - Icon
Journal Details - Icon
nopaneltrue

New
Insert excerpt
New - Global
New - Global
nopaneltrue
Notes
Insert excerpt
Notes - Global
Notes - Global
nopaneltrue
Print
Insert excerpt
Print - Global
Print - Global
nopaneltrue
Save
Insert excerpt
Save - Global
Save - Global
nopaneltrue
FieldsDescription
Checkbook

A single-select combo box to select the Checkbook the deposit is being made to. Once a value has been selected, the contents of the grid will be populated with all the un-deposited 'Payment Receipts' for the selected Checkbook. This field is editable when the Status is New. However, if the Checkbook is changed, all tagged Payment Receipts will be un-selected and the contents of the grid will be refreshed to show un-deposited 'Payment Receipts' for the newly selected Checkbook. This defaults to blank but is required to Approve or Post. If missing, the message "Checkbook is required." will be displayed on Save.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Checkbooks, sorted by Checkbook, displayed as:

  • If the Checkbook's Currency is the 'Home Currency' then [Checkbook]
  • If the Checkbook's Currency is NOT the 'Home Currency' then [Checkbook] +([Checkbook Currency])

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

Comment

A text box to enter a short comment pertaining to the Deposit. This field is is always editable (even after the transaction is posted) and is not required. If a Comment is entered, it must be <= 60 characters. 

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

Deposit Amount

A non-editable text box to show the total amount of the deposit, in the checkbook's currency, displayed in the currency format. If the Checkbook is in a foreign currency then the Currency ID will also be displayed. This defaults to 0.00 but updates as Payment Receipts are selected and/or un-selected. The Deposit Amount must be > 0.00 to Approve or Post. If not, the message "The Deposit Amount must be > 0.00." will appear on Save.  

This field is not linked to a Database Field.

Deposit Date

A date field to enter the date the Deposit posted to, or should post to, the bank account. This defaults to the current date and is required to Approve and/or Post. If not, the message "Deposit Date is required." will be displayed. This field is only editable while the transaction Status is "New". On Approve and Ready to Post the Deposit Date will default as the 'GL Date' if the 'GL Date' is blank. 

Linked Database Field: ERPx_ARTransactionHeader#####.TransactionDate#####.

Reference

A text box to enter a 3rd party reference number for the Deposit. This field is is always editable (even after the transaction is posted) and is not required. If a Reference is entered, it must be <= 60 characters. 

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

Status
Insert excerpt
Status - Single Select RV Lookup
Status - Single Select RV Lookup
nopaneltrue
Linked Database Field: ERPx_#####.#####

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - Record View Items Grid
Delete - Record View Items Grid
nopaneltrue
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
New
Insert excerpt
New - Grid Item
New - Grid Item
nopaneltrue
Notes
Insert excerpt
Notes - Global
Notes - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox (Tag)- Global Field
Checkbox (Tag)- Global Field
nopaneltrue
Field 1
Field 2
Field 3
Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
HyperlinkA 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_#####.#####.
LabelA 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_#####.#####.
Lookup (from an Enumeration)

A single-select standard 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) enabledLinked Database Field: ERPx_#####.#####.

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

Lookup (non Enumeration)

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) enabledLinked Database Field: ERPx_#####.#####

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

Text Field(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_#####.#####.
Yes/No Lookup

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...

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - Record View Items Grid
Delete - Record View Items Grid
nopaneltrue
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
New
Insert excerpt
New - Grid Item
New - Grid Item
nopaneltrue
Notes
Insert excerpt
Notes - Global
Notes - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox (Tag)- Global Field
Checkbox (Tag)- Global Field
nopaneltrue
Field 1
Field 2
Field 3
Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
HyperlinkA 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_#####.#####.
LabelA 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_#####.#####.
Lookup (from an Enumeration)

A single-select standard 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) enabledLinked Database Field: ERPx_#####.#####.

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

Lookup (non Enumeration)

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) enabledLinked Database Field: ERPx_#####.#####

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

Text Field(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_#####.#####.
Yes/No Lookup

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...

...