This processing relies on 3 standard import templates, which you can use from the standard import window, or directly from the screen of this function. In this function, you can also manage the automatic creation of a set of common data.
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.
ABEL Enterprise | Sage X3 |
Assets | Assets |
Accounting documents | Expenditures |
Physical assets | Physical assets |
Refer to documentation Implementation
Presentation
The screen contains the parameters authorizing the choice of objects to be imported:
Use this button 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).
Use these indicators to select the data that you want to create automatically (part of the common data, accounting codes and the Groups miscellaneous table).
When you select the indicator, the value is created in the corresponding table. Otherwise, the creation of the element (asset, expense or physical element) is rejected if the value does not exist in the table.
The other data is imported automatically.
Example:
Table | Imported | Flag | Target value existing | Action |
Supplier | Yes | Checked | Yes | None |
Yes | Checked | No | Creation of the value in the table | |
Yes | Not checked | Yes | None | |
Yes | Not checked | No | Reject of the element | |
No * |
* Used not to import the table in Sage X3 and so not load this table.
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 |
Expenditures | LOFAE | 95 | Single-line | Line L |
Physical assets | 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. |
Common data auto creation
| Enable this flag to request the automatic creation of values in the Supplier table in Common Data. |
| Enable this flag to request the automatic creation of values in the Products table in Common Data. |
| Enable this flag to request the automatic creation of values in the Analytical dimensions table in Common Data. |
| Enable this flag to request the automatic creation of values in the Localizations table in Common Data. |
| Enable this flag to request the automatic creation of values in the Accounting accounts table in Common data. |
| Enable this flag to request the automatic creation of Accounting codes in the database. |
| Enable this flag to request the automatic creation of values in the Activity sector table in Common data. |
| Enable this flag to request the automatic creation of values in the Groups table in Common Data. |
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
In addition to the generic error messages, the following messages can appear during the entry :
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.