Abel Enterprise recovery - Implementation

Prerequisites

Activity codes

The following activity codes (sorted by type) may have an impact on the way the function operates :

  PHY :  Physical assets

Miscellaneous prerequisites

Before launching the import of data extracted from Abel Enterprise, some verifications, actions or setup of parameter values must be done in Sage X3.

This includes:

• creating the mandatory ledger: company, financial and geographic sites, contexts and plans,
• setting up the values of certain parameters,
• verifying that the parameters are equivalent between Abel Enterprise and Sage X3.

Verifications

• Verify the format of the ADI data type.
   
  In the case where non-alphanumeric characters (-, /, ...) are present in the imported data, the data type format must be set to: 20X and not 20B for these characters to be validated.
   
• From the Recovery screen, launch the Audit of the miscellaneous tables which can be subject to an update during the recovery process in order to check their length. The list of the tables concerned and their length is displayed in a log file. The user can thus compare these lengths to those of the tables extracted from Abel Enterprise (Volumetric control, Ledger chapter - ER01 code).
   The length of the miscellaneous table 537 - Category must always be from 1 to 12.
   
  The update of a table length is carried out in the Miscellaneous table definition function (Development / Data dictionary menu). Once the modification is carried out, Save and Validate.
   
• Lease contracts and concession contracts cannot be imported. When they are managed, they MUST have been created in Sage X3 before the recovery.
  It is then necessary to perform, in the FASAE template, a manual load of: 
   
  Lease contracts
   
  --> line 82 Lease contract reference Funding, with the field: LEAREF
  --> line 83 - Original lease contract, with the field: LEAREFORI
   
  Concession contracts
  
  --> line 84 - Concession contract, with the field: CCNREF

Parameter values

The values of the following parameters are to be checked:

AAS Chapter - FAS Group

• PRVSITUPD - Modification of the previous situation
   
  This parameter must be set to: Yes, in order to authorize the recovery of totals and accounting allocation dates prior to the fiscal year.

AAS Chapter - IMP Group

• REPDPRCUM - Depreciation total recovery
   
  This parameter must be set to: Yes, in order to authorize the recovery of depreciation totals. These amounts will be forced and not re-calculated by Sage X3.
   
• REPENDDPE - FY depreciation charge recovery
    
  This parameter must be set to: No, in order not to import fiscal year depreciation charges.
   
• AEPLNL1 to AEPLNL8 - Free plan 1 to 8 (Abel Enterprise)
     
  These parameters are used to match up the plan codes of Abel Enterprise and those of Sage X3.
  
• AEAXE1 to AEAXE4 - Dimension type 1 to 4 (Abel Enterprise)
   
  These parameters are used to match up the analytical dimension type codes of Abel Enterprise and those of Sage X3.
  
• AESCT1 and AESCT2 - Sector 1 and 2 (Abel Enterprise)
   
  These parameters are used to match up the IAS geographic/activity dimension type codes of Abel Enterprise and those of Sage X3.
   
• DISAFAS - Import of "inactive" assets
   
  The value of this parameter is to be checked.

Ledger and organizational information

The following ledger must always be created before import:

• Company
• Financial and geographic sites
• Contexts and plans
   
   The dates of the current period must be the same in Abel Enterprise and Sage X3.

Organizational Information

Headings ABEL Enterprise		Headings Sage X3		Changeable	Comments
REFESOC (3c)	Company	CPY (3c)	Company	No
REFEETB (3c)	Branch	FCY (3c)	Financial site	Yes
RFSITEU11 (6c)	Site	GEOFCY (3c)	Geographic Site	Yes	Recoding possible to 3 characters

The fields of the Abel Enterprise column here above are defined by default to load the fields of the Sage X3 column.

In order to modify this setup (e.g. if the Abel Enterprise Site section must load the Financial Site section of Sage X3), it is recommended to:
 
- either modify the export template by changing the names of the sections to export (see below),
- or modify the import template by changing the names of the sections to load,
- or else create a transcoding table (see below).

 In Sage X3 :
- A financial site is always a geographic site.
- A site can only be a geographic site, therefore, it must be attached to a financial site.

