firerp.app — ERP for small teams

Loading…

firERP is a Firebase noSQL enterprise resource planning (ERP) and CRM application for small teams. Its data model is recursive: everything is a record, every record can hold records of its own, to any depth, and every level uses the same page. Build your own model without code: custom records, forms, 17 field types, linked records, calculated fields and roll-up totals. Run order to cash end to end: leads, opportunities, quotes, sales orders, pick, pack and ship, invoices, payments and a double-entry general ledger. The whole app is one HTML file of plain JavaScript, 979 lines and 73 KB, plus 33 KB of sample data, with no build step and no framework. We remember when Google didn’t need to use CSS; firERP is built the same way, in plain HTML with only a few inline styles. Works on phone and desktop, with Google sign-in or as a guest.

How firERP compares with NetSuite and Salesforce. Each row is a feature, marked ✓ firERP has it, ◐ partly, ✗ not yet: the firERP column says where it is on its path, the NetSuite and Salesforce columns what each platform offers for that feature.
Overall 69% 69%

Data structures

70% 70%

firERP	NetSuite	Salesforce
✓ Records you shape yourself: every list is defined by its own form of typed fields, made in the app.	Custom record types with their own fields, forms and lists	Custom objects
✓ Standard records: every company has the standard lists: customers, contacts, leads, opportunities, quotes, sales orders, invoices, payments, items, vendors, purchase orders, bills, employees, cases, tasks, the chart of accounts and journals, with lines inside quotes, orders, invoices and journals. A company adds its own fields to them; their standard fields stay and the lists can’t be deleted.	Standard records: customer, contact, lead, opportunity, item, vendor, employee, case, task, account and every transaction type	Standard objects: Account, Contact, Lead, Opportunity, Product, Quote, Order, Case, Task, Contract and more
✓ Shared reference data: the /global record holds 200 countries, 72 states and provinces and 146 currencies, kept by the admin in code; anyone can open it and any company can link to it.	Countries, states and currencies built in	State and country picklists, currencies
✓ Records inside records: any record can hold lists of records of its own, to any depth, all on the same page layout.	Sublists and child records, such as an order’s lines	Master-detail, related lists
✓ Link to another record: a link picks a record by name from any list at any depth, such as all customers or just one invoice’s lines, as the 2024 prototype did.	List/Record fields can point at any record type	Lookup relationship
✓ Auto numbers: every record gets the next number in its list, shown on the record and as a list column; each list can set a prefix and a first number (JOB-2401, JOB-2402…). Its web address is still the name typed when it is made.	Auto-generated document numbers with a prefix and a starting number	Auto Number
◐ Business records: the samples and demos set these up as ordinary records you can change.	Built-in customers, items, orders, invoices and accounts	Accounts, opportunities, quotes, orders
✗ Posting to the general ledger: journal entries can be typed in as records, but nothing posts on its own.	Every transaction posts debits and credits to accounts	Not built in (partner apps)
✗ Inventory: on-hand numbers can be typed in, but orders don’t change them.	Stock on hand by location, updated by receipts, fulfillments and adjustments	Not built in (partner apps)
◐ Tax: a calculated field can work out tax from a rate (subtotal × tax rate), but there are no tax codes or rules by place.	Tax codes and rates applied to transactions	Mostly partner apps

Field types

82% 82%

firERP	NetSuite	Salesforce
✓ Text: one-line text.	Free-Form Text	Text
✓ Long text: a multi-line text box.	Text Area and Long Text	Text Area (Long)
✗ Rich text: left out on purpose, because stored HTML could run code in the page.	Rich Text with formatting	Text Area (Rich)
✓ Number: any number, with the phone’s number pad.	Integer and Decimal Number	Number
✓ Currency and percent: both, saved as numbers and shown as $1,234.00 and 12%.	Currency and Percent	Currency, Percent
✓ Date: the browser’s date picker.	Date	Date
✓ Date and time: the browser’s date and time picker.	Date/Time	Date/Time
✓ Time: the browser’s time picker.	Time of Day	Time
✓ Yes / no: a tick box.	Check Box	Checkbox
✓ Email: checked for an @ by the browser.	Email Address	Email
✓ Phone: phones show the number pad.	Phone Number	Phone
✓ Web address: checked as a web address by the browser.	Hyperlink	URL
✓ Choice: one of the choices you list, shown as buttons.	A List/Record field on a custom list	Picklist
✓ Several choices: tick boxes, saved as a comma list.	Multiple Select	Picklist (Multi-Select)
◐ Calculated: + − × ÷ and brackets over the record’s own numbers; no functions or conditions yet.	Formula fields in SQL with functions and conditions	Formula fields
◐ Sum of child records: adds up one number across a record’s child list; sum only.	Sublist totals and summary saved searches (sum, count, average…)	Roll-Up Summary
✗ Files and images: not yet; it would need file storage.	Document and Image fields from the File Cabinet	Files

Field options

70% 70%

firERP	NetSuite	Salesforce
✓ Required: the browser won’t save the form until it is filled in.	Mandatory	Required
✓ Default value: new records start with it.	Default Value	Default Value
◐ Unique values: checked when Update is pressed, not by the database itself.	Enforced on some fields, otherwise by script	Unique
◐ Copy a value from a linked record: picking a link fills this record’s empty fields that have the same name as the linked record’s.	Sourcing, set up field by field	Cross-object formulas
◐ Checks beyond required and formats: lowest and highest values and a text pattern, checked by the browser; no rules across fields.	SuiteScript and workflow validation	Validation rules

Platform

38% 38%

firERP	NetSuite	Salesforce
◐ Access: each top-level record is private to the person who made it, plus shared demos anyone can edit; no sharing or roles yet.	Roles and permissions per record type and field	Profiles, permission sets, sharing
◐ Change history: created and updated times only.	System Notes record every field change	Field History Tracking
✗ Automation: not yet.	SuiteFlow workflows and SuiteScript	Flow, Apex
◐ Reports and search: lists show every field and can be searched, sorted and exported; no saved reports or totals across lists.	Saved searches, reports and dashboards	Reports, dashboards
◐ Import / export: any list exports as a CSV file; no import yet.	CSV Import Assistant and exports	Data Import Wizard, Data Loader
◐ API: any signed-in user (Google or guest) can read and write their own records and the shared demos through the Firebase database REST API with their ID token, under the same rules as the app.	SuiteTalk REST and SOAP web services	REST / SOAP API
◐ Multi-currency: currency fields show any currency, set on the field or taken from another field of the record (an order’s currency code); an order links to a currency in /global, copying its example rate, and a calculated field converts with it. The rates are kept in code by the admin: no automatic daily rates or revaluation.	Multi-currency with daily exchange rates, revaluation and consolidation	Multi-currency, advanced currency management (dated rates)
✗ Subsidiaries: one company per top-level record; nothing rolls up across companies.	OneWorld: many subsidiaries under one parent, with consolidated reports	Not built in (partner apps)