info manager cash guide - standard chartered · info manager cash guide . 2 info manager user guide...

Info Manager Cash Guide

2

Info Manager User Guide

Online Cash Management and Transaction Alert tool from

Standard Chartered Bank

User Guide Version 1.0 May 2008

Info Manager CashInfo Manager CashInfo Manager Cash

3


Contents

Section ONE 6 1.1 Introduction 7 1.2 Cash Products 7

Section TWO 8 2.1 Log In 9 2.2 Info Manager Cash Overview 12

Section THREE 14 3.1 Create Reports 16 3.2 Select Product & Sub-Product 17 3.3 Select Columns & Sorting 18 3.4 Select Filter Settings 19 3.5 Run Time Filter Parameter 21 3.6 Select Schedule & Delivery 22 3.7 Run Report 25 3.8 Print Report 29 3.9 Export Report 30

Section FOUR 31 4.1 Manage Reports 32 4.2 Run Report 35 4.3 Print Report 37 4.4 Export Report 38 4.5 Edit Report 39 4.6 Create Report from Template 40 4.7 Delete Report 41 4.8 Share Report 42 4.9 View Report 44

4


Contents

Section FIVE 45 5.1 Create Alert 46 5.2 Select Product & Sub-Product 47 5.3 Select Alert Details 48 5.4 Consolidated Alert 49 5.5 Email/Fax Delivery settings 50 5.6 Alert Filter settings 51

Section SIX 53 6.1 Manage Alerts 54 6.2 Edit Alert 56 6.3 Create Alert from Template 57 6.4 Delete Alert 58 6.5 View Alert 59

Section SEVEN 60 7.1 Quick Search 61

Section EIGHT 65 8.1 System Defined Reports 66 8.2 Run Report 68 8.3 Create Report from Template 69

Section NINE 70 9.1 Payables 71 9.2 Payables and sub product Payables 72 9.3 Payables and sub product Enquiries 73

5


Contents

Section TEN 74 10.1 Receivables 75 10.2 Paper Instruments 77 10.3 Electronic Instruments 80 10.4 Over the Counter 83 10.5 Returns 85 10.6 Charges 88 10.7 Credit Card 90

Section ELEVEN 92 11.1 Working Capital View 93 11.2 Operating Account Statement 95 11.2.1 Intra Day, Prior Day or Both 96 11.2.2 Select Columns and Sorting 97 11.2.3 Select Filter Settings 98 11.2.4 Run Time Filter Parameter 100 11.2.5 Select Schedule and Delivery 101 11.2.6 Product Setup 104 11.2.7 Run Report 105 11.3 Working Capital View - Loan Account 107 11.4 Working Capital View - Deposit Account 109

6


SECTION ONE

Introduction

Cash Products

7


Straight2Bank from Standard Chartered Bank, a MIS tool, helps the user in managing his cash and trade businesses more effectively. Info Manager Cash enables the user to make important business decisions with accurate and up-to-date financial information available at his finger tips. It provides tools to view transaction data online, create customized reports and receive alerts when cash based transactional activity previously selected by the user, occurs. Info Manager Cash eliminates a large percentage of manual intervention required for traditional report generation.

1.1 Introduction

1.2 Cash Products covered

Info Manager Cash supports the following cash products.

PAYABLES Payables Enquiries RECEIVABLES Paper Instruments Electronic Instruments Over the Counter Returns Charges Credit Card WORKING CAPITAL VIEW Operating Account Statement Loan Account Deposit Account

8


SECTION TWO

Log In

Overview

9


Welcome to Info Manager Cash, the efficient, 24x7 MIS tool within Straight2Bank. This initiative from Standard Chartered Bank will enable quick and easy access to cash based transactions. To begin, open the browser, (which must be Internet Explorer, Version 6 with Java and 128 bit SSL Encryption) and go to the Straight2Bank URL. Please verify the Straight2Bank site address from your system administrator. Below is the login page that should appear on the user screen. Use your Straight2Bank Group ID and User ID to Login. Click "Submit" to enter Straight2Bank.

Enter a valid set of Straight2Bank Group ID and User ID provided by the system administrator. Click “Submit”.

For Non - English speaking regions, language may be set using this control.

2.1 Log In

Figure 2.1.1 : Straight2Bank Login

10


Enter a valid password. Click "Proceed".

Figure 2.1.2 : Password Entry screen

After the Straight2Bank Group & User IDs are accepted, the user is prompted to enter the password. Click "Proceed" to enter Straight2Bank.

11


Figure 2.1.3 : Straight2Bank welcome screen

On successful login, the user will be greeted with a landing page, similar to the one below.

12


2.2 Info Manager Cash Overview

Straight2Bank’s Info Manager Cash provides the following utilities to get up-to-date financial information, automating reporting tasks and generating alerts in response to trade activity.

Create Report : Helps the user create a new cash product specific report designed to suit personal specifications. Manage Report : Using this option the user may run, edit, copy, share and delete existing reports. Create Alert: Using this tool the user may set up alerts in just a few easy steps. Manage Alerts: Helps the user edit, copy, share or delete existing alerts. Quick Search: This helpful function enables the user to run a search based on an individual trans-action or a batch. In case the full transaction details are not known the search functions include the ability to use wild-card characters to find the correct transaction. System Defined Reports: These are reports provided by Standard Chartered Bank to Straight2Bank users. The user may use these report formats to define personalized reports.

Figure 2.2.1 : Info Manager cascading menu

Info Manager Cash Report, Alert and Search menus.

You can access Info Manager Cash menu from the Cash Management Reports menu option on the main Straight2Bank menu bar.

Alternately you can access Info Manager Cash menu from Info Center on the main Straight2Bank menu bar.

13


Info Manager Cash Overview ...continued

Figure 2.2.2 : Info Manager Cash

Info Manager Cash Create Reports / Alerts

Info Manager Cash Manage Reports / Alerts.

Info Manager Cash Quick Search

Info Manager Cash has a very user friendly feature incorporated where the user may select to Create report / alert, Manage reports /alerts and the Quick Search option all on a single page. Select Reports > Info Manager under Cash Management or Info Center > Info Manager . The user screen may look similar to the screen shot illustrated below.

Info Manager Cash Menu

14


SECTION THREE

Create Report

15


4

Product & Sub-Product

Columns & Sorting

Filter Settings

Schedule & Delivery

STEP ONE : Define Cash Product

and Sub-Product

STEP TWO : Select the information

to be displayed in the Report

