Support center for flex.bi version 4.0
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 | |
Item | Item amount | ||
Quotation (Shared) | Record | Quotation amount | |
Sales Order (Shared) | Record | Sales Order amount | |
Stock (Shared) | Record | In stock |
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 | Scroll down the report to see all properties |
Item | Item amount Item quantity Item base amount Discount amount Discount base amount Gross profit Gross profit base amount | ||
Invoices (Shared) | Record | Invoice amount | |
Item | Invoice Item amount | ||
Sales Orders (Shared) | Record | Sales Order amount | |
Item | Sales Order Item amount | ||
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 | |
Invoices (Shared) | Record | Invoice amount | |
Item | Item amount | ||
Quotations (Shared) | Record | Quotation amount | |
Item | Quotation Item amount | ||
Sales Orders (Shared) | Record | Sales Order amount | |
Item | Sales Order Item amount |
Job Costing cube
To see available dimensions check out Job Costing demo cube.
Cube | Level | Measures | Available properties |
---|---|---|---|
CRM (Shared) | Record | Activity Duration | |
Job Costing | Item | Item budget amount | |
Invoices (Shared) | Record | Invoice amount | |
Item | Invoice Item amount | ||
Quotations (Shared) | Record | Quotation amount | |
Item | Quotation Item amount | ||
Sales Order (Shared) | Record | Sales Order amount | |
Item | Sales Order Item amount | ||
Job Costing | Record | Project budget amount |
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 | |
Item | Item amount | ||
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 | |
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 |
---|---|---|---|
Goods Receipts | Record | Total Goods Receipts count OK Goods Receipt count Not OK Goods Receipt count | |
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 | |
Item History | Stock In | ||
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 | |
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 | |
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 | |
Item | Item amount | ||
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 | |
Item | Purchase Invoice item amount | ||
Purchase Order (Shared) | Record | Purchase Order amount | |
Item | Purchase Order item amount |