|
|
|
This page allows you to carry out a search to generate a report containing the adjustment details. Tell me more
Select the “Customer Balance Adjustment” link under the “Reports – Receivable Management” business component.
The “Customer Balance Adjustment” 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 for which you want to view the customer balance adjustment report. All the companies that are in the “Active” status and have been mapped to the login organization unit will be available for selection. |
|
Business Unit |
Use the drop-down list box to select the code identifying the business unit for which you want to view the customer balance adjustment report. All the business units that are in the “Active” status and have been mapped to the login organization unit will be available for selection. |
|
Finance Book |
Use the drop-down list box to select the code identifying the finance book for which you want to view the customer balance adjustment report. All the finance books that have been mapped to the login organization units of the selected business unit will be available for selection. The system displays “All” by default on launch of the page. |
|
Adjustment Point From |
Use the drop-down list box to select the code identifying the organization unit in which the adjustment business component has been deployed. All the organization units in which the “Customer Balance Adjustment” business component has been deployed and that have been mapped to the login organization unit will be available for selection. |
|
To |
Use the drop-down list box to select the code identifying the organization unit in which the adjustment business component has been deployed. All the organization units in which the “Customer Balance Adjustment” business component has been deployed and that have been mapped to the login organization unit will be available for selection. |
|
Customer Code From |
The starting code in the range of customer codes for whom you want to generate a balance adjustment report (Alphanumeric, 18). You can enter the code in full or specify it partially using the “*” character. The system retrieves the details of all the adjustments that have been made for the customer. |
Note: The code entered in this field must be before the code entered in the “To” field.
|
To |
The ending code in the range of customer codes for whom you want to generate a balance adjustment report (Alphanumeric, 18). You can enter the code in full or specify it partially using the “*” character. The system retrieves the details of all the adjustments that have been made for the customer. |
|
Voucher No From |
The starting number in the range of voucher numbers that have been created during adjustment of customer documents and that you want to retrieve in the report (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves the details of all the vouchers that are similar to the value entered in this field. |
Note: The voucher number entered in this field must be before the number entered in the “To” field.
|
To |
The ending number in the range of voucher numbers that have been created during adjustment of customer documents and that you want to retrieve in the report (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves the details of all the vouchers that are similar to the value entered in this field. |
|
Receipt No From |
The starting number in the range of receipt numbers that have been created while receiving payments and for which you want to view the adjustment details (Alphanumeric, 18). |
Note: The receipt number entered in this field must be before the number entered in the “To” field.
|
To |
The ending number in the range of receipt numbers that have been created while receiving payments and for which you want to view the adjustment details (Alphanumeric, 18). |
|
Currency |
Use the drop-down list box to select the code identifying the currency in which the adjustment has been made. All the currency codes that have been assigned to the login company will be available for selection. The system displays “All” by default on launch of the page. |
|
Date From |
The starting date in the date range for which you want to view the adjustment details in the report (Date Format). |
|
To |
The ending date in the date range for which you want to view the adjustment details in the report (Date Format). |
Click the “View Customer Balance Adjustment” pushbutton to view the report.
The system generates and displays a report containing the adjustment details of the customers based on the search criteria entered. The report display the customer adjustment details based on the transaction number. You can also view the document details like the document number, the document date, the document amount, the adjusted amount on the document, the due amount, the type of the reference document and the number identifying the reference document. You can also view the adjustment voucher number. This report can also be printed whenever required.
Customer Balance Adjustment – An overview
Credit documents raised on a customer like receipts, credit notes or prepayments are usually adjusted against the debit documents like invoices or debit notes of the same customer. This process is termed as customer balance adjustments. An adjustment can be made in a single currency, when both the credit and the debit documents are in the same currency, or in multiple currencies, when the currency of the credit and the debit documents are different. You can view the details of adjustments for a given period for a single customer or for multiple customers. The report thus generated is termed as the “Customer Balance Adjustment” report. You can view the details of the report and also print it if required.
You can carry out a search by specifying a range of voucher numbers that have been generated after adjustment for the customer and a range of receipt numbers that have been created on receipt of payment from the customer. You can also search by specifying the currency in which the documents have been raised or adjustments have been made. The system generates and displays the report.
This report can be generated for a selected company or business unit for a customer or a range of customers. You can view the details of the credit and the debit documents that were adjusted. You can also view the details of the voucher that has been generated after adjustment. You can view the document amount, due amount and the adjusted amount in the transaction currency, the base currency and the parallel base currency of the company. You can also view the loss or gain due to exchange variance in the base currency and the parallel base currency of the company. If a due amount has been written off or written back into the books of accounts after the adjustment, you can also view it in the base currency and the parallel base currency of the company.