Viewing customer balance

This page allows you to view the balance of the customer. You can enter the code identifying the supplier if you are aware of it. Otherwise, you can search for the supplier details based on the finance book to which the transactions are posted, the type of credit document, the currency in which the payment is made, the amount due and the date on which the payment is due.

Select the “View Customer Balance” link present under the “Supplier Payment” business component.

The “View Customer Balance” page appears.

Enter the following field:

Supplier #	The code identifying the supplier to whom the payment is made (Alphanumeric, 18). Mandatory.
	Help facility available.

The system displays the following:

Supplier Name	The name of the supplier.
Customer #	The code identifying the customer.
Customer Name	The name of the customer.

Enter the following field:

Currency

Use the drop-down list box to select the code identifying the currency in which the payment is made. All the currencies defined in the “Customer Receivables Account” are available for selection. The system displays “Blank” by default on launch of the page.

The system displays the following:

Customer Balance

The amount due from the customer.

Enter the following fields in the “Search Criteria” group box:

Finance Book	Use the drop-down list box to select the code identifying the finance book to which the transactions are posted. All the finance books that have been mapped to the login organization unit are available for selection in ascending order if postings can be made in multiple finance books. If postings can be made in a single finance book, the book that has been set as default in the “Set Function Defaults” activity of this business component will be displayed.
Document Type	Use the drop-down list box to select the type of credit documents. You can select from “Direct Invoice”, “Order Based Invoice”, “Prepayment Invoice”, “Debit Note”, “Customer Payment” or “All”.
	Order Based Invoice - indicates that the payment made to the supplier is based on an order based invoice or a repair invoice.
	Prepayment Invoice – indicates that the payment made to the supplier is based on a prepayment invoice.
	Direct Invoice – indicates that the payment made to the supplier is based on a direct invoice
	Debit Note – indicates that the payment made to the supplier is based on a debit note
	Customer Payment – indicates that the payment made to the customer
	All – indicates all the above options.
	The system displays “All” by default on launch of the page.
Currency	Use the drop-down list box to select the code identifying the currency in which the payment is made. All the currencies defined in the “Customer Receivables Account” are available for selection. The system displays “All” by default on launch of the page.
Due Amount From	The starting amount in the range of amounts that is due for payment (Decimal). The value entered in this field should be greater than zero.

Note: The value entered in this field should be less than the value entered in the “To” field.

To	The ending amount in the range of amounts that is due for payment (Decimal). The value entered in this field should be greater than zero.
Due Date From	The starting date in the range of dates on which the payment is due (Date Format). The value entered in this field must be earlier than the system date and the date specified in the “To” field. The system date is displayed by default on launch of the page.
To	The ending date in the range of dates on which the payment is due (Date Format). The value entered in this field must be earlier than the system date. The system date is displayed by default on launch of the page.
Overdue Days From	The starting date in the range of dates on which the payment is overdue (Date Format). The value entered in this field must be earlier than the system date and the date specified in the “To” field.
To	The ending date in the range of dates on which the payment is overdue (Date Format). The value entered in this field must be earlier than the system date.

Click the “Get Documents” pushbutton to retrieve the search results.

The system retrieves the results based on the search criteria and the is displayed in the “Document Information” multiline:

Document Type	The type of document based on which the payment is made.
Document #	The number identifying the document based on which the payment is made.
Term #	The number identifying the pay term.
Currency	The code identifying the currency in which the payment is made.
Due Date	The date on which payment is due.
Outstanding (Tran Amount)	The amount due in transaction currency.
Outstanding (Base Amount)	The amount due in base currency.
Finance Book	The finance book to which the transactions are posted.