STEP THREE : Select filters that will allow

the user to narrow down the details in the Report

STEP FOUR : Run or Schedule the Report

16


3.1 Create Report

Info Manager Cash users may create customizable reports. After creating the reports users may choose to either view, edit, copy or simply run a selected report. Users are provided the flexibility to share their reports with other users. Select Reports > Info Manager > Create Reports under Cash Management to create reports. The user screen may look similar to the screen shot shown below.

Figure 3.1.1 : Straight2Bank Create Report

Users may create reports from Reports > Info Manager > Create Report under Cash Management.

17


3.2 Select Product and Sub-Product

At the end of this section, the user will be able to create customized views of his cash transactions. In a few simple steps the user is able to define the Report Fields, Report Filter, Sorting Order, Report Layout, Delivery Schedule, Delivery Channel and finally the Format of Report delivery.

Figure 3.2.1 : Selection menu for Product

Figure 3.2.2 : Selection menu for Sub-Product

STEP ONE: Select desired cash product.

STEP TWO: Select relevant sub-product.

STEP THREE: Click “Create Report”. A screen with options for report creation will be displayed on the user screen.

18


Info Manager Cash offers great flexibility to create reports. Users may create custom reports with desired columns, suitable filters and schedule format and delivery of the report to suit individual requirements. Follow the steps given below and then select the next tab, i.e. “Filter Settings”.

3.3 Select Columns and Sorting

Figure 3.3.1 : Reports—Columns and Sorting

STEP ONE: Enter a suitable name and description for the Report .

STEP TWO: Select relevant Columns from the list. Use “Ctrl” key to select more than one column. Optionally you can double click the column names.

STEP THREE: User may choose to rename column names. From the Selected columns list choose the required column and enter a custom name . Click “Rename”.

STEP FOUR: Apply sort order for the selected columns (optional).

19


3.4 Select Filter Settings

In this section , the user will create Filter Settings. Filters enable one to “fine tune” or narrow down the details of the data which will appear in the report. Select filters appropriate for the report.

Figure 3.4.1 : Reports—Select Filters screen

STEP ONE: Select appropriate columns (filters) from the Available Criteria list and using the arrow keys move them to Selected Criteria list. Use “Ctrl” key to select more than one filter. A max. of 10 filters can be selected.

STEP TWO: Report output will be based on the columns (filters) listed in the Selected Criteria list.

STEP THREE: After selecting the Criteria, click “Continue”. Click “Reset Filter” to revert to original settings.

20


Filter Settings ...continued

Depending on the type of column name (filter) selected text boxes, list boxes or calendar, appropriate to fill in data for the filters, are displayed.

Figure 3.4.2 : Reports—Filter Settings screen

STEP ONE: Fill in appropriate values for the chosen filter criteria. Use % to indicate wildcard characters.

STEP TWO: Select the Schedule and Delivery tab to set the frequency and mode of delivery of the report. Optionally choose to RUN the report with or without saving it. Use “Reset” to cancel the changes made and start afresh.

21


3.5 Run Time Filter Parameter

Now, it's time to specify schedule & delivery details for the reports. Info Manager Cash comes with the additional functionality of Run Time Filter Parameter, where the user specifies the report filters during report creation but has the option to input values for the selected filter criteria during report creation or at report run time, when the system prompts for the same. The Run Time Filter Parameter is set to ‘OFF’ by default. The user has to set this ‘ON’ to use the functionality.

NOTE : Run Time Filter Parameter reports can only be run Online and cannot be

scheduled by the user. Once the Run Time Filter Parameter is set to ‘ON’ the ‘Schedule

and Delivery’ tab is disabled. If the user clicks the tab to schedule delivery of the report a

message is displayed on the user screen, as shown below.

Figure 3.5.1 : Reports—Run Time Filter Parameter

22


3.6 Select Schedule and Delivery

When the Run Time Filter Parameter is set to ‘OFF’ the user may choose to specify schedule & delivery details for the reports. Click the ‘Schedule & Delivery’ tab. By default the Schedule & Delivery is set 'OFF'. To schedule the report set ’Schedule and Delivery’ to 'ON' .

NOTE : All fields in this dialogue are mandatory. Care should be taken while selecting

options available as every item is critical in proper scheduling and delivery.

Figure 3.6.1 : Reports—Schedule & Delivery settings

1. Set the Schedule and Delivery option “ON”. 2. Choose ‘Start Date’ and specify a date for the initiation of report delivery. 3. Select ’End Date’ to indicate end date of report delivery. 4. Set the frequency of report generation, the options available are Daily :will generate the report daily Weekly :for this option you also need to specify the day of the week for report generation Monthly :system will prompt you for a day of the month

23


Schedule and Delivery ...continued

Figure 3.6.2 : Reports—Delivery Format settings

5. Set the time in hours and minutes for the delivery of the report. 6. Select a delivery format for the report from the drop down

menu. Select one of the two available options i.e. CSV or Excel format for delivery.

24



Figure 3.6.3 : Schedule & Delivery — Delivery Channel settings

7. Select one of the available options i.e. Straight2Bank Message, Email or H2H (Host to Host) as delivery channel for the report.

If the user selects Straight2Bank Message option, reports will be generated according to the schedule set and a message will be generated and stored in the Straight2Bank Message centre and can be downloaded at the user’s convenience. If the user selects the Email option, system will provide a text box to enter appropriate email ID for report delivery. Use comma separator to enter multiple email IDs. Validation will be performed on the domain of the email id entered to see if it matches domains registered at the time of Group setup. A message informing Invalid Email Domain will pop up if the domain validation fails. The third option namely, H2H should be selected only if the user has a H2H installation from Straight2Bank. Please verify from the system administrator. If the user selects the H2H (Host to Host) option another drop-down menu is displayed, wherein the user may select the Group ID to which he belongs. A default Group ID will be displayed in the drop-down box. Subsequently, all reports generated for that particular Group ID will be delivered through the H2H channel.

25


8. Click “Save Report” to save the report. Optionally click “Run Report” to execute the newly created report. Click “Save and Run Report” to save and then run the report.

User may choose to Save or Run the newly created report. To save the report click “Save Report”. User will receive a confirmation message if the report has been successfully saved. To run the report online click “Run Report”. If records exist for the newly created report then the report will be displayed on the user screen, as detailed on the next page. To save and run the report click “Save and Run Report”.

3.7 Run Report

Figure 3.7.1 : Reports—Run Report screen

26


