XERPIUM SATELLITE CITY

Summary

Satellite City Development Ecosystem

XERPIUM SATELLITE CITY is an end-to-end ERP solution for property and satellite city developers — covering project master plan, cluster management, plot sales, PPJB (sale and purchase agreements), payment schedule, infrastructure progress, unit handover, community facility management, and IPL billing (environmental maintenance fee).

🏢

PROJECT

Master Plan & Stage

🏛

CLUSTER

Residential / Commercial

📄

PPJB (Sale & Purchase Agreement)

Sales Agreement

💰

IPL

Maintenance Fee

🏭

INFRA

Progress Tracking

🔗

HANDOVER

Unit Handover

🋧

FACILITY

Community Facility

📈

DASHBOARD

KPI Real-time

Master Data

Satellite City Master Data

Structured master data for all satellite-city development entities — from project to plot detail.

🏢

sc.project — Project / Township

Project Code — Auto-sequence SC.PRJ/####, unique per project
Project Type — Residential, Commercial, Mixed-Use, Industrial
Location — City/District, total area (ha), master plan document
Timeline — Commencement date, target completion, state: draft → planned → in_progress → completed
Owner — res.partner linked as developer/owner

🏛

sc.cluster — Cluster / Block

Cluster Code — Unique code per project, area (ha)
Cluster Type — Residential, Commercial, Mixed-Use, Industrial
Linked to Project — One2many from sc.project, cascade delete
Stats — kavling_count, available_count, sold_count computed via @api.depends
Display — Format: [Code] Cluster Name

🏠

sc.kavling — Plot / Unit

Lot Number — Unique per cluster, display: cluster-code-number
Plot Type — Linked to sc.kavling.type for size template
Pricing — Land price + building price = total price (monetary, auto-compute)
Status — Available → Reserved → Sold → Handed Over → Cancelled
Physical Attributes — Land area m², building area m², facing direction, corner lot, facing road
Relations — agreement_id, partner_id, handover_id, sale_order_id

🏢

sc.kavling.type — Plot Type

Type Code — Unique code, sequence order
Dimensions — Building area m², land area m², bedrooms, bathrooms, floors
Linked Product — product.product for sale.order integration
Display — Format: Type Name (100m² / 50m²)
Usage — Template for creating plots with standard dimensions

📈

Master Data Views — Project, Cluster, Plot, Plot Type

Form & Tree View with computed fields, status badges, inline editing

Sales Workflow

PPJB & Sales Agreement

Plot sales flow from reservation to handover — integrated with sale.order and account.move.

Available

→

PPJB Draft

→

Confirmed

→

Approved

→

Payment

→

Handover

📄

sc.customer.agreement — PPJB (Sale & Purchase Agreement)

Agreement No. — Auto-sequence SC.AGR/####, tracking enabled
Parties — Buyer (res.partner), Project, Plot, Plot Type (related)
Pricing — Land price, building price, discount, net price (auto-compute)
Payment Scheme — Cash, Installment 12/24/36/48/60 months, Custom
Down Payment — DP % automatically calculates DP amount from net price
Installment — Per-installment amount computed: (net - DP) / installment_count
State Flow — Draft → Confirmed → Approved → Payment In Progress → Completed → Handed Over

💰

sc.payment.schedule — Payment Schedule

Auto-generated — Created automatically when the agreement is completed
Payment Types — Down Payment, Installment, Fine, Other
Due Date — Per term, amount, currency (multi-currency support)
Invoice Link — account.move linked via invoice_id field
Payment Status — is_paid computed from invoice payment_state
Related Data — Stored related fields: partner_id, project_id, kavling_id

PPJB Flow — From Draft to Handover

Step 1

Reserve Plot

              Wizard → Select available plot → Status → reserved
            

Step 2

Create PPJB (Sale & Purchase Agreement)

              Create agreement → Set pricing → Payment scheme → confirm
            

Step 3

