Checkbook Transfer Record View

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

Page Header

Header Toolbar

Toolbar IconsDescription
Delete

Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

Grid LayoutOpens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

Journal Details

Opens the Journal Details window showing the Journal Entry for this transaction. 

(lightbulb) Until the transaction Approved or Posted, this is a temporary journal entry so no Journal ID will be assigned. 

The Journal Entry for this transaction will:

  • Debit the 'To Checkbooks' GL Account.
  • Credit the 'From Checkbooks' GL Account. 

(lightbulb) This icon is only visible after the transaction is 'Posted'.

(lightbulb) No matter what Currencies belong to the Checkbooks, the 'Transaction Currency Debit' and 'Transaction Currency Credit' will always be in the foreign currency.

NewAllows the user to create a new master file record or transaction by opening a blank record view page. This icon is always enabled. 
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. 

PrintOpens the Print dialog, showing any applicable printable reports to be printed, downloaded, and/or emailed. 
SaveSaves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

Home Tab

FieldsDescription
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])

(lightbulb) 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

StatusA 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])

(lightbulb) 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

Properties Tab

The fields sorted at the bottom of this section, prefixed with "MC:" are only visible on multi-currency transfer transactions.

FieldsDescription
CheckbookSK - From Checkbook

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

CheckbookSK - To Checkbook

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.

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_MFCheckbookTransaction.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_MFCheckbookTransaction.CreatedBy

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_MFCheckbookTransaction.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_MFCheckbookTransaction.LastUser

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_MFCheckbookTransaction.TransactionID

TransactionSK

A non-editable text box to identify the SK value of the Transaction. This is a looked-up value, that is primarily used for support.

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionSK

MC: Journal Entry: Currency Conversion

This field is used to convert a Foreign Currency transfer amount to the 'Home Currency' amount for the Journal Entry.

A non-editable text box that displays the currencies on the 'Exchange Table' being used to convert the foreign currency amount to the 'Home Currency' amount. This is formatted as: "From [foreign currency] to [Home Currency]". This is only displayed and required when one of the Checkbooks is not in the 'Home Currency'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Journal Entry: Exchange Date

This field is used to convert a Foreign Currency transfer amount to the 'Home Currency' amount for the Journal Entry.

A non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Exchange Table' being used to convert the foreign currency amount to the 'Home Currency' amount. This is only displayed and required when one of the Checkbooks is not in the 'Home Currency'.

This is looked-up using the 'Transfer Date', not the 'GL Date'. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19". The date values are formatted based on the User Preference for 'Date Format'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Journal Entry: Exchange Rate

This field is used to convert a Foreign Currency transfer amount to the 'Home Currency' amount for the Journal Entry.

A non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the foreign currency amount' to the 'Home Currency' amount. This is only displayed and required when one of the Checkbooks is not in the 'Home Currency'. It is set as follows:

  • If the 'From Currency' on the Exchange Table matches the foreign currency, then 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 formatted as: [Calculation Method] by [Rate]. For Example, "Multiply by 1.0250" or "Divide by 1.0250".

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Journal Entry: Exchange Table

This field is used to convert a Foreign Currency transfer amount to the 'Home Currency' amount for the Journal Entry.

A non-editable text box that displays the 'Exchange Table ID' used to convert the foreign currency to the 'Home Currency'. This is only displayed and required when one of the Checkbooks is not in the 'Home Currency'.

This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign 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 'Home Currency' and the foreign currency then this will be blank and the message "A valid exchange does not exist between [ForeignCurrencyID] and [HomeCurrencyID]." will be displayed on Save.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Journal Entry: Home Amount

This field is used to convert a Foreign Currency transfer amount to the 'Home Currency' amount for the Journal Entry.

A non-editable text box that displays the 'Home Currency' amount of the Transfer. This is only displayed and required when one of the Checkbooks is not in the 'Home Currency'. It is calculated as follows:

  • If both checkbooks are assigned a foreign currency then [Transfer from Amt.] multiplied or divided by [Journal Entry: Exchange Rate] ELSE 
  • If the 'From Checkbook' is in the 'Home Currency' then [Transfer From Amt.] ELSE 
  • [Transfer To Amt.] 

This value is computed in real time and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: To Checkbook: Amount

This field is used to convert the 'Transfer From Amt.' to the 'Transfer To Amt.'.

A non-editable text box that displays the Amount of money being received by the 'To Checkbook', converted and formatted into the currency of the 'To Checkbook'. This is only displayed and required when the two checkbooks are not in the same currency.

This value is computed in real time and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: To Checkbook: Currency Conversion

This field is used to convert the 'Transfer From Amt.' to the 'Transfer To Amt.'.

A non-editable text box that displays the currencies on the 'Exchange Table' being used on the 'From Checkbook' and 'To Checkbook'. This is formatted as: "From [From Checkbook Currency] to [To Checkbook Currency]". This is only displayed and required when the two checkbooks are not in the same currency.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: To Checkbook: Exchange Date

This field is used to convert the 'Transfer From Amt.' to the 'Transfer To Amt.'.

A non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Exchange Table' being used to convert the currencies between the 'From Checkbook' and the 'To Checkbook'. This is only displayed and required when the two checkbooks are not in the same currency.

This is looked-up using the 'Transfer Date', not the 'GL Date'. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19". The date values are formatted based on the User Preference for 'Date Format'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: To Checkbook: Exchange Rate

This field is used to convert the 'Transfer From Amt.' to the 'Transfer To Amt.'.

A non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the currencies between the 'From Checkbook' and the 'To Checkbook'. This is only displayed and required when the two checkbooks are not in the same currency. It is set as follows:

  • If the 'From Currency' on the Exchange Table matches the currency of the 'From Checkbook', then the 'Calculation Method' will default from the 'Calculation Method' on the Exchange Table.
  • If the 'From Currency' on the Exchange Table matches the currency of the 'To Checkbook', then the 'Calculation Method' will be the opposite as it is on the Exchange Table.

This is formatted as: [Calculation Method] by [Rate]. For Example, "Multiply by 1.0250" or "Divide by 1.0250".

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: To Checkbook: Exchange Table

This field is used to convert the 'Transfer From Amt.' to the 'Transfer To Amt.'.

A non-editable text box that displays the 'Exchange Table ID' used to convert the currencies between the 'From Checkbook' and the 'To Checkbook'. This is only displayed and required when the two checkbooks are not in the same currency.

This is assigned as the first Exchange Table containing both currencies for the 'From Checkbook' and the 'To Checkbook', 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 [FromCheckbookCurrencyID] and [ToCheckbookCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

Related Topics

Voiding or correcting a posted Checkbook Transfer



 Page Definitions

Page Definitions


 Technical Details

Technical Details