Field Descriptions

Table Information

 

Cash Receipt Detail

What can I do in this subtask?

Use this subtask to view the detail of the cash receipts that were applied against customer invoices. You can view all of the detailed activity information about a cash receipt and its relationship to the payments made on that invoice. This detail is located in the AR_DETL_HS table, which is updated when you post the Billing Journal and the Cash Receipts Journal. You can maintain the AR_DETL_HS table in the Initialize A/R History screen (Accounting\Utilities\Transaction History).

All fields in this subtask are non-editable.

When should I use this subtask?

Use this subtask to view the cash receipt detail posted against customer invoices. This information may be helpful if you have projects that use Pay When Paid functionality. Using this functionality means that you will not pay vendors until the costs on their vouchers have been invoiced and paid by customers.

Field Descriptions

Invoice Number

This field displays the invoice number of the row that was selected when you opened the Invoice Detail subtask. All detail information in the table window relates to the displayed invoice number.

Customer Account

This field displays the customer account of the row that was selected when you opened the Invoice Detail subtask. All detail information in the table window relates to the displayed customer account ID.

Customer Name

This field displays the customer name of the row that was selected when you opened the Invoice Detail subtask. All detail information in the table window relates to the displayed customer name.

Receipt Amount

This non-editable field displays the total of all the cash receipts in the table window stated in the pay currency of the customer.

Discount Taken

This non-editable field displays the total of all discounts taken by the client in payment of the invoice number displayed in the header. The value in the Discount Taken field is stated in the transaction currency of the customer.

Finance Charge

This non-editable field displays the total amount of finance charges assessed on the invoice number displayed in the main screen.

In order to include finance charge information on your invoices, you must have your customers set up to compute finance charges in the Credit Info tab of the Customers screen (Accounting\Maintain Customers). You must also have set up the Compute Finance Charges screen.

The system will apply finance charges to all eligible invoices based on the information you entered in the Credit Info tab for the customer, the customer terms, and the age of the customer invoices.

This field is stated in the transaction currency of the customer.

Realized Gain

This non-editable field displays the total amount of realized gains on the invoice number displayed in the main screen.

The system computes realized gains when you enter cash receipts and the pay currency of the customer is different from the functional currency of the company. A realized gain results when the functional to pay currency exchange rate is greater than the functional to billing (transaction) currency exchange rate in the A/R history tables.

Realized Loss

This non-editable field displays the total amount of realized losses on the invoice number displayed in the main screen.

The system computes realized losses when you enter cash receipts and the pay currency of the customer is different from the functional currency of the company. A realized loss results when the functional to pay currency exchange rate is less than the functional to billing (transaction) currency exchange rate in the A/R history tables.

Table Window

Func Discount Taken

This field displays the discount taken by the client in payment of this invoice expressed in terms of your company's functional currency.

You enter discounts at the time you enter cash receipts.

Func Finance Chg Rcvd

This field displays the finance charge received for this invoice when the invoice was paid in the Enter Cash Receipts screen (Accounting\Transactions\Cash Receipts).

This field is expressed in terms of your company's functional currency.

Pay Discount Taken

This field displays the discount taken in payment of this invoice when you entered the cash receipt.

This field is expressed in terms of your customer's pay currency.

Pay Finance Chg Rcvd

This field displays the finance charge received in payment of this invoice when you entered the cash receipt.

This field is expressed in terms of your customer's pay currency.

Func Receipt Amt

This field displays the amount paid on this invoice when you entered the cash receipt.   

This field is expressed in terms of your company's functional currency.

Receipt Amount

This field displays the amount paid on this invoice when you entered the cash receipt.

This field is expressed in terms of the pay currency of the customer.

Realized Gain Amt

This non-editable field displays the total amount of realized gains on the invoice number displayed in the main screen. The system computes realized gains when you enter cash receipts and the pay currency of the customer is different from the functional currency of the company.

A realized gain results when the pay currency of the customer to the functional currency exchange rate is greater than the transaction currency to functional currency exchange rate in the A/R history tables.

Realized Loss Amt

This non-editable field displays the total amount of realized losses on the invoice number displayed in the main screen. The system computes realized losses when you enter cash receipts and the pay currency of the customer is different from the functional currency of the company.

A realized loss results when the pay currency of the customer to the functional currency exchange rate is less than the transaction currency to functional currency exchange rate in the A/R history tables.

Discount Taken

This field displays the discount taken by the client in payment of this invoice.

This field is expressed in terms of the pay currency of the customer.

Pay Receipt Amt

This field displays the amount received on this invoice, when you entered the cash receipt.

This field is expressed in terms of the pay currency of the customer.

Check Number

This field displays the check number that was recorded in payment of this invoice when the cash receipt was entered.

Finance Charge Rcvd

This field displays the finance charge received against this invoice when you entered cash receipts.

This field is stated in terms of the functional currency of your company.

Receipt Date

This field displays the date you entered in the Enter Cash Receipts screen (Accounting\Transactions\Cash Receipts) for payment of this invoice.

