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.
