There may come a time when there is a mismatch in the accounting between your companies’ invoice and Walmart’s payments. Walmart uses codes to identify deduction types. These codes appear in EDI as well as on the check remittance to indicate the deduction type. The first step in resolving any issues is to lookup the listed code to see if the claim is legitimate or if there is a discrepancy. A list of these codes is below.
If you find your records indicate these charges not to be legitimate, the first step is opening a dispute in the resolution portal. Walmart handles these on a claim by claim basis traditionally but should you find these claims to begin to become overwhelming it is possible to join a program that allows for bulk upload of claims and documentation on a quarterly or monthly basis.
The most common reason for an adjustment is 22 Merchandise Billed not Shipped. Some steps that can be taken to reduce these claims are below:
Adjustment Reason Codes – Paper Codes cross-referenced to EDI Codes | ||
Paper Code | Definition | EDI Code |
001 | DEFECTIVE | F1 |
002 | RETURN RECALL | 15 |
003 | UNSELLABLE MERCHANDISE | GG |
010 | PRICE DIFFERENCE AS DOCUMENTED | 01 |
011 | PRICE DIFFERENCE BETWEEN P.O. AND INV | 01 |
012 | INVOICE INCORRECTLY TOTALED/EXTENDED | 03 |
013 | SUBSTITUTION OVERCHARGE | A5 |
014 | TRAILER SEAL INTACT | 06 |
015 | PALLETS/SHRINKWRAPPED | 06 |
020 | CONCEALED DAMAGE | 06 |
021 | CONCEALED SHORTAGE | 06 |
022 | MERCHANDISE BILLED NOT SHIPPED | 59 |
023 | CARTON SHORTAGE SL&C | 06 |
024 | CARTON SHORTAGE FREIGHT BILL SIGNED SHORT | 06 |
025 | P.O.D./NO MERCHANDISE RECEIVED FOR INVOICE | A9 |
026 | CARTON SHORTAGE — MIS-ROUTING CHANGED FOB | TI |
027 | CARTON DAMAGE — SL&C | 06 |
028 | CARTON DAMAGE — FRT. BILL SIGNED DAMAGED | 06 |
029 | CARTON DAMAGE — MIS-ROUTING CHANGED FOB | TI |
030 | DUPLICATE BILLINGS | 19 |
031 | P.O. NUMBER NOT ON INVOICE | MH |
032 | MULTIPLE P.O. NUMBER ON INVOICE | MF |
033 | P.O. NUMBER INCORRECT ON INVOICE | MG |
034 | PALLET CHARGE | 10 |
035 | SALES TAX – STATE | 55 |
036 | SALES TAX – CITY | 55 |
037 | INSURANCE | DO |
038 | STOP-OFF CHARGE INCORRECTLY ADDED TO | 30 |
039 | FREIGHT COST ON BACKORDER | MC |
040 | ROUTING VIOLATION — EXCESSIVE FREIGHT | B8 |
041 | COLLECT — SHOULD HAVE BEEN PREPAID | SO |
042 | BACKHAUL/PICKUP ALLOWANCE | MB |
043 | MDSE. S/B COMBINED FOR LOWER FREIGHT COST | RJ |
044 | FREIGHT ON RETURNED MERCHANDISE | RL |
045 | PREPAID FREIGHT INCORRECTLY ADDED TO INVOICE | 21 |
046 | FREIGHT ALLOWANCE | RB |
047 | EXCESSIVE FREIGHT CHARGE ON INVOICE | SF |
048 | FREIGHT SHOULD BE PREPAID TO CONSOLIDATOR | 21 |
049 | FREIGHT COST TO FORWARD MISROUTED SHIPMENT | 54 |
050 | ALLOWANCE NOT GIVEN OFF INVOICE | 71 |
051 | ALLOWANCE NOT GIVEN OFF INVOICE | A8 |
052 | ALLOWANCE NOT GIVEN OFF INVOICE | D5 |
053 | ALLOWANCE NOT GIVEN OFF INVOICE | D5 |
054 | ALLOWANCE NOT GIVEN OFF INVOICE | ZZ |
055 | ALLOWANCE NOT GIVEN OFF INVOICE | A3 |
056 | ALLOWANCE NOT GIVEN OFF INVOICE | 89 |
057 | QUANTITY DISCOUNT | D5 |
058 | OTHER ALLOWANCES | OT |
059 | ALLOWANCE NOT GIVEN OFF INVOICE | 82 |
060 | HANDLING CHARGE AS DOCUMENTED | 97 |
061 | INCORRECT COLOR/SIZE ALLOWANCE | 37 |
062 | LABOR AND HANDLING — | 98 |
063 | B/L ADDRESSED TO WRONG LOCATION | 40 |
064 | EARLY SHIPMENT | RH |
065 | LATE SHIPMENT | 99 |
066 | NO P.O. NUMBER ON CARTON | MP |
067 | INCORRECT P.O. NUMBER ON CARTON | MN |
068 | P.O. NUMBER NOT ON BILL OF LADING | ME |
069 | INCORRECT P.O. NUMBER ON BILL OF LADING | MD |
070 | NO ITEM NUMBER ON CARTONS | MO |
071 | INCORRECT ITEM NUMBER ON CARTONS | MM |
072 | LABOR AND HANDLING — TICKETING/RE-TICKETING | C9 |
073 | DUPLICATE PAYMENT | 86 |
074 | PREVIOUS ACCOUNT — DEBIT BALANCE | E1 |
075 | TRANSFER OF DEBIT BALANCE | MI |
076 | BUYER’S RESERVE | C4 |
077 | OVERPAYMENT OF INVOICE AMOUNT | WO |
078 | STORAGE CHARGES | MQ |
079 | SAMPLE CHARGES | GD |
080 | CASH DISCOUNT | 76 |
081 | ANTICIPATION — VENDOR REQUEST | FA |
082 | ANTICIPATION — EARLY PAYMENT OF INVOICE | FA |
083 | DISCOUNT NOT TAKEN AT TIME OF PAYMENT | D6 |
084 | INTEREST ON RECOVERY OF PAYMENT IN ERROR | L5 |
085 | INTEREST ON OVERPAYMENT | RU |
086 | EXCISE TAX | 55 |
087 | OTHER | ZZ |
090 | UNAUTHORIZED CHARGE — SYSTEM DEDUCTION | D3 |
091 | MERCHANDISE DESTROYED — DAMAGED/DEFECTIVE | 93 |
092 | MERCHANDISE RETURN — OVERSTOCK/RECALL | 15 |
093 | MERCHANDISE RETURN — DAMAGED MERCHANDISE | 04 |
094 | MERCHANDISE RETURN — DEFECTIVE MERCHANDISE | F1 |
095 | MERCHANDISE RETURN — WRONG ITEM | A2 |
096 | MDSE. FOR REPAIR/ASSEMBLY — NOT RETURNED | B5 |
097 | RETURNED MERCHANDISE HANDLING CHARGE | 97 |
150 | SOFT GOODS DEFECTIVE ALLOWANCE | 82 |
151 | PURCHASE REBATE ALLOWANCE | B2 |
152 | WHOLESALE CLUB ALLOWANCE | 28 |
161 | PURCHASE REBATE ALLOWANCE | B2 |