QUESTION How is the Default Value column used on the mapping screen of Rightworks Transaction Pro Importer for QuickBooks Online? RESOLUTION The Default Value column in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Online. Below are some examples o…
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
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 Unable to locate the Billing Portal RESOLUTION The Billing Portal for Rightworks Transaction Pro Online has been moved! We have recently made some changes to the interface that have changed the location of billing-related options. The articles below outline the tasks that would be performed in the B…
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…
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. PrivateNote Memo N Alpha-numeric 4000 ToAccount Transfer Funds To Y Alpha-numer…
ISSUE When querying data to delete with Rightworks Transaction Pro Deleter, only 200 lines appear in the grid even if more than 200 transactions exist to delete. RESOLUTION Unfortunately, it is a known issue with the QuickBooks Online Application Program Interface (API) that the query is really slow. Therefo…
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 "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…
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…