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.

...

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.

...