Approve & SO

              Action approve → Auto-create sale.order → Plot → sold
            

Step 4

Payment Schedule

              Action complete → Auto-generate payment schedule → Invoices via account.move
            

Step 5

Handover

              Create handover → Condition assessment → Checklist → Plot → handed_over
            

Sale Order Auto-Creation

Action	Result
Action Approve	Create sale.order with product from kavling_type_id.product_id
Origin Field	Set to agreement name for traceability
Order Line	Single line: "Plot [name] - [type]", qty=1, price=net_price
Invoice Link	Invoices accessible via agreement sale_order_id.invoice_ids

Payment Schedule Generator

Cash Scheme — Single down payment line = net price
Installment Scheme — DP line + N installment lines with sequence
Sequence Logic — DP at sequence 10, installment at 11, 12, 13...
Invoice Creation — Each line can be invoiced, is_paid tracks payment state
Fine Lines — Late payment fines with separate payment_type

📄

PPJB Form & Payment Schedule View

sc.customer.agreement — Detail Form with Payment Scheme, Installment Calculator, Invoice Link

Infrastructure

Infrastructure & Handover

Project infrastructure construction tracking and unit handover process to buyers.

🏭

sc.infrastructure — Project Infrastructure

Infrastructure Types — Road, Bridge, Water Supply, Electricity, Drainage, Gas Distribution, Telecom, Green Space/Park
Dimensions — Length (m), width (m), budget amount, actual cost (monetary)
Timeline — Construction start, target completion, actual completion date
Progress — Auto-computed from milestone %: @api.depends milestone_ids.progress_pct
Contractor — res.partner linked as contractor
State — Planned → In Progress → Completed → Cancelled

📝

sc.infra.milestone — Infrastructure Milestone

Per Item — Milestone per infrastructure item, sequence order
Progress Tracking — Progress % vs target %, is_completed boolean
Expense — Monetary expense amount per milestone
Auto-compute — Infrastructure progress_pct = avg of milestone progress
Related — Stored related: project_id from infrastructure

🏠

sc.handover — Unit Handover

Auto-sequence — SC.HDO/#### format, name_get: [No] — Buyer Name
Relations — Buyer, Agreement, Plot (related), Project (related)
Schedule — Planned date, actual date (auto-set on complete)
Condition Assessment — Good, Minor Defect, Major Defect
Checklist — Boolean checklist_done, attachment count computed
Auto-update — action_complete updates plot status → handed_over, agreement → handed_over

🋧

sc.facility — Community Facility

Facility Types — Club House, Swimming Pool, Gym, Playground, Mosque/Musholla, Park, Security Post, Commercial Area
Capacity — Integer capacity per facility, operational status
Opening Date — Track when facility becomes operational
Maintenance Cost — Monthly maintenance cost (monetary) per facility
Linked to Project — One2many from sc.project, cascade delete

🏭

Infrastructure Progress Tracking & Handover Form

Gantt-style Milestones, Progress %, Budget vs Actual, Condition Checklist

IPL Billing

Environmental Maintenance Fee

Monthly environmental maintenance fee billing system for sold plots — auto-generates lines and invoices.

Create Billing

→

Generate Lines

→

Post → Invoice

→

Payment

sc.ipl.billing — IPL Billing Header

Field	Description
Name	Auto-sequence SC.IPL/####
Project	sc.project — billing per project
Period	Period month + period year
Invoice Date	Date of invoice
Due Date	Payment due date
Total Amount	Sum of line amounts (computed)
State	Draft → Posted → Cancelled

sc.ipl.billing.line — Billing Line

Plot — Per plot that is sold/handed_over with partner
Owner — res.partner (related from plot)
Amount — Monetary amount per plot per month
Invoice Link — account.move auto-created on action_post
Bulk Generate — action_generate_lines: search all sold plots, skip existing
Auto-Invoice — _create_invoice method: out_invoice with IPL product

