The purpose of the 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. 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
...
Fields | Description | ||||||||
Comment | A text box to enter a short comment pertaining to the Deposit. 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_#####.##### | ||||||||
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 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 "The currency for the transfer 'To Checkbook' must either be the same as the transfer 'From Checkbook' or 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 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_#####.##### | ||||||||
Status |
| ||||||||
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 '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 "The currency for the transfer 'To Checkbook' must either be the same as the transfer 'From Checkbook' or 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 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_#####.##### | ||||||||
Transfer 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". Linked Database Field: ERPx_ARTransactionHeader.TransactionDate. | ||||||||
Transfer From Amt. | 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_#####.##### | ||||||||
Transfer To Amt. | 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.
Linked Database Field: ERPx_#####.##### |
...
Fields | Description | |||||||||||
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 |
Linked Database Field: ERPx_. | |||||||||||
Created By |
Linked Database Field: ERPx_ | |||||||||||
GL Date |
Linked Database Field: ERPx_ | |||||||||||
Last Updated |
Linked Database Field: ERPx_. | |||||||||||
Last Updated By |
Linked Database Field: ERPx_. | |||||||||||
Transaction ID |
Linked Database Field: ERPx_. | |||||||||||
TransactionSK |
Linked Database Field: ERPx_. | |||||||||||
MC: Currency - From Checkbook | A non-editable text box that displays the Currency ID of the 'From Checkbook'. Linked Database Field: ERPx_MFCheckbook.CurrencySK. | |||||||||||
MC: Currency - To Checkbook | A non-editable text box that displays the Currency ID of the 'To Checkbook'. Linked Database Field: ERPxERPx_MFCheckbook.CurrencySK. | |||||||||||
MC: Exchange Rate Date | A non-editable text box to show the date range of the 'Rate' of the '(Exchange Rate' ) on the 'Exchange Table' assigned to this transaction. The 'Rate' is looked-up using the 'Transfer Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are NOT in the 'Home Currency'. This is displayed as a looked-up value and is not editable from here.MC: Transfer Amount - Home Currency: From [Rate From] to [Rate to]. For example: "From 10/01/19 to 10/07/19". | |||||||||||
MC: Exchange Rate: Journal Entry | A non-editable text box to show the total amount of the Transfer, in'Calculation Method' and 'Rate' being used to convert the Transfer to the 'Home Currency ', displayed'. It is set as follows: | 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 'Rate' is looked-up using the 'Transfer Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the Currency for
| |||||||||
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 'Rate' is looked-up using the 'Transfer Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are NOT in the 'Home Currency'. This is a looked-up value and is not editable from here. Linked Database Field: ERPx_MFCurrencyExchangeRate.Start. | |||||||||||
This is formatted as: [Calculation Method] by [Rate]. For Example "Multiply by 1.0250" or "Divide by 1.0250". | ||||||||||||
MC: Exchange Rate: To Checkbook Amount | A non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the 'Transfer From Amt.' to the 'Transfer To Amt'. It is set as follows:
Linked Database Field: ERPx_MFCurrencyExchangeRate.Expire. | |||||||||||
MC: From Checkbook's Currency | A non-editable text box that displays the Currency ID of the 'From Checkbook'. Linked Database Field: ERPx_MFCheckbook.CurrencySK. | |||||||||||
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 Transfers where BOTH the 'From Checkbook' and 'To Checkbook' 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
This is formatted as: [Calculation Method] by [Rate]. For Example "Multiply by 1.0250" or "Divide by 1.0250". | ||||||||||||
MC: Exchange Table: Journal Entry | A non-editable text box to showthat displays the ' Calculation MethodExchange Table ID' beingused to convert the 'From Currency'transfer amount to the 'Home Currency'. This will either be "Multiply" or "Divide" and is set as follows:Ifbe blank for all Transfers where the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are in the 'Home Currency ' this will the set to "Multiply".This is a looked-up value. Linked Database Field: ERPx_#####.#####. Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN. MC: Exchange Table. This is required for all Transfers where either the 'From Checkbook' or the 'To Checkbook' are assigned a foreign currency. This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign currency on the transfer, 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 [TransactionCurrencyID] and [HomeCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post. | |||||||||||
MC: Exchange Table: To Checkbook | A non-editable text box that displays the 'Exchange Table ID' used to convert the checkbook transfer amounts 'Transfer From Amt.' to the 'Home CurrencyTransfer To Amt'. This will be blank for all Transfers where the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are in the Home same Currency. This is required for all Transfers where either the 'From Checkbook' or the and 'To Checkbook' are assigned a foreign not in the same currency. This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign currency on the transfer, 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 [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 Currency ID of the foreign currency on the TransferMC: From Currency: Transfer Currency | A non-editable text box that displays the Currency ID of the foreign currency on the Transfer. This will be blank for all Transfers where the Currency for BOTH the 'From Checkbook' and 'To Checkbook' are in the 'Home Currency'. This is required for all Transfers where either the 'From Checkbook' or the 'To Checkbook' are assigned a foreign currency. Linked Database Field: ERPx_#####.#####. | ||||||||||
MC: To Currency: Home Currency | A non-editable text box that displays the Home Currency ID. Linked Database Field: ERPx_#####.#####. | |||||||||||
MC: To Checkbook Transfer Amount - Home Currency | A non-editable text box that displays the Currency ID of the 'To Checkbook'.Linked Database Field: ERPx_MFCheckbook.CurrencySKto show the total amount of the Transfer, in the 'Home Currency', displayed in the 'Home Currency' format. The Transfer Amount must be > 0.00 to Approve or Post. |
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
...