Kontakt

Ansicht
Dokumentation

RFFMFGT_OFFSET_FILE - Create Treasury Offset File

RFFMFGT_OFFSET_FILE - Create Treasury Offset File

BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Title

Accounts Receivable Reported to Treasury for Offset

Purpose

This report creates a file containing account receivable records marked "Eligible for Offset". The generated file contains records formatted in accordance with te Debt Managment Serving Center (DMS) accepted format.

Integration

Prerequisites

Records must been previously marked "Eligible for Offset" using the Update Treasury Offset Statuses report.

Features

  • The report can be run in test mode.
  • If you select it, all existing "Eligible for Offset" records that satisfy the selection criteria are displayed on ALV. On save, the Treasury Offset File is created and saved to file entered on selection screen.

  • If you do not select it, the program the Treasury Offset File is created and saved to the file entered on selection screen.

  • During file creation, the status of the records on the database are changed from "Eligible for Offset" to "Referred to Treasury, Uncollected". In addition, the key date is saved as the Treasury offset date. Reason is the same as for why we have the key date: typically such reports run at month end, but since they are part of month-end closing, they are not run until maybe a few days into the next month (volume of month end activities, missing billings, missing payments,...). Therefore the report, as well as the file, should be working off the key date (example: the last day of the month even though we are already into the following month).
  • Customer BAdI named "RFFMFG_TREA_OFFSET" supplied .
  • Method GET_DATE_FIELD - Define date used in ageing calculation. The delivered default code sets the baseline date as the default date used for the ageing calculation.

  • Methods CONTROL_RECORD, DEBT_INFO, and INDIVIDUAL_DEBTOR_INFO - allows the agency to put data in the required file format. The methods correspond to the sections of the Agency File Format "Control Record", "Debt Information" and "Individual Debtor Information". They have been set up in this manner to ease the creation of an implementation for the end-user in putting agency's data in correct format. The delivered default code fills the Treasury Offset File Format to fulfill JFMIP requirements. We recommend that your agency use the default code be used as a template by the agency when creating your implementation.

Selection

The selection screen consists of:

  • Required fields:
  • Company code

  • Document Age Limit in Days

  • Path and Filename

  • Optional fields
  • Key Date - A report of this type is typically run at or after month end. Selection allows user to enter the last day of the month even though they could be already in the following month.

  • Test Run

Standard Variants

Output

  • The output is dependent on the option you select for "Output File Option" (see "Features" above).
  • An application log summarizes the total number of records downloaded, number of debtor records downloaded and the total dollar amount of reocord downloased inot Treasury Offset File.

Activities

You can start this report by running transaction RTREAS_OFFSET_FILE.

Example






General Material Data   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 4134 Date: 20240601 Time: 055814     sap01-206 ( 72 ms )