Page Comparison

The purpose of the Payment Receipt Record View is to enter payments received by Fishermen, Fishermen & Tenders, Tenders and Loans. From here, users can open the 'Apply Documents' window, review the Journal Details, and post the receipt. When receipts are posted, the Fisherman 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.

...

Fields

Description

Amount

Identifies the dollar amount of the payment received. This is a text box that is required. This defaults to 0.00 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

Applied Amt.

Identifies how much of the receipt has been applied. This is a non-editable text box that is required. 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. This field is not stored in the database.

Checkbook

Identifies the checkbook where the receipt will be deposited into. This is a single-select standard lookup that is required. This defaults using the following logic after the Fisherman is selected:

If the Checkbook that is assigned to the Fisherman is in either the Fisherman Currency or the Home Currency, then default to the Fisherman Checkbook, else
If the Checkbook that is assigned to the "Default Fisherman Checkbook ID" Settlement Default Preference is in either the Fisherman Currency or the Home Currency then default from the Preference, else
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 Fishing Transactions list view. If not assigned, the message "Checkbook is required" will be displayed. This field is enabled after a 'Fisherman' has been selected and while the transaction Status is "New". This field is only editable after a 'Fisherman' has been selected and while the transaction Status is "New" and no applications for this receipt have been made.

Insert excerpt

	Def - Checkbook
	Def - Checkbook
nopanel	true

The lookup contains a list of all the 'Active' Checkbooks where the Currency is USD.

Database Fields:

ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Comment

Identifies the comment associated with the payment receipt. This is a text box that is not required. This defaults to blank and is only editable after a 'Fisherman' has been selected. If entered, it must be <= 60 characters. This field is always editable.

Linked Database Field: ERPx_ARTransactionHeader.Description

Currency

Identifies the currency of the receipt. This is a non-editable single-select standard lookup that is required. It defaults to "USD" and cannot be edited.

Linked Database Field:

ERPx_ARTransactionHeader.CurrencySK

Fisherman

Insert excerpt

	Account Name
	Account Name
nopanel	true

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

The lookup contains the current assigned value and a list of all the 'Active' Fishermen, Fishermen & Tenders, and Tenders and Loans not on hold.

Linked Database Field:

ERPx_ARTransactionHeader.CustomerSK

Payment #

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

Linked Database Field:

ERPx_ARTransactionHeader.DocNumber

Receipt Date

Identifies the date the receipt was received. This is a date picker field that defaults to the current date. It is required to Approve and/or Post or to open the Apply Fishing Transactions list view. If not, the message "Receipt Date is required." will be displayed. This field is only editable while the transaction Status is "New" and is disabled once an application for this receipt has been made.

If you need to change the 'Receipt Date' after an application has been made, you must unapply all the transactions that are currently applied.

Linked Database Field:

ERPx_ARTransactionHeader.TransactionDate

Receipt Type

Identifies the type of the receipt. This is a single-select standard lookup the is required to Approve and/or Post. This defaults to "Check". This field is only editable after a 'Fisherman' has been selected and while the transaction Status is "New".

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

Linked Database Field:

ERPx_ARTransactionHeader.CashReceiptTypeEN

Status

Insert excerpt

	Status
	Status
nopanel	true

This is a single-select standard lookup that defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

The Statuses that apply to transactions in this List View include:

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Insert excerpt

	Def - Status - Ready to Post
	Def - Status - Ready to Post
nopanel	true

Database Fields:

ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Unapplied Amt.

Identifies how much of the receipt still needs to be applied. This is a non-editable text box that is required. 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 stored in the database.

...

Fields

Description

Checkbook CurrencyA

Insert excerpt

	Checkbook Currency
	Checkbook Currency
nopanel	true

This is 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

that is required. It can only be edited by changing the Checkbook on the receipt.

Linked Database Field: ERPx_MFCheckbook.CurrencySK

CheckbookSK

Insert excerpt

	CheckbookSK

- RV


	CheckbookSK

- RV


nopanel	true

This is a non-editable text box that is required. It can only be edited by changing the Checkbook on the receipt. This is a looked-up value that is primarily used for support.

Linked Database Field:

ERPx_ARTransactionHeader.CheckbookSK

Created

Insert excerpt

	Created

(Date & Time) - RV


	Created

(Date & Time) - RV


nopanel	true

It is a non-editable textbox that is required.

Linked Database Field:

ERPx_ARTransactionHeader.CreatedDate

Created By

Insert excerpt

	Created By

- RV


	Created By

- RV


nopanel	true

It is a non-editable textbox that is required.

Linked Database Field:

