Assets > Setup > Asset Acquisition Import

Asset Acquisition Import

You use this program to import asset cost and quantity details for assets that have been added using the Asset Import program.

You typically use this program to import asset data that has been created outside of SYSPRO. The data can be in the form of a flat file containing rows of data according to the file layout specified (File layout for 7), or an Microsoft Excel spreadsheet prepared according to the required file layout.

Toolbar

Field Value Description
Import   Validates the contents of the import file and import records if there are no errors.
Save Form Values   This option is only enabled in Design mode (see Automation Design). Your selections are saved and applied when the program is run in automated mode.

Options

Data source

Field Value Description
Import method    
  From file Indicates you want to import data from a file.
  Use data grid Indicates you want to enter data directly into the grid of the Details pane (you can paste the contents of an Excel spreadsheet into the grid).
File location    
  Server Indicates the import file resides on the server.
  Client Indicates the import file resides on the client.
File name   Indicate the name of the import file (include the full path).
Review file   Loads the contents of the import file into the Details pane. This enables you to validate the lines on the grid prior to importing the file. The Import button is enabled only when all lines are valid.

Options

Field Value Description
Import only if all rows are valid   Validate the contents of the import file before the import is processed to ensure that the data is valid.

The validation includes a number of checks to ensure that:

  • the asset code doesn't already exist (Asset Import).
  • the asset cost isn't less than the residual value.
  • the asset quantity entered is greater than zero.
Calculate depreciation   Automatically calculate depreciation. Otherwise the entries in the import file are used.

If you enable this option, then you won't be able to access any depreciation fields displayed in the Acquisition Import Details listview.

Generate GL entries   Automatically create ledger entries (if your Assets module is integrated to General Ledger).

Entries are generated according to your selections on the General Ledger tab of the General Ledger Integration program.

No GL distribution entries are created when this option is not enabled.

After processing completed

Field Value Description
Print the Details   Generate a report of the contents of the Details entry grid.
Email the Details   Generate an email of the contents of the Details entry grid.
Print the Import Results   Generate a report of the contents of the Import Results pane.
Email the Import Results   Generate an email of the contents of the Import Results pane.
Email recipients   Indicates the email addresses of recipients to whom you want to email the information displayed in the output panes.
Delete file after use   Indicates whether you want to delete the import file after all records are successfully imported.

In a client/server environment, both the import file on the server and the temporary import file created on the client are deleted.

Close the application   Exits the program once processing is complete. Do not select this if you want to be able to view the information on screen when processing is complete or you want to print or email the contents of the Details and Import Results panes.

Details

Toolbar

Field Value Description
Validate   This verifies whether there are any errors in the grid, without actually importing records.

Exclamation marks in the Validation status column indicates that one or more fields in the line are invalid. An explanatory error message is displayed when you hover your mouse pointer over the exclamation marks.

Print   Prints the contents of the import file, or changes made in the grid.
Export to Excel   Outputs data from the Details pane to an Excel spreadsheet.
Search text    
Clear   Clears the contents in the search text field.
Edit    
  Copy Copies the lines in the Details pane.
  Paste (all columns) Ensure that you have data for all the columns that can appear in the data grid before selecting this option.
  Paste (visible columns only) Pastes data into the columns that currently appear in the data grid, in the sequence that they appear.
  Duplicate Copies the current row to the end of the data grid.
  Find and Replace  

Import Results

Displays a summary of the results of the validation/import.

This information can be printed or emailed providing you did not select to Close the application in the After processing completed section.

File layout for 7

The following table defines the structure of the import file that must be defined to successfully import asset acquisitions from 3rd party application software.

Field Start position Field length and description
Header   ;SYSPRO IMPORT - Version=001 - ASSIMQ

Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case sensitive.

Asset Code (mandatory) 1 30

The code for the asset. The system checks that the asset code already exists in the system. If the code is numeric, then the field size is 15.

Acquisition quantity (mandatory) 31 19

This must be a numeric value greater than zero.

Investment allowance (%) 50 8

For tax book value. Must be a numeric value or blank.

Initial allowance (%) 58 8

For tax book value. Must be a numeric value or blank.

Tax paid 66 16

Value of tax paid at the time of acquisition (e.g. VAT or GST). This field is notational and is not used in the calculation of the asset's value.

