Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Status | ||||
---|---|---|---|---|
|
Info | ||||||||
---|---|---|---|---|---|---|---|---|
To export data only for specific period, for example, invoices for 2016, use module Integration > Routines > Exports > Transaction registers (period). |
Contact us if you want to use Automated exports from your HansaWorld with HAL.
List of HansaWorld Files Supported
*
to create coresponding Data Cube correctly Status colour Blue title essential
**
you have to choose which Object or Classification types must be imported in HansaWorld Source Application Status colour Blue title Dynamic
Based on Sales Ledger module and Invoices data
|
| ||||||||||||||||||||||||||||||
Based on General Ledger module and Transactions data |
| ||||||||||||||||||||||||||||||
Have a question ? Contact us | |||||||||||||||||||||||||||||||
Based on Quotations module and Quotations data |
| ||||||||||||||||||||||||||||||
Based on CRM module and Activities data |
| ||||||||||||||||||||||||||||||
Based on Sales Orders module and Sales Orders data |
| ||||||||||||||||||||||||||||||
Based on Job Costing module and Project budget data |
| ||||||||||||||||||||||||||||||
Stock module in HansaWorld has 5 transaction registers. Flex.bi supports them all in a seperate data cubes. As we also have shared measures - data from Goods received will be available in also in Stock cube, and for example.
|
| ||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
|
Tip |
---|
Standard ERP If you do not see this module in the list of modules you have to add it to the user account in System > Settings > Access Groups. To find which Access group you have access rights from, you have to look in System > Register > Persons by opening your personal record. |
Anchor | ||||
---|---|---|---|---|
|
For HansaWorld Books 6.3 to export registers you have to go to the System module and for:
- AcVc - System data/Accounts
- AccVc - Registers (period)
- To export Objects - please contact your partner
To create report " Item Statistics By Customer And Object" you have to export data from Sales ledger module that builds Invoices Data cube in Flex.bi and is based on Invoice data. According to list, you have to export :
Keep in mind that HansaWorld Module = Data cube in Flex.bi language. |
How does it work ?
You decide which HansaWorld Modules data you would like to see in Flex.bi, export files in HansaWorld standard format (*txt), afterwards you go to Flex.bi and upload them and setup Hansaworld Import application. Flex.bi will create Data Cubes for Each Hansaworld module data automatically based on files you upload and Import.
Keep in mind that HansaWorld Module = Data cube in Flex.bi language.
Info |
---|
If you would like to have your data imported automatically from HansaWorld to Flex.bi using files, you need to connect Automated exports from your HansaWorld. For HAL license owners we provide HAL code package that configures automatic exports for chosen data and period. Please contact us or your local Hansaworld partner for more info. |
Status | ||||
---|---|---|---|---|
|
Info | ||||||||
---|---|---|---|---|---|---|---|---|
To export data only for specific period, for example, invoices for 2016, use module Integration > Routines > Exports > Transaction registers (period). |
Contact us if you want to use Automated exports from your HansaWorld with HAL.
List of HansaWorld Files Supported
* **
Status | ||||
---|---|---|---|---|
|
Based on Sales Ledger module and Invoices data
- Base currency setting - BaseCurBlock *
- Invoices - IVVc *
- Customers - CUVc (Contacts)
- Items - INVc
- Persons - UserVc (Sales man)
- Item Groups - ITVc
- Invoice Balances - ARVc / Measures Dimension
- Location - LocationVc
- Object Class - OTVc (Object Types) **
- Objects - ObjVc
- Customer Class - CCLassVc (Contact Classifications) **
- Item Class - DIVc (Item Classifications) **
- Item varieties - VARVc
Item variety groups - VARGVc **
Location classes - LocClTypeVc**
Location types - LocCLVc
Status | ||||
---|---|---|---|---|
|
Based on General Ledger module and Transactions data
- Transactions - TRVc*
- Accounts - AccVc*
- Object Class - OTVc (Object Types) **
- Objects - ObjVc *
Status | ||||||
---|---|---|---|---|---|---|
|
Have a question ? Contact us
Quotations
Hansaworld Quotations
- Quotations - QtVc*
- Customers - CUVc (Contacts)*
- Items - INVc*
- Item Groups - ITVc*
- Persons - UserVc * (Sales Person)
- Object Types - OTVc **
- Objects - ObjVc
- Customer Class - CCLassVc (Contact Classifications)**
- Item Class - DIVc (Item Classifications)**
- Item varieties - VARVc
- Item variety groups - VARGVc **
CRM
Hansaworld CRM
- Activities - ActVc
- Customers - CUVc (Contacts)
- Items - INVc
- Item Groups - ITVc
- Persons - UserVc ( Sales man )
- Accounts - AccVc
- Activity Types - ActTypeVc
- Projects - PRVc
- Object Class - OTVc (Object Types) **
- Objects - ObjVc
- Customer Class - CCLassVc (Contact Classifications)
- Item Class - DIVc (Item Classifications)
Sales Orders
Hansaworld Sales Orders
Sales Orders - ORV
Expand | ||
---|---|---|
| ||
|
Job costing
Hansaworld Job costing
Project budget - TBBUVc
Expand | ||
---|---|---|
| ||
|
Stock module
Hansaworld Stock
Hansaworld Goods Receipts
Hansaworld Stock Depreciation
Hansaworld Stock Movements
In HansaWorld has 5 transaction registers. we support them all in a seperate data cube. As we also have shared measers - information from Goods received will be available in also in Stock cube, for example.
Item status - ItemStatusVc
Item History - ItemHistVc
Expand | ||
---|---|---|
| ||
|
Goods Receipts - PUVc
Expand | ||
---|---|---|
| ||
|
Stock Depreciation - SDVc
Expand | ||
---|---|---|
| ||
|
Stock Movements - StockMovVc
title | Extra dimensions Stock Movements cube |
---|
Tip |
---|
Standard ERP If you do not see this module in the list of modules you have to add it to the user account in System > Settings > Access Groups. To find which Access group you have access rights from, you have to look in System > Register > Persons by opening your personal record. |
Expand the lists below to see the specific registers needed/supported for every Flex.bi cube
For all cubes export : Base currency setting - BaseCurBlock
Expand | ||
---|---|---|
| ||
|
title | HansaWorld Invoice cube registers |
---|
- Customers - CUVc (Contacts)
- Items - INVc
- Item Groups - ITVc
- Invoices - IVVc
- Invoice Balances - ARVc (ARVc)
Users - UserVc (Persons)
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Note |
---|
Goods Receipt, Stock Depreciation, Stock Movement cubes require that the Stock cube is also imported with locations and the optional location classes and location types. |
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
title | HansaWorld Stock Movements cube registers |
---|
Export data from HansaWorld
For HansaWorld Books 6.3 to export registers you have to go to the System module and for:
- AcVc - System data/Accounts
- AccVc - Registers (period)
- To export Objects - please contact your partner
1. To export All Register content
Use this option to export all register content, for example - all Invoices, by typing technical name of it " IVVc" in if Register export
- Go to Module Database maintenance
- Open Routines > Exports > Register exports
- Write in technical name of register. Press Ok
Save file under the technical name of register.
Note : Each register has to be exported and saved in file separately.
2. To export register for period ( Only Transaction registers )
- Go to Module Integration.
- Open Routines > Exports > Transaction registers (period)
- Choose from the list of transaction registers ( choose one each time). Press Ok
Save file under the technical name of register.
Note : Each register has to be exported and saved in file separately.
How to export ?
Open your Hansaworld Standard ERP client and make sure you have access to modules Database maintenance and Integration.
- Go to Module Database maintenance
- Open Routines > Exports > Register exports
- Type in the Technical name of register, for example, try exporting Customers - CUVc . Press Ok. See the list below for Technical name s of registers.
Save file and use the technical name as a filename, to make it easier to recognise the content afterwards. Example: IVVc.txt , CUVc.txt
Important: Save files under the technical name of register and period. Each register has to be exported and saved in file separately.
To export data only for specific period, for example, invoices for 2016, use module Integration > Routines > Exports > Transaction registers (period).
This can be used only for Transaction registers.
To create report " Item Statistics By Customer And Object" you have to export data from Sales ledger module that builds Invoices Data cube in Flex.bi and is based on Invoice data. According to list, you have to export :
Keep in mind that HansaWorld Module = Data cube in Flex.bi language. |
How does it work ?
You decide which HansaWorld Modules data you would like to see in Flex.bi, export files in HansaWorld standard format (*txt), afterwards you go to Flex.bi and upload them and setup Hansaworld Import application. Flex.bi will create Data Cubes for Each Hansaworld module data automatically based on files you upload and Import.
Keep in mind that HansaWorld Module = Data cube in Flex.bi language.
Info |
---|
If you would like to have your data imported automatically from HansaWorld to Flex.bi using files, you need to connect Automated exports from your HansaWorld. For HAL license owners we provide HAL code package that configures automatic exports for chosen data and period. Please contact us or your local Hansaworld partner for more info. |