03333 445950
Home
Up

                                

 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Fixed Asset V2010 and Above

The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.

Field   Header Name Notes
1 A Asset Refn This must be just the letters A to Z and the Numbers 0 to 9 You can not have any spaces max size 8 chars
2 B Location or Employee  
3 C Description 1  
4 D Description 2  
5 E Description 3  
6 F Serial No  
7 G Supplier Refn  
8 H Bal Sheet Nom Refn eg 0031
9 I P and L Nom Refn eg 8000
10 J Depreciation Method 0=Straight Line 1 = reducing Balance
11 K Purchase Date  
12 L Category  
13 M Department  
14 N Rate 25 = 25%
15 O Cost Price  
16 P Net Book Value  

Refer to our field information table for the limitations of data values for these fields

Our Custom integration and import solution will allow you to have fields in any order and extract them from formats other than CSV eg: mailing labels printed to disk you can also import all the other fields associated with customers such as price lists.


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017