Below are the instructions to import JOOR sales transactions into QuickBooks Desktop (QBDT) as a Sales Order using Rightworks Transaction Pro Importer. A sample map file is attached on the right-hand side of the screen to use with your JOOR Sales Order Import. After downloading your order file from JOOR, log into …
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…
COMMON ISSUE RESOLUTION Sub-Vendor Name Not Importing Sub-Vendor Name must include full name with a colon between each level with no space on either side of the colon. Example: VENDOR:SUB-VENDOR See this article for more info. Wrong Currency Imports Multi-currency not turned on in QuickBooks Onlin…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref No Y Alpha-numeric 21 The Reference Number is the Credit Card Credit Reference Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction…
QUESTION How can lines be removed from the import file from within Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION Sometimes, the import file may contain additional lines that are not to be imported or when testing, only a line or two is desired to test. The additional lines can…
QUESTION Will Rightworks Transaction Pro Importer import Account Names with special characters? RESOLUTION QuickBooks does not allow any special (non-ASCII) characters in list names.
MESSAGE "String length specified does not match the supported length." RESOLUTION This message appears because some data in the import file exceeds the maximum length allowed in QuickBooks Online. Edit the data in the import file so that it is shorter. For more information about maximum character lengths …
QUESTION Can Memorized Transactions be imported into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION At this time, it is not possible to import Memorized Transactions into QuickBooks Online using Importer. A workaround is to use Importer to create these recurring transactions instead …
QUESTION How is the Transaction Log saved to show only the transactions that did not import? RESOLUTION Below are the steps to follow to save only the transactions that did not import: * Select the OPTIONS button on the first screen of Rightworks Transaction Pro Importer. * On the BASIC options tab, sel…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. Name Name Y Alpha-numeric 100 Name can be an Employee Name or a Vendor Name (Contrac…