Use this activity to import data related to a budget year (or some other period that you define) from a file to the General Ledger. The file may have been created manually in an editor or using a program such as Microsoft Excel.
The import dialog box is used to control the following:
Which File Template to use when unpacking the file.
How to filter imported transactions.
An interval of accounts can be
defined in order to filter out the budget values that refer to these accounts.
A single From account or a From and To account interval can be defined.
How to handle imported budget values, e.g., whether imported values should be added to existing budget values or replace existing budget values.
Whether allocation of year budget values should be performed directly after import of year budget values. The allocation can handle either unallocated year values or all year values.
A standard installation of IFS contains predefined file templates for exporting and importing Budget Year and Budget Period values. The file templates can be found in the External Files toolkit in Accounting Rules. It is also possible to create user-defined templates. The system-defined file templates require that each value be delimited by a text qualifier (e.g. "10000"), which is the standard case when a file is created using Microsoft Excel.
The file to be imported contains the values and format specified by the system-defined external File Type that is associated with Budget Year or Budget Period import/export. Each file template maps some or all of the possible file type columns.
When Importing, if period allocation should be performed, then select the
Allocate Period. This leads to automatic period allocation of unallocated
year budget values immediately after importing the new year budget values.
Select the Allocate All (which is only available if the Allocate Period
is selected) to perform allocation of all the year budget values immediately
after importing new year budget values.
Moreover,if errors occurs during the import, you can view the imported data in the External File Transactions page in IFS/Accounting Rules. All errors can be viewed there. This page can be used to modify the loaded data and to perform the execute step again.
A budget version must exist in the current company in order to perform the import.
A file with budget year values must contain at least the following:
If the year value should be equally allocated among the existing periods, then the following fields should be left empty (do not enter a value in them): From Period, To Period, and Allocation Key. If a year value should be equally allocated over specific periods, then you must specify the periods by entering a value in the From Period and To Period fields. If a year value should be allocated according to an allocation key, then the value in the Allocation Key field must refer to an existing key, and the From Period and To Period fields should be empty.
A file with budget period values must contain at least the following information:
To get a better overview of values represented by standard or user-defined templates, refer to the External File Template page in IFS/Accounting Rules.
As a result of this activity, the budget values in the imported file can be viewed or modified using the pages Budget Year Amount or Budget Period Amount in IFS/General Ledger. The budget is available in all queries and reports using budgets.