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

A non-editable text box to identify the SK value of the Checkbook. This is a looked-up value, that is primarily used for support.

Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK.

Created

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

Linked Database Field: ERPx_ARTransactionHeader.CreatedDate.

Created By

Insert excerpt
Created By- Global FieldRV
Created By- Global FieldRV
nopaneltrue
 

Linked Database Field: ERPx_ARTransactionHeader.CreatedBy.

CustomerSK

A non-editable text box to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support.

Linked Database Field: ERPx_ARTransactionHeader.CustomerSK.

GL Date

Insert excerpt
GL Date - RV Field
GL Date - RV Field
nopaneltrue
ERPx_ARTransactionHeader.GLDate.

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 - Global Field(Date & Time) - RV
Last Updated - Global Field(Date & Time) - RV
nopaneltrue
 

Linked Database Field: ERPx_ARTransactionHeader.LastUpdated.

Last Updated By

Insert excerpt
Last Updated By- Global FieldRV
Last Updated By- Global FieldRV
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

A non-editable text box to identify the Transaction #. This is a system assigned value that is not editable by a user. 

Linked Database Field: ERPx_ARTransactionHeader.TransactionID.

TransactionSK

A non-editable text box to identify the SK value of the Transaction. This is a looked-up value, that is primarily used for support.

Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK.

MC: Exchange Date From

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

MC: Exchange Rate

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

Linked Database Field: ERPx_MFCurrencyExchangeRate.Rate.

MC: Exchange Rate Calculation Method

A label to show the 'Calculation Method' 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 and is not editable from here.

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

Linked Database Field: ERPx_MFCurrencyExchange.RateCalculationMethodEN.

MC: Exchange Table

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 the 'Home Currency' and contains a valid Exchange Rate for the Receipt Date. If there are no Exchange Rates that cover the Receipt Date then the last Exchange Rate will be used. If there are no Exchange Tables that contain 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. 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.

Linked Database Field: ERPx_MFCurrencyExchange.ExchangeID.

MC: From Currency

A non-editable text box 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.

Linked Database Field: ERPx_MFCurrencyExchange.SourceCurrencySK.

MC: To Currency

A non-editable text box 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.

Linked Database Field: ERPx_MFCurrencyExchange.DestCurrencySK.

...