Skip to main content

B0067 NCAS vs SAP Crosswalk

Purpose

The purpose of this report description is to explain how to generate the B0067 NCFS vs SAP Crosswalk report. 

Report Description

This report shows the components of the North Carolina Financial System (NCFS) cost distribution that have been cross walked to the SAP system. It shows the budget code (SAP fund application), Fund Type (NCFS -GASB), SAP Fund, Funding Source, Cost Center, Order Number, and Financial Key. The NCFS to SAP crosswalk information will be included in this report if position(s) have been budgeted for the cost center in SAP.

Report Location

FI: Payroll Financial Data

Report Uses

  • This report displays a comparison so that agencies can review their cost distribution by business area, between NCFS and SAP.
  • This report can assist agencies in identifying that all distributions are correctly documented in both systems for proper financial account posting for salaries, and/or other payments.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts.  All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory).  Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.

The Mandatory prompts for this report are:  

  • Organizational Unit
  • Calendar Month/Year (Single Value, Mandatory)

This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as optional in parentheses beside the prompt.   

The Optional prompts are: 

  • Business Area(s) – (Optional)
  • Fund Type(s) (GASB) – (Optional)
  • Application of Fund(s) (Budget Code) – (Optional)
  • Fund(s) – (Optional)
  • Funding Source(s) – (Optional)
  • Cost Center(s) – (Optional)
  • Order(s) – (Optional)
  • Financial Key(s) – (Optional)

Initial Layout

The report lists all postings for the prompt values selected. Below is a sample of the initial layout rendered.

The Report Info tab displays information about the prompts entered. 

Available Objects 

This is a list of the available objects that can be added to the report, once in Design mode:  

Dimensions

  • Addl. Center Ref.
  • Agency Id
  • Application of Fund
  • Budget Fund
  • Budget Funding Source (OSBM)
  • Business area
  • Cal Mth/Yr
  • Cost Center
  • Financial Key
  • Fund
  • Fund Type
  • Funding Source
  • NCAS Account
  • NCFS Account
  • NCFS Agency
  • NCFS Agency Program
  • NCFS AMU
  • NCFS Budget Code
  • NCFS Budget Fund
  • NCFS Funding Source
  • NCFS Interfund
  • NCFS Project
  • NCFS User Define 1
  • NCFS User Define 2
  • NCFS User Define 3
  • Order
  • Order Type
  • SAP GL Account

Variables

  • Prompt Response Application of Fund
  • Prompt Response Business Area
  • Prompt Response Calendar Month/Year
  • Prompt Response Cost Center
  • Prompt Response Financial Key
  • Prompt Response Fund
  • Prompt Response Fund Type
  • Prompt Response Funding Source
  • Prompt Response Order
  • Prompt Response Organizational Unit
  • DOT NCFS AMU
  • DOT NCFS Budget Fund

Special Report Considerations/Features

  • This report excludes positions in the range 62000000 – 64999999.
  • NCFS Accounting Segments - are available for reporting in this report as drag and drop from Available Objects.
    • NCFS accounting segments here are specific to an NCFS internal order in SAP HR/Payroll ERP system. Transactions with no NCFS internal orders will not display values for the NCFS segments in the BI BOBJ report.  
      • NCFS Agency, NCFS Agency Program, NCFS AMU, NCFS Budget Code, NCFS Budget Fund, NCFS Funding Source, NCFS Interfund, NCFS Project, NCFS User Define 1, NCFS User Define 2, NCFS User Define 3
  • Agencies (like NCDOT, DES and DWS) that do not use NCFS Internal Orders will not see the values for the above NCFS segments in reports.
  • NCFS Account and Budget Funding Source (OSBM) are available for reporting. Values are in the corresponding crosswalk to SAP GL Account and Funding Source in SAP HR Payroll system.
  • Financial Key is representative of internal order from NCFS and old NCAS systems.
  • NCDOT (NC02) specific fields DOT NCFS AMU and DOT NCFS Budget Fund are listed as BOBJ Variables in this report and are derived from NCDOT cost centers and Person Responsible (Addl Center Ref) values from SAP HR Payroll ERP system.

First Published

Last Updated