IPL Billing Flow

1 Create billing header: sc.ipl.billing → period: 01/2026

2 Generate lines: action_generate_lines() → N plot lines created

3 Post billing: action_post() → Auto-create account.move per line

4 Payment: account.move → register payment → state = paid

Analytics

Satellite City Dashboard & KPIs

Real-time analytics dashboard to monitor sales, infrastructure, and IPL billing.

kavling

Total Plots

available

Available

sold

Sold

revenue

Total Revenue

KPI Dashboard — Widgets

Widget	Metric	Source Model
Plots by Status	Count per status (available/reserved/sold/handed_over)	sc.kavling
Sales Revenue	Total revenue per project (monetary)	sc.project
Infrastructure Progress	Average progress % per project	sc.infrastructure
Agreement by State	Count per state (draft/confirmed/approved/etc)	sc.customer.agreement
IPL Billing	Total billed, collected, overdue per period	sc.ipl.billing
Cluster Absorption	Sold vs available per cluster	sc.cluster
Monthly Sales Trend	Agreement count per month (line chart)	sc.customer.agreement
Revenue by Project	Bar chart by project code	sc.project

AI Dashboard Features

Auto-Generate — Natural language → dashboard via DeepSeek
NL → SQL — "Show plot sales this month" → SQL query
Chart Insight — AI analysis of sales trends, slow-moving clusters
Copilot Chat — Streamed chat with property dashboard context
Conditional Formatting — Status colors, overdue alerts, progress bars

Chart Types Available

tile line bar bar_h area pie doughnut funnel gauge bullet list todo stacked_bar waterfall

📈

Dashboard Studio — Satellite City KPI

Plot Status Pie, Revenue Trend Line, Infrastructure Progress Gauge, IPL Collection Waterfall

Accounting

Property & Satellite City Accounting

Property-specific Chart of Accounts and automatic journal flow from plot sales and infrastructure to IPL billing.

Key Accounts — Property

Account	Tipe	Function
Land Inventory	Asset	Value of unsold land
Work in Progress — Infrastructure	Asset	Infrastructure development in progress
Completed Infrastructure	Asset	Completed infrastructure (roads, bridges, etc.)
Revenue from Plot Sales	Revenue	Plot sales revenue
Revenue from IPL	Revenue	Maintenance fee revenue
Cost of Land Sold	Expense	Cost of land sold
Infrastructure Expense	Expense	Infrastructure development costs
Receivables — Plots	Receivable	Plot installment receivables
IPL Receivables	Receivable	IPL Receivables
Deferred Revenue	Liability	Unearned revenue (installments)

Property Accounting Features

Auto-Journal Plot Sales — Automatic journal when sale.order is confirmed
Installment Tracking — Every payment term has a separate invoice
IPL Auto-Invoice — Generate bulk IPL invoices per period
Infrastructure Capitalization — Infrastructure costs capitalized to assets
Multi-Company — Multi-project operations with separate companies
Multi-Currency — Foreign currency transactions, automatic BI/ECB rates
Consolidation Reports — Multi-project consolidated report
Tax Integration — 11% VAT, 4% final property income tax, e-Faktur

Plot Sales Journal Flow

Booking Fee

              DR Cash/Bank   CR Deferred Revenue
            

Full Payment

              DR Cash/Bank   DR Deferred Revenue   CR Revenue   CR Land Inventory
            

IPL Billing

              DR IPL Receivables   CR IPL Revenue
            

💰

Chart of Accounts — Property & Satellite City

COA with groups: Property Revenue, IPL Revenue, Infrastructure Assets, Receivables

Ecosystem

Cross-Module Integration

Satellite City fully integrated with the entire XERPIUM ecosystem.

📄

Satellite ↔ Sales

sc.customer.agreement → sale.order auto-creation via action approve
Product from kavling_type_id.product_id, price = net price
Invoice link: agreement.sale_order_id.invoice_ids

