![]() Errors are represented by a negative number. Warnings are represented by a positive number. The import log shows errors and warnings. Each time you import, the previous log will be overwritten. The errors or warnings are listed at the bottom of the report and correspond to the number in front of each record. Any errors or warnings that occurred during the import process can be found in the import log that is created after the import is complete. The import log is invaluable for troubleshooting import issues. Is date format correct? Is FY correct for import dates? Are Lock Periods in use? File Read-only? Do a Match All, then uncheck the RecordID field. What is error? Positive error numbers are warnings, negative are fatal errors. ![]() ![]() Open Import Log File Check Error Number(s).What is the problem: can't find or open input file can't match fields can't determine error, etc. Determine Problem or Error User is Experiencing.If all fields are on one line on the left-hand panel, you know the import will not be correct. Usually you can determine this when looking at the field match window. File may have NL line endings will need to convert to CR or CRLF. Is the file extension prohibiting AccountEdge from selecting the file? Change the extension to. Did input file come from web maybe extension is not correct for content. Know the type of import before proceeding. Determine type of import Does the import require more than one line per transaction? List imports are usually one line.Troubleshooting the Import Trouble Shooting Steps The import order of record items, when exporting records from one file and importing into a new file, is: It's usually not necessary to import the Record ID into a new file. If it isn't, or you are not sure, this field should not be imported. Note: When importing, the Record ID should be imported if you're sure it's the correct Record ID in the new file. Payroll records are not exportable nor importable. It is not possible to import Activities, Categories, Currencies and Locations. Import Orderįor importing data into a new file, the list below shows the proper import order. There is a separate document that details the different fields that each type of information requires and the limitations of those fields. The following imports require 2 or more lines per record (transaction): The following imports require 1 or more lines: Tax Code List (consolidated) (1 or more lines).Inventory Adjustments (1 or more lines).Cards (customer, vendor, employee, personal).The following imports require one line per record: ![]() ![]() NOTE:,For transaction imports (journal entries, sales, etc) different transactions are separated by a blank line. The total of debits must equal the total of credits. Each line would contain either a debit or a credit. If more than one account is being debited, or more than one account is being credited, then more than 2 lines would be required. Some imports, require 2 or more lines per record or transaction minimally 2 lines are required: one for the debit side of the transaction, and one for the credit side of the transaction. Some imports require 1 line per record or transaction. While AccountEdge can import either comma-separated or tab-delimited text files, there is certain formatting that it requires for the different types of information that can be imported. When importing data from a QIF file into AccountEdge, you will need to change the file name extension of the QIF file from.AccountEdge does not import employee payroll checks, inventory quantities, or inventory values, but you can import inventory adjustments.The following information can be imported from the File > Import Data drop-down menu: The rest of this article will provide information on which information can be imported and export, the order in which you should import information, troubleshooting tips and more. It is generally recommended to use the comma-seperated text file format. AccountEdge can import from and export to either comma-separated or tab-delimited text files. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |