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!

#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

  • Document Date (New) : Age will be calculated based on the document date

  • Ref Date/Document : If Ref doc date is available then ref doc date else the document date

  • Due Date : Based on due date in the document.

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]
01-Master\ARAP Ledger [LV_ARAP_LEDGER]
01-Master\ARAP Sub-Ledger [LV_ARAP_SUB_LEDGER]
02-Finance\04-Report Specific\Bill Wise Outstanding [TV_BILLWISE_OUTSTANDING]
02-Finance\04-Report Specific\Bill Wise Outstanding Format 1 [TV BILLWISE_OUTSTANDING_F1]