mO SharemO Share

We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!

#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]
02-Finance\04-Report Specific\Interest Calculation - Customer [TV_INT_CALC_CUST]