Figure 3.7.2 : Summary Report View

After the user clicks “Run Report” a summary report view is displayed on the user screen as shown in Fig. 3.7.2. Choose a transaction by clicking the hyperlink to see its detailed report view.

Run Report ...continued

RR

The data has been blanked.

27


Complete details of the chosen transaction are displayed under the ‘Main Information’ tab as can be seen in Fig. 3.7.3 below.


Figure 3.7.3 : Detailed Report View

RR


RR


RR


28


Figure 3.7.4 : Invoices


If there are any invoices for the selected cash transaction, the details will be displayed under the ‘Invoices’ tab as seen in Fig. 3.7.4.

RR


RR


29


3.8 Print Report

At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user may choose to either print the report or export the data in excel or CSV (comma separated variable) format.

Click “Print” to print the report.

A print preview of the report is displayed on the screen as shown, which can then be printed.

Figure 3.8.1 : Print Report screen

RR


RR


RR


RR


30


3.9 Export Report

Info Manager Cash offers the user the option to export the report in either CSV or EXCEL formats.

Figure 3.9.1 : Export Report screen

Click “Export” to export the report.

Select the desired file format (Excel or CSV) in the pop-up screen. Click “Export” .

RR


RR

RR


31


SECTION FOUR

Manage Reports

32


4.1 Manage Reports

Info Manager Cash users have a wide range of options to manage the reports they have created. Users may choose to either view, edit, copy, delete or simply run a selected report. Users are provided the flexibility to share their reports with other users. Select Reports > Info Manager > Manage Reports under Cash Management to manage reports previously created.

Figure 4.1.1 : Straight2Bank Manage Report

Users may access reports from Reports > Info Manager > Manage Report s under Cash Management.

33


Manage Reports ...continued

A list of all reports i.e. system defined reports as well as reports previously created by the user is displayed. The user may choose a report by selecting the radio button against it. Click any of the buttons below the list that helps mange the change desired.

Figure 4.1.2 : Manage Report screen

34


Manage Reports ...continued

The user may select the type of report he wants to view from the two drop down menus. Choosing All Reports enables him to choose a particular category of report. The various categories are listed below. My Reports displays user created reports. System Defined Reports are reports provided by Straight2Bank to its users. These reports may be used as templates to define user personalized reports. Recently Run Reports lists reports which have been run in the recent past by the user. Shared Reports lists reports which are shared among a group of users. Run Time Reports lists reports with the run-time filter parameter set up within the report filter criteria. System Adhoc Reports is used to create MT940 or MT950 formatted reports. The user may create as many reports as he wants and schedule them for delivery but unlike the above listed reports, these reports cannot be run online. These can only be scheduled and generated offline. Adhoc Reports lists all System Adhoc Reports created by the users. The user may select these reports and make changes if any or choose to delete them, if no longer required.

Figure 4.1.3 : Report Screen

35


4.2 Run Report

Run report provides the user the option to execute a report as and when required. If the user chooses to run the report and if the run time parameter has been set up in the report filter criteria, system will prompt the user to enter relevant values and then generate the report.

STEP TWO: Choose a report by selecting the radio button against the report.

STEP THREE: Click “Run Report”.

STEP ONE: Select report type from the drop down menus and click “OK”.

Figure 4.2.1 : Run Report Screen

36



Clicking “Run Report” displays a summary report view on the user screen. Click the hyperlink to see the corresponding details. Info Manager Cash reports can be drilled down right up to the transaction detail level of a single cash transaction.

Figure 4.2.2 : Summary Report view

RR


RR


37


4.3 Print Report

At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user can choose to print the report.

Figure 4.3.1 : Print Report screen

Click “Print” to print the report.

A print preview of the report is displayed on the screen as shown, which can then be printed.

RR


RR


RR


RR


RR


38


4.4 Export Report

Info Manager Cash users can choose to export their reports in either CSV or EXCEL formats. Click “Export Report”. Select the desired file format in the pop-up screen. Click “Export” . Subsequently the user can choose to either ‘Open’ the formatted report output or ‘Save’ it.

Figure 4.4.1 : Export Report screen

Click “Export Report ” to export the report.

Select the desired file format in the pop-up screen. Click “Export” .

RR


39


4.5 Edit Report

Info Manager Cash gives the user complete flexibility to edit an existing report. Choose a report by selecting the radio button against the report name. Click “Edit Report” . The user screen may look similar to screen shot shown below. Edit the selected report to incorporate the changes desired. Click on any tab i.e. Columns and Sorting, Filter Settings and/or Schedule & Delivery to make the required changes. To run the report online click “Run Report”. If records exist for the newly edited report then the report will be displayed on the screen. To save the changes and then run the report, click “Save and Run Report”.

Figure 4.5.1 : Edit Report screen

STEP ONE: Edit description of the Report (optional) .

STEP TWO: Make relevant changes to the report i.e. select columns (attributes) relevant to the change desired, rename column names or specify a new sort order for the selected column names.

STEP THREE: Click “Save Report” to save the changes.

40


4.6 Create Report from Template

Info Manager Cash comes with a handy option which saves the user the hassle from creating a new report from scratch. Just create a copy of one of the existing custom reports and save it. Choose the report to copy and click “Create Report from Template”. The user screen may look similar to screen shot shown below. Enter a new name for the report. A copy of the chosen report is saved with the new name when you click “Save Report” .

Figure 4.6.1 : Create Report from Template screen

STEP ONE: Enter a new name and a suitable description for the Report .

STEP TWO: Select attributes relevant to the new report. Use “Ctrl” key to select more than one column. Optionally you can double click the column names.

STEP THREE: User may choose to rename column names. From the Selected columns list choose the required column and enter a custom name . Click “Rename”.

41


4.7 Delete Report

To delete a report, select the radio button against the report name. Click “Delete Report” . System will ask the user to confirm before deleting the report. NOTE : The user can delete only one report at a time.

STEP ONE: Choose a report by selecting the radio button against the report.

STEP TWO: Click “Delete Report”.

Figure 4.7.1 : Delete Report screen

42


4.8 Share Report

Info Manager Cash gives its user the option to share reports among a group of users. During this process, the Attribute Access Profile (AAP) of the user with whom the report is to be shared, will be checked. If the group user does not have the requisite AAP, sharing will not be allowed and a warning message will be displayed. The schedule and delivery settings of the report chosen for sharing will not be transferred to other users. The user must customize the shared report with schedule and delivery settings to suit individual requirements.



