Kontakt

Ansicht
Dokumentation

US Federal Agencies' Centralized Trial Balance System II (Changed) ( RELNPSM_20_FACTSII )

US Federal Agencies' Centralized Trial Balance System II (Changed) ( RELNPSM_20_FACTSII )

General Material Data   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

US Federal Agencies' Centralized Trial Balance System II (Changed)

Use

The US Federal Agencies' Centralized Trial Balance System II (FACTS II) feature has been developed for use by US Federal Government agencies. It is a system maintained by the Financial Management System Service of the US Treasury. Agencies are required to report quarterly their U.S. Standard General Ledger (SGL) budgetary account trial balances and selected proprietary account balances to Treasury using this system. FACTS II subjects the balances to a series of edits which have been replicated in the R/3 environment. The edits test for proper account attributes and relationships. SF-133 and TFS-2108 reports have now been replaced by the data reported to the FACTS II system.

FACTS II processing consists of the following steps:

  1. Extract data from the ledger or run the extract.
  2. Upload the Master Accounts File (MAF) from Treasury and maintain it.
  3. Run the edits. If there are any errors, post adjusting transactions. Return to step 1 and continue.
  4. Maintain footnotes.
  5. Send data (consisting of the edited data and footnotes) to Treasury.
  6. Reporting

Note that the order of steps 1 and 2 can be interchanged and so can the order of steps 3 and 4. The rest must be carried out in the order in which they are listed.

Functionality exists in IS-PS 4.62 for FACTS II. However, it is designed to meet the FY 2001 requirements and does not handle all of the possible data configurations, such as many funds referring to a single application of funds. Treasury has issued new requirements for reporting data in FY 2002 .

As of SAP R/3 Enterprise Public Services 2.0, the programs have been redesigned to include FY 2002 requirements.

Changes to attributes:

  • Transfer Agency. Two-digit code. Every valid Department Code is a valid value for this field. Treasury will validate against edit tables.
  • Transfer Account. Four-digit code. Every 4-digit main account that is valid for a given Department is a valid value for this field. Treasury will validate against edit tables.
  • Advance Flag. One character field. Values are P (Advanced in Prior Year), F (Advanced from Future Year) and X (Not applicable) and space. This can be derived using a combination of SGL account and fund.
  • Defense Indicator. Values: DEF (Defense) or NND (Non-defense) or space. In most agencies, this can be derived using SGL account.
  • Year of Budget Authority. NEW (to track outlays from new budget authority) or BAL (to track outlays from balances brought forward from a previous year) or space. This attribute is associated with all budgetary accounts that represent outgoing payments for no-year funds.
  • Authority Type. New values in addition to existing: D for Advance Appropriation; L for Proceeds of Loan Asset Sales with Recourse, R for Re-appropriaiton.
  • BEA Category Indicator. New value in addition to existing: E for Emergency.
  • Borrow Source. New value in addition to existing: F for Federal Financing Bank.
  • Transaction Partner. New values and definitions replace the old ones:
  • ·,,E for Non-federal exceptions

  • ·,,F for Federal

  • ·,,X for Non-Federal

  • Changes to Input Fields
  • ·,,Legislation (LEGIS) field from the header of FM budget documents. This field is no longer used as of FY 2002. However, it is still included in the bulk file sent to Treasury, but blank-filled.

  • ·,,Non-zero values in the field COHORT are used only if the agency manages loan programs. Cohort should be added by extending the FI coding block using existing techniques . This would make cohort available on FI, MM, and other such transactions.

  • Changes made to FACTS II programs:
  • FACTS II Trial Balance - The field LEGIS removed from report and the following fields were added Transfer Agency, Transfer Account, Year of Budget Authority, Advance Flag, and Defense Indicator.

  • FACTS II Extract - The format of the bulk file, which is the ultimate output of the SAP FACTS II process changed.

The program no longer hard codes the apportionment category B detail field to be 001 if the apportionment flag on the record equals #B# and 000 otherwise. The program has been updated to accommodate multiple category B apportionments (each in a separate fund) within a single TAFS, which would require the detail field to be 001, 002, and so on. If the funds apportionment category is B, the first 25 characters of the fund Description field are placed in the Apportionment Category B Text field of the FACTS II Bulk Extract File for those accounts that report apportionment category B. In addition, a new BAdI iFMFG_FACTS2_CATB' has been added to allow users to specify the detail number and text for each fund. (The system defaults to 001 for this field for accounts that require a value in it.)
Originally, the data extract was written so that the fund code had to be the same as the application of funds code. This has since been changed so that they can have different values. Other changes were made to handle having multiple funds associated with a single application of funds.
  • FACTS II - Upload MAF File - The format of the MAF file, which is an input file that comes from Treasury and is used in editing, was updated. The program to upload was also updated to accomodate changes.

  • FACTS II Edits - An attribute edit and Edit 10 Canceled Authority have been added to the program. In addition, Preparer ID and Application of Funds were added to the selection screen. The resultant list has been changed to allow easier analysis of the edits that have passed or failed.

  • FACTS II Footnote - Function added to enable you to know on the front screen whether or not a footnote has been entered for a particular account detail record.

  • The FACTS II Transaction Register should be run using transaction FMFG_E_TRANS_REG. This newly created report (program RFFMFG_TRANS_REG) replaces the old report (RFMUSFG_FACTS2_TB) run by transaction RFACTS2_TR. This report can display the transaction registers of ledgers 95, 96 and 97. You can maintain the different views on the ledgers by preconfiguring ledger-specific reporting layouts.

  • FACTS II Trial Balance - The following fields were added to the ALV list: trading partner, profit center, BL status, subkey, funds center, funcded program, transfer agency, transfer account, year of budget authority, advanced flag, and defense indicator.

Effects on Existing Data

Effects on Data Transfer

Effects on System Administration

Effects on Customizing

Additional customizing required as a result of these changes: you must configure Edit 10 and the attribute edit.

Further Information






ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 8209 Date: 20240523 Time: 081626     sap01-206 ( 143 ms )