Skip to content

搜索技能.../

Agent Skill Search Engine

搜索

搜索
分类
职业

关于

关于
隐私政策
服务条款

© 2026 Skills Pool. 保留所有权利。

1. Initialize and Explore | Skills Pool

技能档案

1. Initialize and Explore

When the user needs to process invoice receipts from PDF files in a workspace and update a purchase invoice database with payment tracking. This skill automatically scans workspace directories for PDF receipts, extracts invoice data (invoice ID, supplier, amount, purchaser email, date, payment status), inserts records into database tables, sets up payment tracking with outstanding flags, identifies unpaid or partially paid invoices, and sends email notifications to relevant purchasing managers with specific filenames requiring attention. Key triggers include processing receipts, updating invoice databases, tracking outstanding payments, sending payment reminder emails, and handling PDF invoice files with payment status indicators.

zjunlp6 星标2026年2月23日

职业
分类: 支付

技能内容

1. Initialize and Explore

Explore Workspace: List the contents of the /workspace/dumps/workspace directory to locate the files folder containing PDF receipts.
Explore Database: List schemas in the PURCHASE_INVOICE database, then list tables in the PUBLIC schema.
Examine Tables: Describe the structure of the INVOICES and INVOICE_PAYMENTS tables. Read sample data to understand existing records and column formats.

2. Extract Data from PDF Receipts

Scan Files: List all PDF files in the workspace's files directory.
Read PDFs: For each PDF file, extract text from the first page. Parse the following key fields:
- Invoice ID: Look for patterns like "Invoice:", "Invoice ID:", "Document ID:", or text near the filename.
- Supplier Name: Typically under "Supplier:", "Vendor:", or "VENDOR INFORMATION:".

相关技能

快速安装

1. Initialize and Explore

npx skillvault add zjunlp/zjunlp-skills-skills-skill-collections-toolathlon-invoice-receipt-processor-skill-md

下载 Skill 打开源码仓库

作者: zjunlp
星标: 6
更新时间: 2026年2月23日
职业

本页内容

011. Initialize and Explore 02

Invoice Amount: Look for "Amount:", "Total Amount:", or "Total:" followed by a dollar amount.

Purchaser Email: Look for "Contact:", "Bill To:", or "DEPARTMENT INFORMATION:" followed by an email address.

Invoice Date: Look for "Date:", "Processing Date:", or "Invoice Date:".

Payment Status: Identify status keywords:

PAID or checkmark (✓): Fully paid.
PARTIAL or square (■): Partially paid. Extract the paid amount if available.
UNPAID, Awaiting payment, Pending, Verification in process: Outstanding (unpaid).
Default to outstanding if status is unclear.

3. Update Database Tables

Insert Invoices: For each extracted receipt, insert a record into PURCHASE_INVOICE.PUBLIC.INVOICES with columns: INVOICE_ID, SUPPLIER_NAME, INVOICE_AMOUNT, PURCHASER_EMAIL, INVOICE_DATE.
Insert Payments: For each invoice, insert a corresponding record into PURCHASE_INVOICE.PUBLIC.INVOICE_PAYMENTS:
- INVOICE_ID: The extracted invoice ID.
- PAYMENT_AMOUNT:
  - If status is PAID: Set to the full invoice amount.
  - If status is PARTIAL: Set to the extracted paid amount.
  - Otherwise: Set to 0.
- OUTSTANDING_FLAG:
  - 0 if status is PAID.
  - 1 for all other statuses (PARTIAL, UNPAID, Awaiting, Pending, Verification).
Set Column Description: Execute an ALTER TABLE statement to set the comment/description for the OUTSTANDING_FLAG column in INVOICE_PAYMENTS to exactly: 0=Paid, 1=Outstanding. Verify the description was applied.

4. Identify and Notify on Outstanding Invoices

Query Outstanding Invoices: Perform a JOIN between INVOICES and INVOICE_PAYMENTS where OUTSTANDING_FLAG = 1. Group results by PURCHASER_EMAIL.
Map to Filenames: For each outstanding invoice, map the INVOICE_ID back to the original PDF filename (e.g., INV-2024-013 → INV-2024-013.pdf).
Send Emails: For each unique purchasing manager email (PURCHASER_EMAIL):
- Subject: Process Outstanding Invoices
- Body: List the filenames of all outstanding invoices for that manager. Use a clear, professional format.
- Send the email.

5. Final Verification and Summary

Provide a concise summary report including:
- Count of receipts processed and inserted.
- Count of outstanding vs. paid invoices.
- List of managers notified and the number of files each needs to process.
- Confirmation that the column description was set.

2. Extract Data from PDF Receipts

033. Update Database Tables

044. Identify and Notify on Outstanding Invoices

055. Final Verification and Summary

Billing and Posting Clerks

Customer Billing Ops

Operate customer billing workflows such as subscriptions, refunds, churn triage, billing-portal recovery, and plan analysis using connected billing tools like Stripe. Use when the user needs to help a customer, inspect subscription state, or manage revenue-impacting billing operations.

Billing Automation

Build automated billing systems for recurring payments, invoicing, subscription lifecycle, and dunning management. Use when implementing subscription billing, automating invoicing, or managing recurring payment systems.

Paypal Integration

Integrate PayPal payment processing with support for express checkout, subscriptions, and refund management. Use when implementing PayPal payments, processing online transactions, or building e-commerce checkout flows.

Stripe Integration

Implement Stripe payment processing for robust, PCI-compliant payment flows including checkout, subscriptions, and webhooks. Use when integrating Stripe payments, building subscription systems, or implementing secure checkout flows.

Pci Compliance

Implement PCI DSS compliance requirements for secure handling of payment card data and payment systems. Use when securing payment processing, achieving PCI compliance, or implementing payment card security measures.

Square Automation

Automate Square tasks via Rube MCP (Composio): payments, orders, invoices, locations. Always search tools first for current schemas.

Billing and Posting Clerks