A warning is given if this value is greater than the Asset cost/value.

Book Value Details    
Book Value asset cost 82 16

Asset Book Value before any revaluations. Must be a numeric value or blank.

Book Value last year depreciation 98 16

Previous year depreciation. Must be a numeric value or blank.

Book Value accumulated depreciation 114 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Book Value depreciation period 1 130 16

Depreciation value for current year period 1. Must be a numeric value or blank.

Book Value depreciation period 2 146 16

Depreciation value for current year period 2. Must be a numeric value or blank.

Book Value depreciation period 3 162 16

Depreciation value for current year period 3. Must be a numeric value or blank.

Book Value depreciation period 4 178 16

Depreciation value for current year period 4. Must be a numeric value or blank.

Book Value depreciation period 5 194 16

Depreciation value for current year period 5. Must be a numeric value or blank.

Book Value depreciation period 6 210 16

Depreciation value for current year period 6. Must be a numeric value or blank.

Book Value depreciation period 7 226 16

Depreciation value for current year period 7. Must be a numeric value or blank.

Book Value depreciation period 8 242 16

Depreciation value for current year period 8. Must be a numeric value or blank.

Book Value depreciation period 9 258 16

Depreciation value for current year period 9. Must be a numeric value or blank.

Book Value depreciation period 10 274 16

Depreciation value for current year period 10. Must be a numeric value or blank.

Book Value depreciation period 11 290 16

Depreciation value for current year period 11. Must be a numeric value or blank.

Book Value depreciation period 12 306 16

Depreciation value for current year period 12. Must be a numeric value or blank.

Book Value depreciation period 13 322 16

Depreciation value for current year period 13. Must be a numeric value or blank.

Tax Details    
Tax asset cost 338 16

Asset book value before any revaluations. Must be a numeric value or blank.

Capital gains tax cost 354 16

Capital gains tax cost. Must be a numeric value or blank.

Tax last year depreciation 370 16

Total depreciation previous year. Must be a numeric value or blank.

Tax accumulated depreciation 386 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Tax depreciation period 1 402 16

Depreciation value for current year period 1. Must be a numeric value or blank.

Tax depreciation period 2 418 16

Depreciation value for current year period 2. Must be a numeric value or blank.

Tax depreciation period 3 434 16

Depreciation value for current year period 3. Must be a numeric value or blank.

Tax depreciation period 4 450 16

Depreciation value for current year period 4. Must be a numeric value or blank.

Tax depreciation period 5 466 16

Depreciation value for current year period 5. Must be a numeric value or blank.

Tax depreciation period 6 482 16

Depreciation value for current year period 6. Must be a numeric value or blank.

Tax depreciation period 7 498 16

Depreciation value for current year period 7. Must be a numeric value or blank.

Tax depreciation period 8 514 16

Depreciation value for current year period 8. Must be a numeric value or blank.

Tax depreciation period 9 530 16

Depreciation value for current year period 9. Must be a numeric value or blank.

Tax depreciation period 10 546 16

Depreciation value for current year period 10. Must be a numeric value or blank.

Tax depreciation period 11 562 16

Depreciation value for current year period 11. Must be a numeric value or blank.

Tax depreciation period 12 578 16

Depreciation value for current year period 12. Must be a numeric value or blank.

Tax depreciation period 13 594 16

Depreciation value for current year period 13. Must be a numeric value or blank.

