Procurement Price Comparison and Order Management

Problem

Procurement price comparisons, order tracking, and payment status often live in chats, spreadsheets, and emails. Manual calculations can miss tax-inclusive pricing, discounts, delivery exceptions, and outstanding invoice amounts. This skill supports business-ops procurement workflows by turning quotes into auditable Excel workbooks and tracking orders, invoices, and payments over time.

How it works

• Comparison tables: Captures item, specification, quantity, unit price, discounted price, supplier, and notes. Automatically calculates total = unit price × quantity, discounted totals, and savings; displays supplier quotes side by side and marks the best price.
• Monthly order tracking: Maintains order number, delivery dates, delivery status, invoice status, payment status, and payment date. Summarizes monthly order count, delivery rate, uninvoiced amount, and unpaid amount.
• Status management: Supports batch updates for invoice and payment status, highlights completed records, calculates outstanding invoiced/payment totals, and flags overdue payments.
• File output: Uses scripts/procurement_table.py to generate .xlsx files with comparison summary, monthly orders, payment tracking, and statistics; applies right-aligned amounts, bold headers, and green highlighting for optimal prices.

Boundaries

It is suited for organizing quotes, maintaining procurement ledgers, and exporting summary reports, but does not replace ERP, finance, or approval systems. Missing fields should be completed explicitly; dates use YYYY-MM-DD; currency defaults to RMB; status fields must be clear, such as yes/no/partial.