You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172

Showing articles from Import tag

Color Scheme Path Not Found

MESSAGE Path not found for color schemes RESOLUTION Download the appropriate (version 6 or version 7) attached zip file (found on the right-hand side of this article) and extract the files into the following location: VERSION 6.0 C:\Users\(your user name)\Documents\01 Transaction Pro Importer 6.0\Color Sch…

Customer:Job: XYZ is Duplicated in the QuickBooks File

MESSAGE "Customer:Job: XYZ is duplicated in the QuickBooks file," where XYZ indicates the Customer name that is causing the error. RESOLUTION This message appears because a Customer name exists under the same name either as a Customer, Vendor, Other Name, Employee, or Item in the QuickBooks Desktop (QBDT) co…

Validation Error: A Field Cannot Exceed a Certain Number of Characters

MESSAGE "Validation Error: A Field Cannot Exceed a Certain Number of Characters" RESOLUTION The message appears because a value that is being imported exceeds the maximum allowed characters in QuickBooks. For information regarding the maximum allowed characters for QuickBooks fields, reference the Data Dicti…

JOOR Sales Transaction Sales Receipt Import into QuickBooks Online

Below are the instructions to import JOOR sales transactions into QuickBooks Online as a Sales Receipt using Transaction Pro Importer. After downloading your sales file from JOOR , log into QuickBooks Online . Log into Transaction Pro Importer and select to START IMPORT. CHOOSE IMPORT TYPE : Select SAL…

You Must Specify a Transaction Amount that is 0 or Greater - QuickBooks Desktop

MESSAGE "You must specify a transaction amount that is 0 or greater." RESOLUTION When importing a transaction, the sum of all the lines of a transaction must equal an amount of zero or greater. Line items on the transaction can be a negative amount, but the total amount needs to be zero or greater. If less z…

Overpayments on Invoices in QuickBooks Desktop

QUESTION Is there a way to set Transaction Pro Importer Importer to not process payments if it will result in an overpayment? RESOLUTION No, QuickBooks Desktop (QBDT) will make any overpayment a credit on the Customer's account. POSSIBLE WORKAROUND Use Transaction Pro Exporter to export a list of I…

Business Validation Error: There is no Account Associated with the Item

MESSAGE Business Validation Error:  There is no account associated with the item. Is it marked for purchase and has an account associated with it? RESOLUTION If the above message is received when importing using Rightworks Transaction Pro Importer for QuickBooks Online and the Item type is either Non-Invento…

Invalid Number: Error: Duplicate Name Exists Error

MESSAGE "Invalid Number: Error: Duplicate Name Exists Error" RESOLUTION The message appears because a name in the import file is attempting to be added to QuickBooks Online that already exists in another list. The same name cannot be used in multiple lists (Customer, Vendor, or Employee) in QuickBooks Online…

Import Multi-Lined Descriptions

QUESTION How should an Excel file be formatted so that there will be multiple lines in the description instead of the description wrapping when imported into QuickBooks Online? RESOLUTION In the Excel file, enter the full description in the cell. Then, place the cursor right before the first character that n…

Duplicate Document Number Message

MESSAGE "Duplicate Document Number Error : You must specify a different number. This number has already been used." RESOLUTION The message appears because a transaction already exists in QuickBooks Online with this number. In order to allow QuickBooks Online to use duplicate numbers, the following changes…

scroll to top icon