📦

Satellite ↔ Inventory

Stock products for infrastructure construction materials
Material consumption tracking per infrastructure item
Lot/serial number tracking for project materials

💰

Satellite ↔ Accounting

IPL billing → account.move auto-creation
Payment schedule → invoice per termin
Property COA with analytic account per project

👥

Satellite ↔ HR & Project

Project manager assignment for infrastructure
Contractor tracking via res.partner
Integration with XERPIUM project for task management

📈

Satellite ↔ Dashboard

vit_dashboard_studio for real-time KPIs
Dashboard templates: sales, infrastructure progress, IPL
AI auto-generates dashboards from natural language

🤖

Satellite ↔ AI Assistant

Search plots: "Plots available in cluster A"
Create a sales agreement (PPJB): "Create an agreement for Mr. Budi, plot A-01"
Report: "Total sales this month"

🔗

Satellite ↔ Dynamic Stage

Configurable workflow for sc.customer.agreement
Python hooks on state transitions
RBAC groups: Manager, User, Viewer

🌏

Satellite ↔ Coretax

Auto-generate VAT e-Faktur for plot sales
Automatic 4% final income tax calculation
Tax ID validation, invoice returns

Comparison

Why XERPIUM Satellite City?

Aspect	Spreadsheet / Manual	XERPIUM Satellite City
Master Data Project	✗ Separate files per project	✓ Structured model sc.project + cluster + plot
PPJB Agreement	✗ Manual documents, error-prone	✓ 6-stage digital workflow + auto SO + invoice
Payment Schedule	✗ Manual term tracking	✓ Auto-generate per scheme, link ke invoice
Infrastructure Progress	✗ Reports via email / WA	✓ Milestone tracking, progress % auto-computed
IPL Billing	✗ Manual billing per unit	✓ Auto-generate lines + bulk invoices
Handover Process	✗ Paper handover reports	✓ Digital checklist, condition assessment, attachment
Dashboard & KPI	✗ None	✓ Real-time 8+ KPI, AI-powered
Multi-Project	✗ Hard to consolidate	✓ Multi-company, consolidated reports
Tax Compliance	✗ Manual VAT/income tax calculation	✓ Auto 11% VAT, final income tax, e-Faktur Coretax
AI Assistant	✗ Not available	✓ Natural language queries & actions
Dynamic Stage Workflow	✗ Not available	✓ Configurable per model, RBAC, Python hooks
License	Separate SaaS	SaaS / On Premise — all included

Portfolio

XERPIUM Industry Portfolio

Industry	Module	Dashboard	Report
Inventory & WMS	275+	✓	✓
Manufacturing	230+	✓	✓
Purchase	105	✓	✓
HR & Payroll	29	✓	✓
Aerospace	10	✓	✓
Accounting	9	✓	✓
University	9	✓	✓
Distribution	8	✓	✓
Koperasi	8	✓	✓
Retail & POS	7+	✓	✓
Gold Mining & Refinery	7	✓	✓
Aviation	6	✓	✓
Coal Mining	6	✓	✓
Hospital & Pharmacy	6	✓	✓
Hajj & Umrah Travel	6	✓	✓
Logistics	5	✓	✓
Hotel & Property	5	✓	✓
Beauty Clinic	5	✓	✓
Rental	4	✓	✓
Livestock	4	✓	✓
Fishery	4	✓	✓
Software House	4	✓	✓
Event Organizer	4	✓	✓
Satellite City	2	✓	✓
Education Foundation	2	✓	✓
Food & Beverage	1	✓	✓
Civil Construction	1	✓	✓
Garment	1	✓	✓
Agriculture	1	✓	✓
Theme Park	1	✓	✓
Data Center / IT	1	✓	✓
Palm Oil	1	✓	✓
Feedmill	1	✓	✓
Building Management	1	✓	✓
Auditor	1	✓	✓

XERPIUMSATELLITE