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

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

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

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

• 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

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

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

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

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

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

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.

Linked Database Field: ERPx_MFCheckbookTransaction.LastUpdated

Linked Database Field: ERPx_MFCheckbookTransaction.LastUser

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionID

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionSK

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.

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.

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.

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.

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.

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.

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.

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.

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 each 'Payment Receipt' currency (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'

This is a looked-up value. Linked Database Field: ERPx_#####.#####.

Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN.

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

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.

Linked Database Field: ERPx_MFCurrencyExchange.ExchangeID.

A non-editable text box that displays the 'Payment Receipt' Currency ID.

Linked Database Field: ERPx_MFCurrencyExchange.SourceCurrencySK.

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

Linked Database Field: ERPx_MFCurrencyExchange.DestCurrencySK.

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.