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

Table of Contents
typeflat

Page Header

Header Toolbar

...

(lightbulb) If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed. 

...

The Journal Details Window for this transaction will include:

  • The Cash Receipt Journal Entry (in both the Receipt Currency Amounts and Home Currency Amounts)
    • Debit to the Checkbooks Cash Account 
    • Credit to the Customer A/R Account 
  • All the associated application Journal Entries - even though they may have happened on different dates
  • All the associated Currency Gain/Loss Journal Entries - even though they may have happened on different dates

...

Home Tab

...

A text box to enter the dollar amount of the payment you received in the 'Currency' you specified. This defaults to 0.00 but is required and must be > 0.00 to Approve and/or Post. If not, the message "Amount must be greater than 0.00." will be displayed. This field is only editable after a 'Customer' has been selected and while the transaction Status is "New" and while no applications exist for the receipt. Editing this value, and saving the transaction will re-calculate the 'Applied' and 'Unapplied' fields.

Linked Database Field: ERPx_ARTransactionHeader.ExtendedAmount.

...

A single-select standard lookup to select which checkbook the receipt will be deposited into. This defaults using the following logic after the Customer is selected:

  1. If the Checkbook that is assigned to the Customer is in either the Customer Currency or the Home Currency then default to the Customer Checkbook, else
  2. If the Checkbook that is assigned to the "Default Payment Receipt Checkbook" Sales Preference is in either the Customer Currency or the Home Currency then default from the Preference, else
  3. Set to blank and require a value before enabling the rest of the data fields

This is required before you can enter/edit the remaining receipt fields, Approve and/or Post, or to open the 'Apply Documents' window. If not assigned, the message "Checkbook is required" will be displayed. This field is enabled after a 'Customer' has been selected and while the transaction Status is "New". This field is only editable after a 'Customer' has been selected and while the transaction Status is "New" and no applications for this receipt have been made. 

The lookup contains the list of all the 'Active' checkbooks assigned to the Customer or the Home Currency. 

...

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

Table of Contents
typeflat

Page Header

Header Toolbar

Toolbar IconsDescription
Delete

Insert excerpt
Delete LV - Global
Delete LV - Global
nopaneltrue

(lightbulb) If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed. 

Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
Journal Details

Insert excerpt
Journal Details - Record View Header Icon
Journal Details - Record View Header Icon
nopaneltrue

The Journal Details Window for this transaction will include:

  • The Cash Receipt Journal Entry (in both the Receipt Currency Amounts and Home Currency Amounts)
    • Debit to the Checkbooks Cash Account 
    • Credit to the Customer A/R Account 
  • All the associated application Journal Entries - even though they may have happened on different dates
  • All the associated Currency Gain/Loss Journal Entries - even though they may have happened on different dates
New
Insert excerpt
New - Record View Header
New - Record View Header
nopaneltrue
Notes

Insert excerpt
Notes - Global
Notes - Global
nopaneltrue

Print
Insert excerpt
Print - Record View Header
Print - Record View Header
nopaneltrue
Save
Insert excerpt
Save - Record View Header
Save - Record View Header
nopaneltrue

Home Tab

ARTransactionHeader.CashReceiptTypeEN.A non-editable text box to identify how much of the Receipt still needs to be applied. This defaults from 'Amount' entered but will re-calculate as the receipt is applied. Receipts can be posted without applying, but if they have been applied, this amount will be >0.00 and < 'Amount'. This is a calculated field that is not editable on this page. This field is not linked to a Database Field.
FieldsDescription
Comment

A text box to enter a comment. This defaults to blank and is not required. This field is only editable after a 'Customer' has been selected but remains editable, even after the transaction is posted. This must be <= 60 characters.

Linked Database Field: ERPx_ARTransactionHeader.Description.

CurrencyFrom Checkbook

A single-select standard lookup to assign the currency of the Receipt. This initially defaults to the 'Home Currency' but updates to the Customer currency once a Customer has been selected, but can be changed after that. This is required to Approve and/or Post or to open the 'Apply Documents' window. If not assigned, the message "Currency is required and must be in either [Home Currency ID] or [Checkbook Currency ID]." will be displayed. This field is only editable after a 'Customer' has been selected and while the transaction Status is "New" and no applications for this receipt have been made.

