Solavel Docs
English

Dimensions & Custom Fields

Last updated

Dimensions (reporting tags) let you slice your numbers by department, branch, project, campaign or cost centre. Custom fields add your own data fields to records and documents. Dimensions feed dedicated reports; custom fields store information.

Plan availability: both are Professional and above. On Free, existing custom fields and their values are preserved but read-only ("Custom Fields are read-only on Free. Upgrade to … to edit them.").

#Custom fields in the current document workspace

Every supported create/edit workspace has a Custom fields disclosure, even when no fields have been defined. Expand it to enter the fields for this document type. If permitted, Add custom field opens field management; otherwise a plan/access explanation is shown. Define the field for the intended entity, including Sales Order or Purchase Order when needed. Creating a field for an invoice does not automatically create it for every other document.

Example: create a required text field Customer PO reference for Sales Order. Return to a new sales order, expand Custom fields, enter PO-2048, then save. It records the customer's reference without changing the order's own number or creating a financial posting. Use a dimension instead when the purpose is line-based financial reporting.

#Where to find it

Settings (left rail) → Accounting & Tax:

Item URL Permission
Dimensions /settings/dimensions dimensions.view / dimensions.manage
Custom Fields /settings/custom-fields?entity_type=all custom_fields.manage (Owner by default)

Dimension reports: Reports → Business Overview → P&L by Dimension, Reports → Purchases → Expenses by Dimension and Revenue by Dimension (see Reports that use dimensions).

#Dimensions

A dimension is a question you want to answer in reports: which branch, which department, which campaign? Each dimension has values (Dubai, Sharjah). You tag document lines with values, and the dimension reports group the posted amounts by them. Two guides show it end to end: profit by branch and splitting a shared expense between branches.

#Set up (Settings → Dimensions)

The page lists your dimensions, with Search dimensions and a status filter (Active / Inactive).

  1. In Create dimension type enter a Name (for example Branch) and, optionally, a code (generated from the name if left blank).
  2. Tick Allow multiple values per line only if one line may genuinely belong to several values (for example several campaigns). For Branch or Department leave it off, so each line has exactly one value.
  3. Click Create.

Each dimension appears as a card with its name, a chip (Single-value only or Multi-value enabled), an Active badge and Activate / Deactivate.

  • Values come first in the card. Each row has a name, an optional code, Save, and Activate / Deactivate. To add one, type New value name (and an optional code) and click Add Value. Deactivated values disappear from new documents but old tags stay.
  • Expand Settings, required accounts and import / export for the less common controls:
    • Type settings: rename the dimension or change its code or the multi-value option, then Save.
    • Required accounts: choose an account and click Require, so any line posted to that account must carry a value of this dimension (for example Branch on every expense account). Remove deletes a rule.
    • Export CSV and Import of values, to load a long list at once.

#Choose the value on a document

Invoices, sales receipts, bills, expenses and manual journals can be tagged. You need dimensions.assign to save tags.

  • Document header (invoices, bills, expenses and other document forms). Beside Project each active dimension gets one select, for example Branch. Choosing a value sets it on every line, and new lines you add start with the same value. — None — clears it. If lines differ, the field reads Mixed (per line); picking a value again overwrites all lines.
  • More than two dimensions. The header shows one compact Dimensions field instead of one per dimension. It summarises what is set (for example Branch: Dubai · 1 more, or Not set) and opens a small panel with a select per dimension. Press Esc or click outside to close it.
  • Single line. Click the sitemap icon at the end of a line (tooltip Project & dimensions; it changes to Allocation assigned when something is set) to open the line's allocation row. A single-value dimension is a compact select; a multi-value dimension with up to 12 values shows toggle chips you click on and off.
  • Manual journals. There is no header choice; each line has its own dimension pickers.
  • Posted documents. The header choice is locked. Re-tag lines through the posted-document line review, which changes the tags without changing amounts, quantities or tax (Posted corrections).

Tags are per line and never change which accounts are posted. A required-account rule blocks saving or posting with "Missing required dimensions: …" or, on a document line, a message naming the line and the field.

#Reports that use dimensions

Open Reports and choose:

Report Where Shows
Revenue by Dimension Reports → Purchases Posted revenue and other income, grouped by the dimension values you choose.
Expenses by Dimension Reports → Purchases Posted expenses, cost of sales, other expenses and interest.
P&L by Dimension Reports → Business Overview Revenue, Expenses and Profit for each value, with a Net Profit headline.

