Importing transactions in to Sage 50 Accounts 2010

Article ID: 091119172802 - Last Review: 16 December 2009 by jasonl - Revision: 2 - Views: 8228


About "Importing transactions in to Sage 50 Accounts 2010"
In Sage 50 Accounts 2010 when you go to import the Audit Trail Transactions file that has been created by Service Accent you now have to map the fields in the file to the fields in Sage.

In Sage 50 Accounts go to File -> Import, you will then be presented with the Sage Data Import Wizard:

  1. Click on the Backup button to backup your data then click Next
  2. Select Audit Trail Transactions from the list and then click Next
  3. Select the Comma-seperated(*.csv) option and also ensure that no tick is present in the First row contains heading option. Next click on Browse to select the Audit Trail Transactions file that you wish to import and then click next.




  4. Sage 50 Accounts now wants to you set up the field mappings, this can be done in two ways. The easiest way is to just click on Load Map and import the attached file, alternatively you can just start at the top of the list and select A then for the next line down select B and so on until you reach J which should be Tax Amount. The last 5 Sage 50 Accounts Fields should have no field or letter associated with it. Once this is done click Next




  5. If you are happy with the summary that you are presented with then click on Finish and you file will be imported.





Next time you use the routine it will remember the mappings that you have used previously.


 
 Related articles

Service Accent returns "Sage Data Objects is not registered. Please contact your third party supplier" error when posting invoices
Service Accent Sage Live Link for Sage 50 Accounts 2008 (version 14)
Service Accent Sage Live Link for Sage 50 Accounts 2009 (version 15)
Service Accent Sage Live Link for Sage 50 Accounts 2011 (version 17)
Error message 'the object invoked has disconnected from its clients' when using the Sage Live Link
Sage Live Link for Sage 50 Accounts 2013 (version 19)
Supplier purchase invoices
What customer information can be exported to Sage Line 50
What invoice information can be exported to Sage Line 50

 Additional articles from the white papers

Service Accent - User Guide Sage Live Link 2014
Service Accent - Sage Live Link



For additional resources and information, you can go to the Service Accent Support Centre

Click here to go to the Service Accent Support Centre



Copyright © 2003-2023 Vantage Computing Ltd. All rights reserved. The information contained on this web site is correct as of its publication date.