Page Comparison

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

...

true

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.

Favorites

Insert excerpt

Favorites Add/Remove - Global

nopanel

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

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

...

Fields

Description

Checkbook Currency

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 excerpt

	CheckbookSK - RV
	CheckbookSK - RV
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.

Created

Insert excerpt

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

Linked Database Field: ERPx_ARTransactionHeader.CreatedDate.

Created By

Insert excerpt

	Created By- RV
	Created By- RV
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.CreatedBy.

CustomerSK

Insert excerpt

	CustomerSK - RV
	CustomerSK - RV
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.

GL Date

Insert excerpt

	GL Date - RV
	GL Date - RV
nopanel	true

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.

Last Updated

Insert excerpt

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

Linked Database Field: ERPx_ARTransactionHeader.LastUpdated.

Last Updated By

Insert excerpt

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

Linked Database Field: ERPx_ARTransactionHeader.LastUser.

Receipt Currency

A non-editable text box to identify the currency of the receipt. Receipts may not always be in the same currency as the Checkbook.

Linked Database Field: ERPx_ARTransactionHeader.CurrencySK.

Transaction ID

Insert excerpt

	Transaction ID - RV
	Transaction ID - RV
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.TransactionID.

TransactionSK

Insert excerpt

	Transaction SK - RV
	Transaction SK - RV
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK.

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 exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is 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 exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is 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 'Payment Receipts' that 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 each 'Payment Receipt' currency (the 'From Currency') to the 'Home Currency' (the 'To Currency'). This will either be "Multiply" or "Divide" and is set as follows:

If the 'From Currency' on the Exchange Table matches the 'Payment Receipt' Currency and the 'To Currency' on the Exchange Table matches the 'Home Currency' then the 'Calculation Method' on the transaction will match the 'Calculation Method' from the Exchange Table.
If the 'From Currency' on the Exchange Table matches the 'Home Currency' and the 'To Currency' on the Exchange Table matches the 'Payment Receipt' Currency then the Inverse Exchange method will be used and the 'Calculation Method' on the transaction will be 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' being used to convert between the 'Payment Receipt' Currency and the 'Home Currency'. This will be blank for all 'Payment Receipts' that are in the same currency as the 'Home Currency'. This is required for all 'Payment Receipts' that are not in the same currency as the 'Home Currency'.

This value is auto-assigned and not editable by users. It is assigned as the first Exchange Table containing both the Receipt Currency and the 'Home Currency' with a valid 'Rate' (exchange rate) for the Receipt Date. If there are no Rates that cover the Receipt Date then the last Rate will be used. If there are no Exchange Tables containing both the Receipt Currency and the Home 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 'Payment Receipt' Currency ID.

Linked Database Field: ERPx_MFCurrencyExchange.SourceCurrencySK.

MC: To Currency

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

Linked Database Field: ERPx_MFCurrencyExchange.DestCurrencySK.

...

Version	Old Version 2	New Version 3
Changes made by	Tom Williams	Tom Williams
Saved on	Nov 14, 2019	Nov 14, 2019

Versions Compared

Key