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 assigned Vendor Credit Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Imp…
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…
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 Online will apply any overpayment as a credit to the Customer's account. POSSIBLE WORKAROUND Use Transaction Pro Exporter to export a list of Inv…
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 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.
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…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 31 To import Term be a Sub-Term of another Term, use format Term:Sub-Term DueDays Due in fixed number of days N Numeric 3 Due Date calculated by adding the specifi…
ISSUE After launching Rightworks Transaction Pro Importer, the system does not log in. RESOLUTION If the Importer is not logging in, this could be because the Internet Security settings for the computer are set too high. Security settings need to be set to medium or lower.
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…
ISSUE When importing Bill Payments, Rightworks Transaction Pro Importer failed to find a matching Bill (for Bills Payments) in QuickBooks Desktop (QBDT) file even though the record does exist. Error message "Could Not Find Matching Bill to Apply Bill Payment" displays on the Transaction Log. RESOLUTION First…