![]() #1: Only map the fields you requireĪs a minimum for most types of transactions QuickBooks only requires a few fields to successfully create a transaction, for example the mandatory fields to create an invoice are Customer Full Name, & Item Full Name, QuickBooks will assume the transaction date, invoice number and quantity. We have suggested some best practices when importing data that will help to reduce the number of errors that you may encounter. QuickBooks will reject any transaction data that does not match or fit into the QuickBooks data format and requirements, it is important that this data is rejected as it minimises the chances of your company data file becoming corrupted. ![]() or ( Excel 2010) On the File tab, click Info, click Check for issues, click Check Compatibility, and then clear the Check compatibility when you save this workbook box.When importing transactions into QuickBooks using Zed Axis you may encounter errors. Excel may be running a compatibility checker, you can disable the compatibility checker ( Excel 2007) On the Office button, click Prepare, click Run Compatibility Checker, and then clear the Check compatibility when you save this workbook box.If this problem persist please raise a ticket with Zed Systems support and we will arrange a Remote Support session to resolve this issue. You will need to uninstall Zed Axis, delete the folder C:\Users\Public\Documents\Zed then reinstall Zed Axis make sure you are logged into Windows with Administrator permissions, that you temporarily turn off your anti virus software during the install and when installing select the option for all users. Your installation my have not completed successfully and Axis does not have permission to modify the mappings.Here are links on how to configure this in your anti virus system You may need to recreate the map if the problem persists.If the problem is occurring when open Zed Axis then you can clear the last opened file from the cache by deleting the path from the registry at Computer\HKEY_CURRENT_USER\Software\Zed Systems\QuickBooks\Import\Location using the regedit utility.If you are running an anti virus scan in real time please configure the anti virus application so that it does not scan the folder C:\Users\Public\Documents\Zed or add an Exception for the program ZedAxis.exe.For this create a new brand new sheet and then copy the data and Paste special (Values only) into the new empty sheet, save it and try and import that, sometimes saving the Excel sheet to Tab text delimited also works. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |