In Version 7 of Rigthworks Transaction Pro Importer and Exporter for QuickBooks Desktop (QBDT), the color scheme can be changed. This is a similar feature to what the QB Pro, Premier and Enterprise software allows. When in Importer or Exporter, click the box in the upper right-hand corner that looks like an arrow.…
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…
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…
The following are instructions for importing the Concur Employee Expense Reimbursement Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading an Employee Expense Reimbursement Report from Concur , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Sele…
QUESTION Can Classes be imported into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer on a transaction? RESOLUTION If the option to use Classes is selected in QBDT Company Preferences under Accounting, the Class field will be available in Importer for use on imported transactions. In QB…
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…
COMMON ISSUE RESOLUTION Sub-Customer Name Not Importing Sub-Customer Name must include full name with a colon between each level with no space on either side of the colon. Example: CUSTOMER:SUB-CUSTOMER See this article for more info. Wrong Currency Imports Multi-currency not turned on in QuickBoo…
QUESTION How is the Static Value / Formula column used on the mapping screen of Rightworks Transaction Pro Importer? RESOLUTION The Static Value / Formula column in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Desktop (QBDT). Below are some exa…
QUESTION How can Vendor Credits be applied to Bills or Bill Payments? RESOLUTION At this time, Rightworks Transaction Pro Importer cannot apply Vendor Credits during an import. These will need to be matched manually in QuickBooks Online.
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Bill no Y Alpha-numeric 21 The Reference Number is the Bill Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted…