Dickson Auto Parts Command Center
Not logged in

Home

Pick a section — the bubbles up top work from anywhere.
🧾

Create RGN

Ask NAPA for a credit on our own paper — auto RGN, one-time or every month / quarter / year.

Open →
🧾

Store Portal

Submit and track credit requests for any store.

Open →
📋

Office Review

Credit requests, unapplied DC credits and reconciliation.

Open →
📈

Sales & Delivery

Live sales, projections, quotas and delivery by store.

Open →
🧮

Vendor Bills

NAPA vendor invoices reconciled against post-account receipts.

Open →
🏷️

Pricing

Pricing tools — brake pricing calculator, with more to come.

Open →
⚙️

Admin

Users & Access, and Report Printing — which TAMS reports print to which printer each morning.

Open →

Admin

Pick an area to work in.

🖨️

Report Printing

Pick which TAMS reports print each morning and to which printer — printers by IP address, per store, with a log of every print.

Open →
👥

Users & Access

Add people and control the stores and sections each one can see.

Open →

🖨️ Report Printing

loading…

Every TAMS report prints to the ghost printer and lands in the Report Manager archive. Each morning at 5 AM the box sends the reports you pick for each printer. Click a printer to choose its reports.

Printers

Click a printer to pick the reports it prints.

Reports this printer prints

Report not listed?

Recent prints

Inventory

Pick an area to work in.

🚚

Factory Direct

Discount earned, fill rate and order cycle on every factory direct PO — live from the DC archive, with the receive log.

Open →
📦

Min Max Review

What each store's MIN / MAX should be from its own sales history — raise, lower or set up, with the per car floor and std pack. Every line, refreshed monthly.

Open →

🎯 Store Scorecard

One page on one store for the monthly meeting — sales, delivery and store discipline, every measure ranked among the stores. Top third green, middle third amber, bottom third red.

Loading…

📊 To-Do Scorecard

How each store is keeping up with its To-Do cards — one line per store, by District Manager. Click a store to open its To-Do list.

Loading…

🧾 Create RGN

Credits we ask NAPA for on our own paper — the RGN is generated here, not read off a document. One-time, or every month / quarter / year.

Request a new RGN
Describe the credit, say how much and whether it repeats. The RGN # comes from the store's counter the moment it's created — the same series the Over $100 returns and Cores use — and goes on the Returned Goods Notice NAPA gets, so the DC credit matches itself in RGN Tracking.
MISC Credit (MC) is the default — it goes to the MISC Credit log with a 14-day clock.
How much
Same amountkey it once
Varies — ask meemailed for the figure
Based on purchases% of what we bought
Based on sales% of what we sold
The request is created with this figure every time.
Schedule
Supporting documents — optional, as many as you need
📎 Drop files here or click to choose — PDF, photos, Excel, Word, emails. Several at once is fine.
Attached to the request in RGN Tracking (📎 on the row) and included with the RGN sheet email. On a recurring RGN they ride along on every request it creates.
RGN
from the store counter👁
Assigned the moment the request is created · a recurring schedule takes a new RGN every month · 14-day clock for MISC Credit
It lands in RGN Tracking like any other request.
Recurring RGNs
Each one makes a new request — with a fresh RGN — on its day every month, quarter or year (the daily run is 7:10 AM). Edit, pause, run early, or end.
What forStoreTypeAmountEveryNextLast created
Auto-RGN credits in RGN Tracking
Every request this screen created — one-time ones and each copy of a schedule. They are ordinary rows in their type's log too; this is the view of them together.
RGN #CreatedStoreTypeWhat forRequestedCredit receivedDueStatusFrom
RGN # = ours, from the store counter · 👁 shows the Returned Goods Notice (the PDF once the box has drawn and emailed it) · enter amount on a varies RGN keys it here (the people asked got an email link to the same thing) · status, Complete and Dampening are the shared rules.

📋 To-Do

How you're doing up top, past-due work next, then daily tasks on the left and special tasks on the right. Click a row for the details; tick the box when it's handled.

📖 Oversold List SOP 📖 Over $100 SOP 📖 Cores SOP 📖 Defects SOP 📖 Shortages & Damaged SOP

Facing 1 — Store Credit Request

What the store person fills out. Pick a credit type and only the fields that type needs appear; the reason for the credit goes in Description / notes. On submit it drops into the tracking system (today: the SharePoint sheet).

