PO to PR
PR Portal Suite
for NALCO CPP MM-I
A fully offline, browser-based toolkit covering the entire Purchase Requisition lifecycle — from PO lookup and AA proposal drafting to PAC certificates, PR checklists, and GeM Custom Bid undertakings. No server, no internet, no installation required.
Overview
What is the PR Portal Suite?
The PR Portal Suite is a collection of five standalone HTML tools built for the MM-I department at NALCO's Captive Power Plant, Angul. Together they digitize and streamline the complete procurement documentation workflow — from reading past Purchase Orders out of an Excel export, filling Administrative Approval (AA) proposals covering all 32 DOP proposal types, generating Proprietary Article Certificates (PAC), running a 21-point PR verification checklist, and preparing GeM Custom Bid / BoQ undertakings — all without needing any server, ERP login, or external dependencies.
The Five Tools
What's inside the package
Each tool is a self-contained HTML file that runs directly in any modern browser. They share data via auto-fill links — clicking a button in the PO→PR Portal automatically populates fields in the AA Portal, PAC Portal, or PR Checklist.
PO → PR Generation Portal
Upload an ME2M / PO Excel export, search by material code or description, pick line items, and instantly generate a formatted PR creation table ready for SAP ME51N. The central hub of the suite — buttons directly open and pre-fill the AA, PAC, and Checklist portals.
Administrative Approval Proposal Portal
Covers all 32 proposal rows from NALCO's Purchase Manual 2024 DOP — six PR types (Revenue, Capital, Common Consumable, Bulk Raw Material, Proprietary, Standardized) and all tender modes (OTE, GTE, LTE, Single Tender). Generates a formatted Word document ready for signatures.
Proprietary Article Certificate (PAC)
Generates the Certificate of Proprietary Articles in NALCO IMS format. Accepts multiple line items, populates equipment details, OEM / OES / OPS / OTS justification, and prints a two-page certificate formatted for approval by CGM or Executive Director as applicable.
PR Checklist Portal
A structured 21-point checklist aligned with NALCO's Purchase Manual 2024 and GeM guidelines. Each point has YES / NO / NA options. Tracks progress, generates a summary, and prints a compact two-page verification sheet with dual signatory blocks.
GeM Custom Bid / BoQ Undertaking Portal
Fills and prints the Page 2 Undertaking required for GeM Custom Bid / BoQ procurements. Accepts search strings from the GeM Availability Report & Past Transaction Summary (GARPTS), category notification details, and officer declaration. Supports dynamic add/remove of search strings, localStorage auto-save, and live document preview before printing.
Deep Dive
AA Portal — All 6 PR Types Covered
The AA Portal is the most comprehensive tool in the suite. It guides the user through all proposal types defined in NALCO's Purchase Manual 2024 and maps each to the correct DOP authority.
| # | PR Type | Who Raises | Tender Mode | Key Notes |
|---|---|---|---|---|
| 1 | Revenue | User Dept. | OTE / LTE / Single | Min ₹25,000 (below → petty purchase). Consumables, spares, minor raw materials within approved budget. |
| 2 | Capital | User Dept. | OTE / GTE | Plant & Machinery per approved investment plan. Generic specifications required. Submitted to Competent Authority directly. |
| 3 | Common Consumable | Central Planning / AP Cell | OTE / GTE | Rhythmic consumption across departments. Raised centrally. |
| 4 | Bulk Raw Material | Corporate Materials | GTE / OTE | Caustic Soda, CT Pitch, CP Coke etc. Detailed production-based proposal. |
| 5 | Proprietary | User Dept. | Single Tender (PAC) | OEM/OES/OPS/OTS only. Mandatory PAC signed by competent authority. |
| 6 | Standardized | User Dept. | Single Tender | Components standardized for compatibility with existing equipment. Standardization Certificate required. |
PR Checklist Portal
21-Point Verification Before PR Submission
Every PR passing through MM-I must clear this checklist before reaching the approving authority. The portal tracks each point and generates a printable verification certificate.
.html files — no server, no login, no internet required after download. Data entered in the PO→PR Portal flows to other tools via URL parameters and sessionStorage. The AA Portal optionally connects to a local Python server (nalco_aa_server.py on port 5757) for Word document generation using python-docx.
Interface Preview
UI Design — Clean SAP-style Layout
All portals follow a consistent navy-and-white design language inspired by SAP's structured UI — sidebar for controls, content area for data, topbar with module identity.
Technical Notes
Built for NALCO's Restricted Network
Every design choice prioritizes offline reliability over convenience — no CDN calls (all libraries embedded), no cloud sync, no cookies.
Zero Dependencies at Runtime
SheetJS (xlsx.js) is the only external library used in the PO→PR Portal and it's loaded from cdnjs. All other portals are pure HTML + CSS + vanilla JS. Works on any PC with Chrome or Edge — no admin rights needed.
localStorage Auto-Save
All form fields in the AA Portal and GeM Custom Bid Portal auto-save to browser localStorage. Data survives browser close/crash and reloads instantly on re-open. No accidental data loss during lengthy AA proposal filling.
Print-to-PDF Output
Every portal has a dedicated Print / PDF button that triggers a styled @media print layout, hiding all UI chrome. Output matches NALCO IMS document formats — ready for signing and submission without reformatting.
Optional Python Server
The AA Portal optionally connects to nalco_aa_server.py (Flask, port 5757) for .docx generation via python-docx. Run start.bat to launch. Not required for basic use — the Print/PDF path works standalone.