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 Fisherman 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: YYYY2024.MM04.DD 19 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apply Documents | Opens the Apply Documents windowthe Apply Fishing Transactions record view allowing the user to apply this receipt to one or more open transactions. The Apply Documents button is disabled when the Receipt'Amount' field is 0 and other required fields are not completed. | |||||||||||||||||
Delete |
If a Payment Receipt that has been fully or partially applied is deleted (prior to posting), all applications will be automatically removed. | |||||||||||||||||
Grid Layout |
| |||||||||||||||||
Help |
| |||||||||||||||||
Journal Details |
The Journal Details Window for this transaction will include:
| |||||||||||||||||
New |
| Notes | Insert excerpt | Notes - Global | Notes - Global | nopanel | true |
| ||||||||||
| ||||||||||||||||||
Save |
|
...
Fields | Description | ||||||||||||||||||||||||||||||||||
Amount | A text box to enter Identifies the dollar amount of the payment you received in the 'Currency' you specifiedreceived. This is a text box that is required. 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' fieldsRemaining' field. Linked Database Field: ERPx_ARTransactionHeaderAPTransactionHeader.ExtendedAmount | ||||||||||||||||||||||||||||||||||
Applied Amt. | 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 | A single-select standard lookup to select which checkbook the receipt will be deposited intoCheckbook | 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 :
This is required to Approve and/or Post, or to open the Apply Fishing Transactions list view. This field is enabled and only editable while the transaction Status is "New" .
The lookup contains a list of all the 'Active' Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK | Comment | A text box to enter a comment. Checkbooks where the Currency is USD. Database Fields: ERPx_MFCheckbook.CheckbookID, ERPx_APTransactionHeader.CheckbookSK | |||||||||||||||||||||||||||||||
Description | Identifies the description associated with the payment receipt. This is a text box where users can enter a comment for the associated receipt but is not required. If entered, it must be <= 60 characters. This defaults to blank and is not required. This field is only editable after a 'Customer' has been selected but remains always editable, even after the transaction is posted. This must be <= 60 characters.Linked Database Field: ERPx_ARTransactionHeaderAPTransactionHeader.Description | ||||||||||||||||||||||||||||||||||
Currency | 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. 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:
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 editedPayment # | Identifies the number of the payment received, most often associated with the Check #. This is a text box that is not required. If entered, the value must be <= 50 characters. This defaults to blank and is always editable, even after the transaction is posted. If the same combination of Received From, Receipt Type and Payment # exist on an open or Posted Payment Receipt, the message "Duplicate Payment Receipts are not allowed. Payment # [Payment#] on [TransNumber] was keyed on [ReceiptDate] for this account." will be displayed on Save. If the same combination of Received From and Payment # exist on an open or Posted Payment Receipt but with a different Receipt Type, the message "Potential Duplicate Transaction. [ReceiptType] Receipt with Payment # [Payment#] on [TransNumber] was keyed on [ReceiptDate] for this account." will be displayed on Save as a warning that it might be a duplicate but this will not prevent the data from saving. Database Field: ERPx_APTransactionHeader.DocNumber | |||||||||||||||||||||||||||||||||
Received From |
Received From is required." will be displayed . | Receipt Date | A date field to enter the date the Receipt was actually received. This defaults to the current date and 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' 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 | ||||||||||||||||||||||||||||||||||
Fishermen, Fishermen & Tenders, and Tenders and Loans that have not been excluded from the "Cash Receipt" Transaction on the 'Excluded Transaction' tab of the Fisherman & Tender Record View. Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK | |||||||||||||||||||||||||||||||||||
Receipt Date | Identifies the date the receipt was received. This is a date picker that defaults to the current date. It is required to Approve and/or Post or to open the 'Apply Documents' window Apply Fishing Transactions list view. If not, the message "Receipt Date is required." will will be displayed. This field is only editable while the transaction Status is "New" but and is disabled once an application for this receipt has been made. 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' after an application has been made, you must unapply all the transactions that are currently applied. Linked Database Field: ERPx_ARTransactionHeaderAPTransactionHeader.TransactionDate | ||||||||||||||||||||||||||||||||||
Receipt Type | A Identifies the type of the receipt. This is 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 defaults to "Check". 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. Linked Database Field: ERPx_ARTransactionHeader.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.TransactionStatusSK | ||||||||||||||||||||||||||||||||||
Unapplied Amt. | A non-editable text box to identify how much of the Receipt still needs to be applied. This If the same combination of Received From, Receipt Type and Payment # exist on an open or Posted Payment Receipt, the message "Duplicate Payment Receipts are not allowed. Payment # [Payment#] on [TransNumber] was keyed on [ReceiptDate] for this account." will be displayed on Save. If the same combination of Received From and Payment # exist on an open or Posted Payment Receipt but with a different Receipt Type, the message "Potential Duplicate Transaction. [ReceiptType] Receipt with Payment # [Payment#] on [TransNumber] was keyed on [ReceiptDate] for this account." will be displayed on Save as a warning that it might be a duplicate but this will not prevent the data from saving. Database Field: ERPx_APTransactionHeader.CashReceiptTypeEN | ||||||||||||||||||||||||||||||||||
Remaining | 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>= 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
The fields sorted at the bottom of this section, prefixed with "MC:" are only visible on multi-currency payment receipt transactions.
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
Linked Database Field: ERPx_ARTransactionHeader.CheckbookSK
Linked Database Field: ERPx_ARTransactionHeader.CreatedDate
Linked Database Field: ERPx_ARTransactionHeader.CreatedBy
Linked Database Field: ERPx_ARTransactionHeader.CustomerSK
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
Linked Database Field: ERPx_ARTransactionHeader.LastUpdated
Linked Database Field: ERPx_ARTransactionHeader.LastUser
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
Linked Database Field: ERPx_ARTransactionHeader.TransactionID
Linked Database Field: ERPx_ARTransactionHeader.TransactionHeaderSK
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.
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.
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.
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.
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.stored in the database. | |||||||||||||||||||||||||||||||||||||||||
Status |
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
...