03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Standard Sage 50 Imports - Audit Trail Records
Note that unlike the Standard sage import this routine will do grouping of transactions to create headers and splits and all transaction types including PP SA SR and PA can be used.
| Field | Description V12+ | Notes | |
| 1 | A | Transaction Type | See transaction type table below |
| 2 | B | Account Ref | An existing valid account reference |
| 3 | C | Nominal Code | An existing valid nominal code (watch out for leading zeros being dropped_ |
| 4 | D | Department Number | |
| 5 | E | Date | format is ddmmyy or ddmmyyyy |
| 6 | F | Reference | |
| 7 | G | Details | |
| 8 | H | Net Amount | |
| 9 | I | Tax Code | |
| 10 | J | VAT Amount | |
| 11 | K | Exchange Rate | |
| 12 | L | Extra Ref | |
| 13 | M | User Name | |
| 14 | ProjectCol | ||
| 15 | ProjectCostCodeCol |
- 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 |
Sample SI Transaction from a Sales Invoice
Refer to our field information table for the actual limitations of data values for the fields in the Auduit Header and Audit Split tables
