This option transfers data from a file (usually Excel or csv format) into the Management Accounts module.
To transfer imported files to MA:
From the Rev. 8 Master menu, select the Management accounts option and the company you require
The MANAGEMENT ACCOUNTS menu is displayed.
Select the Imported budget options option
The IMPORTED BUDGET OPTIONS menu is displayed.
Select the Import budgets to MA option
The Import Management Accounts Budgets form is displayed.
Import file information:
File Type: Using the drop-down button
, you can select the file format the import uses. The choice is Excel Spreadsheet or CSV file.
Worksheet: This is the title of the worksheet. It defaults to "Sheet 1"
File name: Using the Ellipsis button
, and then the tree structure that contains the drop down directory, the user can select the relevant file to import.
Data starts at line: This defaults to the value that is contained in NL System parameters Journal tab
Budget information:
Budget Code: This pulls the value through that was selected from the File Name field as discussed above.
Description: This is user-definable.
Imported details - User/Date: These fields are not editable by the user.
This tab details all the data contained in the file that is to be imported, in a grid format. It contains the MA Account in the far left hand column, and information for every period that the spreadsheet contains across the remaining columns from left to right.
BUTTONS
Exit: Returns you to the IMPORTED BUDGET OPTIONS menu.
Help: Displays help on the current application using the default browser.
Back: Returns you to the previous step.
Tip: If the user decides to cancel or wishes to amend anything, they must click the Exit or Back [back meaning takes the user back to the File selection form.]
Next: Takes you forward a step.
Finish: Imports the data.
Note: Providing the file has not already been imported, the you are presented with a message that the file has imported successfully.