STEP TWO: Click “Share Report”.

43


Share Report ...continued

Figure 4.8.2 : Share Report screen

STEP TWO: Click “Share”.

STEP ONE: Choose the user to share the report.

Figure 4.8.3 : Shared Report Confirm screen

A message confirming successful sharing of the report is displayed on the user screen.

44


4.9 View Report

Info Manager Cash provides the option to its users to view the details of a report. To view a report, select the radio button against the report name. Click “View Report” . A comprehensive view of the selected columns, filters applied and the delivery schedule of the report are displayed.

Figure 4.9.1 : View Report screen

45


SECTION FIVE

Create Alert

46


5.1 Create Alert

Info Manager Cash enables the user to create alerts for cash based transactions. The Create Alert option under Info Manager Cash is designed to send notification to the user when a pre-defined cash activity has occurred. Users may choose to view, edit, copy, share with other users, delete or simply run a selected alert. Select Reports > Info Manager > Create Alerts under Cash Management to create alerts. The user screen may look similar to screen shot shown below.

Figure 5.1.1 : Straight2Bank Create Alert

Select Reports > Info Manager > Create Alerts under Cash Management to create alerts.

47


5.2 Select Product and Sub-Product

Select desired product and sub-product from the two drop down menus. Then proceed to select the various columns of your alert. The alerts generated can be sent via email or fax. At the end of this section, the user will be able to create customized alerts to better mange his cash transactions. In a few simple steps the user may define the alert fields, alert filters, sorting order, alert delivery schedule, alert delivery channel and finally the format for delivery of the customized alert.

Figure 5.2.2 : Selection menu for Sub-Product

Figure 5.2.1 : Selection menu for Product

STEP ONE: Select desired cash product.

STEP TWO: Select relevant sub-product.

STEP THREE: Click “Create Alert”. A screen displaying options for alert creation will appear.

48


5.3 Select Alert Details

Figure 5.3.1 : Alert Details screen

STEP ONE: Enter a suitable name and description for the Alert .

STEP TWO: Select relevant Alert Activity from the list.

STEP THREE: Choose the option of consolidated alert if required. Details of consolidated alert are explained in section 5.4.

49


5.4 Consolidated Alert

Figure 5.4.1 : Consolidated Alert Details

Consolidated Alert is a functionality provided to facilitate consolidation of alerts generated against a specific alert activity resulting in a consolidated report being generated and dispatched via email/fax for the recipient. The timing of the alert is customizable.

STEP ONE: Select “On” if you want to enable Consolidated Alert feature. Consolidated Alert is by default set to “Off”.

STEP TWO: Specify the Start Date and End Date.

STEP THREE: Set frequency per day of the Consolidated Alert . User can choose any value from one time to up to a maximum of four times during a day. Accordingly specify the delivery time of the consolidated alert.

50


5.5 Email/Fax Delivery settings

Figure 5.5.1 : Email/Fax Delivery Details

STEP ONE: Choose Email or Fax Delivery option by enabling corresponding radio button to “On”. If Email is the selected delivery channel then enter email id details where generated alerts will be notified. If selected option is Fax then enter fax number details where generated alerts will be notified. User can select either delivery channel or both.

STEP TWO: Specify subject of the Alert. The ‘Choose From’ column is populated with relevant fields.

STEP THREE: Create a body of content for the email alert. Use the fields listed in ‘Choose From’ column to create a common alert for multiple users.

51


5.6 Alert Filter settings

In this section, the user will be guided to set Filter Settings. Filters enable the user to “fine tune” or narrow down the details which will appear in the Alert. Select filters appropriate for the alert.

Figure 5.6.1 : Alert Filter settings

STEP ONE: Select appropriate filters from the Available Filter Criteria list and using the arrow keys move them to Selected Criteria list. Use “Ctrl” key to select more than one filter. A max. of 10 filters can be selected.

STEP TWO: The Alertt will be based on the filters chosen and listed in the Selected Criteria list.


52


Alert Filter settings ...continued

Depending on the type of filter selected (i.e. text box, numeric, date, etc. as shown in Fig. 6.9) text boxes, list boxes or calendar appropriate for the filters chosen, are displayed.

STEP ONE: Fill in appropriate values for the chosen filter criteria’s. Use % to indicate wildcard characters.

STEP TWO: Click “Save Alert”. A message is displayed on the user screen if the alert has been saved successfully.

Figure 5.6.2 : Alert Filter parameter settings

53


SECTION SIX

Manage Alerts

54


6.1 Manage Alerts

Info Manager Cash enables its user to mange the alerts they have created for various cash transactions. Users may choose to edit, copy, view or delete a selected alert. Select Reports > Info Manager > Manage Alerts under Cash Management to manage alerts previously created. The user screen may look similar to screen shot shown below.

Figure 6.1.1 : Straight2Bank Manage Alert

Users may access reports from Reports > Info Manager > Manage Alerts under Cash Management.

55


Manage Alerts ...continued

The user may select the cash product he desires to manage from the two drop down menus. A list of alerts corresponding to that cash product will be displayed. In addition the user may sort and search alerts by Alert name, Alert Activity and Delivery Channel. Wild card characters e.g. % can be used in the search.

Figure 6.1.2 : Select Cash Product

STEP ONE: Select product.

STEP TWO: Select sub-product.

STEP THREE: Click “OK”. A list of relevant alerts is displayed.

56


6.2 Edit Alert

Info Manager Cash gives the user complete flexibility to edit an existing alert. Choose an alert by selecting the radio button against the report name. Click “Edit Alert”. The user screen may look similar to screen shot shown below. The user may edit the selected alert to incorporate the changes desired. Click on any tab i.e. Email/Fax Delivery and/or Alert Filter Settings to make the required changes. Click “Save Alert” to save the edited alert.

Figure 6.2.1 : Edit Alert screen

STEP TWO: Make the required changes by choosing in Email/Fax Delivery tab or Alert Filter Settings tab. Click “Save” to confirm the changes .

57


6.3 Create Alert from Template

Info Manager comes with a handy option which saves the user the hassle of creating a new alert from scratch. Just create a copy of one of the existing alerts and save it. Choose the alert to copy and click “Create Alert from Template”. The user screen may look similar to screen shot shown below. Enter a new name for the alert. Make all the required changes. A copy of the chosen alert is saved with the new name when the user clicks the “Save” button. A message confirming the Alert has been copied will be displayed on the user screen.

Figure 6.3.2 : Create Alert from Template

STEP TWO: Make the required changes. Click “Save”.

STEP ONE: Enter a new name and suitable description for the alert .

58


6.4 Delete Alert

To delete an alert, select the radio button against the alert name. Click “Delete Alert” . System will confirm before deleting the alert. NOTE : The user can delete only one alert at a time.

Figure 6.4.1 : Delete Alert screen

STEP ONE: Choose an Alert by selecting the radio button against the Alert.

STEP TWO: Click “Delete Alert”.

59


6.5 View Alert

Info Manager Cash allows the user to view the details of an alert. To view an alert, select the radio button against the alert name. Click “View Alert” . A comprehensive view of the columns selected for the alert, filters applied and the delivery schedule of the alert are displayed.

Figure 6.5.1 : View Alert screen

60


SECTION SEVEN

Quick Search

61


7.1 Quick Search

Info Manager Cash offers its users the option to search reports and alerts in the system. Users may base their search on either Product type, Reference number or Reference value or any combination of these values. Select Reports > Info Manager > Quick Search under Cash Management to specify search criteria. The user screen may look similar to screen shot shown below.

Figure 7.1.1 : Info Manager Cash Quick Search

Users may search reports or alerts from Reports > Info Manager > Quick Search under Cash Management.

62


Quick Search ...continued

Figure 7.1.2 : Select product

Figure 7.1.3 : Select Reference No

STEP ONE: Select cash product.

STEP TWO: Select reference number.

63



Figure 7.1.4 : Select Reference Value

STEP THREE: Enter reference value match criteria. Use % to indicate wildcard characters.

STEP FOUR: Click “Search”.

64



User screen may look as Fig. 7.1.5 shown below. Choose a transaction by clicking the corresponding hyperlink to see the details of the transaction.

Figure 7.1.5 : Quick Search Report screen

RR


RR


65


SECTION EIGHT

System Defined Reports

66


8.1 System Defined Reports

Info Manager Cash provides its users a wide range of standard pre defined and formatted system reports. Using these the users can analyze their cash based transactions to make quick and timely decisions. Select Reports > Info Manager > System Defined Reports under Cash Management to access these reports. The user screen may look similar to screen shot shown below.

Figure 8.1.1 : Straight2Bank System Defined Reports

Users may access pre defined system reports from Reports > Info Manager > System Defined Reports under Cash Management.

67


System Defined Reports ...continued

A list of all system defined reports is displayed. The user may choose a report by selecting the radio button against it. Click “Run Report” to execute the selected report. See the following page for details. The user can choose to click “Copy Report from Template” to use the selected report as a template to create a customized report to better suit his personal requirements.



68


8.2 Run Report

Run report provides the user the option to execute a report as and when required. If the user chooses to run the report and if the run time parameter has been set up in the report filter criteria, system will prompt the user to enter relevant values, for the generation of the report. When the user clicks “Run Report” a summary report view is displayed on the user screen. Click the hyperlink to see corresponding details. Info Manager Cash reports can be drilled down to the transaction detail level of a single cash transaction. At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user can choose to print or export the report.

Figure 8.2.1 : Summary Report view

Click “Print” to print the report. Click “Export Report” to export the report in CSV or Excel format.

RR


RR


69


8.3 Create Report from Template

Info Manager Cash comes with a handy option of creating a new report from an existing report. Choose a system defined report and click “Create Report from Template” . The user screen looks as shown below. Enter a new name and description for the report. The user may choose to make changes to the report to suit his requirement. Click “Save” to get a report customized to personal requirements of the user.

Figure 8.3.1 : Create Report from Template screen


STEP TWO: Make changes to any of the fields on the three tabs namely, ‘Columns and Sorting’, ‘Filter Settings’ or ‘Schedule and Delivery’. Click “Save” to save the changes.

70


SECTION NINE

Payables

71


9.1 Payables

Info Manager Cash offers its users the option to view all payments made by them across the Straight2Bank channels using the Payables cash product. Using these details the user can then generate customized Reports and need based Alerts to better manage their cash transactions.

Figure 9.1.1 : Cash Product Payables

The Cash Product Payables has two sub products Payables and Enquiries

72


9.2 Payables and sub product Payables

For Payables-Payables cash product, the drill down facility is provided based on the unique “Payment Reference Number” so that full details of a payment transaction can be viewed. The details are available under two tabs namely, Main Information and Invoices. The user may configure need based alerts through Info Manager Cash. These alerts are triggered when the alert criteria condition configured occurs. Displayed below is a table with alerts that may be created for the cash product Payables-Payables and its description.

Sl No. Alert Activity Description

1. Payment received after cut-off time

This will be triggered when the payment reaches the STS after the cut-off time. In such scenarios the payment will be processed the next day.

2. Payment rejected Whenever the payment is rejected due to some reason which could be invalid back code or swift address etc. this alert is triggered.

3. Payment returned This alert should be triggered after the payment is successfully processed but, the payment is returned for some reason such as beneficiary account mismatch, invalid beneficiary etc.

4. Payment processed successfully This alert must be triggered once the payment is processed successfully and the status code is updated from STS.

In the Quick Search option for Payables cash product depending on the access profile of the user, the following attributes will be listed in the Reference Number field Payment Reference Customer Reference Batch Reference Payment Amount Instrument Number

73


9.3 Payables and sub product Enquiries

For the Cash Product Payables-Enquiries, the user can format a report for all the SWIFT messages created by him from the Straight2Bank Web Channel. The user can create the following messages MT 195 MT199 MT299 Manual MT 195 Manual MT 999 For this sub product all required attributes are displayed in the Summary report and no further drill down facility is provided. Also note that Alerts and Quick Search facility is not extended to this sub product of Payables.

74


SECTION TEN

Receivables

75


10.1 Receivables

The Cash Product Receivables in Info Manager Cash contains all receivables transaction processed in RCMS, originating from Straight2Bank Web, Straight2Bank Access and RCMS Data entry including Charges. The transactions are further classified on the basis of sub product types, namely Paper Instruments, Electronic Instruments, Over the Counter, Returns, Charges and Credit Card.

Figure 10.1.1 : Cash Product Receivables

The Cash Product Receivables has six sub products Paper Instruments , Electronic Instruments, Over the Counter, Returns, Charges and Credit Card

76


Receivables ...continued

Product Sub Product Transaction Details

Receivables 1. Paper Instruments Details of all Cheques received from various Channels and processed in RCMS.

2. Electronic Instruments Details of all Electronic Instruments received from various channels and processed in RCMS.

3. Over the counter Those credits / collections that have directly hit the customer's account, without being processed in RCMS are referred to as Over The Counter trans-actions (e.g.) RTGS, ITT, Cash De-posit, etc

4. Returns Returns

5. Charges Customer Charges computed in RCMS based on the setup

6. Credit Card Only Credit Card related transactions included.

The user may configure need based alerts through Info Manager Cash. These alerts are triggered when the alert criteria condition configured occurs. Displayed below is a table with alerts that may be created for the Receivables Cash Product .

Sl No. Alert Activity Sub Products Level

1. Deposit 1. Electronic Instrument 2. Paper Instruments

1. Batch Level 2. Instrument Level

2. Return 1. Electronic Instrument 2. Paper Instruments

1. Instrument Level

3. Realized 1. Electronic Instrument 2. Paper Instruments

1. Instrument Level

77


10.2 Receivables — Paper Instruments

Cheque based transactions processed in the RCMS (Regional Collections Management System) will be available for reporting under Paper Instruments. Cheques processed “Over the Counter” will be available for reporting under Receivables - Over the Counter. When the user selects the Receivables - Paper Instrument, he will have the option to create the report at the Deposit level or at the Instrument level. His choice will determine the attributes or columns available to him for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.2.1 : Receivables Paper Instruments

78


Receivables — Paper Instruments ...continued

Figure 10.2.2 : Paper Instruments Summary Report View

Clicking “Run Report” displays a summary report view on the user screen.

Figure 10.2.3 : Paper Instruments Detailed Report View

Choose a transaction by clicking the hyperlink. The detailed report view of that transaction will be displayed and the user screen may look similar to the screen shot below.

Receivables - Paper Instrument reports can be drilled down even to the transaction detail level of a single cash transaction. At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user can choose to print the report. Click “Print” and a print preview of the report is displayed on the user screen, which can then be printed. Users can choose to export their reports in either CSV or EXCEL formats. Click “Export Re-port”. Select the desired file format in the pop-up screen. Click “Export” . Subsequently the user can choose to either ‘Open’ the formatted report output or ‘Save’ it.

RR


79


Receivables — Paper Instruments ...continued

Figure 10.2.4 : Receivables Paper Instruments Details

Complete details of the chosen instrument will be displayed under two tabs, namely Main Information and Invoices. A sample user screen is shown in Fig. 10.2.4 below. The Main Information tab contains complete details of the chosen instrument under various heads such as Customer Details, Drawee Details, Deposit Details and so on. The Invoices tab gives the details of invoices attached to that instrument. It is possible to have more than one invoice attached to a single Cheque.

RR


RR


RR


RR


80


10.3 Receivables — Electronic Instruments

Direct Debit transactions will be available for reporting under Receivables - Electronic Instruments. These transactions can have their origin either from Straight2Bank or through RCMS client systems. When the user selects Receivables - Electronic Instrument, he will have the option to create the report at the Batch level or at the Instructions level. For Batch level the user will have the details of DDI as batch. A Batch may have multiple instructions and it is possible for multiple invoices to be attached to a single instruction. Selecting Instruction Level, the user will be provided the details of an individual DDI instruction at the first level summary report itself . His choice will determine the attributes or columns available to him for the creation of the report. The attributes available to a user are based on the AAP of the user creating the re-port. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.3.1 : Receivables Electronic Instruments

81


Receivables - Electronic Instruments ...continued

Figure 10.3.2 : Electronic Instruments Summary Report View

Clicking “Run Report” displays a summary report view on the user screen.

Figure 10.3.3 : Electronic Instruments Detailed Report View

Choose a transaction by clicking the hyperlink. The detailed report view of that transaction will be displayed and the user screen may look similar to the screen shot below.

Receivables - Electronic Instruments reports can be drilled down even to the transaction detail level of a single cash transaction. At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user can choose to print the report. Click “Print” and a print preview of the report is displayed on the user screen, which can then be printed. Users can choose to export their reports in either CSV or EXCEL formats. Click “Export Report”. Select the desired file format in the pop-up screen. Click “Export” . Subsequently the user can choose to either ‘Open’ the formatted report output or ‘Save’ it.

RR


RR


RR


RR


82


Receivables - Electronic Instruments ...continued

Figure 10.3.4 : Receivables Electronic Instruments Details

Complete details of the chosen instrument will be displayed under two tabs, namely Transaction Details and Invoices. A sample user screen is shown in Fig. 10.3.4 below. The Transaction Details tab contains complete details under various heads such as Customer Details and Transaction Details. The Invoices tab gives the details of invoices attached to that instrument. It is possible to have more than one invoice attached to a single Cheque.

RR


RR


RR


RR


83


10.4 Receivables — Over the Counter

Transaction such as Cash Deposits, ITT, Book Transfers and details of all credits processed through back office for example Cheque, cash and credited to the customers account will be available for reporting under Receivables - Over the Counter. Fig 10.4.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Receivables - Over the Counter. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.4.1 : Receivables Over the Counter

84


Receivables - Over the Counter ...continued

Clicking “Run Report” displays a summary report view on the user screen. The user can choose to print the report. Click “Print” and a print preview of the report is displayed on the user screen, which can then be printed. Additionally, the user can choose to export their reports in either CSV or EXCEL formats. Click “Export Report”. Select the desired file format in the pop-up screen. Click “Export” . Subsequently the user can choose to either ‘Open’ the formatted report output or ‘Save’ it.

Figure 10.4.2 : Over the Counter - Run Report View

RR


85


10.5 Receivables — Returns

Transactions details of DDI’s and Cheques returned unpaid will be available for reporting under Receivables - Returns. Fig 10.5.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Receivables - Returns. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.5.1 : Receivables - Returns

86


Receivables - Returns ...continued


Figure 10.5.2 : Returns - Run Report View

Receivables - Returns reports can be drilled down to a further level to the transaction detail level. Choose a transaction by clicking the hyperlink. The detailed transaction will be displayed and the user screen may look similar to the screen shot shown on the next page.

RR


87


Figure 10.5.3 : Receivables -Returns Details

Complete details will be displayed under two tabs, namely Main Information and Invoices. A sample user screen is shown in Fig. 10.5.3 below. The Main Information tab contains details under various heads such as Customer Details, Drawee Details, Deposit Details and so on. The Invoices tab gives the details of invoices attached. It is possible to have more than one invoice attached to a single Cheque.

