You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Emails from our Customer Support team will be sent from [email protected].

To ensure you receive important updates without interruption, please add [email protected] to your safe sender list and mark it as “not spam.”

Showing articles from Import tag

Alphanumeric Value Error - QuickBooks Online

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.

Error Validating Sales Term ID: Required Field Not Specified

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…

Import Employee Expenses Charged to Company Credit Card

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…

Import Employee Expenses Charged to Company Credit Card into QuickBooks Online

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…

Alphanumeric Value Error - QuickBooks Desktop

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.

Import Sub-Levels for Customers, Vendors, Classes, Items, or Accounts into QuickBooks Online

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…

Desktop Data Dictionary: How Should My Data Be Mapped?

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.…

Import Employee Expense Reimbursement to be Paid

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…

The Item History Could Not Be Locked

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.

Customer Address Being Cleared on Import

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).

scroll to top icon