This page allows you to set a criterion to generate the customer statement. A customer statement is generated for a customer when requested. Tell me more
Select the “Customer Statement” link under the “Reports – Receivable Management” business component.
The “Customer Statement” page appears.
Enter the following fields in the “Search Criteria” group box:
Company Code |
Use the drop-down list box to select the code identifying the company in which the customer has been defined. The company mapped to the Login OU will be available for selection. |
Finance Book |
Use the drop-down list box to specify the finance book of the customer. |
Customer Group |
Use the drop-down list box to select the customer group from which you want to retrieve. The system displays All by default on launch of the page. |
Customer Code From |
The starting code in the range of codes identifying customers for whom you want to view a statement (Alphanumeric, 18). Mandatory. |
|
Help facility available |
Customer Code To |
The ending code in the range of codes identifying the customers for whom you want to view a statement (Alphanumeric, 18). Mandatory. |
|
Help facility available |
Report Type |
Use the drop-down list box to specify the type of report to be generated. The combo is loaded with options “Summary” and “Details”. |
Currency Option |
Use the drop-down list box to select the currency in which you want to view the customer statement. The values" Transaction", "Base" and "Parallel Base" will be available for selection. The system displays Transaction by default on launch of the page. |
As On date |
The date for which you want to view the Customer statement report. The system displays system date by default on launch of page |
Language |
Use the drop-down list box to select the language in which you want to view the customer statement. The system displays “English” by default on launch of the page. |
Include Fully Adjusted Documents |
Use the drop-down list box to specify whether you want to include the fully adjusted document details in the Customer Statement report. You can select from “Yes” or “No”. The system displays “Yes” by default on the launch of the page. |
Include Account Code |
Use the drop-down list box to specify whether you want to include the account code of the customer in the Customer Statement report. You can select from “Yes” or “No”. The system displays “Yes” by default on the launch of the page. |
Include Deposits |
Use the drop-down list box to specify whether you want to include the deposit account details in the Customer Statement report. You can select from “Yes” or “No”. The system displays “Yes” by default on the launch of the page. |
Include Post Dated Receipts/Payments |
Check the box to include the Post Dated Transactions |
Note: When the ‘Include Post dated Receipts' check box is checked, all the Overdue unprocessed and Post Dated Transactions with the instrument date greater than the ‘As on Date’ will be considered for the report.
When the ‘Include Post Dated Receipt' check box is not checked then overdue unprocessed post dated documents with instrument date as equal to or earlier than the As on date as well as Post Dated Transactions with instrument Date greater than the ‘As on Date’ will not be considered in the report.
Display Sales Person Wise |
Use the drop down list box to select whether the report to be launched with sales person wise or not. |
Sales Person Code From |
The starting range of the Sales Person from which the report to be launched Help facility available |
Sales Person Code To |
The Ending range of the Sales Person until which the report to be launched Help facility available |
Note: The controls “Sales Person Code From and To” are visible only when the "Display Sales Person Wise" is selected as "Yes".
Click the “View Customer Statement” pushbutton to view the report
The system generates and displays the customer statement based on the search criteria entered. This report can be printed. If you have opted for a detailed report, you can view the details of the customer, the document details, the outstanding amount, the due date, the instrument details, the opening balance and the balance due from the customer or due from the company to the customer. If you have opted for a summary of the report, you can view the opening and closing balance of the customer, the billing, receipt, advance, deposit and the unadjusted receipt amount.
Customer Statement – An overview
This statement contains the details of all the transactions that have taken place between the company and the customer for a period of time. This period of time could be a financial year, a calendar year or date range. This statement would also contain the opening and closing balances of the customer for the date range. If required a summary of the statement can also be generated.
You can set the criterion by specifying the status of the customer for whom you want to generate the statement and the period of time for which the statement is to be generated. You can also select the type of report that you want view and the currency in which you want to view the report. The system generates the report based on the selected criterion. Based on the type of report that you want to view the system retrieves and displays the details of the customer, document details, the outstanding amount, the due date, the instrument details, the opening balance and the balance due from the customer or due from the company to the customer. You can also view the opening and closing balance of the customer, the billing, receipt, advance, deposit and the unadjusted receipt amount.