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…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Location be a Sub-Location of another Location, use format Location:Sub-Location.
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…
QUESTION Can Rightworks Transaction Pro Importer import attachments into QuickBooks Desktop (QBDT)? RESOLUTION Importer cannot import attachments into QBDT at this time.
QUESTION When importing Credit Memos, how do I select the Print Later option? 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 a …
MESSAGE "Error validating Invalid double:" when importing Time Activities into QuickBooks Online. RESOLUTION Verify the following: * If importing billable time into QuickBooks Online, ensure an import column maps Y to BillableStatus, or enter Y in the Default Value column. * When importing billable time…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. PrivateNote Memo N Alpha-numeric 4000 ToAccount Transfer Funds To Y Alpha-numer…
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, Ch…
QUESTION Is there a way to set Rightworks Transaction Pro Importer to not process payments if it will result in an overpayment? RESOLUTION No, QuickBooks Online will apply any overpayment as a credit to the Customer's account. POSSIBLE WORKAROUND Use Transaction Pro Exporter to export a list of Inv…
QUESTION Can users continue to work in QuickBooks Desktop while importing with Rightworks Transaction Pro Importer? RESOLUTION Yes, multiple users can be working in QuickBooks Desktop while importing. Also, QuickBooks Desktop does not need to be in single-user mode when processing imports with Importer.