03333 445950
Home
Up

                                

 

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.


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