DSV Payment History Report

Updated 1 month ago ​by Merch Transformation Change Management

The DSV Payment History Report allows you to view the past purchase orders you fulfilled as a Drop Ship Vendor (DSV) and the amount you were paid for each order. To see the details of your checks, see the Review Payment Details in Retail Link section of this article. 

The 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.

Download Your Payment History Report

  1. In the left navigation menu, click Payments and select Payment history.
  2. If you have multiple supplier IDs, select one to download the report. If you only have one supplier ID, it will be selected by default. Select a Distribution Center and Report Date from the drop-down menus.
    These selections are required to enable the Download Report button in the next step. 
  3. Click the Download Report button. Your file may take a while to download if you have a long payment history. The system will automatically begin downloading a file that starts with "WMI_DSVAP”. This report contains a record of past purchase orders at the selected distribution center.

The DSV Payment History Report shows you a breakdown of the POs that you shipped for the Report Date. To view the check details, follow these instructions:

  1. Log in to Retail Link and click Apps. Select APIS - Accounts Payable Inquiry System.
  2. In the APIS - Accounts Payable Inquiry System, click Checks in the top navigation menu. Then, enter your Supplier Number and click the Search button.
    1. If you want to view payment details within a specific date range, you can enter them in the First Invoice and Last Invoice fields.
  3. DSVs should select a check number with a date that is 1 or 2 days later than the Report Date you selected in Supplier One. For example, if the detail PO report was generated on May 14th in Supplier One, the check will be generated on May 15th or 16th in Retail Link. 
  4. Click the link under the Check Number column to open a window with the Check List Details. You can click the To Excel button at the top right corner to open the information in Excel and save it for your records. To locate your DSV payment, look under the Store Number column for 3539. Invoice numbers for DSV payments are 14 digits (YYYYMMDD + your 6-digit Supplier Number).

Have Questions or Need Assistance? 

If you experience any issues viewing your Payment History Reports (e.g., your invoice is missing), please click "Help" in the top navigation menu and select "Manage tickets" to file a case ticket. Or, select "Chat" to get real-time help from our chat bot or click "Search articles" to search Supplier One HelpDocs. 

Make sure to select the issue type Payments and the issue subtype (e.g., Invoice status).

For detailed instructions, refer to Manage Case Tickets.

How did we do?