Receivables - Returns ...continued

RR


RR


RR


88


10.6 Receivables — Charges

Transactions details of charges collected for various receivable transactions such as DDI’s, Cheques collected or returned unpaid which are deposited over the counter or processed through the RCMS will be available for reporting under Receivables - Charges. Fig 10.6.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Receivables - Charges. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.6.1 : Receivables - Charges

89



Figure 10.6.2 : Charges - Run Report View

Receivables - Charges ...continued

RR


90


10.7 Receivables — Credit Card

Customers (Merchants) usually set up credit card instruction to collect payments from clients/customers. Details of these transactions are available for reporting under Receivables - Credit Card. Fig 10.7.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Receivables - Credit Card. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 10.7.1 : Receivables - Credit Card

91



Figure 10.7.2 : Credit Cards - Run Report View

Receivables - Credit Card ...continued

RR


RR


RR


92


SECTION ELEVEN

Working Capital View

93


11.1 Working Capital View

Cash product Working Capital View displays Cash Account details of the Customers. Working Capital View has three sub products, namely Operating Account Statement, Loan Account and Deposit Account. Using the Operating Account Statement cash product the user will be able to view all transactions within the account. Loan details and Deposit details will be accessible through Loan Account and Deposit Account cash products respectively. Users have the option to create customized reports and alerts besides performing a Quick Search on the account.

Figure 11.1.1 : Cash Product Working Capital View

The Cash Product Working Capital View has three sub products Operating Account Statement, Loan Account and Deposit Account

94


Working Capital View ...continued

The user may configure need based alerts through Info Manager Cash. These alerts are triggered when the alert criteria condition configured occurs. Displayed below is a table with alerts that may be created for the cash product Working Capital View and its description.

Sl No.

Alert Activity Description

1. Debit Amount An alert may be set to trigger when the debit amount effected to a customer’s account exceeds or equals the limit set.

2. Credit Amount An alert may be set to trigger when the credit amount effected to a customer’s account exceeds or equals the limit set.

3. Closing Ledger / Available Balances

This alert may be set to trigger when the closing available balances/ledger balances reaches the level set by the customer.

In the Quick Search option for Working Capital View cash product depending on the access profile of the user, the following attributes will be available to perform the Search.

Deposit Account Loan Account Operating Account

Deposit Account No. Loan Account No. Transaction Reference No.

Principal Amount Principal Amount Transaction Date

Maturity Date Maturity Date Amount

95


11.2 Operating Account Statement

Operating Account Statement provides to its users a detailed view of account balance and transactions which have occurred in their account. The users have the flexibility to generate their account statement with a Payable view or Receivable View. The reports displayed have drill down capabilities. The user can see the details of all the transactions or even an individual transaction. Complete flexibility is provided to the user to design report views suiting their personal requirement. For example the user can view his operating account statement and drill down to see all payment transactions as a Payable view with latest status update.

Figure 11.2.1 : Operating Account Statement -Create Report


96


11.2.1 Intra Day, Prior Day or Both

Info Manager Cash enables users to select a filter before creating a report for the Cash Product Working Capital - View Operating Account Statement. The user selects the filter for cash reporting by choosing from Intra Day, Prior Day and Both. Intra Day : Only Current Day transactions are displayed in the report. Prior Day : Only transactions processed and received the previous day are displayed in the report. Both : Transactions received till End of Day of the previous day and transactions of the Current Day received until time of generation of the report are displayed in the report.

Figure 11.2.1.1 : Operating Account Statement -Create Report

STEP TWO: Select type of Report i.e. Intra Day, Prior Day or Both.

97


Depending on the filter selection appropriate column names (attributes) are populated in the ‘Available Columns’ list. System automatically populates some attributes in the ‘Selected Columns’ list. The user can choose to de-select them and move these attributes back to the ’Available Columns’ list. Users may create custom reports with desired columns, suitable filters and schedule to suit individual requirements. Follow the steps given below and then select the next tab, i.e. “Filter Settings”.

11.2.2 Select Columns and Sorting

Figure 11.2.2.1 : Reports—Columns and Sorting

STEP THREE: Select relevant Columns from the list. Use “Ctrl” key to select more than one column. Optionally you can double click the column names.

STEP FOUR: User may choose to rename column names. From the Selected columns list choose the required column and enter a custom name . Click “Rename”.

STEP FIVE: Apply sort order for the selected columns (optional).

98


11.2.3 Select Filter Settings

In this section , the user will set Filters applicable to his report. Filters enable one to “fine tune” or narrow down the details of the data which will appear in the report. Select filters appropriate for the report.

Figure 11.2.3.1 : Reports—Select Filters screen

STEP ONE: Select appropriate columns (filters) from the Available Criteria list and using the arrow keys move them to Selected Criteria list. Use “Ctrl” key to select more than one filter. A max. of 10 filters can be selected.

STEP TWO: Report output will be based on the columns (filters) listed in the Selected Criteria list.


99


Filter Settings ...continued

Depending on the type of column name (filter) selected text boxes, list boxes or calendar, appropriate to fill in data for the filters, are displayed.

Figure 11.2.3.2 : Reports—Filter Settings screen

STEP ONE: Fill in appropriate values for the chosen filter criteria. Use % to indicate wildcard characters.

STEP TWO: Select the Schedule and Delivery tab to set the frequency and mode of delivery of the report. Optionally click “Product Setup”. Use “Reset” to cancel the changes made and start afresh.

100


11.2.4 Run Time Filter Parameter

Now, it's time to specify schedule & delivery details for the reports. Info Manager Cash comes with the additional functionality of Run Time Filter Parameter, where the user specifies the report filters during report creation but has the option to input values for the selected filter criteria during report creation or at report run time, when the system prompts for the same. The Run Time Filter Parameter is set to ‘OFF’ by default. The user has to set this ‘ON’ to use the functionality.

NOTE : Run Time Filter Parameter reports can only be run Online and cannot be

scheduled by the user. Once the Run Time Filter Parameter is set to ‘ON’ the ‘Schedule

and Delivery’ tab is disabled. If the user clicks the tab to schedule delivery of the report a

message is displayed on the user screen, as shown below.

Figure 11.2.4.1 : Reports—Run Time Filter Parameter

101


11.2.5 Select Schedule and Delivery

When the Run Time Filter Parameter is set to ‘OFF’ the user may choose to specify schedule & delivery details for the reports. Click the ‘Schedule & Delivery’ tab. By default the Schedule & Delivery is set 'OFF'. To schedule the report set ’Schedule and Delivery’ to 'ON' .

