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

Page Header

Header Toolbar

Toolbar Icons	Description
Delete	Error rendering macro 'excerpt-include' : No link could be created for 'Delete LV - Global'. If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed.
Grid Layout	Error rendering macro 'excerpt-include' : No link could be created for 'Grid Layout'.
Help	Error rendering macro 'excerpt-include' : No link could be created for 'Help - Global Icon'.
Journal Details	Error rendering macro 'excerpt-include' : No link could be created for 'Journal Details - Record View Header Icon'. 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	Error rendering macro 'excerpt-include' : No link could be created for 'New - Record View Header'.
Notes	Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled.
Print	Error rendering macro 'excerpt-include' : No link could be created for 'Print - Record View Header'.
Save	Error rendering macro 'excerpt-include' : No link could be created for 'Save - Record View Header'.

Home Tab

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 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_#####.#####
From Reference	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_#####.#####
Status	A single-select standard lookup to assign the Transaction Status. This defaults to "New" but can be changed to "Approved" or "Ready to Post". This defaults to 'New' and is always required. This field is editable until the transaction is 'Ready to Post'. Updating the Status does the following: New: This is the default value. While in the Status of New all editable fields are open for edit, no posting/approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist. Approved: Performs all the data validations required to post the transaction. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned. Ready to Post: Runs the Approval validations. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted".
To Checkbook	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 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 this Checkbook is not in the 'Home Currency' the 'From 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_#####.#####
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 "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_#####.#####
Transfer To Amt.	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. 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.

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	A non-editable text box to identify the SK value of the Checkbook assigned to the Transaction. This is a looked-up value, that is primarily used for support. Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.
Created	A non-editable text box to identify the Created Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_ARTransactionHeader.CreatedDate.
Created By	A non-editable text box to identify the name of the user that created the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_ARTransactionHeader.CreatedBy.
CustomerSK	A non-editable text box to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support. Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.
GL Date	The date the transaction posted (or will post) to the general ledger. If unassigned when the transactions Status is changed to "Approve" or "Ready to Post", it will default from the Transaction Date. To Approve or Post, the GL Date must be in a valid period that is open for posting. If not the message, "The Fiscal Period is not open." will be displayed on Save. 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	A non-editable text box to identify the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_ARTransactionHeader.LastUpdated.
Last Updated By	A non-editable text box to identify the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. 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	A non-editable text box to identify the Transaction #. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_ARTransactionHeader.TransactionID.
TransactionSK	Error rendering macro 'excerpt-include' : No link could be created for 'Transaction SK - RV'. 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.

Page Header

Header Toolbar

Home Tab

Properties Tab

Related Topics

Page Definitions

Technical Details