#Customer-Vendor Outstanding Ageing Analysis#
Report Name | #Customer-Vendor Outstanding Ageing Analysis# | ||
|---|---|---|---|
Report Location | Finance\Register\ | ||
Report Type | Register | ||
Report Description | This Report will display Customer/Vendor wise consolidated outstanding Ageing. Report will display output based on user selected parameters. Primary Document to be considered up to the date given under 'Document till Date' and the adjusted document to be considered upto the date selected under 'As on Date'. | ||
Report Objective | This Report is designed to have Sub Ledger wise outstanding ageing details. | ||
Target Audience | Finance Manager, Operation Manager, Purchase Manager, Sales Manager | ||
Selections | Name | Selection type | Objective |
As On | Single | Outstanding to be shown as on the date selected by user in this option. | |
Document Till Date | Single | Based on user selected date in this option documents to be considered for outstanding calculation. | |
Document Consideration Basis (Date) | Single | ‘Documents Till Date' will be effective based on this selection. If user opt for ‘Entry Date’ from the options then ‘Document Till Date’ will filtered based in Transaction Entry date. IF user opt for ‘Invoice Due date Basis’ then ‘Document Till Date’ will filtered based on due date basis defined in the Customer/Vendor Master. If It is defined as ‘Entry Date’ then above filter will effective on Entry Date if it is Document Date then it will be effective on 'Document Date’ | |
Show Agent | Single | If user opt for ‘Yes’ then Agent Name will be visible in Report | |
Agent | Single | User can opt for a particular Agent (data to be shown for the AR AP Sub ledgers i.e. Party(s) in which selected Agent is tagged) for specific report purpose. If there is no such specific requirement then ‘ALL’ need to be selected. | |
AR/AP Ledger | Single | User can opt for a particular AR/AP Ledger to see the report. If there is no such specific requirement then ‘ALL’ need to be selected. | |
Include Unposted Entries | Single | If it is ‘True’ then report will consider all those transactions which is not released/posted yet also. | |
Calculate age based on | Single | User need to opt any one option for age calculation from the following three
| |
Agent Source | Single | User can opt to choose source of Agent to be displayed. It can be shown from the Sub Ledger Master or the Agent Name saved in respective transaction. | |
Class Name | Single | User can select particular class of sub ledger by this option. if there is no such need then it should be kept as 'ALL' | |
Show PDC Documents | Single | If user opt for ‘Yes’ then PDC details will be visible in Report in a separate section. | |
Sub Ledger | Multiple | If it is needed to see report for a particular sub-ledger outstanding then this option can be used. | |
Dependencies | NA | ||
Alternative reports to validate | #Bill wise Outstanding Analysis# if the parameter selection is same as it is. There certain parameter is not available in current report hence in that case default value of Bill wise Outstanding Analysis Report will be considered. | ||
Sample Output | 
NB : Default Ageing slab used in Report can be modified as per need from Ginesys Back End. The changed age slab will be effective in all relevant Finance Report. Ageing Slab can not be defined for a specific report. For modification of Ageing Slab user need to contact Ginesys Support Team. | ||
Data Source Category Used | 01-Master\Agent [LV_AGENT] | ||