Make the following menu selections to display this grid:
eFinancials—Accounts Receivable—Transactions—Unapplied Cash
Use this grid to apply Unapplied Cash.
Fields Lists
A red dot indicates a required field or selection.
Header
Customer
The customer identification. Use the lookup to select a Customer. This is a required field.
Bank Account
The bank account. Use the lookup to select a Bank Account. This is a required field.
You can remove the default Bank Account from the field to see Unapplied Cash for the selected Customer from other banks.
Include Approved Receipts
Select this option if you want to see Receipts in the grid that contain transactions that have been approved.
Grid
Notes
Clicking on a column label allows you to sort the grid by that column.
Filter Buttons in column headers allow you to change what appears in the grid.
Grid pagination controls at the bottom of the grid can help you to locate a receipt with unapplied cash.
Apply link
Select the Apply link to apply the unapplied cash for that Receipt. The Unapplied Cash form appears. Refer to Fields list for more information.
Receipt ID
The receipt identification that appears on lists and in reports.
Date
The date of the receipt that appears on lists and in reports.
Status
The status of the Receipt that appears on lists and in reports.
Original Unapplied Cash Amount
The original amount of cash that has not been applied to a Billing and is being held until a decision is made about how to apply the funds using this Unapplied Cash menu item.
Remaining Amount
The remaining amount of Unapplied Cash for this Receipt. Unapplied Cash for a Receipt can be applied in increments.
Description
The description of the Receipt that appears on lists and in reports.
Documents
One of the following icons appears in this column:
No documents are currently stored for the invoice. Click the icon to upload documents for the invoice.
At least one document is currently stored for the invoice. Rest your mouse pointer on the icon to see the number of documents stored. Click the icon to view, add, or delete documents.
For more information, refer to the Documents Tab instructions.
Footer
Company | BatchEntity | Property | Batch (Footer Links)
Make changes using the Footer Links to use the appropriate combination of Company and Batch. The Receipts with Unapplied Cash for that batch appear in the grid.
Make changes using the Footer Links to select the appropriate combination of Entity, Property, and Batch. The Receipts with Unapplied Cash for that batch appear in the grid.
Unapplied Cash Form - General Information Fields
Customer ID
The customer identification, which is the same as the source of the Unapplied Cash.
Bank Account ID
The bank account ID, which is the same as the source of the Unapplied Cash.
Job
The Job associated with the Receipt. Click the lookup to select a Job from the Select Job pop-up
Select a Job to filter the Receipts to only show Receipts that contain a line item pointing to that Job. The Job field is restricted to Jobs that exist within the current EntityCompany.
Receipt Date
Defaults to the current system date. Enter the date for the transaction using the electronic calendar to select a date.
This date is used to calculate discounts. When the Receipt date changes, discounts are recalculated and the discount amounts and extended amounts may be updated.
Accounting Date
Defaults to the current system date. Enter the accounting date for the transaction using the electronic calendar to select a date.
Description
A user-entered description for the Unapplied Cash that appears on lists and in reports (up to 40 characters).
Reference/Receipt #
Enter a reference number for the Unapplied Cash, if desired.
Unapplied Cash Amount
The system-calculated amount of Unapplied Cash for this Receipt.
Amount
The amount you are applying. When you change the amount, the Remaining Amount to Enter field does not change if you use the Allocate button next to the field. See Allocate button description.
Allocate button
Click the button and the system allocates the value in the Amount field from top down for all billings in the grid. The Receipt Amount in the grid changes, however.
NOTE that there is an Allocate button in the grid that works differently. Refer to Grid Fields, below, for details.
Total Amount Entered
The system-calculated sum of the values in the billing row Receipt Amount fields. This amount cannot exceed the amount in the Unapplied Cash. Amount field.
Remaining Amount to Enter
The difference between the Amount field and the Receipt Amount field in the grid.
Force Discount
When this box is checked, any possible discount is applied to the amounts. This option disregards the Discount Due Date fields.
About Billing Grid Fields
Each row in the grid constitutes a Billing. There are multiple ways to assign Unapplied Cash amounts to Billings. You can enter amount on just the Billing level, or you can expand the Billing to enter amounts on the Billing details.
Restrictions on entering amounts in main grid:
Refer to field descriptions for the Allocate button as well.
If you click the Allocate button on the top of the form, the system allocates that amount from top down for all billings in the grid.
If you click the Allocate button on the billing row, and the amount is zero, the amount changes to the extended amount, and the sub grid becomes populated from top down with that amount.
If you click the Allocate button on a billing row where the amount is non-zero, that amount will be used to allocate instead of the extended amount.
Fields
Billing ID
The Billing identification that appears on lists and in reports.
Due
The Billing due date.
Discount Due
The date that the Billing must be paid in order to receive a discount.
Billing
The transaction date of the Billing.
Billing Amount
The amount of the Billing.
Tax
The amount of tax due on the Billing.
Remaining
The system-calculated amount remaining on the Billing.
Discount
The amount of any discount applicable to the Billing. Changing the Receipt Date in the header may cause the discount amount to be updated.
Extended Amount
The system-calculated extended amount. Changing the Receipt Date in the header may cause the Extended Amount to be updated.
Receipt Amount
The receipt amount for the Billing. Enter the amount to be allocated using the Allocate button in the grid.
Allocate button
If you click the Allocate button on the Billing row, and the amount is zero, the amount changes to the extended amount, and the sub grid becomes populated from top down with that amount.
If you click the Allocate button on a Billing row where the amount is non-zero, that amount will be used to allocate instead of the extended amount.
Receipt Form - Sub Grid Fields
Click the arrow for a row to see the detail lines for the Billing. When a Billing row has been expanded to show the sub grid, the amounts in the sub grid must add up to the amount on the Billing row.
Seq No
System-generated sequential number that identifies a transaction. You cannot edit this field.
Description
The read-only billing description.
Billing Amount
The read-only Billing amount.
Tax
The read-only tax amount for the Billing.
Remaining
The system calculated amount remaining to be paid for the Billing.
Discount
The system calculated discount amount associated with the Billing, if any.
Extended Amount
The system calculated extended amount for the Billing.
Receipt Amount
The amount of the receipt to be allocated to this line.
PropertyCompany
The PropertyCompany associated with the Billing.
Job Information
The Job identification associated with the Billing appears if the Track Jobs option is being used.
Procedures
Additional Information
Permissions must be set in the System module to access all Unapplied Cash activities.
Permissions for Unapplied Cash
System module—Security—Users—eFinancials—Accounts Receivable—Unapplied Cash
See Also
Accounts Receivable Introduction
Copyright © 2018 Infor. All rights reserved. www.infor.com.