/
Hansaworld Source File import

Support center for flex.bi version 4.0

Hansaworld Source File import

Mar 02, 2020

Follow these steps:

1. Export register files from HansaWorld

2. Upload register files to flex.bi

3. Set up HansaWorld source application

4. Automate exports with HAL (Optional)

 

 

 

1. Export register files from HansaWorld

Follow These Steps

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

  1. Go to Module  Database maintenance

  2. Open  Routines > Exports > Register exports 

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

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

2. To export register for period (Only Transaction registers)

  1.  Go to Module  Integration. 

  2.  Open   Routines > Exports >  Transaction registers (period) 

  3.  Choose from the  list of transaction registers ( choose one each time). Press Ok

  4.  Save file under the technical name of register.

Note : Each register has to be exported and saved in file separately.

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.

 

Do not forget to press Import for Flex.bi Hansaworld application after file upload

List of HansaWorld Files Supported 

*  essential to create corresponding Data Cube correctly
** Dynamic you have to choose which Object or Classification types must be imported in HansaWorld Source Application

Hansaworld Invoices Data Cube

Based on Sales Ledger module and Invoices data

 

 

  • Base currency setting - BaseCurBlock *

  • Invoices - IVVc *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Persons - UserVc (Sales Person) *

  • 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) **

  • Classification types - CTypeVc

  • Item varieties - VARVc

  • Item variety groups - VARGVc **

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Routes - DelRouteVc

  • VAT codes - VATCodeBlock

Hansaworld Financials Data Cube

Based on General Ledger module and Transactions data

  • Transactions  - TRVc*

  • Simulations - SMVc

  • Accounts - AccVc*

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc *

  • VAT codes - VATCodeBlock

  • Companies - CompaniesBlock

Do not forget to press Import for Flex.bi Hansaworld application after file upload

Have a question ? Contact us

Hansaworld POS Data Cube

Based on Point of Sales module and POS Invoices data

  • Base currency setting - BaseCurBlock *

  • POS Invoices - IVCashVc *

  • Local Machines - LocalMachineVc

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Persons - UserVc (Sales Person) *

  • Item Groups - ITVc *

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Item Class - DIVc (Item Classifications) **

  • Classification types - CTypeVc

  • Item varieties - VARVc

  • Item variety groups - VARGVc **

  • VAT codes - VATCodeBlock

Hansaworld Quotations Data Cube

Based on Quotations module and Quotations data

  • Quotations - QtVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Item Class - DIVc (Item Classifications) **

  • Classification types - CTypeVc

  • Item varieties - VARVc

  • Item variety groups - VARGVc **

  • Routes - DelRouteVc  

Hansaworld CRM Data Cube

Based on CRM module and Activities data

  • Activities - ActVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Accounts - AccVc

  • Activity Types - ActTypeVc *

  • Projects - PRVc *

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Classification types - CTypeVc

  • Item Class - DIVc (Item Classifications) **

Hansaworld Sales Orders Data Cube

Based on Sales Orders module and Sales Orders data

  • Sales Orders - ORVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Location - LocationVc

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Item Class - DIVc (Item Classifications) **

  • Classification types - CTypeVc

  • Item varieties - VARVc 

  • Item variety groups - VARGVc **

  • Routes - DelRouteVc

  • VAT codes - VATCodeBlock

Hansaworld Purchase Orders Data Cube

Based on Purchase Orders module and Purchase Orders data

  • Purchase Orders - POVc *

  • Base currency setting - BaseCurBlock *

  • Projects - PRVc *

  • Persons - UserVc *

  • VAT codes - VATCodeBlock

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Classification types - CTypeVc

  • Supplier categories - VGVc

  • Customer categories - CCatVc *

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Customers - CUVc (Contacts) *

  • Item Class - DIVc (Item Classifications) **

  • Item Groups - ITVc *

  • Item varieties - VARVc 

  • Item variety groups - VARGVc **

  • Items - INVc *

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Location - LocationVc

  • Units of measure - UnitVc

Hansaworld Purchase Invoices Data Cube

Based on Purchase Ledger module and Purchase Invoices data

 

 

  • Base currency setting - BaseCurBlock *

  • Invoices - VIVc *

  • Purchase Invoice Balances - APVc / Measures Dimension

  • Persons - UserVc (Sales Person) *

  • Projects - PRVc *

  • VAT codes - VATCodeBlock

  • Accounts - AccVc*

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Classification types - CTypeVc

  • Supplier categories - VGVc

  • Customer categories - CCatVc *

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Customers - CUVc (Contacts) *

  • Item Class - DIVc (Item Classifications) **

  • Item Groups - ITVc *

  • Item varieties - VARVc

  • Item variety groups - VARGVc **

  • Items - INVc *

  • Units of measure - UnitVc

Hansaworld Job costing Data Cube

Based on Job Costing module and Project budget data

  • Project budget - TBBUVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Activity Types - ActTypeVc

  • Projects - PRVc *

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Classification types - CTypeVc

  • Item Class - DIVc (Item Classifications) **

Hansaworld Stock Data Cube

 

 

Hansaworld Goods Receipts Data Cube

Hansaworld Stock Depreciation Data Cube

Hansaworld Stock Movements Data Cube

Hansaworld Deliveries Data Cube

 

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.

 

 

Hansaworld Stock Data Cube

  • Item status - ItemStatusVc *

  • Item History - ItemHistVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Location - LocationVc

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Item Class - DIVc (Item Classifications) **

  • Classification types - CTypeVc

  • Item varieties - VARVc 

  • Item variety groups - VARGVc **

Hansaworld Goods Receipts Data Cube

  • Goods Receipts - PUVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Location - LocationVc

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Object Class - OTVc (Object Types) **

  • Objects - ObjVc

  • Customer Class -  CCLassVc (Contact Classifications) **

  • Item Class - DIVc (Item Classifications) **

  • Classification types - CTypeVc

  • Item varieties - VARVc

  • Item variety groups - VARGVc **

  • VAT codes - VATCodeBlock

  • Supplier categories - VGVc

Hansaworld Stock Depreciation Data Cube

  • Stock Depreciation - SDVc *

  • Base currency setting - BaseCurBlock *

  • Customers - CUVc (Contacts) *

  • Customer categories - CCatVc *

  • Items - INVc *

  • Item Groups - ITVc *

  • Persons - UserVc (Sales Person) *

  • Location - LocationVc

  • Location types - LocClTypeVc **

  • Location classes - LocCLVc

  • Object Class - OTVc (Object Types) **