NOTE : All fields in this dialogue are mandatory. Care should be taken while selecting

options available as every item is critical in proper scheduling and delivery.

Figure 11.2.5.1 : Reports—Schedule & Delivery settings

1. Set the Schedule and Delivery option “ON”. 2. Choose ‘Start Date’ and specify a date for the initiation of report delivery. 3. Select ’End Date’ to indicate end date of report delivery. 4. Set the frequency of report generation, the options available are Daily :will generate the report daily Weekly :for this option you also need to specify the day of the week for report generation Monthly :system will prompt you for a day of the month

102



Figure 11.2.5.2 : Reports—Delivery Format settings

5. Select the frequency per day of the report. The user has the choice to select up to four times a day.

6. Set the time accordingly in hours and minutes for the delivery of the report.

7. Select a delivery format for the report from the drop down menu. Select one of the two available options i.e. CSV or Excel format for delivery.

8. Select one of the available options i.e. Straight2Bank Message, Email or H2H (Host to Host) as delivery channel for the report. These options are explained on the following page.

9. Click “Product Setup”

103



If the user selects Straight2Bank Message option, reports will be generated according to the schedule set and a message will be generated and stored in the Straight2Bank Message centre and can be downloaded at the user’s convenience. If the user selects the Email option, system will provide a text box to enter appropriate email ID for report delivery. Use comma separator to enter multiple email IDs. Validation will be performed on the domain of the email id entered to see if it matches domains registered at the time of Group setup. A message informing Invalid Email Domain will pop up if the domain validation fails. The third option namely, H2H should be selected only if the user has a H2H installation from Straight2Bank. Please verify from the system administrator. If the user selects the H2H (Host to Host) option another drop-down menu is displayed, wherein the user may select the Group ID to which he belongs. A default Group ID will be displayed in the drop-down box. Subsequently, all reports generated for that particular Group ID will be delivered through the H2H channel.

104


Click “Save Report” to save the report. Optionally click “Run Report” to execute the newly created report. Click “Save and Run Report” to save and then run the report.

Info Manager Cash users have the option to drill down from the Operating Account Statement to the corresponding Payment, Collection and Trade Bill instructions initiated through the Straight2Bank channels. When the user clicks “Product Setup” the user screen may look similar to the screen shot below. Depending on the filter selection appropriate column names (attributes) are populated in the ‘Available Columns’ list. The user may choose and move these attributes to the ’Selected Columns’ list to create customized reports with desired columns. User may choose to Save or Run the newly created report. To save the report click “Save Report”. User will receive a confirmation message if the report has been successfully saved. To run the report online click “Run Report”. If records exist for the newly created report then the report will be displayed on the user screen, as detailed on the next page. To save and run the report click “Save and Run Report”.

11.2.6 Product Setup

Figure 11.2.6.1 : Product Setup

105


After the user clicks “Run Report” an account statement summary report is generated and a report similar to the screen shot below is displayed on the user screen. The user may choose multiple transactions by selecting the checkbox against each transaction or optionally click the hyperlink to select a single transaction. For the case illustrated, the user will see a summary report view containing attributes selected during Product setup when he clicks “Payable View”. Depending on the report created the user screen may have the “Payable View”, “Receivable View” and “ Trade View” buttons or any combination of these three. At every stage of the report, whether it is the summary report view, the detailed report view or at the transactional level, the user can choose to print the report. Click “Print All” to print this report. Info Manager Cash users can choose to export their reports in either CSV or EXCEL formats. Click “Export All Report”. Select the desired file format in the pop-up screen and click “Export” . The report will be exported in the chosen file format.

Figure 11.2.7.1 : Run Report screen

11.2.7 Run Report

Click “Payable View” to see a summary report view of the selected transaction/s with attributes chosen during Product Setup.

RR


106


After the user clicks “Payable View” a summary report view containing attributes selected during Product Setup is displayed on the user screen. A screen shot similar to the one shown below may be displayed on the user screen. Click the hyperlink, to choose a transaction and to see its detailed report view (as shown in Fig. 11.9.3 below).

Figure 11.2.7.2 : Payable View


Figure 11.2.7.3 : Payable Details—Detailed View

RR


RR

This has been blanked

RR


RR


RR


RR


RR


RR


107


Details of Loans will be available for reporting under Working Capital View - Loan Account. Fig 11.4.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Working Capital View - Loan Account. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 11.3.1 : Working Capital View - Loan Account

The user is additionally provided the facility to see certain amount fields with reference to a chosen currency (also called as Reference Currency) besides the actual currency of the amount. The reference currency will be based on indicative exchange rates received and updated on a daily basis. The user should select the relevant reference currency attributes during attribute selection.

11.3 Working Capital View - Loan Account

108



Figure 11.3.2 : Loan Account - Run Report View

Loan Account ...continued

1. Principal Amount in Reference Currency

2. Interest Amount in Reference Currency

3. Next Repayment Amount in Reference Currency

4. Next Interest Due Amount in Reference Currency

Attributes available for selection in reference currency are listed below.

109


Details of Deposits will be available for reporting under Working Capital View - Deposit Account. Fig 11.4.1 shows a sample user screen, the user is likely to see when he chooses to create a report for Working Capital View - Deposit Account. The ‘Available Columns’ is populated with attributes or columns available to the user for the creation of the report. The attributes available to a user are based on the AAP of the user creating the report. A set of pre selected attributes will be displayed under the ‘Selected Columns’ list. The user can choose to include additional attributes from the ’Available Columns’ list into his report. He can even customize the display sequence of the attributes in his report by clicking the desired attribute and then manipulating its order using the up and down arrows.

Figure 11.4.1 : Working Capital View - Deposit Account

11.4 Working Capital View - Deposit Account

The user is additionally provided the facility to see certain amount fields with reference to a chosen currency (also called as Reference Currency) besides the actual currency of the amount. The reference currency will be based on indicative exchange rates received and updated on a daily basis. The user should select the relevant reference currency attributes during attribute selection.

110



Figure 11.4.2 : Deposit Account - Run Report View

Deposit Account ...continued

1. Principal Amount in Reference Currency

2. Interest Amount in Reference Currency

3. Interest at Maturity in Reference Currency

Attributes available for selection in reference currency are listed below.

RR


RR


info manager cash guide - standard chartered · info manager cash guide . 2 info manager user guide...

Documents