(lightbulb) Since a Receipt can only be applied to transactions matching the Receipt's currency, the 'Currency' cannot be edited once an application exists. If you need to change the Currency, you must unapply all the transactions that are currently applied.

Validations include:

  • If the Currency assigned to the Checkbook matches the 'Home Currency' then the receipt currency can be any currency with a valid exchange table setup to the Home Currency.
  • If the Currency assigned to the Checkbook does NOT match the 'Home Currency', then the receipt must either be in the Checkbook's currency or the 'Home Currency'.

The lookup contains all 'Active' currencies.

Linked Database Field: ERPx_ARTransactionHeader.CurrencySK.

Customer

A single-select load on demand lookup to select the Customer you received the payment from. This defaults to blank but is required before anything other than the 'Receipt Date' can be edited. If not assigned, the message "Customer is required." will be displayed. Because this value determines the initial values assigned for the 'Checkbook' and 'Currency', if it is changed after it has been assigned, a message will appear as: "Changing the Customer will reset the Checkbook and/or Receipt Currency." This field is only editable while the transaction Status is "New" and the 'Applied Amount' is blank or 0.00.

The lookup contains the list of all 'Active' customers displayed as Customer Name (Customer ID). 

Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.

Payment #

A text box to enter the number of the payment you received, most often associated with the Check #. This field defaults to blank, is not required, and is only editable after a 'Customer' has been selected. This field is always editable, even after the transaction is posted.

Linked Database Field: ERPx_ARTransactionHeader.DocNumber.

Receipt Date

A date field to enter the date the Receipt was actually received. This defaults to the current date and is required to Approve and/or Post or to open the 'Apply Documents' window. If not, the message "Receipt Date is required." will be displayed. This field is only editable while the transaction Status is "New" but is disabled once an application for this receipt has been made.

(lightbulb) Since the 'Receipt Date' can impact a Currency Gain / Loss when it is applied, it the cannot be edited once an application exists for receipts that are not in the Home Currency. If you need to change the 'Receipt Date', you must unapply all the transactions that are currently appliedcombo 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 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' the 'To Checkbook' must be in the 'Home Currency'. If not, the message "At least one of the Checkbooks must 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 for the Transfer that applies to the 'From Checkbooks' bank. This field is 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
Insert excerpt
Status - RV
Status - RV
nopaneltrue
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 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' the 'From Checkbook' must be in the 'Home Currency'. If not, the message "At least one of the Checkbooks must 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 for the Transfer that applies to the 'To Checkbooks' bank. This field is 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 actually initiated 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.

Receipt Type

A single-select standard lookup to select the type of the Receipt. This defaults to "Check" but can be changed. This is required to Approve and/or Post. This field is only editable after a 'Customer' has been selected and while the transaction Status is "New". 

The lookup contains all the values in the MFCashReceiptType Enumeration Class. Transfer From Amt.

An editable text box to enter the amount of the Transfer, in the "From" Checkbook's 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_

Status

Changing this value will re-assign the Checkbook and the receipt currency.A single-select standard lookup to select the Status of the Receipt. This defaults to New but can be changed to Approved or Ready to Post. Setting this to Approved, and saving, runs all the posting validations and disables all the fields except the Comment, Payment #, and Status. Setting this to Ready to Post, and saving, posts the transaction, disables  all the fields except the Comment and Payment #, and posts the journal entry.

The lookup contains the list of New, Approved, and Ready to Post.

Linked Database Field: ERPx_ARTransactionHeader.TransactionStatusSK.

Unapplied

#####.#####

Transfer To Amt.

A non editable text box that displays the calculated amount of the Transfer, in the "To" Checkbook's 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. The exchange table is auto-assigned and not editable by users. It is assigned as the first Exchange Table containing both the 'From Checkbook's' Currency and the 'To Checkbook's' 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 'From Checkbook's' Currency and the 'To Checkbook's' Currency then 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_#####.#####


Properties Tab

Fields prefixed with "MC: " are sorted at the bottom of the list and are only visible to multi-currency receipt transactions.

FieldsDescription
Checkbook Currency

A non-editable text box to identify the Currency ID for the currency assigned to the Checkbook. Receipts cannot be posted if this value is missing.

Linked Database Field: ERPx_MFCheckbook.CurrencySK.

CheckbookSK

Insert excerpt
CheckbookSK - RV
CheckbookSK - RV
nopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.

Created

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

Linked Database Field: ERPx_ARTransactionHeader.CreatedDate.

Created By

Insert excerpt
Created By- RV
Created By- RV
nopaneltrue
 

Linked Database Field: ERPx_ARTransactionHeader.CreatedBy.

CustomerSK

Insert excerpt
CustomerSK - RV
CustomerSK - RV
nopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.

GL Date

Insert excerpt
GL Date - RV
GL Date - RV
nopaneltrue

For Payment Receipts only, If blank, the value will be automatically updated as follows:

  • For Receipts in the Home Currency -  updated to the 'Receipt Date' on Approve or Ready to Post.
  • For Receipts NOT in the Home Currency, that have not been applied -  updated to the 'Receipt Date' on Approve or Ready to Post.
  • For Receipts NOT in the Home Currency, that have been applied -  updated to the 'Receipt Date' on application

The GL Date must be >= the 'Receipt Date'. If not, the message "GL Date must be >= the Receipt Date." will be displayed on Save. The GL Date must fall within a Fiscal Period that is open for Sales. If not, the message, "The Fiscal Period is not open." will be displayed on Save.

Linked Database Field: ERPx_ARTransactionHeader.GLDate.

Last Updated

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

Linked Database Field: ERPx_ARTransactionHeader.LastUpdated.

Last Updated By

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

Linked Database Field: ERPx_ARTransactionHeader.LastUser.

Receipt Currency

A non-editable text box to identify the currency of the receipt. Receipts may not always be in the same currency as the Checkbook.

Linked Database Field: ERPx_ARTransactionHeader.CurrencySK.

Transaction ID

Insert excerpt
Transaction ID - RV
Transaction ID - RV
nopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.TransactionID.

TransactionSK

Insert excerpt
Transaction SK - RV
Transaction SK - RV
nopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK.

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 exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here.

Linked Database Field: ERPx_MFCurrencyExchangeRate.Start.

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 exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here.

Linked Database Field: ERPx_MFCurrencyExchangeRate.Expire.

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 'Payment Receipts' that 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

A non-editable text box to show the 'Calculation Method' being used to convert each 'Payment Receipt' currency (the 'From Currency') to the 'Home Currency' (the 'To Currency'). This will either be "Multiply" or "Divide" and is set as follows:

  • If the 'From Currency' on the Exchange Table matches the 'Payment Receipt' Currency and the 'To Currency' on the Exchange Table matches the 'Home Currency' then the 'Calculation Method' on the transaction will match the 'Calculation Method' from the Exchange Table.
  • If the 'From Currency' on the Exchange Table matches the 'Home Currency' and the 'To Currency' on the Exchange Table matches the 'Payment Receipt' Currency then the Inverse Exchange method will be used and the 'Calculation Method' on the transaction will be opposite as it is on the Exchange Table.

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

Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN.

MC: Exchange Table

A non-editable text box that displays the 'Exchange Table ID' being used to convert between the 'Payment Receipt' Currency and the 'Home Currency'. This will be blank for all 'Payment Receipts' that are in the same currency as the 'Home Currency'. This is required for all 'Payment Receipts' that are not in the same currency as the 'Home Currency'.

This value is auto-assigned and not editable by users. It is assigned as the first Exchange Table containing both the Receipt Currency and the 'Home Currency' with a valid 'Rate' (exchange rate) for the Receipt Date. If there are no Rates that cover the Receipt Date then the last Rate will be used. If there are no Exchange Tables containing both the Receipt Currency and the Home 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 'Payment Receipt' Currency ID.

Linked Database Field: ERPx_MFCurrencyExchange.SourceCurrencySK.

MC: To Currency

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

Linked Database Field: ERPx_MFCurrencyExchange.DestCurrencySK.

Related Topics



Expand
titlePage Definitions

Page Definitions


...