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.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172

Showing articles from Data Dictionary tag

Product and Service Import Fields for Rightworks Transaction Pro Online

TYPE: INVENTORY TYPE: NONINVENTORY TYPE: SERVICE TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Product & Service item into a Category, import Category:Name for the Name field. Type Type N …

Customer Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Dr Company Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-numeric 25 …

Bill Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Bill no Y Alpha-numeric 21 The Reference Number is the Bill Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted…

Journal Entry Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Journal no. Y Alpha-numeric 21 The Reference Number is the assigned Journal Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Impor…

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

Employee Import Fields for Transaction Pro Online

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…

Validation Error: A Field Cannot Exceed a Certain Number of Characters

MESSAGE "Validation Error: A Field Cannot Exceed a Certain Number of Characters" RESOLUTION The message appears because a value that is being imported exceeds the maximum allowed characters in QuickBooks. For information regarding the maximum allowed characters for QuickBooks fields, reference the Data Dicti…

Online Data Dictionary: How Should My Data Be Mapped?

QUESTION How I should my data be mapped when importing into QuickBooks Online? RESOLUTION The attached Data Dictionary shows the types of lists and transactions that can be imported using Transaction Pro Importer into QuickBooks Online, as well as the available and required fields for each import type. Pleas…

Invoice Import Fields for Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Invoice no Y Alpha-numeric 21 The Reference Number is the Invoice Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be so…

scroll to top icon