#Cash Planning - Detail#
Report Name | #Cash Planning - Detail# | ||
|---|---|---|---|
Report Location | Finance\Register | ||
Report Type | Register | ||
Report Description | This Report will helpful to have Cash Planning (Detail) for future date. This Report will consider Purchase Invoice, Service Invoice, Sales Invoice, Sale of Service Invoice document as parent document for the analysis purpose. | ||
Report Objective | The objective of this report to plan future liability with respect to current outstanding and future due date. In this Report Document Amount considered based on the due date of the document. For this report Purchase Invoice, Service Invoice (Purchase), Service Invoice (Sales), Sales Invoice is considered. In this Report if is Due days is higher than the due days defined in Party/AR AP Sub Ledger Master then it is marked with red colour. | ||
Target Audience | Finance Manager, Finance Executive, Management | ||
Selections | Name | Selection type | Objective |
Due Date From | Single | Report to be shown based this document due date from selected by user. This date should be future date w.r.t the date of report running. | |
Due Date To | Single | Report to be shown based this document due date to selected by user. This date should be future date w.r.t the date of report running. | |
Class Name | Single | User can opt for particular Sub Ledger Class i.e. Customer, Transporter etc. for specific report purpose. If there is no such specific requirement then ‘ALL’ need to be selected. | |
Show Past Due | Single | If user consider ‘True’ then any documents with pending balance (Partial / Full) has due date less than equal to ‘Due Date To’ selected by user will be considered in Report. If user consider ‘False’ then only those record which has due date between the selected Due Date will be shown. It is recommended to set as ‘True’. | |
Ledger | Multiple | User can opt for Ledger (i.e. Party or AR/AP Ledger) for the report purpose. If no such specific selection is required then it can be kept in Blank. | |
Sub Ledger | Multiple | User can opt for Sub Ledger (i.e. Party) [based on selected Ledger above ]for the report purpose. If no such specific selection is required then it can be kept in Blank/Remove. | |
Agent | Multiple | User can opt for Agent of Sub Ledger (i.e. Party) [based on previous selection ]for the report purpose. If no such specific selection is required then it can be kept in Blank. | |
Dependencies | NA | ||
Alternative reports to validate | In Certain cases Cash Planning Summary Report can be used | ||
Sample Output | 
| ||
Data Source Category Used | 01-Master\ARAP Ledger [LV_ARAP_LEDGER] | ||