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
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
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

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

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

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

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

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

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

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