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 "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…
QUESTION When importing Credit Memos, how do I select the Print Later option? RESOLUTION When importing Credit Memos into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer, a value of Y must be imported for the QB field TO BE PRINTED on the import map. A value of Y may also be entered as a …
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…
QUESTION Is there a way to set Rightworks Transaction Pro 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…
MESSAGE " Error validating Detail Lines:At least one detail line is required" RESOLUTION If importing Expenses on the transaction, make sure that data is mapped to both QuickBooks fields EXPENSEACCOUNT and EXPENSEAMOUNT. If importing Items on the transaction, make sure that data is mapped to both QuickBo…
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 Rightworks Transaction Pro Importer import attachments into QuickBooks Desktop (QBDT)? RESOLUTION Importer cannot import attachments into QBDT at this time.
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…
COMMON ISSUE RESOLUTION Invalid Email Format Email must be formatted [email protected] Example: [email protected] Invalid Postal Code Value Postal Code must be a minimum of five characters