Here are some example of setup combinations (the Financial Site section of Abel Enterprise being optional or managed in another section):

Heading: Company

Abel Enterprise	Sage X3	Comments
REFESOC	CPY	---

Heading: Site / Financial site

Abel Enterprise	Sage X3	Comments
REFEETB	FCY
Not managed: ***	FCY	Use of the transcoding table 98 in order to redirect the *** code towards the default financial site (see transcoding example below).
RFZOLI1U03 Free field 1	FCY	Modification of the export template in order to redirect the column no. 12 (RFZOLI1U03) to FCY and not to USRFLDA1.

Heading: Site / Geographic site

Abel Enterprise	Sage X3	Comments
RFSITEU11	GEOFCY	Caution with the length of the RFSITEU11 section (6 characters): In Abel Enterprise, a recoding can be mandatory.
Not managed: VIDE	GEOFCY	The geographic site will loaded with the financial site, which is also a geographic site.

Specificities linked to the book vs. tax depreciation

Data structure variance between Abel Enterprise and Sage X3 as far as book vs. tax depreciation is concerned:

• Abel Enterprise:
  The book vs. tax depreciation is stored in the BCO table header, except for the 4 recurring total sections (book vs. tax provision, re-integration provision, book vs. tax recovery, re-integration recovery) which are stored in the Fiscal plan of the AMT table.

In order to properly migrate theses data, the output file of Abel Enterprise considers and respects the Sage X3 data structure, which is:

• the book vs. tax depreciation is stored in the Accounting plan of the DEPREC table,
• the fiscal re-integration is stored in the Fiscal plan of the DEPREC table.

Matching setup between Abel Enterprise and Sage X3.

 

Abel Enterprise	Abel Enterprise		Sage X3	Sage X3
Source	Parameter		Source	Parameter
Company / Management	Deferred - Deferred type   - Deferred rate		Context	Deferred - Deferred type - Deferred rule - Deferred rate
	Subsidy plan		Context	Managed by a dedicated plan
	Review earlier subsidy		Parameter    AAS Chapter GRT Group	GRTPRVUPD - Review earlier subsidy
Company / Indicators	Modification of the previous situation		Parameter AAS Chapter FAS Group	PRVSITUPD - Modif. earlier situation
	Take into account minimum depreciation		None
	WIP calculation in Fiscal plan		Parameter AAS Chapter FAS Group	DEROENCOUR - Book vs tax on FA in process
	Recover book vs. tax in case of issue		Parameter    AAS Chapter FAS Group	IMLRVEISS - Issue:Depreciation increase
	- No depreciation charge calculated on the issue year - No depreciation charge calculated on the issue day - Depreciation charge complete on the sales year		None	Managed by rules upon issue
	Take into account VAT+/-values		Parameter    AAS Chapter VAT Group	PCOTVAPMV - Take into account VAT+/-values
	Take WIPs into account upon VAT adjustment		Parameter    AAS Chapter VAT Group	REGENCOURS - FA in process: VAT adjustment?
Company / Association	Priority association		None
Company / Physical	- Assets barcodes length - Localizations barcodes length		Parameter    AAS Chapter PHY Group	FMTCABFAS - Asset BC format FMTCABLOC - Localization BC format
Contexts / Indicators	- Depreciation charge on the last day of the previous semester (issue) - Depreciation charge on the last day of the current semester (issue)			Managed by rules upon issue

Transcoding tables

Table	Local code	External code	Comments
100 Flag --> Yes / No	1 2	0 (FALSE) 1 (TRUE)
98 Site / Building	Default financial site	***	Used to manage the case where a *** site is used in Abel Enterprise

Generally, the External code corresponds to the data of Abel Enterprise and the Local code corresponds to those of Sage X3.
For the sections for which a transcoding process is written in the import processing (all internal tables for instance table I08 - Issue type), it is also possible to define a transcoding table; in this case, Local and External codes are Enterprise data.

Example

In Abel Enterprise, the user has defined an issue type: S - "Export Sales".
In order to recover the issued assets having the issue type: S - Export Sales, one must:

• Create a transcoding table (example: Table 96 - Abel issue type) and enter local and external codes:
  Local code: 1 (Sales)
  External code: S (New issue type "Export Sales")
   
• Modify the FASAE template and assign to the field *81 - Issue type, the table created for this purpose (table 96), in the column: Table number.
  During the import, the External code: S becomes the External code: 1 which will be recoded into the Local code: 1 - Sales.
  
  

Automatic recoding of local menus

Table ABEL Enterprise	Value	Value	Sage X3 Table	Title in Sage X3
I01	1: Tangible 2: Intangible   3: Financial Other	1: Tangible 2: Intangible 3: Goodwill 4: Financial 0: Anomaly	3151	Fixed asset type
I02	1: New  2: Second hand Other	1: New 2: Second hand 0: Anomaly	3152	Status of the asset at the purchase
I03	0: Not insured 1: Other Insurance 2: Building Insurance  Other	1: Not insured  2: Other Insurance 3: Building Insurance 0: Anomaly	3153	Insurance type
I07	1: Fixed  2: General Installation  3: Mobile Other	1: Fixed 2: General Installation 3: Mobile 0: Anomaly	3156	Asset stability type
I05	1: Purchasing  2: Internal Production 3: Partial asset provision 4: Merger 5: Split 6: Intra-group sales 7: Buyback Other	1: Purchasing 2: Internal Production  3: Partial asset provision 4: Merger 5: Split 6: Intra-group sales 7: Leasing buyback 0: Anomaly	3157	Asset receipt nature
i06	1: Professional  2: Property 3: Exempt 4: Sub-contracted Other	1: BNPTF 2: BPTF 3: Ex-field 3: Ex-field 0: Anomaly	3158	Tax type
I08	0: Not issued 1: Sales 2: Scrap  5: Scrap with exceptional Amt D: Scrap with depreciation closing 3: Intra-group cession H: Intra-group sales 4: Stolen or disappeared 8: Contract end 9: First asset sold E : Partial asset provision 7: Merger G : Split A: Terminated contract Other	0: Blank or null 1: Sales  2: Scrap 2: Scrap 2: Scrap 3: Intra-group sales 3: Intra-group sales 4: Stolen or disappeared 5: Leasing contract end 12: Renewal 6: Partial asset provision 7: Merger 8: Split 10: Terminated contract 2: Scrap	3159	Issue reason
W02	1: 1/5 rule  2: 1/10 rule 3: No VAT A: No adjustment E: No adjustment (stolen, scrap...) 4: VAT / Sales (LF 1990) 5: 1/20 rule B: Deductible VAT amount adjustment: increase C: Deductible VAT amount adjustment: decrease D: No VAT (intracommunity)	1: 1/5th rule  2: 1/10th rule  4: No adjustment 4: No adjustment 4: No adjustment 0: Anomaly 3: 1/20th rule 5: Deductible VAT amount adjustment: increase 6: Deductible VAT amount adjustment: decrease 0: Anomaly	3160	VAT rule for the issue
CIGS02	1: Preferential treatment 2: Common treatment 3: Other	1: Preferential treatment 2: Common treatment 3: Other	3163	Tax rule intragroup cession
RIV	1: Fiscal engine size (HP)  2: CO2 emission rate Other	1: Fiscal engine size (HP) 2: CO2 emission rate 0: Anomaly	3165	Tax rule
I04	1: Actual asset  2: Fictional asset 5: Asset issued previous FY 8: Asset in process 3: Asset in rental A: Lease end previous FY 4: Asset in leasing B: Leasing end previous FY 6: Canceled asset 9: Provisional asset 5: Concession 6: In template Other	1: Property 1: Property 1: Property 1: Property 2: in rental 2: in rental 3: in leasing 3: in leasing 7: Voided 4: Provisional 5: Concession 6: In template 0: Anomaly	3171	Holding type for the asset
I08	E : Partial asset provision F : Merger G : Split H: Intra-group sales	1: Partial asset provision 2: Merger 3: Split 4: Intra-group sales	3172	Intra-group cession type

Tables used

No table is used by this function.