ERPNext Custom Reports (CD- Series)

Location: erp.velobiotics.com → Reports menu → Search "CD-Velobiotics"

Financial Reports

CD-Velobiotics Debtor Age Analysis

Purpose: AR aging by customer
Output: 5 buckets: Current / 1-30 / 31-60 / 61-90 / 91+ days per customer
Who uses: Tsakane (weekly), Chomba (monthly), Precious (B2B follow-ups)

CD-Velobiotics Creditor Age Analysis

Purpose: AP aging by supplier
Output: Same 5-bucket structure for suppliers
Who uses: Tsakane (weekly), Chomba (monthly)

CD-Velobiotics Supplier Statement

Purpose: Supplier account statement
Output: Opening balance + all transactions + running balance + closing balance
Who uses: Tsakane (weekly reconciliation)

CD-Velobiotics Monthly P&L Summary

Purpose: Profit & Loss statement
Output: Revenue / Expenses by account type / Net Profit / YTD column
Who uses: Chomba (monthly), Tsakane (monthly), Cary (monthly)

Sales & Operations Reports

CD-Velobiotics Daily Operations Report

Purpose: Daily business snapshot
Output: Today's invoices, Sales Orders, payments in/out, top 5 products
Who uses: Cary (daily), Chomba (daily)

CD-Velobiotics Weekly Sales Report

Purpose: Week-on-week sales comparison
Output: Auto Mon-Sun week, vs prior week, daily breakdown, top 5 customers
Who uses: Cary (weekly Monday), Chomba

CD-Velobiotics Monthly Sales Summary

Purpose: Monthly KPIs
Output: Revenue, top 10 customers, top 10 products, green header formatter
Who uses: Chomba (monthly), Cary, Tsakane

CD-Velobiotics Quarterly Business Review

Purpose: Quarterly analysis
Output: vs prior quarter, monthly breakdown, top 5 customers + products
Who uses: Chomba (quarterly), Cary

CD-Velobiotics Annual Sales Analysis

Purpose: Annual review
Output: 12-month row-by-row, vs prior year, YoY%, cumulative YTD
Who uses: Chomba (annual)

Print Formats

Format	Document Type	Notes
CD-Velobiotics Tax Invoice v44	Sales Invoice	VAT-compliant, branded green header, PAID stamp for Shopify
CD-Velobiotics Sales Order v30	Sales Order	Branded, terms included
CD-Velobiotics Customer Statement	Customer	Opening + transactions + running balance
Velo2026 Pick List	Pick List	Warehouse scanning, signature blocks, prints on Submit

Technical Rules

• report_script is the correct field for Python code in Script Reports (NOT script)
• javascript field for JS filter definitions
• P&L GL query: use is_cancelled=0; Income = credit − debit; Expense = debit − credit
• All CD- Jinja print formats require custom_format: 1