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 inaccordance with te Debt Managment Serving Center (DMS) accepted format.

Prerequisites
Records must been previously marked "Eligible for Offset" using theUpdate Treasury Offset Statuses report.

Features

• The report can be run in test mode.

If you select it, all existing "Eligible for Offset" records thatsatisfy the selection criteria are displayed on ALV. On save, theTreasury Offset File is created and saved to file entered on selectionscreen.
If you do not select it, the program the Treasury Offset File is createdand 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 offsetdate. Reason is the same as for why we have the key date: typicallysuch reports run at month end, but since they are part of month-endclosing, 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 offthe key date (example: the last day of the month even though we arealready into the following month).

• Customer BAdI named "RFFMFG_TREA_OFFSET" supplied .

Method GET_DATE_FIELD - Define date used in ageing calculation. Thedelivered default code sets the baseline date as the default date usedfor the ageing calculation.
Methods CONTROL_RECORD, DEBT_INFO, and INDIVIDUAL_DEBTOR_INFO -allows the agency to put data in the required file format. The methodscorrespond to the sections of the Agency File Format "Control Record","Debt Information" and "Individual Debtor Information". They have beenset up in this manner to ease the creation of an implementation for theend-user in putting agency's data in correct format. The delivereddefault code fills the Treasury Offset File Format to fulfill JFMIPrequirements. We recommend that your agency use the default code be usedas 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 monthend. Selection allows user to enter the last day of the month eventhough they could be already in the following month.
Test Run

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 ofreocord downloased inot Treasury Offset File.

Activities
You can start this report by running transaction RTREAS_OFFSET_FILE.