![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no. Y Alpha-numeric 21 The Reference Number is the assigned Vendor Credit Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must …
![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. PrivateNote Memo N Alpha-numeric 4000 ToAccount Transfer Funds To Y Alpha-numeric 100 Account…
**MESSAGE** "You must select a product/service or an account for each split line with either an amount or a billable customer" **RESOLUTION** This is a known bug in the QuickBooks Online Application Program Interface (API) as it is a false error message. The actual issue is that an expense transaction (Bills, Chec…
**MESSAGE** "You must specify a transaction amount that is 0 or greater." **RESOLUTION** When importing a transaction, the sum of all the lines of a transaction must equal an amount of zero or greater. Line items on the transaction can be a negative amount, but the total amount needs to be zero or greater. If less …
![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this…
**QUESTION** How is a QuickBooks Online Company ID number found? **RESOLUTION** In order to find the correct user and company information, Rightworks Transaction Pro Support may ask for the QuickBooks Online Company ID. Below is a quick and easy way to retrieve this information. Log into the QuickBooks Online Comp…
**MESSAGE** "Error validating Customer ID: Invalid Integer" **RESOLUTION** This message appears because QuickBooks Online is not allowing Rightworks Transaction Pro Importer to save the Customer name. This is typically the result of one of the two situations below: * The value mapped to the field Customer alread…
**MESSAGE** "Target is not Reimbursable" **RESOLUTION** This message appears because in Rightworks Transaction Pro Importer, the Bill import or the Check import has either the field ExpenseBillableStatus or LineBillableStatus marked as Y. However, a value (Customer) is not mapped to ExpenseBillableEntity or LineBil…
COMMON ISSUE RESOLUTION Sub-Location Name Not Importing * Sub-Location Name must include full name with a colon between each level with no space on either side of the colon. * Example: LOCATION:SUB-LOCATION * See this [article ][1]for more info. [1]: https://support.transactionpro.com/kb/article/344-imp…
COMMON ISSUE RESOLUTION Invalid data value for DayOfMonthDue * Valid values are 1 - 31