Overview
This function allows the user to Import COA into the system, when clicking "Import", all import files specified under the path in the Location of Import Files are imported into the Chart of Account specified under Chart of Accounts and Fiscal Year specified under the COA Import Form.
Admin ► Chart of Accounts ► Coa Import ► COA Import
| Field | Description |
| COA | This field allows the user to select the Chart of Account from the drop down-list. |
| Fiscal Year | The fiscal year for the COA import. The user can change it using the drop-down list. |
| Location of Import Files | Default should be from system parameter, the default path for COA Import. |
The System Administrator should always view the log of the import process to confirm that the import was successful and identify any changes made during the import. This log includes the list of modifications and errors associated with each COA Import, per Import File. All fields are read-only.
Admin ► Chart of Accounts ► Coa Import ► COA Import Log
| Field | Description |
| Application Id | Unique identifier of the Log, generated by the system. |
| Fiscal Year | Fiscal Year to which the transaction belongs. |
| Log Date Time | Date and Time at which the COA Import was executed, generated by the system. |
| COA | COA for which the import is performed. |
| Imported By | Automatically populated by the system. Corresponds to the User who imported the COA. |
| Coa Errors and Modification | Collection of 1 to many Imported Files Errors and Modifications. |
Note: The application generates a log for each file imported.
This entity includes the import files that comprise the COA Import.
Admin ► Chart of Accounts ► Coa Import ► Support Entities ►COA Import Definition
| Fields | Description |
| Application Id | Unique identifier generated by the system. |
| Is Active | By default it is checked. It user make it unchecked then the Imported File Definition will not be available. |
| Chart of Account | The drop-down list allows the user to select the COA. |
| COA Segments Tab | Includes the COA Segment Import File definition for each segment to be imported. The same "COA Segment File Definition" cannot be selected twice. An error message should be generated if the same "COA Segment File Definition" is selected twice. |
Overview
This tab includes the COA Segment Import File definition for each segment to be imported.
CoA Segment File Definition screen fields and tab
| Fields | Description |
| Sequence Number | Unique identifier generated by the system. |
| Name of Import File | Name of each file to be imported. |
| With Level | Indicates if the segment includes more than one (1) level within the hierarchy. |
| CoA Segment | Segment associated to the import file. |
| Is Active | By default is is checked. If unchecked, the CoA segment will not be used in the CoA import definition. |
Overview
This entity includes the imported File Fields, for each Valid Code Combinations with ranges, with their Start and End positions.
CoA Segment File Definition Detail screen fields
| Fields | Description |
| Serial Number | Unique identifier generated by the system. |
| External field | Each possible value can only be selected once per Imported File, and per Segment. |
| Segment | Segment associated to the External Field. Will be populated only for the High and Low External field. |
| Start Position | External Field Start Position |
| End Position | External Field End Position |
| Is Active | If unchecked, the detail will not be used in the VCC with range file definition. |