SM Product Transfer/Resale-EDI 867 Report overview

Sales Manager > Reports > SM Reports > SMRVT

Function acronym: SMRVT

Use this report to send vendors an EDI 867 document that provides information about the sales and transfers of vendor's product.

This information is available for vendors:

  • Which of their products you have sold
  • Who you sold the product to
  • Which products have been transferred
  • Which warehouse received the product
  • Which division is associated with an order

When you run this report, you can generate ION BOD, EDI flat file, or XML output. EDI and XML output is only valid in on-premises Distribution SX.e. ION BOD output, as XML files, is processed by Infor ION. ION BOD output is valid in CloudSuite Distribution. This output is also valid in on-premises Distribution SX.e if your company uses ION Messaging Service (IMS) to connect to Infor ION.

EDI and XML output is saved to one of these directories:

  • Outbound EDI directory that is specified in SA Company Setup
  • EDI flat file directory that is specified on the report

XML files, both ION BOD and XML output, are based on the SXInventoryMovement BOD, but XML output is not processed as a BOD.

XML files support the fields that are included in the EDI flat file and additional fields. All sales, price, and cost values in XML files are represented in the currency specified on your SA Company Setup record.

See the Infor Distribution SX.e Setup and Administration Guide for EDI to view the fields that are supported by the EDI flat file format. See the Infor Distribution SX.e Outbound BOD Mapping and Descriptions to view the contents of the BOD and the fields that are supported by the XML file.

If you output to EDI, the report generates one flat file. If you output to ION or XML, the report generates one XML file for each sales order invoice or shipped warehouse transfer. Because this report processes numerous transactions, we recommend that you run this report during off hours.

The Alternate Product Group setting on Product Setup or Product Catalog Setup records affects output. If an alternate product group is specified on one of these records, the report generates output for the product only if Report to Supplier on the SA Table Code Value Setup-Alternate Product Group record is selected. The output does not include the alternate product group value.

See the Infor Distribution SX.e Setup and Administration Guide for EDI for setup information.