The purpose of the Checkbook Transfer Record View is to add, edit, and remove transactions that record the movement of money from one Checkbook to another. From here, users can create a new transfer, edit an un-posted transfer, or delete an un-posted transfer. Deleting a transfer transaction removes the associated journal entry. When Checkbook Transfers are posted, the Checkbook Balances for both checkbooks are updated, a journal entry is created and posted, and a transaction for each checkbook is added to the Checkbook Transaction Inquiry. Transfers make a Journal Entry that Debits the GL Account assigned to the 'To Checkbook' (the receiving checkbook) and Credits the GL Account assigned to the 'From Checkbook' (the sending checkbook). Transfers do not create a 'Currency Gain/Loss' journal entry.

Software Version: YYYY.MM.DD and newer

Table of Contents

type	flat

Page Header

Header Toolbar

...

If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed.

...

The Journal Details Window for this transaction will include:

The Cash Receipt Journal Entry (in both the Receipt Currency Amounts and Home Currency Amounts)
- Debit to the Checkbooks Cash Account
- Credit to the Customer A/R Account
All the associated application Journal Entries - even though they may have happened on different dates
All the associated Currency Gain/Loss Journal Entries - even though they may have happened on different dates

...

Home Tab

...

A text box to enter a comment. This defaults to blank and is not required. This field is only editable after a 'Customer' has been selected but remains editable, even after the transaction is posted. This must be <= 60 characters.

Linked Database Field: ERPx_ARTransactionHeader.Description.

...

A single-select combo box to select the Checkbook the money is being withdrawn from. This is editable when the Status is "New". If the 'From Checkbook' is changed, and a journal entry was already created, the journal entry will be updated. This defaults to blank but is required to Approve or Post. If missing, the message "From Checkbook is required." will be displayed on Save. This must also be different than the 'To Checkbook'. If not, the message "The 'From Checkbook' and 'To Checkbook' must be different." 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])

If this Checkbook is not in the 'Home Currency' the 'To Checkbook' must be in the 'Home Currency'. If not, the message "At least one of the Checkbooks must be in the Home Currency." will be displayed on Save.

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

...

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

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

...

The purpose of the Checkbook Transfer Record View is to add, edit, and remove transactions that record the movement of money from one Checkbook to another. From here, users can create a new transfer, edit an un-posted transfer, or delete an un-posted transfer. Deleting a transfer transaction removes the associated journal entry. When Checkbook Transfers are posted, the Checkbook Balances for both checkbooks are updated, a journal entry is created and posted, and a transaction for each checkbook is added to the Checkbook Transaction Inquiry. Transfers make a Journal Entry that Debits the GL Account assigned to the 'To Checkbook' (the receiving checkbook) and Credits the GL Account assigned to the 'From Checkbook' (the sending checkbook). Transfers do not create a 'Currency Gain/Loss' journal entry.

Software Version: YYYY.MM.DD and newer

Table of Contents

type	flat

Page Header

Header Toolbar

Toolbar Icons

Description

Delete

Insert excerpt

	Delete LV - Global
	Delete LV - Global
nopanel	true

If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed.

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 - Record View Header Icon
	Journal Details - Record View Header Icon
nopanel	true

The Journal Entry for this transaction will:

Debit the 'To Checkbooks' GL Account in the Home Currency amount.
Credit the 'From Checkbooks' GL Account in the Home Currency amount.

No matter what Currencies belong to the Checkbooks, the Transaction Currency Debit and Transaction Currency Credit will always be in the 'Home Currency'.

New

Insert excerpt

	New - Record View Header
	New - Record View Header
nopanel	true

Notes

Insert excerpt

	Notes - Global
	Notes - Global
nopanel	true

Print

Insert excerpt

	Print - Record View Header
	Print - Record View Header
nopanel	true

Save

Insert excerpt

	Save - Record View Header
	Save - Record View Header
nopanel	true

Home Tab

FieldsDescriptionCheckbook Currency

A non editable text box that displays the calculated amount of the Transfer, in the "To" Checkbook's currency, displayed in the currency format. This defaults to 0.00 but is updated on Save, after the 'Transfer From Amt.' is entered.

