MESSAGE "Error validating Invalid double:" when importing Time Activities into QuickBooks Online RESOLUTION Verify the following: * If importing billable time into QuickBooks Online, be sure to have an import column with a Y mapped to BillableStatus or enter a Y for the Default Value column. * If import…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Miss, Dr FirstName First name Y Alpha-numeric 50 MiddleName M.I. N Alpha-numeric 1 QuickBooks Online only stores the Middle Initia…
Employee Expenses charged to the company credit card may be imported into QuickBooks Online using Transaction Pro (TPro) Importer as a Credit Card Charge import type. TPro Importer does not require a specific file layout to import into QuickBooks Online. However, if you wish to view or use the TPro sample file for…
QUESTION What is the easiest way to tell if the QuickBooks Online company is set to automatic or manual tax? RESOLUTION The quickest way to tell if on the automatic sales tax or manual sales tax option is to open a Customer in QuickBooks Online and go to the TAX INFO tab. If the tab displays a checkbox follo…
MESSAGE "E rror validating sales term ID: required field not specified" RESOLUTION This error message appears because a Sales Term was not specified and mapped to the field Sales Terms. QuickBooks Online requires that a Sales Term be mapped to the field. To resolve this issue, either a Sales Terms must be…
ISSUE Error received or incorrect data imports when importing alphanumeric columns. RESOLUTION Make sure that mixed formatted columns (alphanumeric) are formatted as text in the import file.
QUESTION Can Custom Fields be imported into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION Yes, Custom Fields can be imported into QuickBooks Online using Importer. * Note: Only the first 3 custom fields created will be available. This is a limitation of the QuickBooks Online API. …
Employee Expense Reimbursements may be imported into QuickBooks Online using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Expense or Check import type, if the reimbursement has already occurred. This article discusses importing as a Check import type. For i…
MESSAGE " Error Validating Employee or Vendor" when importing Time Activities. RESOLUTION This message appears because an Employee or Vendor in the import file does not already exist in QuickBooks Online. All Employees and Vendors in a Time Activities import file must previously exist in QuickBooks Online pr…
QUESTION How can the next transaction number in QuickBooks Online be used when importing a transaction with Transaction Pro Importer? RESOLUTION If the transaction number is not in the import file or if it is preferred to let QuickBooks Online use the next transaction number in the current numbering sequence…