Versions Compared

Key

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

The purpose of the Payment Receipt Record View is to enter payments received by customers. From here, users can open the 'Apply Documents' window, review the Journal Details, and post the receipt. When receipts are posted, the Customer Balances and Customer Aging are updated and the receipt becomes available to the Checkbook Deposit transaction. Payment Receipts make a journal entry when they are posted.

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

...

The purpose of the Payment Receipt Record View is to enter payments received by customers. From here, users can open the 'Apply Documents' window, review the Journal Details, and post the receipt. When receipts are posted, the Customer Balances and Customer Aging are updated and the receipt becomes available to the Checkbook Deposit transaction. Payment Receipts make a journal entry when they are posted.

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

Header Toolbar

Toolbar IconsDescription
Apply DocumentsOpens the Apply Documents window allowing the user to apply this receipt to one or more open transactions.  The Apply Documents button is disabled when the Receipt Amount is 0.
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
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

FieldsDescription
Amount

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.

AppliedA non-editable text box to identify how much of the Receipt, in the Receipt currency, has been applied. This defaults to 0.00 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. This is a calculated field that is not editable on this page. This field is not linked to a Database Field.
Checkbook

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 while no applications exist for the this receipt . Editing this value, and saving the transaction will re-calculate the 'Applied' and 'Unapplied' fields.have been made. 

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

Linked Database Field: ERPx_ARTransactionHeader.ExtendedAmountCheckbookSK.

Applied
Comment

A

non-editable

text box

to identify how much of the Receipt, in the Receipt currency, has been applied. This defaults to 0.00 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. This is a calculated field that is not editable on this page. This field is not linked to a Database Field.Checkbook

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.

Currency

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, 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 "Checkbook Currency is required " will be displayed. This field is enabled after a 'Customer' has been selected and while the transaction Status is "New"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

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

Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.

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.

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

Currency
Customer

A single-select standard load on demand lookup to assign the currency of the Receiptselect the Customer you received the payment from. This initially defaults to blank but is required before anything other than 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 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 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'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.CurrencySKDocNumber.

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

Linked Database Field: ERPx_ARTransactionHeader.CustomerSKTransactionDate.

Payment #Receipt Type

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 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 . This field is always editable, even after and while the transaction is posted.Status is "New". 

The lookup contains all the values in the MFCashReceiptType Enumeration Class. 

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

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

Receipt TypeUnappliedA single-select standard lookup to select the type non-editable text box to identify how much of the Receipt still needs to be applied. 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. 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.


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_

ARTransactionHeader

MFCheckbook.

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

CurrencySK.

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

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.

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

Properties Tab

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

trueCustomerSK.

 Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK.

 

Linked Database Field: ERPx_ARTransactionHeader.LastUser.

Linked Database Field: ERPx_ARTransactionHeader.TransactionID.

trueMC: Exchange Date To date field to show the 'Start Date' of the 'Exchange Rate' from 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 Start date field End Date' of the 'Exchange Rate' from 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.

A label to show the 'Exchange Rate' that applies to this transaction. The 'Exchange Rate' is looked-up from the 'Exchange Table' assigned to this transaction, based on the Transaction 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 hereMFCurrencyExchangeRateRateA label to show the 'Calculation Method' property from ' assigned to this transaction. 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.

The options include all the values in the MFRateCalculationMethod Enumeration Class. 

Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN.

A text box to display the Exchange Table that was auto assigned to this transaction. This defaults from the first Exchange Table that contains both the receipt currency and contains Exchange Exchange Exchange that contain to Approve and/or Ready to Post. This field is only populated, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This field is a looked up value and is not editable. to show the 'From Currency' property from the 'Exchange Table' assigned to this transaction. 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 to show the 'To Currency' property from the 'Exchange Table' assigned to this transaction. 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
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 - RVCheckbookSK - RVnopanel
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.

CheckbookSK

GLDate.

CreatedLast Updated

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

Linked Database Field: ERPx_ARTransactionHeader.CreatedDateLastUpdated.

Created Last Updated By

Insert excerpt
Created Last Updated By- RVCreated
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.CreatedByCurrencySK.

CustomerSKTransaction ID

Insert excerpt
CustomerSK Transaction ID - RVCustomerSK
Transaction ID - RV
nopaneltrue

Linked Database Field: ERPx_ARTransactionHeader.CustomerSKTransactionID.

GL DateTransactionSK

Insert excerpt

GL Date

Transaction SK - RV

GL Date

Transaction SK - 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) - RVLast Updated (Date & Time) - RV
nopaneltrue
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_ARTransactionHeaderMFCurrencyExchangeRate.LastUpdatedStart.

Last Updated By
Insert excerpt
Last Updated By- RVLast Updated By- RV
nopaneltrue
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 - RVTransaction ID - RV
nopaneltrue
TransactionSK
Insert excerpt
Transaction SK - RVTransaction SK - RVnopanel

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

MC: Exchange Date FromRate

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 Date ToRate Calculation Method

A

non-editable text box to show the '

MC: Exchange Rate

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 Rate Calculation MethodTable

A non-editable text box that displays the 'Exchange Table

MC: 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


...