RUSA Weekly Open Invoice & MISC Report: Location Changes and Denials
How to work the report that Rexel sends with their updates.
Overview
Travis sends the report back with his updates in column B (AFS LocNo/Acct#). Use it to correct the location (branch) on RUSA invoices, then queue them for processing. If column B contains only a location number, the invoice just needs to be moved to that location.
Location changes are made in the Batch Update Utility (database: Freight Payment), using the Branch Location listing on the P Drive.
Before you start
- The report from Travis with his updates in column B
- The Branch Location listing on the P Drive
- The location prefix rules in the LocNo cheat sheet at the end of this article
- Access to the Batch Update Utility (and PowerGrid, if denying Parcel invoices)
Process order
Start with LTL invoices. They have one extra step (updating the Gexpro bill recipient). Then follow the same location-and-queue steps for all invoices.
LTL invoices only: update the Gexpro Bill Recipient
- In the Batch Update Utility, choose the Freight Payment database.
- Set the update type to Gexpro Update Bill Recipient in the Support Docs. This updates the Bill Recipient value to the new value.
- Fill in the spreadsheet columns: Loc_No, SCAC, ProBillNo, New_Bill_Recipient.
- For New_Bill_Recipient, use the 4-digit branch number Travis provides in column B.
- Click Process.
All invoices: update the location
- In the Batch Update Utility, choose the Freight Payment database.
- Set the update type to Change Location. This changes the assigned location for the specified pro #.
- Fill in the columns: LocNo, SCAC, ProBillNo, NewLocNo.
- Click Process.
Note: Change Location cannot be used on bills that are already paid.
All invoices: set the invoice to Queued
- In the Batch Update Utility, set the update type to Change Status to Queued. This changes the status of the specified pro bill(s) to Queued, clears the status reason field if it is blank, and resets the business rule flag.
- Fill in the columns: LocNo, SCAC, ProBillNo, StatusReason, Comments.
- Click Process.
Note: Change Status to Queued cannot be used on bills that are already paid.
Denying invoices
How you deny an invoice depends on the type:
|
Invoice type |
Where to deny |
Requirements |
|
Parcel |
PowerGrid |
|
|
LTL |
Batch Update Utility |
A LOA (letter of authorization) from the responsible party is required. Leave comments. |
RUSA LocNo cheat sheet
Location numbers use a Division-Branch format, for example GEX-1832. The prefix is determined by the branch number:
|
Branch number |
Prefix |
Division |
|
1832, 1833, 1834, 1838 |
GEX- |
Gexpro |
|
All 7### |
GEX- |
Gexpro |
|
All 6### |
MAY- |
Mayer Electric |
|
All 59## |
RES- |
Rexel Energy |
|
5075, 5180, 5180z, 5183, 5195 |
PLTDC- |
Platt Electric (DC) |
|
All other 5### |
PLT- |
Platt Electric |
|
All 1###, 2###, 3###, 4### |
REX- |
Rexel USA |
Tips:
- The four 18## branches listed under Gexpro are exceptions to the general 1### = REX rule, so check them first.
- The specific PLTDC branches are exceptions to the general 5### = PLT rule.
- In spreadsheets, enter MAY locations as 'MAY (with the leading apostrophe).
Quick checklist
- Report from Travis received; column B reviewed
- LTL invoices: Gexpro Bill Recipient updated first
- Location changed for all invoices (correct prefix per cheat sheet)
- Invoices set to Queued
- Any denials handled in the right system (PowerGrid for Parcel, Batch Update Utility for LTL with LOA and comments)