03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Sage 50 Audit Trail Transactions and Transaction Types
The field available for import in Sage 50 Audit trail transactions are listed below, the field sequence order is not important for V2011 (V17) and above as field mapping can be done, for users using a spreadsheet to prepare data we have also included column letters please also see our spreadsheet warnings. If you would rather not need to change the field orders we can provide import solutions that can import from your existing files.
| Field | Description V7 - V11 | Description V12+ | Notes | |
| 1 | A | Transaction Type | Transaction Type | See transaction type table below |
| 2 | B | Account Ref | Account Ref | An existing valid account reference |
| 3 | C | Nominal Code | Nominal Code | An existing valid nominal code (watch out for leading zeros being dropped_ |
| 4 | D | Department Number | Department Number | |
| 5 | E | Date | Date | format is ddmmyy or ddmmyyyy |
| 6 | F | Reference | Reference | |
| 7 | G | Details | Details | |
| 8 | H | Net Amount | Net Amount | |
| 9 | I | Tax Code | Tax Code | |
| 10 | J | VAT Amount | VAT Amount | |
| 11 | K | Extra Ref | Exchange Rate | |
| 12 | L | Extra Ref | ||
| 13 | M | User Name |
 | Sage 50 Audit Trail Transaction Types |
| Transaction Type | Description |
| SI | Sales Invoice |
| SA | Sales receipt on Account |
| SC | Sales Credit Note |
| SP | Sales Payment (Refund) |
| SR | Sales Receipt |
| PI | Purchase Invoice |
| PA | Payment on Account |
| PC | Purchase Credit Note |
| PR | Purchase Receipt (Refund) |
| PP | Purchase Payment |
| JD | Journal Debit |
| JC | Journal Credit |
| BP | Bank Payment |
| BR | Bank Receipt |
| VP | Visa Payment |
| VR | Visa Receipt |
| CP | Cash Payment |
| CR | Cash Receipt |
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.
