Versions Compared

Key

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

The purpose of the Cash 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 is are updated and the receipt becomes available to the Checkbook Deposit transaction. Cash Payment Receipts make a journal entry when the they are posted.

Software Version: YYYY2020.MM01.DD 13 and newer

Table of Contents
typeflat

Page Header

Header Toolbar

Opens the Journal Details window showing the Journal Entry for this transaction. Until the transaction is posted, this is a temporary journal entry so no Journal ID will be assigned.
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.
DeletePrompts the user, Are you sure you wish to delete the transaction? OK or Cancel. Selecting OK - Deletes the transaction, selecting Cancel, cancels the delete.Grid LayoutOpens the Saved Grid Layout dialog.Journal Details

Insert excerpt
Delete - LV
Delete - LV
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 - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Journal Details

Insert excerpt
Journal Details - RV Header
Journal Details - RV Header
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
NewAllow user to add a new AR Cash Receipt Transaction.NotesOpens the Notes window filtered for the appropriate Note Type(s).PrintOpens print window showing any applicable printable reports.SaveSaves the transaction.
Insert excerpt
New - RV Header
New - RV Header
nopaneltrue
Notes

Insert excerpt
Notes - Global
Notes - Global
nopaneltrue

Print
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue
Save
Insert excerpt
Save - RV Header
Save - RV Header
nopaneltrue

Home Tab

FieldsDescription
Amount

A text box

used

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

Applied Amt.A label used 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 identify select which checkbook the receipt will be deposited into.  If a checkbook has been assigned to the Customer, this defaults from the customer (once the 'Received From' customer has been assigned), otherwise it defaults from the checkbook assigned to the "Default Cash Receipt Checkbook" Sales Preference. This is required to 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 once the 'Received Fromafter a 'Customer' has been assigned 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 no applications for this receipt have been made. 

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

Linked Database Field: ERPx_#####ARTransactionHeader.#####.CheckbookSK

Comment

A text box

used

to enter a comment. This defaults to blank and is not required. This field is

always

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 identify assign the currency of the Receipt. This defaults from the customer currency 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 enabled once the 'Received Fromonly editable after a 'Customer' has been assigned selected and while the transaction the transaction Status is "New" but is disabled once an application and no applications for this receipt has been madehave 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 Receipt Currency is not in the Home Currency, the Receipt Currency must match the Checkbook CurrencyIf the Receipt Currency does not match the Checkbook Currency, NorthScope must be able to assign a valid Exchange Table and Exchange Rate 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.#####.CurrencySK

Payment #Customer

A

text box used to enter the Check# / Payment# of the payment you received. This

single-select load on demand lookup to select the Customer you received the payment from. This defaults to blank but

must be filled in to Approve and/or Post

is required before anything other than the 'Receipt Date' can be edited. If not assigned, the message "

Payment #

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, including the customer accounts that are on hold, displayed

. This

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. This must be <= 50 characters.

Linked Database Field: ERPx_

#####

ARTransactionHeader.

#####.

DocNumber

Receipt Date

A date field

used

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.

#####.

TransactionDate

Receipt Type

A single-select standard lookup to identify 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 while the transaction 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  

Linked Database Field: ERPx_#####ARTransactionHeader.#####.CashReceiptTypeEN

Received From

A single-select load on demand lookup to identify the Customer you received the payment from. This defaults to blank. This is required before any other data entry can be done. If not assigned, the message "Received From is required" will be displayed. This field is disabled once it has been assigned..

The lookup contains the list of all 'Active' customers displayed as Customer Name (Customer ID). Linked Database Field: ERPx_#####.#####.

StatusStatus

Changing this value will re-assign the Checkbook and the receipt currency.A single-select standard lookup to identify 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 label used 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

The fields sorted at the bottom of this section, prefixed with "MC:" are only visible on multi-currency payment receipt transactions.

FieldsDescription
Checkbook Currency

A

label used

non-editable text box to identify the Currency

of

ID for the currency assigned to the Checkbook. Receipts cannot be posted if this value is missing.

This is a looked-up value and is never editable by a user. Linked

Linked Database Field: ERPx_

#####.#####.

MFCheckbook.CurrencySK

CheckbookSK

Insert excerpt
CheckbookSK

A label used to identify the SK value of the Checkbook. This is a looked-up value, that is primarily used for support, and is never editable by a user.

- RV
CheckbookSK - RV
nopaneltrue

Linked Database Field: ERPx_

#####.#####.
CreatedA label used to identify the Created Date/Time of the Transaction. This is a system assigned value and is never editable by a user.

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

A label used to identify the name of the user that created the Transaction. This is a system assigned value and is never editable by a user.

- RV
nopaneltrue
 

Linked Database Field: ERPx_

#####.#####.

ARTransactionHeader.CreatedBy

CustomerSK

Insert excerpt
CustomerSK

A label used to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support, and is never editable by a user.

- RV
CustomerSK - RV
nopaneltrue

Linked Database Field: ERPx_

#####.#####.

ARTransactionHeader.CustomerSK

GL Date

Insert excerpt
GL Date - RV
GL Date

A date field used to enter the date the transaction will post to the General Ledger. This defaults to blank and is set to the Transaction 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.
If a user manually sets this value then it is not overwritten on Approve/Ready to Post. This date must be a valid date that falls within an open fiscal period
  • 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, "

Receipt Date is required

The Fiscal Period is not open." 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.

on Save.

Linked Database Field: ERPx_

#####

ARTransactionHeader.

#####.

GLDate

Last UpdatedA label used to identify the Last Updated Date/Time of the Transaction. This is a system assigned value and is never editable by a user.

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

A label used to identify the name of the user that last updated the Transaction. This is a system assigned value and is never editable by a user.

- RV
nopaneltrue
 

Linked Database Field: ERPx_

#####

ARTransactionHeader.

#####.

LastUser

Receipt Currency

A

label used

non-editable text box to identify the

Currency

currency of the

Receipt

receipt. Receipts may not always be in the same currency as the Checkbook.

This comes from the value assigned on Home tab and is not editable from here. Linked

Linked Database Field: ERPx_

#####.#####.

ARTransactionHeader.CurrencySK

Transaction ID

Insert excerpt
Transaction ID

A label used to identify the Transaction. This is a system assigned value that is not editable by a user. Linked

- RV
Transaction ID - RV
nopaneltrue

Linked Database Field: ERPx_

#####

ARTransactionHeader.

#####.

TransactionID

TransactionSKA label used to identify the SK value of the Transaction.

Insert excerpt
Transaction SK
Transaction SK
nopaneltrue
 This is a looked-up value, that is primarily used for support

, and is never editable by a user.

.

Linked Database Field: ERPx_

#####

ARTransactionHeader.

#####.

TransactionHeaderSK

MC: Exchange Date FromA date

This field is used

to show the 'Start Date' of the 'Exchange Rate' from the Exchange Table assigned to this transaction. The exchange Rate is looked-up based on the Transaction Date, not the GL Date. This field is only visible when the 'Receipt Currency' is not in the Home Currency.  This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####.
MC: Exchange Date ToA date field used to show the 'End Date' of the 'Exchange Rate' from the Exchange Table assigned to this transaction. The exchange Rate is looked-up based on the Transaction Date, not the GL Date. This field is only visible when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####.
MC: Exchange RateA 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 when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####.
MC: Exchange Rate Calculation MethodA label to show the 'Calculation Method' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####.
MC: Exchange TableA label to show the Exchange Table assigned to this transaction. This field is only visible when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. ***How is this assigned?***
MC: From CurrencyA label to show the 'From Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####.
MC: To CurrencyA label to show the 'To Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####

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.

Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details