GPO Submissions · Northwind Medical

Monthly NDC file builder

Select one invoice month, load P21, and build against the stored NDC contract catalog.

Distributor ID · HSMS

1 · Select and load source data

Invoice month

GPO Agreement Distributor ID

Checking D1NDC contract itemsReading the stored item-cost catalog

Checking D1NDC contracts & tiersReading stored program and tier definitions

Loading P21 sales-price-page data…

2 · Select output file

Choose one file type before building

Sales TracePrepare the complete monthly sales-trace upload.GPO Rebate FileMatch contracts and calculate the rebate expected from NDC.

3 · Validation rules

Filter invoice monthOnly rows whose Invoice Date falls in the selected month are retained.

Validate against stored NDC dataManufacturer item, effective dates, and sales-price-page cost are matched to the active D1 catalog; program and tier come from its stored contract definitions.

Split outputsSales trace receives every monthly row; rebate receives only validated positive claims. Returns, missing costs, and zero or negative rebate calculations are held for review.

4 · Results

Load NDC audit

How to read the GPO rebate results

This separates GPO business already recognized by P21 from rebate opportunities that still need setup or review.

P21 GPO mapping foundP21 has an eligible price page and active NDC contract. Rebate Disposition shows whether a positive claim was created or why the row was excluded.

Available but not fully trackedA GPO opportunity exists, but the P21 price page, contract mapping, library, or customer setup needs attention.

Review before submissionReturns, missing costs, and rows with no positive rebate are never treated as money Northwind owes NDC; they are excluded and labeled for review.

Exact tier reportingThe NDC upload uses the exact tier-level NDC Contract Code in Manufacturer Contract ID. The audit view adds the readable tier, vendor contract code, and requirement.

Source rows0

Selected month0

Sales trace0

Qualified rebates0

Needs review0

5 · Outstanding item setup from this submission

Convert missed invoice lines into reusable P21 setup

Source invoice lines show every missed transaction in this submission. Unique setup targets consolidate repeat invoices and customers into one item, GPO program, contract, and UOM action so the highest-volume opportunities can be fixed first.

0 source invoice lines

Outstanding source lines0

Unique setup targets0

Ready to check in P210

Needs contract/tier review0

Monthly sales affected$0.00

Estimated recoverable rebate$0.00

1. Sales price pageCreate or update the item, contract cost, UOM, dates, and exact GPO tier.

2. Sales price bookAttach the verified price page to the correct reusable GPO book.

3. Sales price libraryAttach the book to the matching Vizient, Provista, or NuEdge library.

4. Eligible customersAssign the library only to customers whose roster membership supports it.

	Priority	Item	Recommended contract	Monthly volume	Estimated rebate	Affected	Readiness

Customer GPO Gap Analysis

Compare Vizient and Provista membership rosters with every Northwind customer and their live P21 price-library setup.

1 · Refresh the customer GPO gap

Read-only comparison · no P21 changes are made

View outstanding GPO customers

Load the latest prepared comparison of P21 customers against the indexed Vizient and Provista rosters.

Loading the prepared customer gap…

Loading prepared customer gap…

2 · Customer gap results

How to read the customer GPO gap

The status tells you whether Northwind already accounts for the customer in P21. The row color identifies the supplier-roster membership found.

Already known and accounted forThe customer roster membership is supported by the GPO library currently assigned in P21.

Accessible but not tracked correctlyThe customer matched a GPO roster, but P21 is missing the library or has the wrong membership level.

P21 only / reviewP21 shows GPO pricing, but the customer could not be confidently confirmed in the supplier rosters.

Vizient membershipYellow row background.

Provista membershipGreen row background.

NuEdge membershipBlue row background.

Relevant customers0

Correct setup0

Missing GPO setup0

Wrong GPO setup0

P21 only / review0

Customer GPO Setup

Review customer membership gaps, preview the exact P21 library changes, and apply approved assignments.

Admin sign-in

GPO customer setup queue

Maximum 10 customers per approved batch

	Customer	Membership	Current P21	Expected P21	Status

GPO Item & Tier Gap Analysis

Compare P21 GPO price pages 1105+ with NDC Contracts.txt, ContractItems.txt, and the Northwind item master.

Prepared snapshot · fast load

1 · Reconciled item and tier sources

No live 600,000-row scan is required in the browser

P21 GPO price pages

Loading current Vizient, Provista, and NuEdge price pages…

NDC contract + tier catalogs

Joining Contracts.txt tiers to ContractItems.txt prices…

P21 item master

Loading Northwind supplier, part, manufacturer, cost, and product-group fields…

