#Interest Calculation - Sub Ledger(Customer)#
Report Name | #Interest Calculation - Sub Ledger(Customer)# | ||
|---|---|---|---|
Report Location | Finance\Register | ||
Report Type | Register | ||
Report Description | This report will show the interest calculation for Subledger (Customer) for the selected date range. | ||
Report Objective | This Report is design to have a report to calculate the interest need to be charged for any outstanding value of the selected date range. | ||
Target Audience | Accounts Executives, Accounts Manager, Finance Manager, Finance Executive | ||
Selections | Name | Selection type | Objective |
From Date | Single | Report to be shown based on transaction happened for the period starts from this date | |
To Date | Single | Report to be shown based on transaction happened for the period starts from this date | |
Agent | Single | Report will display for the payment recipient who has Agents defined in their master. User can select a particular agent or can consider 'ALL' to have record irrespective of Agent available in Customer/Vendor Subledger Master. | |
AR/AP Ledger | Single | Report will display for the Customer/Vendor Subledger which is under selected AR/AP Ledger. If no such specific selection needed then ‘ALL’ can be selected. | |
Consider Cheque Date (For Vouchers) | Single | If it is ‘True’ Report will display Voucher which have Cheques with date within the date range selected by user. If it is ‘False’ then Vouchers with voucher date within the selected date range to be considered. | |
Consider Due Date (For Invoices) | Single | If it is ‘True’ Report will display Invoices which have due date within the date range selected by user. If it is ‘False’ then Invoice with Invoice date within the selected date range to be considered. | |
Disallow Reverse Interest | Single |
| |
Grace Days (Addition to Due Date) | Single | If Due Date considered and need to provide grace days beyond due date to calculate interest charged | |
Default Interest Rate | Single | If user provides a value here then the same will considered as Interest Rate for the calculation in Report. Please Note if Customer / Vendor Sub-ledger Master have value in ‘Interest Charged for delayed payment’ under Sales tab then that will be considered as interest rate for the outstanding instead of given value in this parameter. | |
Dependencies | NA | ||
Alternative reports to validate | NA | ||
Sample Output | 
| ||
Data Source Category Used | 01-Master\Sub-Ledger [LV_SUBLEDGER] | ||