Navigation Reporting Pane Management Activity v4.1 MA Navigation - - PowerPoint PPT Presentation

navigation reporting pane management activity v4 1 ma
SMART_READER_LITE
LIVE PREVIEW

Navigation Reporting Pane Management Activity v4.1 MA Navigation - - PowerPoint PPT Presentation

Navigation Reporting Pane Management Activity v4.1 MA Navigation Reporting Pane What is the NRP? Navigation Reporting Pane (NRP) is a Front End available to ESA and Industry to access any Contract (normal or Large Contract) or Purchase


slide-1
SLIDE 1

Navigation Reporting Pane Management Activity v4.1

slide-2
SLIDE 2

FINREF

Navigation Reporting Pane (NRP) is a Front End available to ESA and Industry to access any Contract (normal or Large Contract) or Purchase Order. It provides:

  • An overview of the whole Contract / PO (including relevant amounts, e.g.

contract amount, confirmed/invoiced/paid amount) to merge into one view an entire contract both in terms of contract structure and financial envelope

  • Navigation through the Contract / PO and related follow-on documents (e.g.

Good Receipts, Invoices)

  • Extraction of data to Excel

MA – Navigation Reporting Pane What is the NRP?

| Page 2

slide-3
SLIDE 3

FINREF

  • 1. Navigation

The main purpose of the NRP is to synthesize even complex contracts into one unique view to immediately display basic data of the contract and financial information. Starting from consolidated data, drill down will then allow simplified navigation to all contractual and financial documents.

  • 2. Reporting

The NRP does not replace any existing reports. It is an additional reporting tool, which shows (consolidated) financial information on a contract/purchase order

  • 3. Improved usability and performance

Most transactions in esa-p are about querying contractual or financial information that may be complex in SRM, involving many steps. The NRP improves usability and performance of data queries and extractions.

  • 4. Access by Industry

NRP is also available for Suppliers, with the same visibility rules adopted when accessing the contract/purchase order in SRM

Important Note: NRP has no impact on the current procurement solution for setting up contracts / purchase orders and creating/submitting invoices and GRNs for approval in SRM

MA – Navigation Reporting Pane NRP Key Functionalities

| Page 3

slide-4
SLIDE 4

FINREF

MA – Navigation Reporting Pane Management Activities

NRP supports following highlighted procurement related management activities:

| Page 4

slide-5
SLIDE 5

FINREF

For a better use of the NRP following features are provided:

  • „Showing and hiding‟ and „Resizing‟ functionality to remove redundant

information

  • „Filtering‟ functionality on pre-defined set of criteria to remove not needed

information

  • Tooltips showing complete Business description of the fields
  • „Expand and Collapse‟ functionality to drill down to the relevant Contract and

POs information

MA – Navigation Reporting Pane NRP Usability Functionalities

| Page 5

slide-6
SLIDE 6

FINREF

“Expand and Collapse”: Icons are showing node status:

  • Closed
  • Opened
  • Final node

“Filtering”: Hiding documents in a selected range of statuses or types Reporting: Document number and item number are divided by a dot “Navigation via hyperlink”: Icon to hyperlink to SRM object “Resizing”: Resizable columns

MA – Navigation Reporting Pane NRP Layout - 1

“Showing and Hiding functionality”: Hiding closed items in order to facilitate navigation of the active part of the contract

NRP Functionality (1 of 2)

“Refresh”:

Changes in the Contract/PO

  • r related follow-on

documents, made simultaneously while using NRP, become visible through the use of the Refresh button. | Page 6

slide-7
SLIDE 7

FINREF

MA – Navigation Reporting Pane NRP Layout - 2

Page 7

“Expand and Collapse”: Collapse All / Expand All Button “Expand and Collapse”: The file icon means that the end of the tree branch is reached and can reflect both a milestone or a follow on document Excel: Download NRP data to excel “Filtering”: Presence or absence of funnel symbol is informing on filter status (active/not active)

NRP Functionality (2 of 2)

“Filtering”: Closed Items are easily filtered out. Closed items are:

  • PO lines with final

confirmation and invoice

  • Historical milestones

“Tooltip”: Moving the cursor above a field it will show the complete business description which is useful (especially for item type column) “Filtering”: Show or hide all filter functionality

| Page 7

Advance Payments”: Information is loaded only by user request

slide-8
SLIDE 8

FINREF 1) „Hierarchy‟ This column represents the hierarchy of the PO, by clicking on a folder node it is possible to expand or collapse the node. On the right of the icon the corresponding document number and item number is shown. 2) „Details‟ By clicking on this icon the SRM document corresponding to the row is opened in a separate window 3) „Item Type‟ It shows the Item type of the object. A list of the item types and corresponding description is available at page 9 pages are not there, please insert them 4) „Title/Reference‟ For Confirmation and Cancellation it represents the „Confirmation Name‟ field, for Invoice and Credit Memo it represents the „External Invoice Number‟ field for remaining objects it represents the „Title‟ field 5) „Vendor Name‟ It is the Vendor Name of the corresponding object. 6) „Vendor Code‟ It is the Vendor Code of the corresponding object. 7) „Active PO amt‟ This column shows the amount of the contractual objects (Milestone, MPPs and Contract) including historical milestones 8) „Draft PO amt‟ This column shows the amount of the contractual objects (Milestone, MPPs and Contract) of the contract changed version (if existing). For Industry users this column is always equal to „0‟ for confidentiality reasons. 9) „Confirmed amt‟ It shows the sum of the Confirmations/Cancellations in status Posted in backend linked to the node (or the Confirmation amount in case of Confirmation/Cancellation

  • bjects regardless of the status)

10) „Invoiced Net amt‟ It shows the sum of the Invoices/Credit Memos in status Posted in backend, Paid or Cancelled linked to the node (or the Invoice amount in case of Invoice/Credit Memo

  • bjects regardless of the status)

11) „Paid amt‟ It shows the sum of the Paid SRM invoices (cleared) linked to the node. 12) „APR amt‟ This column shows Advance Payment Request documents amount in status Posted in backend or Paid linked to the node (or the Advance Payment Request amount

  • bjects regardless of the status) created for the milestone to which they belong.

13) „Advance Payment Paid ‟ The column shows the Advance Payments paid for the item to which they belong (useful in case of Advance Payments performed prior to the introduction of the Advance Payment Request documents in esa-p ). The amounts in this column are shown only once the „Load APR Data‟ link in the upper left section of the panel is launched. 14) “Curr‟ It shows the currency of the corresponding object. 15) „Status‟ It shows the status of the corresponding object in SRM 16) „Substatus‟ It shows the substatus of the object in SRM (applicable only to Confirmation/ Cancellation/ Invoice/ Credit Memo)

MA – Navigation Reporting Pane Column Definition

| Page 8

slide-9
SLIDE 9

FINREF

1.Milestone amounts are aggregated into the higher hierarchical level regardless of the status (ordered/saved/awaiting approval,…). 2.Amounts related to “Ordered” CTR/PO are shown in the “Active PO Amt” column while amounts related to CTR/PO in any other status (except “Deleted”) are shown in the “Draft PO Amt” column. 3.Milestones with changed amount are colored in order to draw attention on them 4.Amounts related to Confirmations and Cancellations with status other than "posted in backend" are not aggregated at higher level 5.Amounts related to Invoices and Credit Memos with status other than "posted in backend" , “cancelled” or "paid" are not aggregated at higher level

  • 6. Amounts related to Advance Payments Requests with status other than “posted in backend” or “paid” are not aggregated at higher

level. 7.In case of Confirmations and Cancellations split on more than one line item (e.g. issued against more milestones in POs), each position is shown as a specific line below the related milestone. 8.In case of Invoices and Credit Memo split on more than one line item (e.g. invoices issued against POs), each position is shown as a specific line below the related milestone. 9.Incidental cost are summed up to the invoice amount 10.Invoice tax is not included in the invoice amount 10.Each single PO is reported using only the PO defined currency. Should any child PO use a different currency, it is converted into Parent currency just for the calculation of the aggregated amount at contractual line level. Relevant date for detecting conversion exchange rate is the approval date of each PO. 11.Aggregated amounts are not affected by any filtering action 12.Extract to Excel is not affected by any filtering action 13.In order to avoid wrong field definition in Excel export some columns are transferred into Excel with a „ as starting character 14.In case of parent-child contracts if the parent contract is opened with the NRP the full structure is opened. If a child component is selected the specific PO is shown in the NRP.

MA – Navigation Reporting Pane Important rules

| Page 9

slide-10
SLIDE 10

FINREF

Item type Business Description Z1_PRIME_V Outline Prime Vendor Z1_SUB_CR Outline Subcontractor Z1_MPP Milestone Payment Plan (MPP) Z3_MAT_IT Material Item Z3_MIL_IT Milestone Z4_FRAME Frame Contract line (Value) Z4_FRAME_Q Frame Contract line (Qty) Z4_MPP Parent Contract line Z2_LOL Limit of Liability (LoL) Z2_LOL_NOI Limit of Liability (LoL) w/o GRN/ INV Z3_SML_IT Shadow Milestone Z1_DCPL Development Cost Plan Z3_DEVC Development Cost Z3_INC Incentive Fee Z3_ESC Escalation settlement Z3_HIST_IT Historical Milestone

Conversion Table – Item & Document Types vs. Business Objects

MA – Navigation Reporting Pane Item Types

Item type Business Description CONF Confirmation INV Invoice CANC Cancellation CRME Credit Memo ADV Advanced Payment APR Advance Payment Requests

In the third column of NRP called “Item Type” Technical name of item type is given. Tooltip shows the business description:

| Page 10

slide-11
SLIDE 11

FINREF

Launch NRP NRP can be accessed in two ways: 1.Via POWL (Procurement Order Work List) 2.Via direct Portal hyperlink Difference between both ways is that:

  • By accessing the NRP in the POWL, user is able to look for a Contract / Purchase Order via standard

available queries. After result from query it is only possible to have a single selection on a single PO, a stand alone Contract or a Large Contract

  • By accessing the NRP via Portal hyperlink a custom selection screen is opened where it is possible to run

NRP for a multiple selection of a number of PO‟s. To do that, the following actions has to be performed. Main Step:

  • Launch NRP

MA – Navigation Reporting Pane How to Access the NRP

| Page 11

slide-12
SLIDE 12

FINREF

Summary

  • In this section you have learned how to query, access and navigate through

Contracts, Purchase Orders and related follow-on documents. Output/Result

  • NRP shown in your screen

MA – Navigation Reporting Pane

| Page 12