If both the 'From Checkbook' and 'To Checkbook' are assigned the same currency, the 'Transfer To Amt.' will equal the 'Transfer From Amt.'

If the 'From Checkbook' and 'To Checkbook' are assigned a different currency, the 'Transfer To Amt.' will be calculated from the applicable Currency Exchange table. The exchange table is auto-assigned and not editable by users. It is assigned as the first Exchange Table containing both the 'From Checkbook's' Currency and the 'To Checkbook's' Currency with a valid 'Rate' (exchange rate) for the Transfer Date. If there are no Rates that cover the Transfer Date then the last Rate will be used. If there are no Exchange Tables containing both the 'From Checkbook's' Currency and the 'To Checkbook's' Currency then the message "A valid exchange does not exist between [FromCheckbookCurrencyID] and [ToCheckbookCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

Fields

Description

Comment

A text box to enter a comment. This defaults to blank and is not required. This field is only editable after a 'Customer' has been selected but remains editable, even after the transaction is posted. This must be <= 60 characters.

Linked Database Field: ERPx_ARTransactionHeader.Description.

From Checkbook

A single-select combo box to select the Checkbook the money is being deposited intowithdrawn from. This is editable when the Status is "New". If the 'To From Checkbook' is changed, and a journal entry was already created, the journal entry will be updated. This defaults to blank but is required to Approve or Post. If missing, the message "To From Checkbook is required." will be displayed on Save. This must also be different than the 'From To Checkbook'. If not, the message "The 'From Checkbook' and 'To Checkbook' must be different." 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])

If this Checkbook is not in the 'Home Currency' then the 'From To Checkbook' must either be in the same currency or the 'Home Currency'. If not, the message "At least one of the Checkbooks must the message "The currency for the transfer 'To Checkbook' must either be the same as the transfer 'From Checkbook' or be in the 'Home Currency." will be displayed on Save.

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

To From Reference

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

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

Transfer Date

A date field to enter the date the Transfer was actually initiated on the sending side. This defaults to the current date and is required to Approve and/or Post. If not, the message "Transfer Date

Status

Insert excerpt

	Status - RV
	Status - RV
nopanel	true

To Checkbook

Transfer To Amt.

A single-select combo box to select the Checkbook the money is being deposited into. This is editable when the Status is "New". If the 'To Checkbook' is changed, and a journal entry was already created, the journal entry will be updated. This defaults to blank but is required to Approve or Post. If missing, the message "To Checkbook is required." will be displayed . This field is only editable while the transaction Status is "New".

Linked Database Field: ERPx_ARTransactionHeader.TransactionDate.

Transfer From Amt.

An editable text box to enter the amount of the Transfer, in the "From" Checkbook's currency, displayed in the currency format. This defaults to 0.00 but must be a positive amount to Approve or Post. If not, the message "Transfer from Amt. must be positive." will appear on Save.

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

on Save. This must also be different than the 'From Checkbook'. If not, the message "The 'From Checkbook' and 'To Checkbook' must be different." 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])

If the 'From Checkbook' is not in the 'Home Currency' then the 'To Checkbook' must either be in the same currency or the 'Home Currency'. If not, the message "The currency for the transfer 'To Checkbook' must either be the same as the transfer 'From Checkbook' or be in the 'Home Currency." will be displayed on Save.

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

To Reference

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

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

Transfer Date

A date field to enter the date the Transfer was actually initiated on the sending side. This defaults to the current date and is required to Approve and/or Post. If not, the message "Transfer Date is required." will be displayed. This field is only editable while the transaction Status is "New".

Linked Database Field: ERPx_ARTransactionHeader.TransactionDate.

Transfer From Amt.

An editable text box to enter the amount of the Transfer, in the transfer's 'From Checkbook' currency, displayed in the currency format. This defaults to 0.00 but must be a positive amount to Approve or Post. If not, the message "Transfer from Amt. must be positive." will appear on Save.

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

Properties Tab

Fields prefixed with "MC: " are sorted at the bottom of the list and are only visible to multi-currency receipt transactions.

Transfer To Amt.

A non

-

editable text box

to identify the Currency ID for the currency assigned to the Checkbook. Receipts cannot be posted if this value is missing.

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

CheckbookSK Insert excerptCheckbookSK - RVCheckbookSK - RVnopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.

Created Insert excerptCreated (Date & Time) - RVCreated (Date & Time) - RVnopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CreatedDate.

Created By Insert excerptCreated By- RVCreated By- RVnopaneltrue

that displays the calculated amount of the transfer receipt, in the transfer's 'To Checkbook' currency, displayed in the currency format. This defaults to 0.00 but is updated on Save, after the 'Transfer From Amt.' is entered.

If both the 'From Checkbook' and 'To Checkbook' are assigned the same currency, the 'Transfer To Amt.' will equal the 'Transfer From Amt.'
If the 'From Checkbook' and 'To Checkbook' are assigned a different currency, the 'Transfer To Amt.' will be calculated from the applicable Currency Exchange table.

Linked Database Field: ERPx_

ARTransactionHeader

#####.

CreatedBy.

#####

CustomerSK Insert excerptCustomerSK - RVCustomerSK - RVnopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.

GL Date Insert excerptGL Date - RVGL Date

Properties Tab

Fields prefixed with "MC: " are sorted at the bottom of the list and are only visible to multi-currency receipt transactions.

For Payment Receipts only, If blank, the value will be automatically updated as follows:

For Receipts in the Home Currency - updated to the 'Receipt Date' on Approve or Ready to Post.
For Receipts NOT in the Home Currency, that have not been applied - updated to the 'Receipt Date' on Approve or Ready to Post.
For Receipts NOT in the Home Currency, that have been applied - updated to the 'Receipt Date' on application

The GL Date must be >= the 'Receipt Date'. If not, the message "GL Date must be >= the Receipt Date." will be displayed on Save. The GL Date must fall within a Fiscal Period that is open for Sales. If not, the message, "The Fiscal Period is not open." will be displayed on Save.

Linked Database Field: ERPx_ARTransactionHeader.GLDate.ARTransactionHeader.LastUpdatedARTransactionHeaderLastUser. to identify the currency of the receipt. Receipts may not always be in the same currency as the Checkbook ERPxARTransactionHeaderARTransactionHeaderTransactionID.Transaction SK Transaction SK ARTransactionHeader.TransactionHeaderSK exchange Receipt Receipt Currency' is not exchange the Receipt 'Receipt Currency' is not in the Home Currency 'Payment Receipts' that each 'Payment Receipt' currency () the 'Home Currency' (To ) Currency' on the Exchange Table matches the 'Payment Receipt' Currency and the 'To 'Home Currency' then the ' on the transaction match from the 'From Currency' on Exchange Table matches the 'Home Currency' and the 'To the Payment Receipt' Currency then the Inverse Exchange method will be used and the on the transaction being between the 'Payment Receipt' Currency and 'Payment Receipts' that are in the same currency as the 'Home Currency'. 'Payment Receipts' that are not in the same currency as the 'Home Currency'.This value is auto-assigned and not editable by users. It Receipt Currency and the Receipt If Receipt Receipt Home Currency then the 'Payment Receipt' MFCurrencyExchangeSourceCurrencySKMFCurrencyExchangeDestCurrencySK

Fields

Description

Created

Insert excerpt

	Created (Date & Time) - RV
	Created (Date & Time) - RV
nopanel	true

Linked Database Field: ERPx_.

Created By

Insert excerpt

	Created By- RV
	Created By- RV
nopanel	true

Linked Database Field: ERPx_

From Checkbook Currency

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

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

From CheckbookSK

A non-editable text box that displays the CheckbookSK of the 'From Checkbook'. This is a looked-up value, that is primarily used for support.

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

GL Date

Insert excerpt

	GL Date - RV
	GL Date - RV
nopanel	true

Linked Database Field: ERPx_

Last Updated

Insert excerpt

	Last Updated (Date & Time) - RV
	Last Updated (Date & Time) - RV
nopanel	true

Linked Database Field: ERPx_

.

Last Updated By

Insert excerpt

	Last Updated By- RV
	Last Updated By- RV
nopanel	true

Linked Database Field: ERPx_

.

Receipt

To Checkbook Currency

A non-editable text box

that displays the Currency ID of the 'To Checkbook'.

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

To CheckbookSK

A non-editable text box that displays the CheckbookSK of the 'To Checkbook'. This is a looked-up value, that is primarily used for support.

Linked Database Field:

ERPx_

MFCheckbook.CurrencySK.

Transaction ID

Insert excerpt

	Transaction ID - RV
	Transaction ID - RV
nopanel	true

Linked Database Field: ERPx_

.

TransactionSK

Insert excerpt

	TransactionSK - RV

	TransactionSK - RV
nopanel	true

Linked Database Field: ERPx_

.

Transfer Amount - Home Currency

A non-editable text box to show the total amount of the Transfer, in the 'Home Currency', displayed in the 'Home Currency' format. The Transfer Amount must be > 0.00 to Approve or Post.

MC: Exchange Date From

A date field to show the 'Start Date' of the 'Exchange Rate' on the 'Exchange Table' assigned to this transaction. The

'Rate' is looked-up using the '

Transfer Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the Currency for BOTH the '

From Checkbook' and 'To Checkbook' are NOT in the 'Home Currency'. This is a looked-up value and is not editable from here.

Linked Database Field: ERPx_MFCurrencyExchangeRate.Start.

MC: Exchange Date To

A date field to show the 'End Date' of the 'Exchange Rate' on the 'Exchange Table' assigned to this transaction. The

'Rate' is looked-up using

the '

Transfer Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the

Currency for BOTH the 'From Checkbook' and 'To Checkbook' are NOT in the 'Home Currency'. This is a looked-up value and is not editable from here.

Linked Database Field: ERPx_MFCurrencyExchangeRate.Expire.

MC: Exchange Rate

A label to show the 'Rate' (exchange rate) applicable on the Transaction Date (not the GL Date) on the 'Exchange Table' assigned to this transaction. This is set to 1.00 for all

Transfers where BOTH the 'From Checkbook' and 'To Checkbook' are in the 'Home Currency'. This is a looked-up value and is not editable from here.

Linked Database Field: ERPx_MFCurrencyExchangeRate.Rate.

MC: Exchange Rate Calculation Method

A non-editable text box to show the 'Calculation Method' being used to convert

the 'From Currency'

to

the '

Home Currency'

. This will either be "Multiply" or "Divide" and is set as follows:

If BOTH the 'From

Checkbook' and 'To Checkbook' are in the 'Home Currency' this will the set to "Multiply".
If the 'From Currency' on the Exchange Table matches the

foreign currency of Transfer, the 'Calculation Method'

will

default from the 'Calculation Method'

on the Exchange Table.
If

the

'From Currency' on the Exchange Table matches

the '

Home Currency', the 'Calculation Method'

will be the opposite as it is on the Exchange Table.

This is a looked-up value. Linked Database Field: ERPx_#####.#####.

Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN.

MC: Exchange Table

A non-editable text box that displays the 'Exchange Table ID'

used to convert

the checkbook transfer amounts to the 'Home Currency'. This will be blank for all

Transfers where the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are in the Home Currency. This is required for all

Transfers where either the 'From Checkbook' or the 'To Checkbook' are assigned a foreign currency.

This is assigned as the first Exchange Table containing both the

'Home Currency' and the foreign currency on the transfer, with a valid 'Rate' (exchange rate) for the

Transfer Date.

If there are no Rates that cover the

Transfer Date then the last Rate will be used. If there are no Exchange Tables containing both the

'Home Currency' and the

foreign currency then this will be blank and the message "A valid exchange does not exist between [TransactionCurrencyID] and [HomeCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

Linked Database Field: ERPx_MFCurrencyExchange.ExchangeID.

MC: From Currency

A non-editable text box that displays

the Currency ID of the foreign currency on the Transfer.

Linked Database Field: ERPx_

#####.

MC: To Currency

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

Linked Database Field: ERPx_

#####.

Version	Old Version 4	New Version 5
Changes made by	Tom Williams	Tom Williams
Saved on	Nov 14, 2019	Nov 14, 2019

Versions Compared

Key

Page Header

Header Toolbar

Home Tab

Page Header

Header Toolbar

Home Tab

Properties Tab

Properties Tab

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Header Toolbar

Home Tab

Page Header

Header Toolbar

Home Tab

Properties Tab

Properties Tab

Related Topics

Page Definitions