.png)
.png)
Remove Lines from Import File before Importing
QUESTION How can lines be removed from the import file from within Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION Sometimes, the import file may contain additional lines that are not to be imported or when testing, only a line or two is desired to test. The additional lines can…
Import Accounts Instead of Items on Sales Transactions
QUESTION How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer? RESOLUTION In QBDT, Intuit does not allow a GL Account to be used on sales transact…
Working in QuickBooks Desktop While Importing
QUESTION Can users continue to work in QuickBooks Desktop while importing with Rightworks Transaction Pro Importer? RESOLUTION Because Importer uses the QB Software Development Kit (SDK), multiple users can be working in QB while importing. Also, QB does not need to be in single-user mode when processing imp…
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…
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…
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…
Use Deleter to Reduce QuickBooks Company File Size
QUESTION How can Rightworks Transaction Pro Deleter be used to reduce a QuickBooks Desktop (QBDT) company file size? RESOLUTION Deleter can be used to remove unneeded transactions, but it can also be used to reduce ever growing QB data file sizes. After deleting the transactions, these additional steps ne…
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.…
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…
Transactions or List Items are not Being Deleted
ISSUE Selected transactions or list items are not being deleted when using Rightworks Transaction Pro Deleter. RESOLUTION If selected transactions or lists are not being deleted in QuickBooks company file, check the following: * Make sure that the transactions or lists are actually being selected to be d…
