Inventory Adjustment Not Importing
ISSUE Inventory Adjustment import is not importing but cannot locate the reason. All Inventory Item show as rejecting. RESOLUTION If the Inventory Adjustment is being imported as a single large transaction (same Reference Number for all rows), a single item not importing will cause the entire import to fail. Theref…
Failure to Install file Asis420.bmp
**MESSAGE** "Failure to install file Asis420.bmp" when installing Transaction Pro Exporter or Importer Version 6.0 **RESOLUTION** To resolve this issue, please verify the following: 1. Transaction Pro is being installed on local C drive 2. MY DOCUMENTS folder is located on local C drive and user has full read/…
Error Validating Invalid Double
**MESSAGE** "Error validating Invalid double:" when importing Time Activities into QuickBooks Online **RESOLUTION** Verify the following: 1. 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. 2. If imp…
java.lang.Formal Exception
**MESSAGE** "java.lang.FormatException" when importing Bill Payments or Receive Payments **RESOLUTION** The message appears because Transaction Pro Importer cannot locate an unpaid Bill for the Vendor to which to apply the Bill Payment or an open Invoice for the Customer to which to apply the Receive Payment. Verif…
Common Issues Importing Products & Services into QuickBooks Online
COMMON ISSUE RESOLUTION Required parameter ExpenseAccountRef or IncomeAccountRef is missing in the request * Income Account is required on all Types. * Expense Account is required for type Inventory. * Expense Account is required for type NonInventory and Service if values are imported for Purchase Descriptio…
Time Tracking Error: WriteEmployee This key is already associated with an element of this collection
**ISSUE** When performing a Time Tracking import into QuickBooks Desktop (QBDT) with Transaction Pro Importer, error appears for WriteEmployee stating THIS KEY IS ALREADY ASSOCIATED WITH AN ELEMENT OF THIS COLLECTION. ![][1] **RESOLUTION** A conflict is occurring between Importer and QBDT because of a setting. To …
Invoice Import Error: WriteInvoice Subscript Out of Range
**ISSUE** When importing Invoice into QuickBooks Desktop (QBDT) using Transaction Pro Importer, a Write Invoice error appears stating SUBSCRIPT OUT OF RANGE. The Invoice Import will complete, but the error appears for each Invoice during the import. ![][1] **RESOLUTION** The issue is the result of a value being ma…
Root Element is Missing
**MESSAGE** "Root Element is Missing" **RESOLUTION** The message appears because Transaction Pro Importer is experiencing intermittent issues with QuickBooks Online Application Programming Interface (API). Please go into QuickBooks Online and review recent transactions and re-import any remaining transactions.
Error Validating Sales Term ID: Required Field Not Specified
**MESSAGE** "Error 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 a…
Time Tracking - Hours/Minutes Must Be Supplied
**MESSAGE** "Hours/minutes must be supplied for a time tracking item" **RESOLUTION** Check to see if any transaction in the import file that have a zero for the duration. These rows should be deleted from the import file prior to importing.