On each report: set From and To; open Accounts to limit to certain accounts; open Group by and tick up to two dimensions (two gives a matrix with row and column totals); when a dimension is grouped, a filter for its values appears so you can show only one value (for example Dubai). Click Apply, then use PDF, Print or Excel. Lines with no value appear as Unassigned. The details table shows the latest 300 lines. Reports read posted journals only, in your base currency.

Profit per value. P&L by Dimension shows Revenue, Expenses and Profit for each value and a Net Profit headline; a loss is negative. The grand total, including Unassigned, equals the net profit of the standard Profit & Loss for the same dates. A line that carries several values of a multi-value dimension counts 1/n under each value, in this report and in the revenue and expense reports, so nothing is counted twice.

Stock sales and credit notes. The cost of goods sold and inventory lines of a stock invoice or sales receipt keep the sales line's tags; the same item on two lines for two branches stays separate. On a credit note, the sales return, discount, VAT and restock lines keep the tags of the original invoice line, and tags you choose on the credit line win. If two invoice lines have the same item and price but different tags, tag the credit line yourself; otherwise it stays untagged. Reversals copy the tags. With SolaStock connected, cost of sales is posted from the stock shipment. Those COGS and inventory lines take the branch of the invoice lines the shipment fulfils, and a SolaStock return takes the branch of the credit or invoice line. When one shipment or return covers lines from different branches, each branch receives its line's actual stock cost. A SolaStock shipment or return journal posted before this update reached SolaCount (the evening of 20 November 2026) keeps no branch, appears under Unassigned and is not changed automatically. A review of all customer companies found no tagged stock sales before the update, so no customer history is affected; only internal test entries were posted earlier.

Dimension reports need the Dimensions plan feature and dimensions.view. A budget can also be scoped to one dimension value (Dimension value (optional)) and compared in Budget vs Actuals with the Scope filter and the Combined by view; see Budgets.

#Worked example

Palm Grove Furnishings LLC creates Branch with Dubai and Sharjah and requires it on Service Revenue, Rent and Utilities. In October, Dubai invoices 10,000 and has expenses of 4,600; Sharjah invoices 6,000 and has expenses of 3,400. Grouping P&L by Dimension by Branch shows profit of 5,400 (Dubai) and 2,600 (Sharjah). A shared rent bill of 12,000 is entered as two lines, 7,200 tagged Dubai and 4,800 tagged Sharjah, so each branch carries its share while the supplier is paid once. There is no automatic percentage split; you divide the amount into lines yourself. P&L by Dimension shows the same result in one table: Dubai 10,000 / 4,600 / 5,400 and Sharjah 6,000 / 3,400 / 2,600 (Revenue / Expenses / Profit).

#Custom fields

#Create a custom field

  1. Open Settings → Custom Fields. Filter by Entity or keep All Entities.
  2. Click New Field.
  3. Choose the Entity, enter a Label and optional Internal Name ("Auto-generated from label unless overridden.").
  4. Choose the Field Type: Text, Textarea, Number, Date, Date & Time, Select, Multi Select, Checkbox. For selects, enter Options (comma or new-line separated).
  5. Mark Required if needed, then Save Field.

Supported entities: customers, suppliers (vendors), products, quotes, sales orders, purchase orders, invoices, sales receipts, credit notes, debit notes, bills, expenses, payments, bill payments, journal entries, bank transactions and recurring templates.

#Manage fields

In the field list: Edit, Delete ("Delete this custom field? Existing values will also be deleted."), and instant Required/Active toggles. Select a single entity to drag rows to reorder (Order saved).

Fields appear on the entity's create/edit form, on its detail page sidebar, in bulk-import grids (Custom Fields column) and as variables in PDF templates.

#Rules

  • Dimensions are analytic only; custom fields are descriptive. Neither changes which accounts are posted.
  • A required custom field or a required-account dimension blocks saving until filled.
  • Posted documents keep their original tags; change them only through the posted line review.
  • Deleting a custom field deletes its values.

#Common problems

  • No Branch field in the header — the dimension is inactive, has no active values, you lack dimensions.assign, or your plan does not include Dimensions. A locked-capability notice appears on the form when the plan is the cause.
  • A report shows an Unassigned row — posted lines without a value. Require the dimension on the account, and re-tag old documents through the posted line review.
  • A cost is split between values — the dimension allows several values per line, so the line counts 1/n under each. Use single-value for branches and split the amount into lines.
  • "Required" error on posting — a Required Accounts rule applies to that account.
  • Can't edit custom fields — plan downgraded to Free (values are preserved) or you lack custom_fields.manage.