03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Standard Sage 50 Imports - Product Transactions
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| 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 | |
| 9 | I | ProjectCol | |
| 10 | J | ProjectCostCodeCol |
- 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
