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

Target is Not Reimbursable

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 Expenses Billable or Items Billable marked as Y. However, a value is not mapped to Expenses Customer or Items Customer. If a transac…

Invoice Import Error: WriteInvoice Subscript Out of Range

ISSUE When importing an Invoice into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer, a Write Invoice error appears stating SUBSCRIPT OUT OF RANGE. The Invoice Import will complete, but the error appears for each Invoice during the import. RESOLUTION The issue is caused by a value bei…

Skip Duplicate Transactions with Matching Reference Numbers when Importing

QUESTION When importing, will Rightworks Transaction Pro Importer skip transactions that already exist in QuickBooks Desktop (QBDT)? RESOLUTION By default, Transaction Pro Importer for QBDT does not skip transactions that already exist. However, there is an option to SKIP TRANSACTIONS WITH MATCHING REFERENCE…

Certify Bill Report Import into QuickBooks Online

The following are instructions for importing the  Certify  Bill Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Bill Report from  Certify , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE:  Select BILLS as your import type by clicking on the b…

JOOR Sales Transaction Sales Receipt Import into QuickBooks Desktop

Below are the instructions to import JOOR sales transactions into QuickBooks Desktop (QBDT) as a Sales Receipt using Rightworks Transaction Pro Importer . A sample map file is attached on the right-hand side of the screen to use with your JOOR Sales Receipt Import After downloading your order file from JOOR, lo…

You Must Fill Out At Least Two Detail Lines

MESSAGE "You must fill out at least two detail lines." RESOLUTION The message appears because a Journal Entry in the import file does not have at least two lines. Rightworks Transaction Pro Importer for QuickBooks Online groups multiple lines onto the same Journal Entry that have the same value mapped to the…

Allow Online Payment for Imported Invoice

Overview In TPro, certain fields labeled as  "AllowIPNPayments"  relate to the  Intuit Payment Network (IPN) . IPN was previously used for Intuit's Merchant Services. However, this service has been discontinued, and as a result, these fields in TPro are now deprecated and no longer functional. What This Means for T…

General Ledger Account Formatting

QUESTION How do General Ledger Accounts need to be formatted in the import file when using Rightworks Transaction Pro Importer with QuickBooks Online? RESOLUTION If Accounts are used in the import file, only the Account Name or the Account Number should be used, never both. If using Account Numbers, only …

Indicated Object Failed Validation

MESSAGE "Indicated Object Failed Validation." RESOLUTION When importing a Journal Entry with a debit and credit column, the numbers in both columns must be positive numbers.

Automate SQL Server Imports into QuickBooks using Rightworks Transaction Pro Importer

QUESTION Can SQL Server imports into QuickBooks Desktop (QBDT) using Transaction Pro Importer be automated? RESOLUTION Yes, SQL Server Imports into QB may be automated using Importer. Below are some tips on how to automate the import process once several successful manual imports are made. The command …

scroll to top icon