Open this tab to load the prepared item-tier snapshot.

2 · GPO item and tier results

How to read the GPO item and tier gap

Each screen row is one Northwind item. The CSV expands each item into its exact NDC contract-code, tier, cost, UOM, effective dates, and requirement text.

Accounted in P21The item is already on a Vizient, Provista, or NuEdge P21 price page ID 1105 or higher.

Available but not trackedAn active NDC contract maps to the Northwind item, but no corresponding P21 GPO price page exists.

Needs item mapping reviewThe identifier maps, but the supplier/manufacturer match is not strong enough for automatic setup.

Current P21 tierShown only when one contract option uniquely matches the P21 program, cost, and UOM.

Access / base optionTier 1 or explicitly labeled Base/General Access. It is a reference—not proof of customer eligibility.

Lowest visible tierA theoretical same-UOM catalog minimum. Never apply it until customer/vendor tier entitlement is confirmed.

How NDC receives the tier: the rebate upload keeps NDC's required template and reports the exact tier-level code in Manufacturer Contract ID. The audit view adds the readable tier and requirement.

Relevant Northwind items—

Accounted in P21—

Available, not tracked—

Needs item mapping—

Exact P21 tier matches—

Tier eligibility review—

Contract tier options—

NDC rows without Northwind bridge—

Open this tab to load item results.

3 · Create Sales Price Pages in P21

No items selected

Each page is created and read back one at a time. Checking changes nothing in P21. Creating adds only the Sales Price Page. Attaching then puts it in the matching GPO price book, and because each book already sits in its library that is what makes the page live for that program. Eligible customers are still assigned in P21. A page whose Source Price is not Other Cost is refused rather than attached.

Most items have more than one NDC contract option. The cheapest tier is not automatically the one a customer is entitled to, so nothing is chosen for you when the item is ambiguous — pick the contract you have confirmed, then check it.

Tick items in the table above to create their Sales Price Pages.

Item	Description	NDC contract & tier to price from	Status
Tick items in the table above to create their Sales Price Pages.

NDC Catalog Import

Merge the weekly NDC Price Change Notification workbooks into the stored contract catalog that the submission builder and item gap analysis read.

Delta merge · versioned

1 · Current catalog

Merges never overwrite the active catalog until they finish

Loading

Reading the active catalog version and applied windows…

2 · Select notification workbooks

Choose files

What a notification workbook is

Each NDC file covers one filtered change window and holds only what changed inside it, so it is merged on top of the existing catalog rather than replacing it. Select the whole backlog at once — the oldest window is applied first, because applying an older window last would overwrite a current contract cost with a superseded one.

ContractItemsChanged contract costs. Every row for a touched contract and item is replaced as a set, so a UOM change that arrives as two dated rows lands correctly.

ContractHeadersChanged contract definitions, including NDC’s explicit tier identifier and requirement text.

Not imported hereContractEndUsers is the membership roster and feeds the customer gap analysis, not the contract catalog.

Or the full catalogSelect NDC’s ContractItems.txt and Contracts.txt together to replace the whole catalog instead of merging a change window. A snapshot also expresses removals, which a change file cannot, and carries item descriptions the workbook has no columns for.

Select the NDC notification workbooks to merge.

4 · Applied windows

Gaps here mean that week’s changes are still stale

5 · Add or update one contract

Choose file

Drop an ExportItemContractDDG workbook (NDC’s per-contract export) to seed a contract that isn’t in the catalog yet, or to correct one contract’s header fields. The row is written straight into the active catalog version — there is no versioned copy-forward. This file carries no item rows, so item costs on existing contracts still need an NDC Price Change Notification.

Select an ExportItemContractDDG workbook.

7 · Attach one item to a contract

Writes one gpo_contract_items row directly into the active catalog

Use this when a contract is in the catalog (or was just added above) but NDC has not published items for it. The item row is what gap analysis and price lookups match against.

Fill in the item and write it into the active catalog.

Rebates Received

Record the NDC credit memos that pay our rebate claims. One A/P credit per memo against vendor NDC, with the manufacturer on the entry.

PDF or sheet · net of NDC fee

1 · Upload the memos

Raw memo PDFs are read here; a keyed summary works too

Drop the raw credit-memo PDFs (singly, or a .zip of them) and they are read here in your browser — nothing is uploaded to do it. Or upload a keyed sheet with a memo number, manufacturer, rebate month and amount. A memo whose figures cannot be corroborated against a second place on the page is held back for review rather than recorded.

3 · Already recorded

Keyed on NDC’s memo number, so re-uploading is safe

GPO Portal