Financial snapshot extraction

Use this function to obtain real-time top-level financial overviews, snapshots, of one or multiple projects, for one company or for all companies.

A financial snapshot is based on the actual financial status of a project relative to its budgets. It provides similar figures to those provided for a project financial overview.

To extract data for a single project, you can access this functionality directly from that project.

Snapshot headers need to exist for the projects before you can use this fucntion. Refer to the Financial snapshots function (GESPJMSNP) documentation which describes how to create a "snapshot header".

Prerequisites

See also Refer to documentation Implementation

Screen management

The Financial snapshot extraction function contains a single screen in which you define your snapshot extraction selection criteria.

See also Financial snapshots function (GESPJMSNP) to view the extracted data.

Entry screen

You use this screen to filter or select the projects to be included in the financial extraction run.

A "snapshot header" sets the parameters for a financial extraction. A snapshot header is a prerequisite to running a snapshot extraction. It comprises the project code, the financial view to extract, the unit, and the currency to use each time the data extraction is requested.

You can use this function to extract project financial data as needed after a snapshot header is created.

Extracted snapshot data is added to the list of snapshots in the Financial snapshots function (GESPJMSNP).

Each time you extract snapshot data, the Financial status sections of the associated project and the cost structure are synchronized with the extracted data if the FINOVERSYN-Updated fin. status/snapshot parameter (TC chapter, PJM group) is set to Yes and the Revenue recognition checkbox (REVRECFLG field) is selected for a snapshot header. If the ESTPRGSYNC-Updated est. progress/snapshot parameter (TC chapter, PJM group) is set to Yes, the estimated progress percentage of the project, the project budget, and the operational task (Estimated progress (%) fields) are updated.

As a snapshot is real time, each new snapshot you obtain overwrites a previous snapshot created on the same date. Similarly, each new snapshot you obtain refreshes 1: the project and cost structure financial status, if the FINOVERSYN-Updated fin. status/snapshot parameter (TC chapter, PJM group) is set to Yes and the Revenue recognition checkbox (REVRECFLG field) is selected in the snapshot header, 2: the estimated total revenue for the project, if the ESTREVSYNC-Updated est. revenue/snapshot parameter (TC chapter, PJM group) is set to Yes and the Revenue recognition checkbox is selected in the snapshot header, 3: the estimated progress percentage of the project, the project budget, and the operational task, if the ESTPRGSYNC-Updated est. progress/snapshot parameter (TC chapter, PJM group) is set to Yes.

Criteria

All companies (field ALLCPY)
Indicates that all companies are included. To run the process for a single company, leave the checkbox clear.
Company (field CPY)
The company code. You can only access this field if the All companies checkbox is clear.
All snapshots (field ALLSNP)
Indicates that all snapshot codes are included. To run the process for a single or a range of snapshot codes, leave clear.
From snapshot (field SNPCODF)
Extract data for a range of snapshot codes. To extract data for a single snapshot code, enter the same code in the From snapshot and To snapshot fields. You can leave the From snapshot field blank to extract data for all snapshot codes.
All projects (field ALLPRJ)
Indicates that all projects are included. To run the process for a single or a range of projects, leave clear.
From project (field OPPNUMF)
Filter for results within a range of project codes. For a single project, enter the same project code in the From/start project and To/end project fields.
Revenue recognition snapshot (field REVRECFLG)

Indicates that the snapshot needs to recognize project revenue, otherwise leave clear.

The method your project will use to calculate the values is defined in the Revenue recognition rule field (RRCC) in the General section, Financials block on your project.
Financial view (field PCCGRP)

The financial view to link to an SQL query. Select a view code from the codes activated in the 388—Financial view miscellaneous table. For example, for an expense view select view 10 or a revenue view, select view 20.

By default, the 388 miscellaneous table enables data tracking on selected financial views such as expenses and revenue. The 388 table therefore controls which financial overview data can be displayed.

Project management includes standard, or master SQL queries for both expense and revenue financial overviews. Delivered by default with your solution are master SQL queries for Financial views 10 (expenses) and 20 (revenue). You can modify these master SQL queries, or create new SQL queries from scratch to suit your organization, your processes or your users. You are advised, however, to get a basic understanding of how your system works before changing a master query.

Sage advises that you save a copy of a master SQL query before modifying it.
Launched projects only (field LCHDPRJ)
Indicates that only projects that are launched are included. To run this process for all projects at all stages of the project cycle, leave clear.
Exclude closed projects (field CLSDPRJ)
Indicates that closed projects are excluded. To include closed projects, leave clear.
Log file (field LOGFILE)
Indicates that a detailed log file of the run is needed. If you do not require a log file, leave blank.

Batch task

This function can be run in batch mode, but no dedicated standard task is delivered to run it.

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation