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
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
Financials	Record	Balance Debit amount Credit Amount

Quotations cube

To see available dimensions check out Quotations demo cube.

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
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
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
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
Sales Orders	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
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
POS	Item	Item amount Item quantity Item base amount Gross profit Gross profit base amount	Scroll down the report to see all properties

Goods receipts cube

To see available dimensions check out Invoices demo cube.

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
Goods Receipts	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
Financials (Shared)	Record	Account Balance Account Debit amount Account Credit amount	Scroll down the report to see all properties
Invoice item (Shared)	Item	Stock FIFO Stock Quantity Item quantity Item base amount Gross profit base amount
POS item (Shared)	Item	POS Item quantity POS Item base amount POS Gross profit base amount
Stock	Item Status	In stock On order On Purchase orders On unOKed purchase orders On delivery Incoming Outgoing Item Varieties
Stock	Item History	Stock In Stock Out Non-Stock In Non-Stock Out Total cost In Total cost Out Total Non-Stock cost In Total Non-Stock cost Out
Invoice (Shared)	Item	Stock FIFO Stock Quantity

Stock Depreciations cube

To see available dimensions check out Stock Depreciations demo cube.

Cube	Level	Measures	Available properties
Stock Depreciation	Record	Stock Depreciation count OK Stock Depreciation count Not OK Stock Depreciation count	Scroll down the report to see all properties
Stock Depreciation	Item	FIFO Quantity
Financials (Shared)	Record	Account Balance Account Debit amount Account Credit amount

Stock Movements cube

To see available dimensions check out Stock Movements demo cube.

Cube	Level	Measures	Available properties
Stock Movements	Record	Quantity In Quantity Out Total Cost In Total Cost Out	Scroll down the report to see all properties

Deliveries cube

To see available dimensions check out Deliveries demo cube.

Cube

Level

Measures

Available properties

Deliveries

Record

Delivery Count

Total Shipped Quantity

Total Weight

Total Volume

Scroll down the report to see all properties

Item

Shipped Quantity

Item Row Count

FIFO

Item base amount

Ordered Quantity

Purchase Order cube

To see available dimensions check out Purchase Order demo cube.

Cube	Level	Measures	Available properties
Purchase Orders	Record	Purchase Order amount Discount amount Tax amount Purchase Order base amount Discount base amount Tax base amount Purchase Order count	Scroll down the report to see all properties
Purchase Orders	Item	Item amount Item quantity Item base amount Open amount Open base amount Open quantity
Stock (Shared)	Record	In stock Stock on order

Purchase Invoices cube

To see available dimensions check out Purchase Invoices demo cube.

Measures and 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 Item Quantity Goods Receipts Total cost Goods Receipts Total base cost
Purchase Invoice	Record	Purchase Invoice amount Purchase Invoice tax amount Purchase Invoice base amount Purchase Invoice tax base amount Purchase Invoice count Purchase Invoice balance Purchase Invoice base balance
Purchase Invoice	Item	Purchase Invoice item amount Purchase Invoice item quantity Purchase Invoice item base amount Purchase Invoice row count
Purchase Order (Shared)	Record	Purchase Order amount Purchase Order discount amount Purchase Order tax amount Purchase Order base amount Purchase Order discount base amount Purchase Order tax base amount Purchase Order count
Purchase Order (Shared)	Item	Purchase Order item amount Purchase Order item quantity Purchase Order item base amount Purchase Order open amount Purchase Order open base amount Purchase Order open quantity