Abel Enterprise recovery
This function is used during the migration of the Abel Enterprise software in order to import extracted Abel Enterprise data into Sage X3.
This processing relies on 3 standard import templates, usable either from the standard import window, or directly from the screen of this function, which also makes it possible activate the management of the auto ledger creation in the database.
The extraction process of Abel Enterprise data is described in the annex document: Extraction of Abel Enterprise data
Before launching the import of data extracted from Abel Enterprise, some verifications, actions or setup of parameter values must be done in Sage X3.
Please refer to the Implementation documentation.
Term equivalences
ABEL Enterprise | Sage X3 |
Assets | Assets |
Accounting documents | Expenses |
Physical assets | Physical elements |
Prerequisites
Refer to documentation Implementation
Screen management
Entry screen
Presentation
The screen contains the parameters authorizing the choice of objects to be imported:
Miscellaneous table audit
This button is used to display a log file listing miscellaneous tables and corresponding lengths that can be subject to an update during the recovery processing. The user can thus check these lengths with respect to those of the Abel Enterprise table codes (see above the Checks to be performed before launching the recovery process).
Automatic ledger creation
These indicators are used to choose (or not) the automatic creation of the ledger in the database, for the selected objects and the miscellaneous table of Groups.
When the indicator is checked, the value is created in the table of the corresponding leger. Otherwise, the creation of the element (asset, expense or physical element) is rejected if the section value does not exist in the ledger.
Other ledgers are automatically imported.
Example
Section | Imported | Flag | Target value existing | Action |
Supplier | Yes | Checked | Yes | None |
| Yes | Checked | No | Creation of the value in the ledger |
| Yes | Not checked | Yes | None |
| Yes | Not checked | No | Reject of the element |
| Non * |
|
|
|
* Used not to import the section in Sage X3 and so not load the ledger.
Assets / Expenses / Physical Elements
Check the indicators corresponding to the flags to be imported and indicate the location of the recover file if it is on the server.
The standard templates used and their characteristics are as follows:
Object | Template | No. of columns | Type | Comments |
Assets | FASAE | 303 | Multi-line | 'F' & 'D' Lines |
Expenses | LOFAE | 95 | Single-line | Line L |
Physical elements | PHYAE | 61 | Single-line | Line P |
The default parameters of these templates are:
- File type: recording separator
- Field separator: ; (semi colon)
- Field delimiter: Quotes
- Decimal separator: , (coma for France)
- Date format: DDMMYYYY (France)
Close
Fields
The following fields are present on this tab :
Audit
|
This audit is used to display in a log file, the length of the miscellaneous tables likely to be updated during the increase processing. |
Auto ledger creation
|
When activated, this flag is used to request the automatic creation of the values of the ledger Supplier in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Products in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Analytical dimension in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Locations in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Accounting accounts in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Accounting codes in the database. |
|
When activated, this flag is used to request the automatic creation of the values of the ledger Activity sectors in the database. |
|
When activated, this flag is used to request the automatic creation of the Groups in the database. |
Assets
|
This flag is used to request the import of the Fixed assets. |
|
|
|
Indicates the location type where the recovery file is located. |
|
Indicates the directory access path where the recovery file is located. |
Expenses
|
This flag is used to request the import of the Expenses. |
|
|
|
Indicates the location type where the recovery file is located. |
|
Indicates the directory access path where the recovery file is located. |
Physical assets
|
This flag is used to request the import of the Physical elements. |
|
|
|
Indicates the location type where the recovery file is located. |
|
Indicates the directory access path where the recovery file is located. |
Close
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Incorrect Version Number
This message is displayed when there is a variance between the processing associated to the import template and the data from the Abel Enterprise extraction program. The "Version" field is used to perform this control. The content of this field consists in 4 numbers that represent the Abel Enterprise version, followed by the extraction program version. This field must appear at the end of each template in order to best guarantee the compatibility if the source and target templates are out of phase.