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