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…
QUESTION How can the box THIS CUSTOMER IS TAX EXEMPT on the Tax tab of Customer setup be checked when importing Customers? RESOLUTION When processing a Customer import, if a value is imported for the TAX EXEMPTION REASON field in the Rightworks Transaction Pro mapping, the box for THIS CUSTOMER IS TAX …
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 "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 Is there a way to stop Rightworks Transaction Pro Importer from setting up new Customers in QuickBooks Desktop (QBDT) during import? RESOLUTION Yes, there are options in Transaction Pro Importer to prevent new list items (Accounts, Customers, Employees, Items, and Vendors) during import. These optio…
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…
The following are instructions for importing the Certify Credit Card Report into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer. After downloading a Credit Card Report from Certify , log into QBDT. Open Transaction Pro Importer and select the file to import into QBDT by clicking BROWSE a…
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…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be so…
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…