QUESTION Can Rightworks Transaction Pro Importer import into the additional fields connected with using Advanced Inventory in QuickBooks Enterprise (QBE)? RESOLUTION If using QBE, a subscription to Advanced Inventory can be added that will add the additional features listed below: * FIFO costing * Multi…
QUESTION How is the Static Value / Formula column used on the mapping screen of Rightworks Transaction Pro Importer? RESOLUTION The Static Value / Formula column in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Desktop (QBDT). Below are some exa…
MESSAGE " Hours/minutes must be supplied for a time tracking item" RESOLUTION Check to see if any transaction in the import file has a zero for the duration. These rows should be deleted from the import file prior to importing.
QUESTION Can Classes be imported into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer on a transaction? RESOLUTION If the option to use Classes is selected in QBDT Company Preferences under Accounting, the Class field will be available in Importer for use on imported transactions. In QB…
MESSAGE "This account period is closed" RESOLUTION The date of the transaction being imported falls before the closing date restriction set in QuickBooks Online. To import, either the date of the transaction to be imported will need to be changed to a later date or the closing date restriction will need to be removed…
QUESTION Can I use Rightworks Transaction Pro Importer to set up a new QuickBooks Desktop (QBDT) company file? RESOLUTION Yes, several companies have used Importer to migrate data from a different accounting application into QBDT or to start a new company file at the beginning of the year in QBDT. Please …
QUESTION How can an IIF file from a Payroll Provider be imported into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Most Payroll Providers provide an IIF file for importing Payroll data into QuickBooks. However, QuickBooks Online does not allow IIF files to be imported, as these file…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Journal no. Y Alpha-numeric 21 The Reference Number is the assigned Journal Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Impor…
MESSAGE "You must specify a transaction amount that is 0 or greater." RESOLUTION When importing a transaction, the sum of all the lines of a transaction must equal an amount of zero or greater. Line items in the transaction can have negative amounts, but the total must be zero or greater. If less zero, the t…
MESSAGE "Validation Error: Indicated failed object." RESOLUTION QuickBooks may return this or a similar generic error message to Rightworks Transaction Pro Importer during a Journal Entry import to indicate one of the following issues: * A debit or credit in the import file has a negative value. Negative…