SGI Punch Quotation System
Welcome to the SGI Punch Quotation System documentation. This automated quotation processing system helps streamline the creation and management of quotations from Excel files.
Overview
The SGI Punch Quotation System is a Django-based web application that automates the extraction, processing, and generation of quotations from Excel files. It supports multiple quotation formats including:
- Standard (PII + SGI)
- TMMIN (Toyota Motor Manufacturing Indonesia)
- METINDO (Logistics format)
- MARUICHI (Discount format)
Key Features
- 📤 Excel File Upload - Upload and process multiple quotation files
- 🔍 Automatic SKU Checking - Real-time validation against SAP HANA database
- 📊 Dashboard - View statistics and manage upload sessions
- 📄 PDF Generation - Automatic PDF quotation generation
- 🔔 Notifications - Microsoft Teams webhook integration
- 👥 User Management - Role-based access control
- 📈 Detailed Reports - Item availability checks and summary reports
Quick Start
User Roles
- Uploader - Can upload Excel files only
- Processor - Full access to dashboard, processing, and reports
System Requirements
- Python 3.8+
- Django 5.2.8
- PostgreSQL or SQLite
- SAP HANA database access (optional)
- Modern web browser
Support
For issues or questions, please contact the IT department at PT Somagede Indonesia.
© 2025 PT Somagede Indonesia. All rights reserved.