What properties and measures are available for HansaWorld cubes?

Invoices cube

To see available dimensions check out Invoices demo cube.

Measures and properties

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties
Financials (Shared)	Record	Account Balance Account Debit amount Account Credit amount	Scroll down the report to see all properties
Goods Receipts (Shared)	Item	Goods Receipts Quantity Goods Receipts Total cost Goods Receipts Total base cost
Invoice	Record	Invoice amount Discount amount Tax amount Invoice base amount Discount base amount Tax base amount Invoice count Invoice balance Invoice base balance New customer count
Invoice	Item	Item amount FIFO Gross profit Item quantity Item base amount Gross profit base amount Stock FIFO Stock Quantity
Quotation (Shared)	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount
Sales Order (Shared)	Record	Sales Order amount Sales Order base amount Sales Order Item open amount Sales Order Item open base amount
Stock (Shared)	Record	In stock Stock on order Stock In Stock Out

Financials cube

To see available dimensions check out Financials demo cube.

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties
Financials	Record	Balance Debit amount Credit Amount

Quotations cube

To see available dimensions check out Quotations demo cube.

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties
Quotations	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Discount amount Tax amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount Discount base amount Tax base amount Probability Quotation count Open Quotation count Rejected Quotation count Accepted Quotation count	Scroll down the report to see all properties
Quotations	Item	Item amount Item quantity Item base amount Discount amount Discount base amount Gross profit Gross profit base amount
Invoices (Shared)	Record	Invoice amount Invoice Discount amount Invoice Tax amount Invoice base amount Invoice Discount base amount Invoice Tax base amount Invoice count Invoice balance Invoice base balance
Invoices (Shared)	Item	Invoice Item amount Invoice FIFO Invoice Gross profit Invoice Item quantity Invoice Item base amount Invoice Gross profit base amount
Sales Orders (Shared)	Record	Sales Order amount Sales Order Discount amount Sales Order Tax amount Sales Order base amount Sales Order Discount base amount Sales Order Tax base amount Sales Order count
Sales Orders (Shared)	Item	Sales Order Item amount Sales Order Item quantity Sales Order Item base amount Sales Order Gross profit Sales Order Gross profit base amount Sales Order Open amount Sales Order Open base amount Sales Order Open quantity
Stock (Shared)	Record	In stock Stock on order

CRM cube

To see available dimensions check out CRM demo cube.

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties
CRM	Record	Activity Duration Activity Count Activity OKed Duration Activity OKed Count Activity Not OKed Duration Activity Not OKed Count	Scroll down the report to see all properties
Invoices (Shared)	Record	Invoice amount Discount amount Tax amount Invoice base amount Discount base amount Tax base amount Invoice count Invoice balance Invoice base balance
Invoices (Shared)	Item	Item amount FIFO Gross profit Item quantity Item base amount Gross profit base amount
Quotations (Shared)	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Quotation Discount amount Quotation Tax amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount Quotation Discount base amount Quotation Tax base amount Quotation count
Quotations (Shared)	Item	Quotation Item amount Quotation Item quantity Quotation Item base amount Quotation Gross profit Quotation Gross profit base amount
Sales Orders (Shared)	Record	Sales Order amount Sales Order Discount amount Sales Order Tax amount Sales Order base amount Sales Order Discount base amount Sales Order Tax base amount Sales Order count
Sales Orders (Shared)	Item	Sales Order Item amount Sales Order Item quantity Sales Order Item base amount Sales Order Gross profit Sales Order Gross profit base amount Sales Order Open amount Sales Order Open base amount Sales Order Open quantity

Job Costing cube

To see available dimensions check out Job Costing demo cube.

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties
CRM (Shared)	Record	Activity Duration Activity Count Activity OKed Duration Activity OKed Count Activity Not OKed Duration Activity Not OKed Count	Scroll down the report to see all properties
Job Costing	Item	Item budget amount Item budget base amount Item budget quantity Budget Gross profit Budget Gross profit base Budget discount amount Budget discount base amount Item budget count
Invoices (Shared)	Record	Invoice amount Invoice Discount amount Invoice Tax amount Invoice base amount Invoice Discount base amount Invoice Tax base amount Invoice count Invoice balance Invoice base balance New customer count
Invoices (Shared)	Item	Invoice Item amount Invoice FIFO Invoice Gross profit Invoice Item quantity Invoice Item base amount Invoice Gross profit base amount
Quotations (Shared)	Record	Quotation amount Quotation base amount Quotation Discount amount Quotation Discount base amount Quotation Tax amount Quotation Tax base amount Quotation count
Quotations (Shared)	Item	Quotation Item amount Quotation Item quantity Quotation Item base amount Quotation Gross profit Quotation Gross profit base amount
Sales Order (Shared)	Record	Sales Order amount Sales Order base amount Sales Order Discount amount Sales Order Discount base amount Sales Order Tax amount Sales Order Tax base amount Sales Order count
Sales Order (Shared)	Item	Sales Order Item amount Sales Order Item base amount Sales Order Item quantity Sales Order Gross profit Sales Order Gross profit base amount
Job Costing	Record	Project budget amount Project budget base amount Project count

Sales Order cube

To see available dimensions check out Sales Order demo cube.

Cube	Level	Measures	Available properties

Cube

Level

Measures

Available properties

Sales Orders

Record

Sales Order amount
Discount amount
Tax amount
Sales Order base amount
Discount base amount
Tax base amount
Sales Order count

Scroll down the report to see all properties

Item

Item amount
Item quantity
Item base amount
Gross profit
Gross profit base amount
Open amount
Open base amount
Open quantity

Stock (Shared)

Record

In stock
Stock on order

POS cube

To see available dimensions check out POS demo cube.

Cube	Level	Measures	Available properties

Cube

Level

Measures

Available properties

POS

Record

POS count
POS amount
Discount amount
Tax amount
POS base amount
Discount base amount
Tax base amount

Scroll down the report to see all properties

Item

Item amount
Item quantity
Item base amount
Gross profit
Gross profit base amount

Goods receipts cube

To see available dimensions check out Invoices demo cube.

Cube	Level	Measures	Available properties

Cube

Level

Measures

Available properties

Goods Receipts

Record

Total Goods Receipts count
OK Goods Receipt count
Not OK Goods Receipt count

Scroll down the report to see all properties

Item

Quantity
Total cost
Total base cost

Financials (Shared)

Record

Account Balance
Account Debit amount
Account Credit amount

Stock cube

To see available dimensions check out Stock demo cube.

Cube	Level	Measures	Available properties

Cube	Level	Measures	Available properties