What properties and measures are available for HansaWorld cubes?

Invoices cube

To see available dimensions check out Invoices demo cube.

Measures and properties

CubeLevelMeasuresAvailable properties
Financials (Shared)RecordAccount Balance  
Account Debit amount  
Account Credit amount

Scroll down the report to see all properties

Goods Receipts (Shared)ItemGoods 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

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.

CubeLevelMeasuresAvailable properties
FinancialsRecordBalance
Debit amount
Credit Amount

Quotations cube

To see available dimensions check out Quotations demo cube.

CubeLevelMeasuresAvailable properties
QuotationsRecord

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

ItemItem 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

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

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)RecordIn stock
Stock on order

CRM cube

To see available dimensions check out CRM demo cube.

CubeLevelMeasuresAvailable properties
CRMRecord

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

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

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

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.

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

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

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

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

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.

CubeLevelMeasuresAvailable properties
Sales OrdersRecordSales 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)RecordIn stock
Stock on order

POS cube

To see available dimensions check out POS demo cube.

CubeLevelMeasuresAvailable properties
POSRecordPOS count 
POS amount 
Discount amount 
Tax amount 
POS base amount 
Discount base amount 
Tax base amount

Scroll down the report to see all properties
ItemItem amount 
Item quantity 
Item base amount 
Gross profit 
Gross profit base amount

Goods receipts cube

To see available dimensions check out Invoices demo cube.

CubeLevelMeasuresAvailable properties
Goods ReceiptsRecordTotal Goods Receipts count
OK Goods Receipt count
Not OK Goods Receipt count

Scroll down the report to see all properties
ItemQuantity
Total cost
Total base cost
Financials (Shared)RecordAccount 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)RecordAccount Balance  
Account Debit amount  
Account Credit amount



Scroll down the report to see all properties

Invoice item (Shared)ItemStock FIFO  
Stock Quantity  
Item quantity  
Item base amount  
Gross profit base amount
POS item (Shared)ItemPOS 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

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)ItemStock FIFO
Stock Quantity

Stock Depreciations cube

To see available dimensions check out Stock Depreciations demo cube.

CubeLevelMeasuresAvailable properties
Stock DepreciationRecordStock Depreciation count
OK Stock Depreciation count
Not OK Stock Depreciation count

Scroll down the report to see all properties
ItemFIFO
Quantity
Financials (Shared)RecordAccount 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 MovementsRecordQuantity 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
DeliveriesRecord

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