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

Common Issues Importing Locations into QuickBooks Online

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.

Error 9999002 - Decrypt String: Bad Data

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…

Vendor Credit Import Fields for Rightworks Transaction Pro Online

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

Common Issues Importing Terms into QuickBooks Online

COMMON ISSUE RESOLUTION Invalid data value for DayOfMonthDue Valid values are 1 - 31

Working in QuickBooks Online While Importing

QUESTION Can users continue to work in QuickBooks Online while importing with Rightworks Transaction Pro Importer? RESOLUTION Yes, multiple users can be working in QuickBooks Online while processing imports with Transaction Pro Importer.

Import Fees on PayPal Transactions with Rightworks Transaction Pro Importer for QuickBooks Online

QUESTION How can PayPal transaction fees be imported? RESOLUTION The download file from PayPal lists the gross amount and PayPal fees on a single line. However, in Rightworks Transaction Pro Importer, only one item can be mapped per line. The workaround is to import the Gross Amount as a Product/Service a…

Overpayments on Imported Invoices in QuickBooks Online

QUESTION Is there a way to set Rightworks Transaction Pro Importer to not process payments if it will result in an overpayment? RESOLUTION No, QuickBooks Online will apply any overpayment as a credit to the Customer's account. POSSIBLE WORKAROUND Use Transaction Pro Exporter to export a list of Inv…

Location Import Fields for Transaction Pro Online

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.

Use a SQL Data Source with Rightworks Transaction Pro Importer

QUESTION Can a SQL data source be used with Rightworks Transaction Pro Importer? RESOLUTION To connect to a SQL data source, follow the steps below: * In Importer, choose DSN for the file source and then click CONNECT * Select the MACHINE DATA SOURCE tab * Click NEW * An error message will appear that…

You Must Select a Product / Service or an Account for Each Split Line with Either an Amount or a Billable Customer

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…

scroll to top icon