Show TOC

 Monitoring Quantity Differences Between Sales and Purchasing

Use

You can use report SDMFSTRP to create a list of all sales orders with third-party order items for which there are discrepancies between the quantities ordered, invoiced, canceled, or credited in Sales and the quantities ordered, invoiced or credited in Purchasing.

Prerequisites

You have materials that were processed in third-party orders.

Features

You can restrict the selection to certain orders and a specific time period.

If you select List all open quantities , the system also displays all third-party transactions with open quantities in Purchasing or Sales.

Note that the quantity in the purchasing or sales documents is displayed in the unit of measure used in that document. The totals are always specified in the base unit of measure.

A third-party order for 10 pieces of a material gives rise to a purchase order of 10 pieces. Three pieces were delivered in the first delivery and this has been billed to the customer. The vendor sends a credit memo for three pieces so that the open quantity is 10 in the purchasing document and 7 in the sales document.

The report lists all the documents that belong to this transaction and specifies the quantities that are contained in the documents.

Activities

To run this report, proceed as follows:

  1. Choose Start of the navigation path Tools Next navigation step ABAP/4 Workbench Next navigation step on the initial screen. End of the navigation path

  2. Choose Start of the navigation path Development Next navigation step ABAP/4 Editor. End of the navigation path

  3. Enter the report name SDMFSTRP in the program field and choose Execute.

  4. You reach the selection screen.

  5. Enter the interval of sales orders and the time period which you want to monitor.

  6. Choose Start of the navigation path Program Next navigation step Execute. End of the navigation path

You receive a list of all third party orders for which quantity discrepancies exist between Purchasing and Sales.