SM Product Transfer/Resale-EDI867 Report ranges and options

Ranges

See Ranges.

Specify a range of vendors, dates, warehouses, divisions, or order numbers to determine which information is included on the report. Optionally, specify a list of vendor on the Options page.

Options

Enter Days to Allow Backward

Specify the number of days to subtract from the run date to determine which transactions to select.

If you use this option, it overrides the Date range. If you do not use the range or this option, all data is reported from day one.

EDI Flat File Directory

Leave this field blank.

Report Records With Zero Quantity?

Select Yes to send all records, regardless of the quantity, based on the ranges and options selected.

Select No to send only those records with a quantity shipped or returned that does not equal to zero, based on the ranges and options selected.

(S)ale, (V)endor/Whse Sale, (T)ransfer

For ION and XML output, this option affects the content but not the format of the files. For EDI output, this option affects both the contents and format of the file.

This option determines what data is included in the report, what data is sent, and the sort order.

Specify S to generate sales order line (OEEL) data and sort the file by vendor, by order.

Specify V to generate sales order line (OEEL) data and sort the file by vendor, by warehouse.

Note:  When kits are sold and the SM Product Transfer/Resale-EDI 867 Report is run to report sales of a vendor’s product, the ARP vendor from the kit component’s Product Warehouse Product Setup record is used.

Specify T to generate warehouse transfer line (WTEL) data and sort the file by vendor, by warehouse, including information specific to interbranch transfers.

Totals By Vendor - EDI output only?
Select Yes to track the number of line items for each vendor. A new header and SA Company Setup User Defined record is created for each vendor encountered.

If you select Yes for this option, specify V or T for the (S)ale, (V)endor/Whse Sale, (T)ransfer option.

XML Only - Include Serial Number?

Select Yes to include product serial numbers in the ION and XML output.

Include the Sell Price?

Select No to exclude the sell price of each product from the report. This value is customer’s price for the product specified on the sales order line.

Individually Price KP/VA Components?
Select Yes to determine prices of the components based on the customer and component. Select No to use standard logic to determine component prices.
Include VA Components?

Specify whether you want to include VA components on the EDI 867 Point of Sale document that is generated by the SM Product Transfer/Resale -EDI 867 Report.

If you select Yes, components are included in the output if these conditions are met:

  • The component is sourced in Sales Order Entry to a VA order.
  • EDI 867 on the Value Add Transaction Entry header is selected.
  • The VA section line component is from an inventory component (IN) or internal process (IT) type section.
  • The VA section line component has the same Product Warehouse Product Setup ARP vendor for a stocked component, or in the case of a nonstock component, is sourced from a vendor as the specified on the report.
Note: If you sell a fabricated item that exists in stock and has a VA Product Default Setup record, the component list from the VA Product Default Setup record is used to report components on this report. If the VA Product Default Setup record is modified between the time the VA fabricated items are built and sold, the component list reported reflects the VA Product Default Setup record and may not be the exact items used when the fabricated item was built. For example, a component may have been purchased from a different vendor.
Enter a List of Vendors?

To specify vendors to receive output, select Yes, and then click List to specify the vendors to include on the report. The vendors that you specify for this option override the vendor range values.

Report Only Sales without Vendor Rebates?

If you use the SM Rebate Report, you can avoid reporting duplicate data to vendors by retaining the default value for this option.

Select Yes to include products with an associated Vendor on Sale rebate on the report. Rebates with a zero value are not included.

Output to EDI, XML, or ION?

The output method for each vendor can be specified on the vendor record. The output method specified for this option is used only if the Product Transfer/Resale (EDI 867) field in Vendor Setup-eCommerce is blank.

Specify I to generate SXInventoryMovement BODs.