ISSUE Error received or incorrect data imports when importing alphanumeric columns. RESOLUTION Ensure that the mixed-format columns (alphanumeric) are formatted as text in the import file.
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…
Employee Expenses charged to the company credit card may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as a Credit Card Charge import type. TPro Importer does not require a specific file layout to import into QBDT. However, if you wish to view or use the TPro sample file for impo…
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…
ISSUE Error received or incorrect data imports when importing alphanumeric columns. RESOLUTION Make sure that mixed-format columns (alphanumeric) are formatted as text in the import file.
QUESTION If importing Sub-Levels for Customers, Vendors, Classes, Products and Services, or Accounts into QuickBooks Online using Rightworks Transaction Pro Importer, how do they need to be formatted? RESOLUTION Format for Customers If the Customer import file contains Sub-Customers, both the main Custome…
QUESTION How I should my data be mapped when importing into QuickBooks Desktop (QBDT)? RESOLUTION The attached Data Dictionary shows the types of lists and transactions that can be imported using Rightworks Transaction Pro Importer into QBDT, as well as the available and required fields for each import type.…
Employee Expense Reimbursements may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Check import type, if the reimbursement has already occurred. This article discusses importing as a Bill import type. For infor…
QUESTION The item history could not be locked RESOLUTION This message appears because one of the Items in the import file is being edited in the QuickBooks company file while the import is being processed. Once this Item is saved or closed in QB, the message will not appear.
ISSUE When importing Invoices or Sales Receipts, the Customer Address is being cleared. RESOLUTION Verify that the Option to CLEAR TRANSACTION BILL TO/SHIP TO ADDRESS WHEN IMPORTING is not selected in the OPTIONS on the BASIC tab (see image below).