QUESTION How is the Default Value column used on the mapping screen of Rightworks Transaction Pro Importer for QuickBooks Online? RESOLUTION The Default Value column in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Online. Below are some examples o…
COMMON ISSUE RESOLUTION Invalid Email Format Email must be formatted [email protected] Example: [email protected] Invalid Postal Code Value Postal Code must be a minimum of five characters
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…
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 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 …
ISSUE After launching Rightworks Transaction Pro Importer, the system does not log in. RESOLUTION If the Importer is not logging in, this could be because the Internet Security settings for the computer are set too high. Security settings need to be set to medium or lower.
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…
QUESTION Can Rightworks Transaction Pro Importer import attachments into QuickBooks Desktop (QBDT)? RESOLUTION Importer cannot import attachments into QBDT at this time.
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…
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 to the same transaction. The import must be sorted by this column prior to impo…