Getting Started with Gcon4 iConnect
Please select a topic on the left menu to get more info about it. For every topic see the different sections listed on the right.
Main aspects of iConnect
- iConnect automatically creates Excel templates to be uploaded to UNIT4 ERPx based on UNIT4 ERPx information browsers, considering the relations and flexi-fields that each master file contains.
- iConnect can be used to INSERT new information or UPDATE existing data at the same time into UNIT4 ERPx
- iConnect verifies that the data uploaded is correct. If there are any inconsistencies in the data, the detailed error is displayed.
- The retrieving of data is made based on
Information Browsersreports. - The processes are handled through a Queue system.
Differences between GCON4 iConnect and GCON4 MFL
These are the main differences between both data migration tools.
| Gcon4 iConnect | Gcon4 MFL |
|---|---|
| API-based web service | Standard ACT |
| Designed for UNIT4 ERPx | Designed for UNIT4 ERP |
| Enquiry of ERPx reports to generate templates | Direct enquiry on database tables related to each masterfile |
| Masterfiles got via API | Validation on ERP menu entries (from Web client) |
The following masterfiles / transactional information are currently supported:
| Masterfile | iConnect (ERPx) | ERPx Screen code | MFL (ERP) | ERP Screen code |
|---|---|---|---|---|
| Absence information | x | TPS023 | ||
| Account | x | TGL001 | x | TGL001 |
| Account groups | x | TGL003 | ||
| Applicant | x | TPS001 | ||
| Assets | x | TAT002 | ||
| Attribute | x | TGL004 | ||
| Attribute (Attribute details) | x | TGL005 | x | TGL005 |
| Attribute list | x | |||
| Balance | x | TPR055 | ||
| Balance value references | x | TPR021 | ||
| Company | x | TCR033 | ||
| Contracts | x | TCN001 | ||
| Country | x | TAG006 | ||
| Course | x | TTA007 | ||
| Course event | x | TTA008 | ||
| Currency code | x | TCR032 | ||
| Custom titles | x | TAG034 | ||
| Customer | x | TCU002 | x | TCU002 |
| Customer group | x | TCU001 | ||
| Customer pay recipient | x | TCU027 | ||
| Employee competences | x | TCV008 | ||
| Exchange rate entry | x | TCR029 | x | |
| Goods Receipt | x | TPO006 | x | TRA015 |
| Goods Return | x | TPO007 | ||
| Holidays | x | THS039 | ||
| Menu | x | N/A | ||
| Menu Access | x | XAG003 | ||
| Pay Scales | x | TPR038 | ||
| Payment and Deductions | x | TPR002 | x | TPR002 |
| Payment Dispatch | x | TPR020 | ||
| PD Connections | x | TPR004 | ||
| Personnel (Employee) | x | THS005 | x | THS005 |
| Personnel cost distribution | x | TPR041 | ||
| Personnel employment | x | THS005 | ||
| Personnel Rate | x | TPR014 | ||
| Personnel work schedule | x | THS035 | ||
| Position | x | THS032 | x | THS032 |
| Position code | x | TPR062 | ||
| Posting cycle | x | TCR009 | ||
| PostingAP/AR/GL (Financial transaction batch) | x | TCR021 | x | TCR021 |
| Products | x | TLG002 | x | TLG002 |
| Project Information | x | TTS001 | x | TTS001 |
| Purchase Order amendment | x | TLG018 | ||
| Purchase orders | x | TPO050 | x | TRA015 |
| Rate value references | x | THS034 | ||
| Rates | x | THS034 | ||
| Relation | x | TGL006 | ||
| Requisitions (Requisitions - simple) | x | XPQ002 | ||
| Requisitions (Requisitions - standard) | x | TPO002 | ||
| Revenue recognition | x | XRC001 | ||
| Role Information | x | TAG062 | x | TAG062 |
| Sales Order | x | TSO011 | x | TSO011 |
| Stock withdrawal | x | TRA015 | ||
| StockEntry | x | TRA015 | ||
| Subscriptions | x | TUI001 | ||
| Supplier | x | TSU002 | x | TSU002 |
| Supplier pay recipient | x | TSU027 | ||
| Supplier group | x | TSU001 | ||
| Timesheet | x | TTS025 | ||
| Timesheet single | x | |||
| Training needs | x | TTA001 | ||
| Transaction document archive | x | |||
| Transaction series | x | TCR004 | ||
| Transaction types | x | TCR041 | ||
| User Information | x | TAG064 | x | TAG064 |
| Value Reference | x | TPR021 | TPR021 | |
| Value matrix | x | TGL036 | ||
| Work Order information | x | TTS047 | x | TTS047 |
| Workflow substitute rule | x | |||
| Workschedule | x | THS031 |
Additionally, through the master file “Attribute details”, the following values can be treated:
| Description | Att Desc | Att ID | Module |
|---|---|---|---|
| Relation group | RELGRP | GM | CR |
| Currency types | EXCHTYPE | AZ | CR |
| Posting groups | POSTGRP | AB | CR |
| Journal ID | REPJOURN | K0 | GL |
| Portfolio status | PORTSTAP | I3 | AP-AR |
| Complain codes | COMPLAIN | AM | AP-AR |
| Text types for invoice description | TEXTTYPE | G0 | AP-AR |
| Payment status | PAYSTAT | GP | AR |
| Collection agency | COLLAGENT | GH | AR |
| Invoice history status codes | FASTAT | AA | AP-AR |
| Portfolio status | PORTSTAT | G3 | AR |
| Cheque status | CHQSTAT | GB | AR |
| Depreciation books | DEPRBOOK | G11 | AT |
| Posting types | POSTTYPE | G12 | AT |
| Accountants | ACCNO | G1 | CA |
| Transaction type | ZTYPE | I0 | CA |
| Contract groups | CON.GRP | A9 | CN |
| Contr. Type | CON.TYPE | A8 | CN |
| Units | UNITCODE | AU | CN |
| Budget proposal | BUDPROP | GC | BU |
| Budget year | BUDYEAR | G6 | BU |
| Scheme types | SCHTYPE | G8 | FP |
| Statistical types | STATTYPE | GY | AC |
| Day type variants | DTVAR | H1 | TS-PS |
| Income categories | INC.CAT | B2 | TS |
| Cost categories | COST.CAT | B3 | TS |
| Resource connection | CONNECT | BC | TS |
| Discipline | DISCIP | B5 | TS |
| Resource types | RESTYP | C2 | TS-PS-TT |
| Project types | PRO.TYPE | B4 | TS |
| Resource groups | RESGRP | C6 | TS-PS-TT |
| Job types | JOBTYPE | BH | TS |
| Units | UNIT | BK | TS |
| Rate codes | RATE | BP | TS |
| Function type | FUNCTYPE | BR | RR |
| Pay step | PAYSTEP | CS | PR |
| Position authorization | POSAUTH | CR | PR |
| Position code | POSCODE | CQ | PR |
| Appointment type | APPTYPE | CV | PR |
| Pay step | PAYSTEP | CS | PR |
| Treatment code | TRERULE | CY | PR |
| Course types | COURSTYP | IB | TA |
| Next of kin codes | FAMILY | C3 | PS |
| Transport types | TRANSP | CZ | TT |
| Terms of delivery | DELTERM | D2 | SO-PO |
| Modes of delivery | DELMET | D3 | SO-PO |
| Invoicing amount limits | AMNTLIM | DH | SO-UI |
| Initiator | TASKSUPP | DR | SO-UI |
| Price method | PRICEMET | DJ | SO-UI |
| Time pricing | PRICETIM | DN | SO-UI |
| Price per year | PRICEPER | DO | SO-UI |
| Property type | PROPTYPE | DP | UI |
| Codes for price list groups | PRICEGROUP | D28 | OS |
| Price list codes | PRICECODE | D14 | OS |
| Add up codes | ADDUP | D32 | OS |
| Event status codes | EVENTSTAT | D26 | OS |
| Additional information groups | SOCINFOGR | D29 | OA |
| Additional info rows | SOCINFOGR | D27 | OA |
| Reason codes | DIAGNOSIS | D13 | OS |
| Priority codes | PRIO | D15 | OS |
| Action codes | SERVACTION | D12 | OS |
| Area codes | AREA | D10 | OA |
| SOC scheme codes | SOCSCHEME | D16 | OA |
| SOC rule codes | SOCRULE | D17 | OA |
| Index series | INDEXESERIE | D18 | OA |
| Price types | OAPRICE | D21 | OA |
| Geography | GEOGRAPHY | D22 | OA |
| Object types | OBJTYPE | D24 | OA |
| Cancellation codes | CANCELCODE | D33 | OA |
| Reason codes for price changes | CHGCODE | D35 | OA |
| Schedule groups | SCHEDULEGR | D37 | OA |
| Message codes | MSGCODE | D34 | EN |