03333 445950
Home
Up

                                

 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Project Transactions 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 Type A two character integer defining whether the transaction is a costing credit or debit.  20 Debit 19 Credit
2 B Project Reference The project reference, to which the transaction is related, using up to twelve characters.
3 C Cost Code Reference The project reference cost code assigned to the transaction. (8 char max no spaces)
4 D Date The date when the transaction was recorded, expressed in DD/MM/YYYY format.
5 E Reference The transaction reference entry, using up to thirty characters. (Time, Expenses, Purchase)
6 F Details Detailed description of the transaction, using up to sixty characters
7 G Resource Reference The resource reference, using up to eight characters.
8 H Quantity The amount or quantity used in the transaction.
9 I Rate The rate at which this transaction is charged.

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