1

Procedures to retrieve rebate deduction (REBxxxxxxxxxx) support from Vendors.com

Go to Vendors.com and click

on “E-Tools”

2

Click on the Tool Box icon

3

Enter your Vendor ID and Password

4

Click on “ADW Reporting”

5

After reading the agreement, click “I agree”

6

Click on the “Vendor Rebates” tab

7

Click on “W-VSTX-V0001 – Vistex Reporting”

8

1. Click on “Report Type” to indicate whether to retrieve summary or detail support to the rebate

deduction (the default is Detail).

2. Enter Vendor Reference Doc #. Use the invoice number from Vendor AP data as the vendor

reference document # (e.g., REB0330000001).

3. Click “Submit”

Note: The default report format for the

download is Excel. The report as can be

submitted in PDF, HTML and CSV format.

Make sure to select the

Detail type for all

invoices included in the

rebate calculation.

9

Click on “Close”

10

Click on “Yes” to close the window

11

Go back to the “Vendor Dashboard” main screen

1. Click on the “Report Status” tab

2. Click on the “Enable Refresh” checkbox

3. Once the report has changed to “Completed” status (previously either “Queued” or “Running”

status) click on “View” to open the report (the default format is Excel unless changed in report

specifications screen). Note that the report runtime will depend on the amount of data being

retrieved.

1

2 3

12

Sample detail report

Agreement Description: Vistex field containing Vendor #, Rebate Type, Agreement #, Settlement Frequency (M1-

monthly, M3-quarterly, M6-semi-annual, Y1-annual)

Ace Agreement Number: Vistex assigned agreement number

Buyer Code: Ace’s buying department

Purchase Type: Indicates whether this was a drop ship or warehouse purchase

PO Number: The purchase order number

PO Date: The purchase order date

SAP Invoice Number: Ace’s internally generated invoice number

SAP Billing Document: Ace’s internally generated billing document number

Vendor Invoice Number: The vendor’s invoice number

Invoice Date: The vendor’s invoice date

Gross Rebate Eligible: The total amount of the vendor’s invoice line items that are eligible for the rebate

Cash Discount: The amount of cash discount for the eligible invoice line items (if applicable per contract terms)

Net Rebate Eligible: The Gross Rebate Eligible column less the Cash Discount column

Manual Adjustment: The amount of any manual adjustments

Net Rebate Amt Deducted: The calculated rebate amount. The total amount is the A/P deduction.