From the Deductions Summary, you can click View all deductions to gain insights about deduction reasons and view details by PO Number, Invoice Number, or Check Number. These details and insights can help you spot trends so you can decide if action is needed.

• The data in the Deductions table is updated at the beginning of each month, and there is a 1-month lag. For example, the data at the beginning of February 2024 shows deductions as of December 2023.

View Deductions

1. In the left navigation menu, click Performance and select Deductions.

   

2. In the Deductions by master group and category section, click View all deductions at the top right corner.

   

3. By default, each page in the table shows 25 deductions. Click the arrows below the table to navigate to the previous / next page or jump back / forward. You can hover over any column header and click the arrow to sort the data.

   

4. To search for specific deductions, select PO Number, Invoice Number, or Check Number. Then, copy and paste the corresponding number(s) in the search bar. Click the magnifying glass icon to apply your search.

   

5. Click Filters to narrow down the results.

   

   Make your selections for Deduction Category and/or Deduction code. Click the Apply button to apply your selections.

   

Download Deductions

You can download data for up to 10,000 deductions. Use the filter to narrow down the results, or select individual deductions using the check boxes in the table.

Then, click the Download all button.

If you select individual deductions (or click Select Page), click the Download selected button.

The file will look like this example.

Download History

The Download History panel displays each deductions download you have requested in Supplier One. If your file didn't download automatically, click the download icon next to the date and time of your request.

Terminology

Term	Definition
Supplier Number	The 6-digit number assigned to you during Supplier Onboarding (e.g., Vendor ID in the example below).
Assigned Dept Number	The 2-digit Merchandising Department Number. Also known as the Accounting Department Number (1-99).
Dept Sequence	The 1-digit (0-9) sequence to identify the 9-digit Supplier Number (i.e., Agreement Number). Also known as the Sequence Number.
Division	Identifies the area of the operating business (e.g., Walmart, Sam's).
Store Number	The Internal Accounts Payable Store Number.
AP Dept Number	The Internal Accounts Payable Department Number. Appears as Dept Number on the check.
PO Number	The number assigned to an official authorization for purchasing merchandise.
PO Date	The date (mm/dd/yyyy) of authorization for purchasing merchandise.
Invoice Number	The assigned invoice number.
Invoice Date	The date (mm/dd/yyyy) of the assigned invoice number.
Gross Amount	The total amount of the transaction.
Reason Code	The reason type code that corresponds to the description of an adjustment that was taken/given.
Deduction Code	The reason type code that corresponds to the description of an adjustment that was taken/given.
Deduction Description	See Deduction Reasons below to learn more.
Currency Exchange	The currency code of the transaction (e.g., USD).
Check Number	The actual number on the check that was issued.
Check Date	The date (mm/dd/yyyy) the check was issued.
Check Amount	The actual amount issued on the check.
Control Number	The microfilm number that the microfilm department in accounting requires when requesting backup for a deduction.
Batch Number	This column will be removed in a future release.
Deduction Source	The identified business area to initiate the transaction: Electronic Data Interchange (EDI) Accounts Payable (AP) Accounts Receivable (AR) Post Payment Audit (PPA) Coops/Deals DPX (Claims) Accounts Receivable - not yet billed (AR SL)
Fiscal Month	The Walmart fiscal month of the transaction posted.
Fiscal Quarter	The Walmart fiscal quarter of the transaction posted.
Fiscal Year	The Walmart fiscal year of the transaction posted.
Deduction Category	The grouping identifier for related deduction transactions: Allowances Cash Discount Charges/Taxes Cost PO Credit Memo from Supplier Discounts Duplicates Freight Handling Margin Other Overpayment Penalty POD Pricing Returns Cost Returns Handling Short/Damaged Supplier Penalty Error Violation

Deduction Reasons

A list of the deduction codes and descriptions (also known as claim codes and labels) is available in Supplier Academy:

1. Go to Retail Link and click Academy.

   

2. Under Quick Learning Articles, click Getting Paid.

   

3. Under Accounts Payable, click Accounts Payable and Deductions Guide.

   

4. In the pop-up window, click Accounts Payable and Deductions Guide and scroll down to page 44 to view the list.

   

Have Questions or Need Help?

If you experience any issues using Supplier One, 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 that best describes your experience.