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.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172

Showing articles from Import tag

Link Invoices to Sales Order When Importing

QUESTION How can an open Sales Order be linked to an Invoice during import? RESOLUTION Rightworks Transaction Pro Importer can link an open Sales Order to an imported Invoice with the use of the command line /INVOICESO=1 The information below discusses this option as well as some additional steps to be ta…

Product and Service Import Fields for Rightworks Transaction Pro Online

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 …

Auto Assign Transaction Numbers - QuickBooks Desktop

QUESTION How can it be set so that QuickBooks Desktop (QBDT) auto assigns the next transaction number when importing with Rightworks Transaction Pro Importer? RESOLUTION On the first window of Importer, click OPTIONS. On the BASIC tab in the Transaction Reference Numbers section, select the option to LET QUI…

Pre-Defined Rightworks Transaction Pro Maps for Data Migration from QuickBooks Online to QuickBooks Online

QUESTION If exporting from QuickBooks Online using Rightworks Transaction Pro Exporter and then importing the data back into a QuickBooks Online company file, all of the column names do not match exactly. Are there pre-defined maps that can be used for the process? RESOLUTION When the data is exported from Q…

Advanced Inventory Imports into QuickBooks Enterprise

QUESTION Can Rightworks Transaction Pro Importer import into the additional fields connected with using Advanced Inventory in QuickBooks Enterprise (QBE)? RESOLUTION If using QBE, a subscription to Advanced Inventory can be added that will add the additional features listed below: * FIFO costing * Multi…

Practical Uses for Static Values or Formulas in Rightworks Transaction Pro Importer

QUESTION What are some ways that the Static Value/Formula column can be used in Rightworks Transaction Pro Importer? RESOLUTION Transaction Pro Importer for QuickBooks Desktop (QBDT) has the ability to map either a Static Value or a Formula on the mapping window to use with the import file.  For more informa…

Import Expenses into QuickBooks Desktop

QUESTION What is the best import type to use to import expenses into QuickBooks Desktop (QBDT)? RESOLUTION Often times, users will have an Excel listing of expenses to import into QBDT but are unsure as to which import type to select. Below are the different import types to consider selecting and how they…

Saved Map Does Not Match One or More Fields

MESSAGE "Saved map does not match one or more fields from the current import file. Cannot load saved map. Please try loading the same file format used when creating the mapping or click the Load Map button to load a map for this file." RESOLUTION If this message is received when using Rightworks Transaction …

Receive Payment Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber   Y Alpha-numeric 31 The Reference Number for this type of import should be unique for each row. TxnDate Payment date N Date N/A If no date is imported, transaction will be date…

Account Does Not Exist error during Import in Rightworks Transaction Pro Importer

MESSAGE When importing transactions into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer and using the Account Name, it says the Account does not exist even though it does. RESOLUTION There are two options to resolve this issue: 1. Check your preferences in QuickBooks Desktop to make su…

scroll to top icon