Fiscal Year

This field displays the fiscal year you entered in the Period to Post groupbox of the Enter Cash Receipts screen (Accounting\Transactions\Cash Receipts).

The fiscal year entered determines the fiscal year into which the cash receipt will post.

Period

This field displays the period you entered in the Period to Post groupbox of the Enter Cash Receipts screen (Accounting\Transactions\Cash Receipts.)

The period entered determines the period into which the cash receipt will post.

Subperiod

This field displays the subperiod you entered in the Period to Post groupbox of the Enter Cash Receipts screen (Accounting\Transactions\Cash Receipts.)

The subperiod entered determines the subperiod into which the cash receipt will post.

Receipt Number

This field displays the cash receipt number for the monies received.

The cash receipt number is assigned by the system when the cash receipt is saved and cannot be changed.

You can view the last cash receipt assigned in the Set System Assigned Cash Receipt Number screen. You can change the last-assigned number in this screen, so that when the next cash receipt is assigned in the same fiscal year/period/subperiod, the system will increment the last assigned number by one.

Posting Seq No

This field displays the posting sequence used when this receipt was posted.

The system assigns a unique posting sequence number with each period when you print and post cash receipts.

Entry User ID

This field displays the entry user ID of the person who originally entered this transaction.

Entry Date

This field displays the system date used when you entered the cash receipt.

Account

This field displays the accounts receivable account to which the cash receipt was posted.

If the cash receipt was entered against a project invoice, the accounts receivable account is the account in the Project Account Group linked to the invoice project where the function code is "Billed A/R."

If the cash receipt was not applied to a project invoice, the accounts receivable account used is the account linked to the Transaction Type of "Customer Receivable Account" in the Default Accounts tab of the Customers screen (Accounting\Maintain\Customers).

If there are no lines in that tab, the account used is the account linked to the "Dflt Receivables Account" Transaction Type in the A/R Settings screen (Administration\Configure\Accounting).

Bank Deposit No

This field displays the receipt deposit number you assigned when entering the cash receipt.

This is not a required field when entering cash receipts.

Organization

This field displays the accounts receivable organization to which you posted the cash receipt.

If you entered the cash receipt against a project invoice, the accounts receivable organization is the owing organization of the invoice project.

If the cash receipt was not applied to a project invoice, the accounts receivable organization used is the organization linked to the "Customer Receivable Account" Transaction Type in the Default Accounts tab of the Customers screen (Accounting\Maintain\Customers).

If there are no lines in that tab, the organization used is the organization linked to the "Dflt Receivables Account" Transaction Type in the A/R Settings screen (Administration\Configure\Accounting).

Document Location

When you enter a cash receipt, you can link a scanned document to the cash receipt. You can maintain file locations by using the Alternate File Locations screen (Administration\Maintain\Files).

This field displays the alternate file location of the document that contains supporting data for the cash receipt.

Project

This field displays the project to which the cash receipt was posted.

This field contains a project only if the cash receipt was posted against an invoice that was posted to a project. The project number displayed is the project level at which the invoice was previously posted.

Ref 1

This field displays the reference 1 number to which this cash receipt was posted, if reference numbers are used in data entry.

If the cash receipt is posted against an invoice that was posted to a project, reference numbers will be used if ref 1 is linked to the A/R billed account from the PAG (Project Account Group) in the Project/Account/Organization Links screen (Projects\Maintain\Project). The project must be set up to validate by project/account/organization.

If the cash receipt is not applied to a project invoice, a Ref 1 value will be used if it is linked to the Transaction Type of "Customer Receivable Account"in the Default Accounts subtask of the Customers screen (Accounting\Maintain\Customers).

If there are no lines in that subtask, a Ref 1 value will be used if it is linked to the Transaction Type of "Dflt Receivables Account"in the A/R Settings screen (Administration\Configure\Accounting).

Ref 2

This field displays the reference 2 number to which this cash receipt was posted, if reference numbers are used in data entry.

If the cash receipt is posted against an invoice that was posted to a project, reference numbers will be used if ref 2 is linked to the A/R billed account from the PAG (Project Account Group) in the Project/Account/Organization Links screen (Projects\Maintain\Project.) The project must be set up to validate by project/account/organization.

If the cash receipt is not applied to a project invoice, a Ref 2 value will be used if it is linked to the Transaction Type of "Customer Receivable Account"in the Default Accounts subtask of the Customer screen (Accounting\Maintain\Customers).

If there are no lines in that subtask, a Ref 2 value will be used if it is linked to the Transaction Type of "Dflt Receivables Account"in the A/R Settings screen (Administration\Configure\Accounting).

Exchange Rates

Select this pushbutton to open the Exchange Rates subtask.

Table Information

This subtask accesses the CASH_RECPT_HDR_HS (Cash Receipt Header History) and the CASH_RECPT_TRN_HS (Cash Receipt Transaction History)  tables.

Top of Page