TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no Y Alpha-numeric 21 The Reference Number is how TPro and QuickBooks Online know which detail rows belong to the same transaction. The import must be sorted by this column prior to impo…
MESSAGE "Error validating Invalid double:" when importing Time Activities into QuickBooks Online. RESOLUTION Verify the following: * If importing billable time into QuickBooks Online, ensure an import column maps Y to BillableStatus, or enter Y in the Default Value column. * When importing billable time…
MESSAGE "java.lang.FormatException" when importing Bill Payments or Receive Payments. RESOLUTION The message appears because Rightworks Transaction Pro Importer cannot locate an unpaid Bill for the Vendor to apply the Bill Payment to, or an open Invoice for the Customer to apply the Receive Payment to. Ve…
MESSAGE "Target is not Reimbursable." RESOLUTION This message appears because, in Rightworks Transaction Pro Importer, the Bill or Check import has either the ExpenseBillableStatus or LineBillableStatus field marked as Y. However, a value (Customer) is not mapped to ExpenseBillableEntity or LineBillableEntit…
QUESTION Can the components of a Group Item be printed on a transaction that has been imported with Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION When a Group Item is imported during a transaction import (Invoices, Sales Orders, Sales Receipts, etc.), whether its components pr…
The following are instructions for importing the CenterCard Employee Reimbursement Report into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer. After downloading an Employee Reimbursement Report from CenterCard , log into QBDT. Open Transaction Pro Importer and select the file to import i…
QUESTION If the Location label name has been changed in QuickBooks Online company settings, what field needs to be used in Rightworks Transaction Pro Importer to import to the updated Location label? RESOLUTION In QuickBooks Online in company settings under categories, the Location label may be changed to an…
MESSAGE "Root Element is Missing" RESOLUTION The message appears because Rightworks Transaction Pro Importer is experiencing intermittent issues with the QuickBooks Online Application Programming Interface (API). Please log in to QuickBooks Online, review recent transactions, and re-import any remaining t…
ISSUE Inventory Adjustment import is not importing but cannot locate the reason. All Inventory Item show as rejecting. RESOLUTION If the Inventory Adjustment is imported as a single large transaction (with the same Reference Number for all rows), a single item not importing will cause the entire import to fa…
QUESTION Can Microsoft Access files be imported into QuickBooks Desktop using Rightworks Transaction Pro Importer? RESOLUTION Yes, Transaction Pro Importer can import a Microsoft Access database with the .mdb extension.