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

type	flat

Page Header

Header Toolbar

...

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

...

Home Tab

...

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

...

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

...

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

type	flat

Page Header

Header Toolbar

Toolbar Icons

Description

Delete

Insert excerpt

	Delete RV - Global
	Delete RV - Global
nopanel	true

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
nopanel	true

Grid Layout

Insert excerpt

	Grid Layout
	Grid Layout
nopanel	true

Help

Insert excerpt

	Help - Global Icon
	Help - Global Icon
nopanel	true

Journal Details

Insert excerpt

	Journal Details - Icon
	Journal Details - Icon
nopanel	true

New

Insert excerpt

	New - Global
	New - Global
nopanel	true

Notes

Insert excerpt

	Notes - Global
	Notes - Global
nopanel	true

Print

Insert excerpt

	Print - Global
	Print - Global
nopanel	true

Save

Insert excerpt

	Save - Global
	Save - Global
nopanel	true

Home Tab

Fields

Description

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

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
nopanel	true

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

Properties Tab

Fields

Description

Checkbook Currency

A non-editable text box that displays the Currency ID of the Checkbook.

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

CheckbookSK

A non-editable text box that displays the SK value of the Checkbook that is assigned to the Transaction.

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

Created

Insert excerpt

	Created - Global Field
	Created - Global Field
nopanel	true

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

Created By

Insert excerpt

	Created By- Global Field
	Created By- Global Field
nopanel	true

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

GL Date

Insert excerpt

	GL Date - List View/Inquiry Field
	GL Date - List View/Inquiry Field
nopanel	true

ERPx_#####.#####.

Last Updated

Insert excerpt

	Last Updated - Global Field
	Last Updated - Global Field
nopanel	true

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

Last Updated By

Insert excerpt

	Last Updated By- Global Field
	Last Updated By- Global Field
nopanel	true

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

Transaction HeaderSK

A non-editable text box that displays the SK value of the Transaction ID.

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

Transaction ID

A non-editable text box that displays the Transaction ID.

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

Page Detail

Open Payment Receipts Grid

The purpose of the Open Payment Receipts grid is to show all the "Posted" Payment Receipts that have not been deposited. The grid contains all the "posted" Payment Receipts, received against the Checkbook of the deposit, that have not been assigned to deposit. Fields prefixed with "MC: " are sorted at the bottom of the list and are only applicable to multi-currency transactions. The column headers in the interface do not include the MC: prefix.

Toolbar Icons

Description

Excel

Insert excerpt

	Excel - Global
	Excel - Global
nopanel	true

Fields

Description

Deposit Amount

Displays the amount the Payment Receipt will add to the deposit, in the checkbook's currency, displayed in the checkbook currency format.

If the Checkbook is in a foreign currency then the Currency ID will also be displayed. This

The 'Deposit Amount' 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:

and is updated for each selected record. This column has a total at the bottom.

If the 'Receipt Currency' matches the Checkbook's Currency, the 'Deposit Amount' will be the 'Receipt Amount'. If it does not, the 'Deposit Amount' will be the 'Receipt Amount' converted to the Checkbook's Currency.

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

Payment #

Displays the 'Payment #' from the 'Payment Receipt' (e.g. for Receipt Types of "Check", this represents the Check #). This field is not editable from the grid but is editable from the record view of the Payment Receipt transaction by clicking on the Trans. # hyperlink, even after the transaction is posted.

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

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

Receipt Amount

Displays the amount of the 'Payment Receipt' in the 'Currency' and currency format it was received in. This column has a total at the bottom.

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

Status Insert excerptStatus - Single Select RV LookupStatus - Single Select RV Lookupnopaneltrue

Receipt Currency

Displays the Currency ID of the currency the 'Payment Receipt' was received in.

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

Receipt Date

Displays the 'Receipt Date' from the Payment Receipt.

Linked Database Field:

ERPx_

#####.#####

Properties Tab

FieldsDescriptionCheckbook CurrencyA non-editable text box that displays the Currency ID of the Checkbook.

#####.#####.
Receipt Type	Displays the 'Receipt Type' of the Payment Receipt. The options available in this filed include all the values in the MFCashReceiptType Enumeration Class. Linked Database Field:

ERPx

ERPx_

MFCheckbook

ARTransactionHeader.

CurrencySK to the Transaction

CashReceiptTypeEN.

CheckbookSKA non-editable text box that displays the SK value of the Checkbook that is assigned

Received From

Displays the name of the account that the Payment Receipt was received from. Most Payment Receipts are from customers but they can also be from Fishermen and Loan Accounts.

Linked Database Field for A/R Payment Receipts: ERPx_#####.#####

.Created

Insert excerptCreated - Global FieldCreated - Global Fieldnopaneltrue

Linked Database Field for A/P Payment Receipts: ERPx_#####.#####

.Created By Insert excerptCreated By- Global FieldCreated By- Global Fieldnopaneltrue

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

GL Date Insert excerptGL Date - List View/Inquiry FieldGL Date - List View/Inquiry Fieldnopaneltrue ERPx_#####.#####.Last Updated Insert excerptLast Updated - Global FieldLast Updated - Global Fieldnopaneltrue

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

Last Updated By Insert excerptLast Updated By- Global FieldLast Updated By- Global Fieldnopaneltrue

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

Transaction HeaderSKA non-editable text box that displays the SK value of the Transaction ID


Select	A checkbox used to select and/or un-select receipts for the current deposit. This defaults to unchecked but can be checked or unchecked while the transaction status is "New". Selecting a receipt adds it to the deposit, updates the 'Deposit Amount' column in the grid, and updates the 'Deposit Amount' in the header. Un-selecting a receipt removes it from the deposit, clears it from the 'Deposit Amount' column in the grid, and removes it from the 'Deposit Amount' in the header. This is not linked to a database field
Source	Identifies which Functional Area the 'Payment Receipt' was posted from. Payment Receipts from customers will have a Source of "Sales". Payment Receipts from Fishermen or Loans will have a Source of "Fisherman Accounting".
Trans. #	The Transaction # from the Payment Receipt. This is a hyperlink that opens the record view of the selected Payment Receipt. Linked Database Field: ERPx_#####.#####.

Transaction ID

MC: Deposit Exchange Rate

A non-editable text box

that displays the Transaction ID.

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

Page Detail

Open Payment Receipts Grid

The purpose of the Open Payment Receipts grid is to show all the "Posted" Payment Receipts that have not been deposited. The grid contains all the "posted" Payment Receipts, received against the Checkbook of the deposit, that have not been assigned to deposit. Fields prefixed with "MC: " are sorted at the bottom of the list and are only applicable to multi-currency transactions. The column headers in the interface do not include the MC: prefix.

Insert excerpt
Toolbar Icons	Description
Excel
Excel - Global	Excel - Global
nopanel	true
Fields	Description
Deposit Amount	Displays the amount of the deposit, in the checkbook's currency, displayed in the checkbook currency format. The 'Deposit Amount' that displays the 'Exchange Rate', from the 'Exchange Table' for the 'Deposit Date'. This field will display as 1.00 for all Payment Receipts that are in the Checkbook's Currency. Linked Database Field: ERPx_#####.#####.
MC: Deposit Currency Gain / Loss	A non-editable text box to show the calculated amount of the Currency Gain/Loss. This defaults to 0.00 and is updated for each selected record.If the 'Payment Receipt Currency' matches the Checkbook's Currency, the 'Deposit Amount' will be the 'Receipt Amount'. If it does not, the 'Deposit Amount' will be added to the Deposit, where the 'Receipt Amount' converted to the Currency' does not match the Deposit Checkbook's Currency. Linked Database Field: ERPx_#####.#####.
Payment #	Displays the 'Payment #' from the 'Payment Receipt'. For Receipt Types of "Check", this represents the Check #. This field is not editable from the grid but is editable from the record view of the Payment Receipt transaction by clicking on the Trans. # hyperlink, even after the transaction is posted. Linked Database Field: ERPx_#####.#####.
Receipt Amount	Displays the amount of the 'Payment Receipt' in the 'Currency' and currency format it was received in. Linked Database Field: ERPx_#####.#####
Receipt Currency	Displays the Currency ID of the currency the 'Payment Receipt' was received in. Linked Database Field: , calculated as ([Receipt Amount] * [Deposit Exchange Rate]) - ([Receipt Amount] * [Receipt Exchange Rate]). This field will be 0.00 for all 'Payment Receipts' that were posted in the Deposit Checkbook's Currency. This column has a total at the bottom. If the column total is positive, then the Deposit will result in a Currency Gain and a journal entry will be created when the Deposit is posted. If the column total is negative, then the Deposit will result in a Currency Loss and a journal entry will be created when the Deposit is posted. If the column total is 0.00 then there is no Currency Gain or Loss and the Deposit will not create a journal entry.
MC: Exchange Rate Calculation Method	A non-editable text box to show the 'Calculation Method' property from the 'Exchange Table' that was assigned to the 'Payment Receipt'. This field will display as "Multiply" for all 'Payment Receipts' that were posted in the Deposit Checkbook's Currency. This is a looked-up value. Linked Database Field: ERPx_#####.#####.
Receipt Date	Displays the 'Receipt Date' from the Payment Receipt. For multi-currency deposits, the exchange rate for 'Receipt Date' is compared to the exchange rate for 'Deposit Date'. MC: Exchange Table	A non-editable text box that displays the 'Exchange Table ID', from the 'Currency Exchanges'. This field will be blank for all 'Payment Receipts' that are in the same currency as the Checkbook they are being deposited into. This field is required for all 'Payment Receipts' that are not in the same currency as the Checkbook they are being deposited into. Linked Database Field: ERPx_#####.##### .	Receipt Type	Displays the 'Receipt Type' of the Payment Receipt. The options available in this filed include all the values in the MFCashReceiptType Enumeration Class .
MC: From Currency	A non-editable text box to show the 'From Currency' property from the 'Exchange Table' that was assigned to the 'Payment Receipt'. For Deposits that do not involve a Foreign Currency, this field will display the Home Currency ID. Displays the name of the account that the Payment Receipt was received from. Most Payment Receipts are from customers but they can also be from Fishermen and Loan Accounts. Linked Database Field for A/R Payment Receipts: ERPx_#####.##### Linked Database Field for A/P Payment Receipts Linked Database Field: ERPx_ARTransactionHeader#####.CashReceiptTypeEN.	Received From	#####.
MC: Receipt Exchange Rate	A non-editable text box that displays the 'Exchange Rate', from the 'Exchange Table' for the 'Receipt Date'. This field will display as 1.00 for all Payment Receipts where the 'Receipt Currency' matches the Deposit Checkbook's Currency. Linked Database Field: ERPx_#####.#####.	Select
Insert excerpt
Checkbox (Tag)- Global Field	Checkbox (Tag)- Global Field
nopanel	true
Source	Trans. #	The Transaction # from the Payment Receipt. This is a hyperlink that opens the record view of the selected Payment Receipt.MC: To Currency	A non-editable text box to show the 'To Currency' property from the 'Exchange Table' assigned to the 'Payment Receipt'. For Deposits that do not involve a Foreign Currency, this field will display the Home Currency ID. Linked Database Field: ERPx_#####.#####.	MC: Dep Exchange Rate	MC: Deposit Gain / Loss	MC: Exchange Rate Calculation Method	MC: Exchange Table	MC: From Currency	MC: Receipt Exchange Rate	MC: To Currency

Version	Old Version 20	New Version 21
Changes made by	Tom Williams	Tom Williams
Saved on	Nov 10, 2019	Nov 10, 2019

Versions Compared

Key

Page Header

Header Toolbar

Home Tab

Page Header

Header Toolbar

Home Tab

Properties Tab

Page Detail

Open Payment Receipts Grid

Properties Tab

Page Detail

Open Payment Receipts Grid

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Header Toolbar

Home Tab

Page Header

Header Toolbar

Home Tab

Properties Tab

Page Detail

Open Payment Receipts Grid

Properties Tab

Page Detail

Open Payment Receipts Grid

Related Topics

Page Definitions