Lowe’s provides vendors with the opportunity to receive product activity data via EDI 852. The EDI 852 data is used to report actual unit sales, on-hand, on-order and order receipts. Vendors are expected to use the data to identify items deserving increased service levels and fill rates as well as those targeted for inventory reduction. Lowe’s requires vendors to document how the data will be used and how it will benefit both parties.
Item activity can be received for all items by location. This detailed data can be very useful if the vendor has the tools to process the data and quickly analyze activity. The key is to have the tool do the work, so your administrative team is not stuck with hours of data manipulation in Excel, or worse yet, on printed reports.
Lowe’s provides the following fields on their EDI 852 files: quantity sold units, quantity sold dollars, quantity on-hand units, quantity on-hand dollars, quantity on order units, quantity on order dollars, quantity on requisition from RDC units, quantity on requisition from RDC dollars, quantity received units, quantity received dollars, requisition quantity received units, requisition quantity received dollars. Not all fields are always populated in all files.
Sales units and sales dollars will match between EDI 852 and Lowe’s Vendor DART. But inventory on hand units may be different due to damaged inventory. Vendor part numbers are not transmitted in EDI 852. Only the Lowe’s SKU number is sent. Canadian EDI 852 is transmitted in Canadian Dollars and US sales are transmitted in US dollars. Note that Vendor DART is not available for Canada.
Related posts