📖 Oversold List SOP 📖 Over $100 SOP 📖 Cores SOP 📖 Defects SOP 📖 Shortages & Damaged SOP
New credit request

Fields marked * are required.

🏬 Store —from your login
📅 —today · auto-set
$
📎 Click to attach RGN copy, RPT 130 / 044, credit memo, screenshots… multiple files OK

Office Review

Pick an area to work in.

📋

RGN Tracking

Credit requests & returns — open dollars by credit type, past-due RGNs, and the detail logs.

Open →
🧾

DC Bill Review

DC invoice price vs the store's MS box cost — every part where what we were billed doesn't match the cost file.

Open →
🛒

BOPIS 41050

Buy Online Pickup In-Store — every sale billed to the house account, the DC credit that pays it back, and the 7% processing fee.

Open →
💵

Cash Received Journal Recon

Every trading day: the register's RPT077 / RPT080 against what the store keyed on the SCR041 Cash Received Journal — over/short, cards, the deposit.

Open →
🛞

BSCP Rebates

Brake Share Capture Program — rebate earned on every brake line against what the DC actually credited, by store, by customer, down to the part line.

Open →
🏷️

MI Rebates

Master Installer rebate — each store's month-end claim against the DC's credit, the rows the DC declined and why, with the office's notes.

Open →
🎨

PPG

PPG Rebates, and every invoice and credit PPG sends us — checked against MultiStore and coded to a rebate.

Open →
🧾

Vendor Bills

NAPA vendor invoices reconciled against what was received — pick a month billed, mark each account reconciled.

Open →
📑

COM150 Review

Receipts reconciliation — what the DC billed against what each store posted and received.

Open →

RGN Tracking — Summary

Open credit by type. Click a credit type to open its detail log.

🛒 BOPIS — account 41050

Every BOPIS sale should be credited back in full and charged a 7% processing fee. Click a month for the store breakdown.

💵 Cash Received Journal Recon

What the register says went in the drawer (RPT077 / RPT080), what the store keyed for the deposit (SCR041), and what went to the bank. Click a store, then a day, to open the sheet.

Loading…

🧾 DC Bill Review

Latest DC invoice price for each part vs the store's MS last/replacement cost — any difference is flagged.

Loading…

🚝 BSCP Rebates

connecting…

Brake Share Capture Program. NAPA pays only when the item is billed at the exact price the customer's pricing profile sets for that group code — per line, not per invoice. A line that misses still counts as a sale; it just earns nothing.

Period

Rebate earned vs received from the DC — by store

click a store to open its customers
loading…
Credits received — per store, per month earned
loading…

NAPA credits per store, never per customer, which is why the customer level has no credited column. The DC invoice archive starts 2026-06-03, so months earned before May 2026 have no document on file at all.

The program sheet — required price by profile, line and group
loading…
How these numbers are made

Three different numbers

Sales is everything on a paying group code. At profile price is the part of it billed to the cent. Earning nothing is the rest. All three are shown because a line that misses the price is still a sale.

Where each figure comes from

  • bscp_ms_line — raw MultiStore lines, stored exactly as returned, keyed on (store, invoice, line seq). Every figure on this page walks back to one of them.
  • bscp_ladder — the program sheet, by effective period. Never derived from billed prices.
  • v_bscp_line — the graded view: customer's profile → part's group code → that profile's price on the sale date → billed price compared to the cent.
  • bscp_credit — what NAPA actually paid, per store, per month earned.

What counts as a sale

Transaction types 1 and 2 only, applied in the view rather than the pull, so an excluded line is still stored and still reachable — bscp_excluded(store, from, to) returns what did not count and why. Item billing type is not filtered.

Known assumptions, carried openly

  • PFB 600/605/610/615 on the August ladder is carried from the Jan–July sheet. The August sheet does not state it.
  • Profile 41544 GRT 901 is loaded at $49.00 (Jan–Jul) / $51.00 (Aug). The sheet shows that price against NB 901 with GRT 901 missing; every other profile pairs GRT 501 with 901.
  • Rotors sold as NB before February 2026. GRT 501/503 has no sales before then, so January and earlier depend entirely on NB 500/502 resolving.

Store Dashboard

Live sales — month to date
Loading…

Vendor Billing Accounts