ERPx_ARTransactionHeader.CreatedBy

CustomerSKFishermanSK

CustomerSK - RV

Insert excerpt

CustomerSK - RV

FishermanSK
	FishermanSK
nopanel	true

This is a non-editable text box that is required. It can only be edited by changing the Fisherman on the receipt. 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
	GL Date - RV
nopanel	true

For Payment Receipts only, This is a date picker that is required to Approve or Post the receipt. It defaults to blank and is always editable while the transaction is in a Status of "New". If blank, the value it will be automatically updated as follows:

For Receipts in the Home Currency - updated to

set to match the 'Receipt Date'

on Approve or Ready to Post.For Receipts NOT

field in the

Home Currency, that have not been applied - updated to the 'Receipt Date' on Approve

'Home' tab when the transaction is saved with a Status of either Approved 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 >= be on or after the 'Receipt Date' field when Approving or Posting. If not, the message "GL Date must be >= the Receipt Date." will be displayed on Save. The The GL Date must fall within a an open 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


nopanel	true

It is a non-editable textbox that is required.

Linked Database Field:

ERPx_ARTransactionHeader.LastUpdated

Last Updated By

Insert excerpt

	Last Updated By

- RV


	Last Updated By

- RV


nopanel	true

It is a non-editable textbox that is required.

Linked Database Field:

ERPx_ARTransactionHeader.LastUser

Receipt Currency

A Identifies the currency of the receipt. This is a non-editable text box to identify the currency of the receipt. Receipts may not always be in the same currency as the Checkbookthat is required. It defaults to "USD" and cannot be edited.

Linked Database Field:

ERPx_ARTransactionHeader.CurrencySK

Transaction ID

Insert excerpt

	Transaction ID

- RV


	Transaction ID

- RV


nopanel	true

This is a non-editable text box that is system generated, required and is not editable.

Linked Database Field:

ERPx_ARTransactionHeader.TransactionID

TransactionSK

Insert excerpt

	Transaction SK - RV	Transaction SK - RVTransactionSK
	TransactionSK
nopanel	true

Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK

MC: Exchange Date

This

field is used to convert the transaction total 'Receipt Amount' to the 'Home Currency' amount.

This is a non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Exchange Table' being used to convert the 'Receipt Amount' to the 'Home Currency' amount. This is only displayed and required when the Receipt currency is not in the 'Home Currency'.

This is looked-up using the 'Receipt Date', not the 'GL Date'. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19". The date values are formatted based on the User Preference for 'Date Format'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Exchange Rate

This field is used to convert the transaction total 'Receipt Amount' to the 'Home Currency' amount.

This is a non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the 'Receipt Amount' to the 'Home Currency' amount. This is only displayed and required when the Receipt's currency is not in the 'Home Currency'. It is set as follows:

If the 'From Currency' on the Exchange Table matches the Receipt currency, then the 'Calculation Method' will default from the 'Calculation Method' on the Exchange Table.
If the 'From Currency' on the Exchange Table matches the 'Home Currency', the 'Calculation Method' will be the opposite as it is on the Exchange Table.

This is formatted as: [Calculation Method] by [Rate]. For Example, "Multiply by 1.0250" or "Divide by 1.0250".

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Exchange Table

This field is used to convert the transaction total 'Receipt Amount' to the 'Home Currency' amount.

This is a non-editable text box that displays the 'Exchange Table ID' used to convert the 'Receipt Amount' to the 'Home Currency' amount. This is only displayed and required when the Receipt's currency is not in the 'Home Currency'.

This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign currency assigned to the Receipt, 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 'Home Currency' and the foreign currency then this will be blank and the message "A valid exchange does not exist between [ReceiptCurrencyID] and [HomeCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Currency Conversion

This field is used to convert the transaction total 'Receipt Amount' to the 'Home Currency' amount.

This is a non-editable text box that displays the currencies on the 'Exchange Table' being used to convert the 'Receipt Amount' to the 'Home Currency' amount. This is formatted as: "From [Receipt Currency] to [Home Currency]". This is only displayed and required when the Receipt's currency is not in the 'Home Currency'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Home Currency Amount

This field is used to convert the transaction total 'Receipt Amount' to the 'Home Currency' amount.

This is a non-editable text box that displays the Receipt Amount converted to the Home Currency. This is only displayed and required when the Receipt's currency is not in the 'Home Currency'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

is a non-editable text box that is system generated, required and is not editable.

Linked Database Field:

ERPx_ARTransactionHeader.TransactionHeaderSK

Versions Compared

Old Version 3

New Version 4

Key

Related Topics

Page Definitions