Alternate Valuation 1 Details    
Alternate Valuation 1 cost 610 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 1 last year depreciation 626 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 1 accumulated depreciation 642 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 1 year to date depreciation 658 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 2 Details    
Alternate Valuation 2 cost 674 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 2 last year depreciation 690 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 2 accumulated depreciation 706 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 2 year to date depreciation 722 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 3 Details    
Alternate Valuation 3 cost 738 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 3 last year depreciation 754 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 3 accumulated depreciation 770 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 3 year to date depreciation 786 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 4 Details    
Alternate Valuation 4 cost 802 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 4 last year depreciation 818 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 4 accumulated depreciation 834 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 4 year to date depreciation 850 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 5 Details    
Alternate Valuation 5 cost 866 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 5 last year depreciation 882 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 5 accumulated depreciation 898 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 5 year to date depreciation 914 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 6 Details    
Alternate Valuation 6 cost 930 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 6 last year depreciation 946 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 6 accumulated depreciation 962 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 6 year to date depreciation 978 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 7 Details    
Alternate Valuation 7 cost 994 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 7 last year depreciation 1010 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 7 accumulated depreciation 1026 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 7 year to date depreciation 1042 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 8 Details    
Alternate Valuation 8 cost 1058 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 8 last year depreciation 1074 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 8 accumulated depreciation 1090 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 8 year to date depreciation 1108 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 9 Details    
Alternate Valuation 9 cost 1122 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 9 last year depreciation 1138 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 9 accumulated depreciation 1154 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 9 year to date depreciation 1170 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 10 Details    
Alternate Valuation 10 cost 1186 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 10 last year depreciation 1202 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 10 accumulated depreciation 1218 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 10 year to date depreciation 1234 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

File layout for 6.1

Field Start position Field length and description
Asset Code (mandatory) 1 15

The code for the asset. The system checks that the asset code does not already exist in the system.

Acquisition quantity (mandatory) 16 19

This must be a numeric value greater than zero.

Investment allowance (%) 35 8

For tax book value. Must be a numeric value or blank.

Initial allowance (%) 43 8

For tax book value. Must be a numeric value or blank.

Tax paid 51 16
Book Value Details    
Book Value asset cost 67 16

Asset Book Value before any revaluations. Must be a numeric value or blank.

Book Value last year depreciation 83 16

Previous year depreciation. Must be a numeric value or blank.

Book Value accumulated depreciation 99 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Book Value depreciation period 1 115 16

Depreciation value for current year period 1. Must be a numeric value or blank.

Book Value depreciation period 2 131 16

Depreciation value for current year period 2. Must be a numeric value or blank.

Book Value depreciation period 3 147 16

Depreciation value for current year period 3. Must be a numeric value or blank.

Book Value depreciation period 4 163 16

Depreciation value for current year period 4. Must be a numeric value or blank.

Book Value depreciation period 5 179 16

Depreciation value for current year period 5. Must be a numeric value or blank.

Book Value depreciation period 6 195 16

Depreciation value for current year period 6. Must be a numeric value or blank.

Book Value depreciation period 7 211 16

Depreciation value for current year period 7. Must be a numeric value or blank.

Book Value depreciation period 8 227 16

Depreciation value for current year period 8. Must be a numeric value or blank.

Book Value depreciation period 9 243 16

Depreciation value for current year period 9. Must be a numeric value or blank.

Book Value depreciation period 10 259 16

Depreciation value for current year period 10. Must be a numeric value or blank.

Book Value depreciation period 11 275 16

Depreciation value for current year period 11. Must be a numeric value or blank.

Book Value depreciation period 12 291 16

Depreciation value for current year period 12. Must be a numeric value or blank.

Book Value depreciation period 13 307 16

Depreciation value for current year period 13. Must be a numeric value or blank.

Tax Details    
Tax asset cost 323 16

Asset book value before any revaluations. Must be a numeric value or blank.

Capital gains tax cost 339 16

Capital gains tax cost. Must be a numeric value or blank.

Tax last year depreciation 355 16

Total depreciation previous year. Must be a numeric value or blank.

Tax accumulated depreciation 371 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Tax depreciation period 1 387 16

Depreciation value for current year period 1. Must be a numeric value or blank.

Tax depreciation period 2 403 16

Depreciation value for current year period 2. Must be a numeric value or blank.

Tax depreciation period 3 419 16

Depreciation value for current year period 3. Must be a numeric value or blank.

Tax depreciation period 4 435 16

Depreciation value for current year period 4. Must be a numeric value or blank.

Tax depreciation period 5 451 16

Depreciation value for current year period 5. Must be a numeric value or blank.

Tax depreciation period 6 467 16

Depreciation value for current year period 6. Must be a numeric value or blank.

Tax depreciation period 7 483 16

Depreciation value for current year period 7. Must be a numeric value or blank.

Tax depreciation period 8 499 16

Depreciation value for current year period 8. Must be a numeric value or blank.

Tax depreciation period 9 515 16

Depreciation value for current year period 9. Must be a numeric value or blank.

Tax depreciation period 10 531 16

Depreciation value for current year period 10. Must be a numeric value or blank.

Tax depreciation period 11 547 16

Depreciation value for current year period 11. Must be a numeric value or blank.

Tax depreciation period 12 563 16

Depreciation value for current year period 12. Must be a numeric value or blank.

Tax depreciation period 13 579 16

Depreciation value for current year period 13. Must be a numeric value or blank.

Alternate Valuation 1 Details    
Alternate Valuation 1 cost 595 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 1 last year depreciation 611 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 1 accumulated depreciation 627 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 1 year to date depreciation 643 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 2 Details    
Alternate Valuation 2 cost 659 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 2 last year depreciation 675 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 2 accumulated depreciation 691 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 2 year to date depreciation 707 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 3 Details    
Alternate Valuation 3 cost 723 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 3 last year depreciation 739 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 3 accumulated depreciation 755 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 3 year to date depreciation 771 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 4 Details    
Alternate Valuation 4 cost 787 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 4 last year depreciation 803 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 4 accumulated depreciation 819 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 4 year to date depreciation 835 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 5 Details    
Alternate Valuation 5 cost 851 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 5 last year depreciation 867 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 5 accumulated depreciation 883 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 5 year to date depreciation 899 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 6 Details    
Alternate Valuation 6 cost 915 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 6 last year depreciation 931 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 6 accumulated depreciation 947 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 6 year to date depreciation 963 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 7 Details    
Alternate Valuation 7 cost 979 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 7 last year depreciation 995 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 7 accumulated depreciation 1011 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 7 year to date depreciation 1027 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 8 Details    
Alternate Valuation 8 cost 1043 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 8 last year depreciation 1059 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 8 accumulated depreciation 1075 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 8 year to date depreciation 1091 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 9 Details    
Alternate Valuation 9 cost 1107 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 9 last year depreciation 1123 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 9 accumulated depreciation 1139 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 9 year to date depreciation 1155 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Alternate Valuation 10 Details    
Alternate Valuation 10 cost 1171 16

Asset book value before any revaluations. Must be a numeric value or blank.

Alternate Valuation 10 last year depreciation 1187 16

Previous year depreciation. Must be a numeric value or blank.

Alternate Valuation 10 accumulated depreciation 1203 16

Total depreciation for the life of the asset. Must be a numeric value or blank.

Alternate Valuation 10 year to date depreciation 1219 16

Depreciation value for current year (Period 1-13). Must be a numeric value or blank.

Notes and warnings

Importing considerations

  • To import asset information into SYSPRO, you must first use the Asset Import program to import static information for the assets. Thereafter, you use Asset Acquisition Import program to import all the additional information for the same assets.

  • If you want to import from an Excel spreadsheet file, then you need to ensure that the first column of the spreadsheet is blank to accommodate the Validation status flag column in the listview.

  • Exclamation marks in the Validation status flag column indicate that one or more fields in the line are invalid. These errors are indicated with an exclamation mark in the relevant column. When you hover your mouse pointer over the exclamation mark, the error message is displayed.

    You need to fix these columns before the line can be imported. Once you have made the relevant changes, you use the Validate function to repeat the validation process.

    Details of the information required in each column are explained in the Asset Acquisition program.

Ledger integration considerations

  • You can create ledger entries when importing data from this program if your Assets module is linked to General Ledger (General Ledger Integration).

Date entry considerations

  • Dates must be entered as CCYY-MM-DD or CCYYMMDD (any delimiter character is valid). You define the default date format on the Date Format tab of the System Setup program.

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity Description
Listview/Forms - Export or print data Controls whether an operator can print the contents of a listview and/or output the contents of a listview to an HTML page, XML document or Excel spreadsheet.
Maintain data in import programs Controls whether an operator can maintain import data in a data grid within any SYSPRO import program before the import is performed.
Allowed to import from client Controls whether an operator can use a SYSPRO import program to import data from a client machine (in a client/server environment).
File Browse on server (C/S system) Controls whether an operator use the browse function to load the Browse on Files and Folders program to locate files on the server in a client/server environment. Operators can still navigate to a file or folder on the server by typing in the full path name in the entry field.

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.