Ansicht
Dokumentation

RFFMFG_UNFILLED_ORDERS - Sales Order Adjustment Program

RFFMFG_UNFILLED_ORDERS - Sales Order Adjustment Program

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

A reimbursable agreement is a planning document between a Federal Government agency and another entity, where the delivering agency supplies goods or services to the other entity whom it may then bill.

Like purchase orders, sales orders should be monitored throughout the year, especially at year-end, and updated based on obligations, expenses, billings, and so on. Based on the stage of the internal fund and the sales order ending date or period of performance date, the sales order will be reduced or will have excess line item values transferred to new lines.

This program was initially designed as part of year-end processing, but can be run at any other time if needed. It is designed to process Sales and Distribution (SD) orders relating to reimbursable agreements and its function is to update sales orders (unfilled orders).

In addition, budget values must be updated and any down payments must be updated or returned.

The link between the customer order and the obligations is provided by the funded program, fund, and budget period, if applicable.

Values for the Obligations column are defined in the Customizing steps listed below under Customizing.

The program can be used in the following scenarios:

  • Project closing
If the overall project is ever terminated or closed, any excess funding (unfilled orders) from the customer must be returned.
  • Periodic closing (fiscal year end)
Due to limited availability of Federal funding (annual funds, multi-year funds, and so on), closing actions are associated when the fund expires. The options are:
  • Closing - that is, reducing the line item and adjusting any down payment - when agency (provider) funds expire (based on fund master data).

  • Closing - that is, reducing the line item and adjusting any down payment - when the customer's funds expire (based on the Sales Order Contract End Date or Period of Performance dates).

The Obligation amount can be increased by a specified percentage. This percentage cannot be greater than 99. If the resulting Obligation amount is greater than the value of the Sales Order line, the Obligation amount is made equal to the Sales Order line.

Integration

Prerequisites

Features

The program processes the documents corresponding to the reimbursable orders with reference to the selection criteria.

The status of the internal fund is checked using the Check Date (Fund/Contract) on the selection criteria. If the internal Federal fund expires the program reads the customer order line item, finds the obligation amount, and reduces the sales order line items for expiring funds to the obligated amount. If there is no obligation against the customer order, the amount is reduced to zero. In addition, if the customer's fund does not expire, the program creates a new line item(s) with the excess value from the reduced line(s). The creation of new lines can be suppressed by unchecking the Generate New Lines box on the selection screen.

The status of the internal fund and the external customer's fund will be checked using the Check Date (Fund/Contract) on the selection criteria.

Every reimbursable agreement should have has its own WBS/funded program or internal order/funded program combination. In other words, one WBS/funded program or internal order/funded program should not be used in multiple Sales Orders. If several reimbursable agreements share a WBS/funded program, this program retrieves all the orders in question, even though the selection criteria could may have just one reimbursable agreement.

To accommodate end-of-year processing and to update Funds Management (FM) in two different fiscal years, the program can use different posting date and document date when reducing the line item on the expiring fund and when creating a new line item in the new year. Configuration (FM Derivation based on validity dates) is necessary in order to use a different account assignment when creating the new line. In addition, derivation is available so that you can use a different WBS element or internal order on the new line.

Selection

  • Company Code
  • Sales Order (From - To)
  • Sales Order Document Type (From - To)
  • Contract Start Date (From - To)
  • Contract End Date (From - To)
  • Fund (From - To)
  • Budget Period
  • Fund Status (Unexpired, Expired, Cancelled, All Status)
  • Date to check fund and contract status
  • Funded program (From - To)
  • Posting Date for Lines Reduced
  • Posting Period for Lines Reduced

  • Document Date for Lines Reduced

  • Posting Date for Lines Generated

  • Posting Period for Lines Generated

  • Document Date for Lines Generated

  • Generate New Lines
  • Obligation % Increase
  • Test Mode flag
The program can be run in test mode or production mode. In test mode, all the reductions are simulated. On the other hand, production mode has a "Save" button. When you use this, the reductions are recorded to the database.

Standard Variants

Output

If you run the program in production mode, you have two extra columns you do not see when you run it in test mode. These two columns are open for you to enter values and change the way the report calculates the value to be returned. These two columns are as follows:

  • New Order Quantity
Allows you to change the original order Quantity but it will not affect the value to be returned.
  • Additional Obligation Amount
Any amount entered in this field/column increases the overall obligation amount of the sales order line item (Obligation = Obligation + Additional Obligation Amount). You could use this field if, when you run the program, you are still expecting some other purchase orders, vendor invoices, or any other expense against the reimbursable order and you want to include it in your run.

Activities

Reimbursable Orders

Define Reimbursable Orders

Sales Order Adjustments

In Customizing, choose Public Sector Management -> Functions for US Federal Government -> Integration -> Sales and Distribution -> Sales Order Adjustments, then work the following steps:

This configuration is required to define which types of documents are to be included in the Obligation columns. If nothing is defined, the program returns no results.
Use this to exclude certain document types from the Obligation column.
Use this to exclude certain document types from the Obligation column.
Use this to exclude certain document types from the Obligation column.
Create derivation strategies to define WBS or internal orders to be used on the new Sales Order Line.

Example






RFUMSV00 - Advance Return for Tax on Sales/Purchases   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 9020 Date: 20240601 Time: 102932     sap01-206 ( 145 ms )