NAPA invoices (billed) vs what was received — SCR053 store PO receiving first, post account as the fallback
Accounts click a row for the breakdown, then a bubble to see the invoices behind it
Billing acctVendorPost acctStore InvoicesBilledMatched Needs
correcting		Double
posted		 Never
received		Not
received		 No
invoice		Wrong
store		 StatusWhat's wrong
Matched = the goods were found on the SCR053 (store PO receiving, matched on the full PO number) or on the post account (the NAPA invoice # keyed into the receipt’s PO field) and the amount and every line agree. Double posted = both sources show it, so it was received into inventory twice. Needs correcting counts invoices, not exceptions — an invoice that is both short and taxed is counted once. Wrong store is a flag, not a bucket: a receipt can be reconciled and still have been rung at the wrong store.
✓Submitted

🎨 PPG

Pick an area to work in.

🎨

PPG Rebates

Each body shop's rate × its PPG buying at green, month by month, against what PPG credited — what is still owed, the PPG report, Meets Comp.

Open →
🔧

Gerber Reconciliation

Marion's invoices to Gerber (account 10700) that PPG pays us for, each held line by line against the PPG credit that pays it.

Open →
📤

PPG Invoices → QuickBooks

Review PPG invoices and credits, code them (PPG GLs, store, split lines) and send them to QuickBooks as Bills and Vendor Credits whenever you're ready.

Open →

🎨 PPG Rebates

What PPG owes us each month for our body-shop accounts: rate × refinish, where refinish = every PPG line the shop bought that calendar month (all stores) valued at the PPG green sheet price. Held against what PPG actually credited.

Year Month

Over / Short — rebate requested vs. what PPG credited

Every finished month this year, shop by shop. Short = requested but not (fully) credited — PPG owes us. Over = credited more than requested. Differences of 5¢ or less are rounding and ignored. The month in progress is left out. Click a shop for its months.

Customers

Key what PPG credited on the row and Save. Click a customer name for the invoice lines behind the figure; 🖨 prints that shop's PPG report.

Rebate due by customer, by month

paid short not received over month to date
Each cell is the rebate due. Hover it for received / difference; click it to open that month.

By month

Click a month to open it. GP is what our PPG invoices made at the counter; the rebate is on top of it.

Program — who is on it, at what rate

A rate change re-grades every month the invoice lines cover (August 2026 on) the moment it is saved; months already locked keep their refinish figure. Rate is a percent (12.5 = 12.5%).
Add a shop

Everything PPG emails to PPGInvoices@carolinacolors.net, read every 2 hours. Credits: each one is coded to the shop and month it pays (that fills Received on the rebate grid) or marked not a rebate. Invoices: what PPG billed, every unit price held against MultiStore cost. Click any number to see the document.

Credits — what PPG credited, and which rebate it pays

Read from PPGInvoices@carolinacolors.net (credit memos and PPG's account statements). Each credit is tied to a shop and month by its PO (“12202- AUG26”), else by being the only shop-month with exactly that rebate, else by you. A matched credit fills Received on the grid. Agrees = what was already keyed matches; Conflict = the grid shows a different received amount for that month — check it.

PPG invoices & credit memos

Last
What PPG billed (or credited) us, as read from the mailbox. Click a row for its lines.

Store 821 (Marion) bills Gerber Collision (ONLINE ORDER), account 10700; PPG pays us for those orders with an Autogen credit (same items, same prices, plus a Boyd service fee) that lands in PPGInvoices@carolinacolors.net. Each invoice is matched to its credit by PO (invoice PO 1734180 = credit WEB1734180) and checked line by line. Click an invoice to compare.

Show

Gerber invoices → PPG credit

PPG Autogen credits that tie to no invoice

Pick the invoice a credit pays when its PO doesn't tie it automatically.

Review every PPG invoice and credit from PPGInvoices@carolinacolors.net (since 10/1/2026), confirm where it went and how it's coded, tick the ones that are right and Send to QuickBooks — whenever you like. Invoices post as Bills, credits as Vendor Credits, each with PPG's PDF attached. Coding saves as you go; nothing reaches QuickBooks until you send it.

Datedto
PPG rebate credits: each one is applied to the shop and month it pays for — that marks the month received on the PPG Rebates grid. Most match on their own; the rest need a person.
Every PPG invoice line's unit price against the MultiStore cost — there shouldn't be a difference when PPG bills us.
MultiStore post accounts for PPG — stores post here when product arrives after the PO was already posted on the SCR053. The PO on the posting is the PPG invoice number.
Monthly: every invoice / credit on PPG's statement should be here, and in QuickBooks.

🏷️ MI Rebates

connecting…

On the last day of every month TAMS prints the RPT025 Reportable Sales Summary (the claim broken out by manufacturer line, program and product group, one row per Master Installer account) and the RPT026 customer recap (the same claim by account — the complete figure, because the RPT025 print can leave a summary out that the claim itself carries). The DC pays it as a C2 Reportable Sales Credit around the 20th of the following month — one credit line per claimed row, in its own rounding. This page holds claim and credit side by side.

Month claimed

Earned vs received from the DC — by store

click a store to open its claim
loading…

Declined by the DC — the RPS446

loading…

Month by month

click a month to select it
loading…
Earned and received are compared only across stores that have both a loaded RPT025 and a DC credit for that month. A store whose report is not loaded is not a store that was underpaid.
DC credits received — per store, per month earned
loading…

Order type C2 Reportable Sales Credit in the DC invoice archive, read as RPS Ctl# <n> <line> MI Rebate lines. The document never names the month it pays, so the month earned is taken as the month before the invoice date (May → 06/18, June → 07/20, July → 08/20). The archive starts 2026-06-03; nothing earlier has a document on file.

Reports loaded from TAMS
loading…
How these numbers are made

Two documents, one comparison

Earned is the month's claim. The RPT026 recap states it by account and is the figure a store is graded on; the RPT025 breaks the same claim out by manufacturer line (FIL, ACK, …) and Reported Sales program ID (F, P, X, …), a summary with its own number, one row per Master Installer account per product group, with the rebate the store's pricing earned on the cost of those sales. Received is the DC's C2 credit: one Ref block per summary, one line per row, recomputed by the DC. A cent here and there is the DC's rounding (821 July: 46 lines, $527.56 claimed, $527.51 paid). Anything beyond one cent per line plus five cents is flagged.

When the RPT025 print is short a summary

At some stores the printed RPT025 leaves out a whole summary — A/C Kits for the F program at 884, the X filter program at 862 — while the RPT026 counts those accounts and the DC's credit carries a Ref block for exactly that summary and pays it (884 July: RPT025 $742.59, RPT026 $840.07, credited $840.09 with an ACK block the print never showed). The claim TAMS sends is complete; only the print is short. The store row says print short with the difference, the Ref block shows below as not on the print, and nothing is counted as unclaimed. (Found 2026-09-18 on the May–August loads; before that the page read the gap as money never claimed.)

Pairing a claim with its credit

The credit carries no summary number and no month. Inside (store, month, line) a Ref block that holds as many lines as a summary has rows and lands within rounding of its rebate is that summary's block, wherever the DC put it; a block the DC trimmed (a denied row: fewer lines, less money) pairs next; only what is left pairs by position, and a summary that claimed nothing (ACK at $0.00) gets no block. Inside a block the DC prints its lines customer by customer, then group by group, so rows pair by position too, but only when the block holds exactly as many lines as the summary has rows; otherwise the row level says it could not pair rather than guessing.

The DC’s audit — RPS446

With each month’s credit the DC prints the RPS446 Reportable Sales Jobber Credit Report: every claimed row with NAPA’s recomputed credit requested, the credit issued, and a message where it refused (“No Customer Account Information” = the account is not on file at NAPA as a Master Installer; “This record has been voided”). A refused row is dropped from the credit invoice, not shown at zero. The report is not on TAMS: the DC emails a scan with the credit, the invoice fetch saves it with that night’s PDFs, and rps446_load.py reads the whole thing by OCR — every control proven against its printed total — into mi_dc_audit. “Declined by the DC” above is that table with the office’s notes; “DC turned down” reads a dash for a month with no report loaded. January–June 2026 came from the office’s tracking sheet.

Missing is never zero

  • A store with a credit and no report loaded reads no report loaded. Its earned figure is unknown, not $0.00.
  • A month whose credit has not arrived reads waiting on credit until 30 days after month end, then past due — the same 30-day clock the office workbook uses for MI Rebate.
  • The month tiles compare only the stores that have both sides.

Where each figure comes from

  • mi_rpt025_summary / mi_rpt025_lines — the RPT025 exactly as printed, per summary and per row.
  • mi_rpt026_store / mi_rpt026_cust — the RPT026 recap: reportable sales against the store's total, per customer.
  • mi_credit_line — a view over invoice_lines (order type C2), nothing copied.
  • mi_pairing — the summary↔block pairing above; every RPC on this page reads through it.