.png)
.png)
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…
Purchase Order Import Fields for Rightworks Transaction Pro Online
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be so…
CenterCard Employee Reimbursement Import into QBDT
The following are instructions for importing the CenterCard Employee Reimbursement Report into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer. After downloading an Employee Reimbursement Report from CenterCard , log into QBDT. Open Transaction Pro Importer and select the file to import i…
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.
Bill Due Date Not Importing Correctly
ISSUE When importing a Bill using Rightworks Transaction Pro Importer into QuickBooks Desktop (QBDT) where the Bill Due Date is specified in the import file and mapped accordingly, the Due Date is being recalculated based upon the Vendor's Terms. RESOLUTION This is a known issue in QBDT. QBDT recalculates th…
Inventory Adjustment Not Importing
ISSUE Inventory Adjustment import is not importing but cannot locate the reason. All Inventory Item show as rejecting. RESOLUTION If the Inventory Adjustment is being imported as a single large transaction (same Reference Number for all rows), a single item not importing will cause the entire import to fail.…
Can Memorized Transactions Be Imported into QuickBooks Online?
QUESTION Can Memorized Transactions be imported into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION At this time, it is not possible to import Memorized Transactions into QuickBooks Online using Importer. A workaround is to use Importer to create these recurring transactions instead …
QuickBooks Non US Versions - Tax Implications
NOTE: THIS POST ONLY IMPACTS QUICKBOOKS USERS FROM CANADA, UNITED KINGDOM, AND AUSTRALIA. USA USERS CAN IGNORE THIS POSTING. ISSUE As of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. Users that have been using these fields to set GST/PST (Canada) or VAT (UK) will not longer hav…
Error Validating Detail Lines: At Least One Detail Line is Required
MESSAGE " Error validating Detail Lines:At least one detail line is required" RESOLUTION If importing Expenses on the transaction, make sure that data is mapped to both QuickBooks fields EXPENSEACCOUNT and EXPENSEAMOUNT. If importing Items on the transaction, make sure that data is mapped to both QuickBo…
Concur Credit Card Import into QuickBooks Online
The following are instructions for importing the Concur Credit Card Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Credit Card Report from Concur , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Select CREDIT CARD CHARGES as your import t…
