import_and_export:importing_assets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revisionBoth sides next revision
import_and_export:importing_assets [2021/05/03 10:08] – [Import spreadsheet format] Gary Willettsimport_and_export:importing_assets [2021/10/08 09:31] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>90}} {{indexmenu_n>90}}
- +====== 17.09. Importing assets ======
-====== 16.09. Importing assets ======+
 Assets are imported directly from Excel spredsheets so there is no need to export data from the spreadsheet to a tab delimited text file first (as you need to do for other imports). Assets are imported directly from Excel spredsheets so there is no need to export data from the spreadsheet to a tab delimited text file first (as you need to do for other imports).
  
Line 51: Line 50:
 | 30             | AD             | Disposal value                  | Number, currency. The value of the asset at the end of its useful life | | 30             | AD             | Disposal value                  | Number, currency. The value of the asset at the end of its useful life |
 | 31             | AE             | Insurer name                    | 255 alphanumeric characters | | 31             | AE             | Insurer name                    | 255 alphanumeric characters |
-| 32             | AF             | Insurance policy nummber        | 255 alphanumeric characters |+| 32             | AF             | Insurance policy number        | 255 alphanumeric characters |
 | 33             | AG             | Insurance renewal date          | Valid date in current operating system format. The date the insurance should be renewed by | | 33             | AG             | Insurance renewal date          | Valid date in current operating system format. The date the insurance should be renewed by |
 | 34             | AH             | Notes                           | Lots of alphanumeric characters! Any other information that needs to be stored against the asset | | 34             | AH             | Notes                           | Lots of alphanumeric characters! Any other information that needs to be stored against the asset |
Line 85: Line 84:
 \\ \\
 \\ \\
-|  //  Previous:  **[[import_and_export:importing_a_supplier_invoice]]** | | Next: **[[import_and_export:export_items]]** //  |+|  //  Previous:  **[[import_and_export:importing_a_supplier_invoice]]** | | Next: **[[import_and_export:importing_regions]]** //  |
 ---- struct data ---- ---- struct data ----
 pagestatus.status    :  pagestatus.status    : 
 ---- ----
  
  • Last modified: 2022/01/19 15:27
  • by Gary Willetts