Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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: 20202024.0105.13 20 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete - LV
Delete - LV
nopaneltrue

Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Journal DetailsThis icon is only visible after the transaction is Posted.
Journal Details

Insert excerpt
Journal Details - RV Header
Journal Details - RV Header
nopaneltrue

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.

New
Insert excerpt
New - RV Header
New - RV Header
nopaneltrue
Notes

Insert excerpt
Notes - Global
Notes - Global
nopaneltrue

Print
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue
Save
Insert excerpt
Save - RV Header
Save - RV Header
nopaneltrue

...

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.

Linked Database Field: ERPx_MFCheckbookTransaction.GLDate

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

Insert excerpt
Created (Date & Time) - RV
Created (Date & Time) - RV
nopaneltrue
 

Linked Database Field: ERPx_MFCheckbookTransaction.CreatedDate

Created By

Insert excerpt
Created By- RV
Created By- RV
nopaneltrue
 

Linked Database Field: ERPx_MFCheckbookTransaction.CreatedBy

GL Date

Insert excerpt
GL Date - RVGL Date - RV
nopaneltrue
Last Updated

Insert excerpt
Last Updated (Date & Time) - RV
Last Updated (Date & Time) - RV
nopaneltrue
 

Linked Database Field: ERPx_MFCheckbookTransaction.LastUpdated

Last Updated By

Insert excerpt
Last Updated By- RV
Last Updated By- RV
nopaneltrue
 

Linked Database Field: ERPx_MFCheckbookTransaction.LastUser

Transaction ID

Insert excerpt
Transaction ID - RV
Transaction ID - RV
nopaneltrue

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionID

TransactionSK

Insert excerpt
TransactionSK
TransactionSK
nopaneltrue

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.

...