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-numer…
COMMON ISSUE RESOLUTION Invalid data value for DayOfMonthDue Valid values are 1 - 31
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Location be a Sub-Location of another Location, use format Location:Sub-Location.
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, Ch…
MESSAGE "Error:9999002 - Decrypt String: Bad Data" RESOLUTION This message appears because the Rightworks Transaction Pro user does not have write permissions to the folder c:\program data. The user must have full write permission on this folder. Additionally, write permissions to the folder c:\Documents and…
QUESTION Can Microsoft Access files be imported into QuickBooks Desktop using Rightworks Transaction Pro Importer? RESOLUTION Yes, Transaction Pro Importer can import a Microsoft Access database with the .mdb extension.
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 for more info.
QUESTION How is the Default Value column used on the mapping screen of Rightworks Transaction Pro Importer for QuickBooks Online? RESOLUTION The Default Value column in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Online. Below are some examples o…
QUESTION When importing Credit Memos, how do I select the Print Later option? RESOLUTION When importing Credit Memos into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer, a value of Y must be imported for the QB field TO BE PRINTED on the import map. A value of Y may also be entered as a …
QUESTION Can the components of a Group Item be printed on a transaction that has been imported with Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION When a Group Item is imported during a transaction import (Invoices, Sales Orders, Sales Receipts, etc.), whether its components pr…