03333 445950



Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Sage 50 Product Transactions and Transaction Types

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

Sage 50 Product Record
Field   Description Notes
1 A Transaction Type See transaction type table below
2 B Product code An existing valid product reference
3 C Date NB date format is ddmmyy or ddmmyyyy excel may try and convert these to date values, make sure that this column is set as text to avoid this.
4 D Reference I
5 E Details  
6 F Quantity  
7 G Cost Price  
8 H Sales Price  
Sage 50 Product Transaction Types
Transaction Type Description
AI Adjustment In
AO Adjustment Out
GI Goods In
GO Goods Out
MI Manufacturing In
MO Manufacturing Out

Refer to our field information table for the actual 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