Cash Planning

Entities list of cash planning.

Cash Planning Voucher

Overview

Cash planning voucher details are saved in this screen.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Cash Planning Voucher

Cash Planning Voucher screen Fields and Tabs

Fields	Descriptions
Code	Voucher unique id which is entered by the user or system generated. It depends on the system settings.
Workflow Status	The workflow status of the Cash Planning voucher. It depends on the workflow status settings. The value changes according to the approval. Possible values are Created, Approval Requested and Approved, etc.
Fiscal Year	The default value of the fiscal year is the current fiscal year which is open for the transactions. User can select it using the drop-down button.
Voucher Type	The type of cash planning voucher. The default value is Programming.
Posting Status	Posting status provides the status of the cash planning voucher. It is updated by the system when the voucher is either saved or temp saved.
Cash Plan Type	Cash plan type, it can be selected using the drop-down list.
Funding Source	The funding source for the cash planning voucher. User can select it using the lookup button feature or enter manually.
Copy Annual Programming	It is used to indicate if the Quarterly programming must be copied of Annual programming. By default, it is a read-only mode.
Not Posted Reason	The user will select a reason for not posting the voucher when the voucher is Temp Saved, the field should be cleared automatically when the voucher is completely saved.
Institution	The institution code for the cash planning voucher. The user can enter manually or select it using the lookup feature.
Voucher Date	It automatically fetches the system current date.
Temp Number	The serial number generated by the system when the voucher is Temp Saved status.
Language	The default language is English. User can change the language using the drop-down button.
Description	Description of the cash planning voucher.
Currency	By default, it shows the country's domestic currency. If the cash planning voucher is created with foreign currency user need to select it using the drop-down list.
Exchange Rate	It displays the active exchange rate for foreign currency. It fetch the exchange rate from the exchange table.
Is Consolidated	Value “True” indicates that the Cash Planning Voucher is consolidated in another (in superior level), “False” is not consolidated.
Programming to Reprogramming	Default value is zero.
Grouping Cash Planning Voucher	This attribute should be used to identify the document that groups or contains different Cash Planning vouchers.
Distributed	By default it is False. It indicates if the amount was distributed if the amount approved was different to request for higher level only. The system will update automatically.
Is Update Higher Level Budget Controls	An indicator to allow updating the higher level Cash Controls once the lower control is updated through this voucher.
Total Amount Requested(Domestic)	Total of Domestic Amount Requested of all line item. Default is Zero.
Total Amount Requested(Foreign)	Total of Foreign Amount Requested of all line item. Default is Zero.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all line item. Default is Zero
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all line item. Default is Zero
Consolidated Total Amount Approved(Domestic)	Total of Domestic Amount Consolidated and approved in the High level. Default is Zero
Consolidated Total Amount Approved(Foreign)	Total of Foreign Amount Consolidated and approved in the High level. Default is Zero
Created By	The user id of the creator, the system automatically displays the information.
Creation Date	Date of the Cash planning voucher creation.
Approved By	The user id of the approver. The system automatically fetches the approver information.
Approved Date	System fetch the current system date when Cash Planning Voucher got approved.
Is Consolidated to High Level	Value “True” indicates that the Cash Planning Voucher is consolidated in another (in superior level), “False” is not consolidated. The Default value is “False”.
Consolidated High Level Voucher	This attribute should be used to identify the document that groups or contains different Cash Planning vouchers consolidated to High Level.
Cash Planning Voucher Details	Collection of one or more line items of type Cash Plan Detail.

Cash Planning Voucher Details

Overview

This tab stores Cash Planning Voucher Details.

Cash Planning Voucher Details Screen and Tabs

Fields	Descriptions
Correlative	Auto-Generated Correlative Number.
Fiscal Period	Fiscal Period of the Cash Planning. User can select it using drop-down list.
Coding Block	The coding block structure for cash planning voucher.
Language	The default language is English. The user can select other language from the drop-down list.
Description	The small description related to cash planning voucher.
Total Amount Requested(Domestic)	The Total of Domestic Amount Requested of all Line Item Distribution. By default value is Zero.
Total Amount Requested(Foreign)	The Total of foreign Amount Requested of all Line Item Distribution. By default value is Zero.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all Line Item Distribution. Default value is Zero.
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all Line Item Distribution. Default value is Zero.
Consolidated Voucher Detail	Parent Voucher Detail.
Distributed	The default value is False. It Indicate if amount was distributed if the amount approved was different to requested.
Cash Planning Voucher Detail Distribution Tab	The tab allows to store cash planning voucher details.

Cash Planning Voucher Details Distribution

Overview

The tab store Cash Planning Voucher Details Distribution details.

Cash Planning Voucher Details Distribution Screen and Tabs

Fields	Distributions
Fiscal Period	Auto-Generated Correlative Number.
Total Amount Requested(Domestic)	The Total of Domestic Amount Requested of all Line Item Distribution. The default value is zreo.
Total Amount Requested(Foreign)	The Total of Foreign Amount Requested of all Line Item Distribution. The default value is zreo.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all Line Item Distribution. The default value is zreo.
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all Line Item Distribution. The default value is zreo.

Consolidate Cash Planning Voucher

Overview

Allows user to create a consolidate cash planning vouchers at lower level.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Consolidate Cash Planning Voucher

Consolidate Cash Planning Voucher screen fields

Fields	Description
Voucher Type	Type of voucher can be selected from the dropdown list. It can be wither 'Programming' or 'Reprogramming'.
Budget Office	Budget Office to Consolidate can be selected using the lookup function. Syatem allows to filter by Parent level and display same and inferior levels (Childs).
Cash PlanType	Allows users to select the Cash Plan Type based selected Voucher type.
Currency	Applicable currency can be selected from the dropdown list.
Funding Source	Displays the funding source. It shows the Elements restricted to definition where Concept Id is equal to' Financing Source' parameter. If Cash Plan Type attribute selected on their Cash Plan Group attribute is 'Accounting' this attribute should be hidden and clear information selected it self.

Consolidate Cash Planning Voucher to High Level

Overview

Allows user to create a consolidate voucher to high level, grouping cash planning vouchers at next lower level, after create this new Cash Planning voucher system must update all Cash Planning voucher consolidated with the corresponding ID on Voucher.

Only the Cash Planning Voucher documents of Expenditures can be consolidated to high level (Institutional - Programming and reprogramming).

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Consolidate Cash Planning Voucher To High Level

Consolidate Cash Planning Voucher To High Level screen fields

Fields	Description
Voucher Type	Type of voucher can be selected from the dropdown list. It can be wither 'Programming' or 'Reprogramming'.
Budget Office	Budget Office to Consolidate can be selected using the lookup function. Syatem allows to filter by Parent level and display same and inferior levels (Childs).
Cash Planning Voucher Type	Allows users to select the Cash Plan Voucher Type based selected Voucher type.
Currency	Applicable currency can be selected from the dropdown list.
Funding Source	Displays the funding source. It shows the Elements restricted to definition where Concept Id is equal to' Financing Source' parameter. If Cash Plan Type attribute selected on their Cash Plan Group attribute is 'Accounting' this attribute should be hidden and clear information selected it self.

Import Cash Planning Voucher From Financial Programming Of Payments

Overview

The cash planning voucher using the data from budget control, the status of the workflow should be Approved.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Import Cash Planning Voucher From Financial Programming Of Payments

Import Cash Planning Voucher From Financial Programming of Payment screen Fields and Tabs

Fields	Descriptions
Source Fiscal Year	It is retrieved from the fiscal year, the fiscal year must be open for the transactions. The default value is the current fiscal year.
Source Budget Control Type	The budget control type. It can be selected from the drop-down list.
Institution Id	Institution code. It can be manually entered by the user or can select it with the lookup feature.
gea_CreateCashPlanningVoucherFrom FinancialProgrammingOfPayments_distributionMethod	It allows selecting the distribution method from the drop-down list. The possible value is "Pondered and First Period".
Cash Planning Voucher Type	It shows a list with Cash Plan Type.
Currency	It shows the country default currency which is active. It allows the users to select the other currency if the transaction is in foreign currency.
Funding Source	It displays the funding source.

Payment Quota Mapping

Overview

This entity allows user to allocate payment quota from one bank account to another bank account for a specific coding block. Using this entity, system creates a Bank Account Transfer described as below:

This process should be run through batch jobs, with the default scheduled day and time
System allow to select a TBA type main(physical / Secundary) and transfer to one or many TBA type secondary
System must create One Voucher by Accounting Office and TBA as per the quota mapping with Approved status
System must validate the current fiscal period is not processed yet
When BATV is approved (through BATV automatic WF) system will insert the current fiscal period on

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Payment Quota Mapping

Payment Quota Mapping screen fields

Fields	Description
Application ID	Unique code of each individual record. It can be either system generated or manual based on Appropriation parameters, if system generated then each voucher type will have different serial.
Fiscal Year	Current Fiscal year on which the mapping takes place.
Active	Indicate whether the record is active or not to use as a reference in other entities.
Source Bank Acocunt	Source Bank Account code can be selected using the lookup function from which the amount will be transferred.
Description	A description about the transfer.
Destination Bank Account tab	Destination Bank Account code can be added using the "Add New" button under the tab to which the amount will be transferred.

Planning through Implementing Agencies Voucher

Overview

This entity hepls the spending agencies to provide fund to the other Implementing Agencies for Cash Planning with following requirements:

This screen will be entered by Spending Agency which give funds to Implementing Agencies.
There should be a workflow process needs to be implemented.
This screen needs to include FR 208 Coding block and once the approval done from Spending Agency system needs to create commitment for that coding Block
Security needs to be skipped based on this FR 208 Control screen. That is once the FR 208 Control is approved, implementing agency users should have access to FR 208 Control coding Block

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Enable Planning Through Implementing Agencies

Planning through Implementing Agencies Voucher screen fields and tab

Fields	Description
Code	Unique identification, entered by the user
Workflow Status	Displays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Originating Institution	Originating Institution, a look up for selection of Institution is needed. By default current user's institutiion. User can update.
Amount	Voucher amount, calculated field. Read Only.
Coding Block	Coding Block Information.
Initiated Date	System given current date assigned automatically.
Description	Description of the record.
Created By	Name user who creates. Populated automatically by the system at creation time of the record.
Created Date	Read only. Will be automatically populated by the system at creation time of the record.
Approved By	Populated automatically by the system at approval time of the record.
Approved Date	Populated automatically by the system at approval time of the record.
Planning Through Implementing Agencies Details tab	This entity will record the information regarding the Implementing Agencies
Attachments tab	To add any related documents.

Planning through Implementing Agencies Detail

Overview

This entity will record the information regarding the Implementing Agencies

Planning through Implementing Agencies Detail screen fields

Fields	Description
Serial Number	Auto generated item serial number starts with 1 for each Journal Voucher
Implementing Agency	Implementing Institution can be selected using the lookup function.
Amount	Amount that Implementing Agency will manage.

Support Entities

Cash Planning Support entities.

Cash Planning Voucher Seasonality Factor

Overview

Stores the Seasonality factor of the Cash Planning Voucher.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Support Entities ► Cash Planning Voucher Seasonality Factor

Cash Planning Voucher Seasonality Factor screen Fields and Tabs

Fields	Descriptions
Application Id	Automatically assigned by the system or manually entered by the user, depending on the system parameter setting.
Fiscal Year	Fiscal Year of the Cash Planning, default current Fiscal Year. The fiscal year should be open for the transaction.
Fiscal Period	The default value is the current fiscal period. The fiscal period should be open for the transaction.
Cash Planning Voucher Type	This field should display the "Cash Planning voucher type".
Budget Office	Budget Office Code. By default use current employee institution.
Application Language	The default value is English. User can change it.
Description	Description relates to Cash Planning Voucher Seasonality Factor.
Currency	By default, this field displays the country domestic currency. If the transaction is in a foreign currency system allows selecting the foreign currency from the drop-down menu.
Coding Block	Coding block structure. User can select it using lookup feature.
Created By	The system automatically fetches the user id of the creator.
Created Date Time	The system automatically fetches the current date and time.
Cash Planning Voucher Seasonality Factor Distribution	Collection of one or more line items of Cash Planning Voucher Seasonality Factor Distribution.

Cash Planning Voucher Seasonality Factor Distribution

Overview

This tab storage the Seasonality factor of the Cash Planning Voucher.

Cash Planning Voucher Seasonality Factor screen Fields and Tabs

Fields	Descriptions
Correlative Id	A unique identification id.
Fiscal Period	It dispalys the current Fiscal period.
Percentage Factor	The percentage of the cash planning voucher seasonality factor.

Cash Planning Voucher Type

Overview

Cash Planning voucher type allows the users to classify Cash Planning Voucher for data entering, searching and reporting purposes. Examples of cash plan types can be Annual Cash Planning for Revenues, Annual Cash Planning for Expenditures, Monthly Cash Planning for Revenues, etc.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Support Entities ► Cash Planning Voucher Type

Cash Planning Voucher Type screen Fields and Tabs

Fields	Descriptions
Id	Automatically assigned by the system or manually entered by the user, depending on the system parameter.
Active	The default value is true. If this is False, then this Cash Plan Type cannot be used in future transactions
Language	The Default value is English. The user can change the language.
Name	Name of the Cash Planning Voucher Type.
Description	Description of Cash Planning Voucher Type.
Budget Control Type	Limited to Budget Control Type Where Used to Create Manual Cash Planning Voucher True.
Period Level	Period Level Which Cash Plan Type will use.
Cash Plan Group	The cash plan group by default value is Revenues.
Voucher Execution Type	The voucher execution type. The possible values are 'PROGRAMMING OF PAYMENTS', 'PROGRAMMING OF REVENUES', and 'REPROGRAMMING OF PAYMENTS', etc.
Is ApplySeasonality Factor	The default value is False. If user make it false then it would be not applied for seasonality factor.