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. 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). If the Currency of the two checkbooks do not match, the currency and amounts of the foreign currency will be used for the Journal Entry transaction amounts. Transfers do not create a 'Currency Gain/Loss' journal entry.

Software Version: 2024.05.20 and newer

[ 1 Page Header ] [ 1.1 Header Toolbar ] [ 1.2 Home Tab ] [ 1.3 Properties Tab ] [ 1.3.1 Related Topics ] [ 1.3.1.1 Page Definitions ] [ 1.3.1.2 Technical Details ]

Page Header

Header Toolbar

Toolbar Icons	Description

Toolbar Icons	Description
Delete
Grid Layout
Help
Journal Details	The Journal Entry for this transaction will: Debit the 'To Checkbooks' GL Account. Credit the 'From Checkbooks' GL Account. This icon is only visible after the transaction is 'Posted'. No matter what Currencies belong to the Checkbooks, the 'Transaction Currency Debit' and 'Transaction Currency Credit' will always be in the foreign currency.
New
Notes
Print
Save

Home Tab

Fields	Description
Comment	A text box to enter a short comment pertaining to the Transfer. This field 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_MFCheckbookTransaction.Comment
From Amount	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_MFCheckbookTransaction.Amount Where TransferFromCheckbookTransactionSK is null
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". This defaults to blank but is required to Save. 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' then the 'To Checkbook' must either be in the same currency or the 'Home Currency'. If not, the message "Either the From Checkbook Currency or To Checkbook Currency must be in the Home Currency or both Checkbook Currencies must be the same Currency." will be displayed on Save. Linked Database Field: ERPx_MFCheckbookTransaction.CheckbookSK Where TransferFromCheckbookTransactionSK is null
From Reference	A text box to enter a 3rd party reference number that applies to the 'From Checkbooks' bank. This field 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_MFCheckbookTransaction.Reference Where TransferFromCheckbookTransactionSK is null
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". 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 remain as previously assigned. 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) 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". Linked Database Field: ERPx_MFCheckbookTransaction.TransactionStatusSK
To Amount	A non editable text box that displays the transfer amount, 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_MFCheckbookTransaction.Amount Where TransferFromCheckbookTransactionSK is not null
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". This defaults to blank but is required to Save. 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 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 "Either the From Checkbook Currency or To Checkbook Currency must be in the Home Currency or both Checkbook Currencies must be the same Currency.." will be displayed on Save. Linked Database Field: ERPx_MFCheckbookTransaction.CheckbookSK Where TransferFromCheckbookTransactionSK is not null
To Reference	A text box to enter a 3rd party reference number that applies to the 'To Checkbooks' bank. This field 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_MFCheckbookTransaction.Reference Where TransferFromCheckbookTransactionSK is not null
Trans. Date	A date field to enter the date the Transfer was generated 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". This date will set the GL Date in the database and will always be the date used on the journal. Linked Database Field: ERPx_MFCheckbookTransaction.TransactionDate