.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…
You Must Select a Product / Service or an Account for Each Split Line with Either an Amount or a Billable Customer
MESSAGE "You must select a product/service or an account for each split line with either an amount or a billable customer" RESOLUTION This is a known bug in the QuickBooks Online Application Program Interface (API) as it is a false error message. The actual issue is that an expense transaction (Bills, Che…
Term Import Fields for Rightworks Transaction Pro Online
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 31 To import Term be a Sub-Term of another Term, use format Term:Sub-Term DueDays Due in fixed number of days N Numeric 3 Due Date calculated by adding the specifi…
Import Microsoft Access Data Files into QuickBooks using Rightworks Transaction Pro Importer
QUESTION Can Microsoft Access files be imported into QuickBooks Desktop using Rightworks Transaction Pro Importer? RESOLUTION Yes, Transaction Pro Importer can import a Microsoft Access database that has the extension .mdb
Root Element is Missing
MESSAGE "Root Element is Missing" RESOLUTION The message appears because Rightworks Transaction Pro Importer is experiencing intermittent issues with QuickBooks Online Application Programming Interface (API). Please go into QuickBooks Online and review recent transactions and re-import any remaining trans…
Import Fees on PayPal Transactions with Rightworks Transaction Pro Importer for QuickBooks Online
QUESTION How can fees on PayPal transactions be imported? RESOLUTION The download file from PayPal has the gross amount and the PayPal fees listed on one line. However, in Rightworks Transaction Pro Importer, only one item can be mapped per line. The workaround for this is to import the Gross Amount as a Pro…
CenterCard Employee Reimbursement Import into QuickBooks Online
CenterCard Employee Reimbursement Import into QuickBooks Online The following are instructions for importing the CenterCard Bill Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading an Employee Expense Reimbursement Report from CenterCard , log into Transaction Pro and sel…
Purchase - Cash Import Fields for Rightworks Transaction Pro Online
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no Y Alpha-numeric 21 The Reference Number is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this column prior to importin…
Field to Use on Mapping to Import Location in QuckBooks Online
QUESTION If the Location label name has been changed in QuickBooks Online company settings, what field needs to be used in Rightworks Transaction Pro Importer to import to the updated Location label? RESOLUTION In QuickBooks Online in company settings under categories, the Location label may be changed to an…
Import Credit Memos with To Be Printed Selected
QUESTION When importing Credit Memos, how is the option to Print Later selected? RESOLUTION When importing Credit Memos into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer, a value of Y must be imported for the QB field TO BE PRINTED on the import map. A value of Y may also be entered as…
