Reports

Updated 3 weeks ago ​by Merch Transformation Change Management

The Reports page in Supplier One consolidates important reports in one place so you can download and view them easily. To download reports, make sure to apply filters first to get the data you want.

If you are looking for the previous DSV Payment History Report, it has moved to this Reports page and been renamed. Find it under Payment and Sales > DSV Shipped Orders Report. The report is still only for DSV suppliers.
  1. In the left navigation menu, click Reports.
  2. Click Learn More for information about premium reports with Scintilla that provide additional sales, cost, and forecasting information (plus more).
  3. Reports are organized by area, such as:
    1. Cost & pricing: Vendor managed pricing
    2. Payments: Paid invoice details, Unpaid invoice details, 90 days paid detail, Store sales (free Scintilla report), E-commerce sales (free Scintilla report)
    3. Inventory, Orders and Fulfillment: E-commerce In-stock, Purchase Orders (Scintilla Charter membership required), OTIF (Scintilla Charter membership required)
  4. For downloadable reports, click Download and continue to Step 5.
    For free Scintilla Reports, click View Report.
    To view premium Scintilla Reports, you must have Charter membership. If View Report is disabled, click Unlock with Charter membership to learn more about Scintilla options.
  5. Apply filters from the available options (refer to the table below) and click Download.
    If you select today's date and get a blank download, try selecting a previous date before downloading again.

Filters for Downloadable Reports

Area

Report

Filters

Cost & pricing

Vendor managed pricing

  • Supplier ID
  • Store numbers
  • Enter item numbers

Payments

Paid invoice details

  • Report date (mm/dd/yyyy)
  • Supplier ID

Payments

Unpaid invoice details

  • Report date (mm/dd/yyyy)
  • Supplier ID

Payments

90 days paid detail

  • Supplier ID

Payments

DSV Shipped Orders Report

  • Supplier ID
  • Distribution center
  • Report date

Inventory, Orders and Fulfillment

E-commerce In-stock

  • Supplier ID

DSV Shipped Orders Report

The DSV Shipped Orders Report allows you to view past purchase orders that you fulfilled as a Drop Ship Vendor (DSV) and the amount you were paid for each order.

To see the details of your checks, refer to the Payment History in Supplier One.

While the DSV Shipped Orders Report lists all POs that will be paid for the cost of goods, it's important to note the following:

  • Walmart will only pay on POs that are updated to Shipped status in Walmart's system.
  • Walmart does not accept any invoices for the cost of goods payments.
  • Any canceled, backordered, discontinued, or unrecognized POs will not be paid. Requests to be paid for these POs may be rejected.
  • All payments will be paid based on the terms of your Walmart contract.

Terminology

Term

Definition

Purchase Order #

The identifier for the purchase order.

Distribution Center

The name of the distribution center (DC) that the items in a purchase order were shipped from.

Distribution Center ID

The identifier for the distribution center (DC) that the items in a purchase order were shipped from.

Date Marked as Shipped

The date that you sent the items in a purchase order. This is formatted as YYYYMMDD (e.g., June 20, 2023 = 20230620).

Amount Paid to Vendor

The amount that you were paid by Walmart for the items in a purchase order.

Downloading the DSV Shipped Orders Report

Your file may take a while to download if you have a long list of shipped orders. The system will automatically begin downloading a file that starts with "WMI_DSVAP”. This report contains a record of past shipped orders at the selected distribution center.


How did we do?