4 Pass Strategy

From Q2Q Wiki
Jump to: navigation, search

For a video on the 4 Pass Presentation:

Four Pass Strategy

For a video on Filtering and Individual Selection:

Filtering and Individual Selection

For transfers of large amounts of data we recommend the following sequence of events (we refer to these as Transfer Passes 1 through 4):

1. Transfer all Lists without using any date range or other filters.

2. Transfer Transactions other than Receive Payment, Bill Payment Check and Deposit

3. Transfer Receive Payments and Bill Payment Checks

4. Transfer Deposits

After each step above, any rejects noted must be corrected and re-transferred before proceeding to the next step.

You can click the buttons in the lower right corner of the Select Type of Data screen (see the Change button on row 2 of the main screen) to select the types of date to transfer in each of the 4 transfer passes noted above.

To transfer data:

Make a new backup of the source and destination companies

Pass 1

Transfer just the “Lists” (no transactions) without using any date range or other filters (this is referred to as Pass 1). You can use the transfer utility or you can use QuickBooks’ built-in export/import process. The transfer utility allows you to transfer just selected list items (e.g. only active customers or customers added/modified after a certain date) whereas the QuickBooks process transfers all items in a list. This step is not required if you use the QuickBooks “Remove ALL transactions” processed as discussed in the “Preparation” section of the following web page http://www.q2q.us/bbtuoverview.htm

If you use the transfer utility, use the “Import Status Report” (View Import Report button on row 6) to identify all rejected List names, if any. If there are any import errors, you will need to correct the underlying problem and transfer the lists again because if the rejected list entry is used in a transaction imported later, the transaction will be rejected. Following is an example of an underlying problem that prevents the transfer of a vendor.

Some Lists such as customers and vendors contain references to other Lists. For example a vendor (say Cal Telephone) could reference the Vendor Type “Residential”. If you transfer Cal Telephone, the transfer will be rejected if the Vendor Type “Residential”, is not in the destination company or if it’s not transferred at the same time as the vendor Cal Telephone. If a needed list name (in this case vendor type “Residential”) causes a rejection of a List transfer you will get an ‘invalid reference to” type of error message and it will tell you the list type and the missing name. To correct these errors, you will need to transfer the missing list name and the list name that was initially rejected. In this example you would need to make additional transfer passes and transfer the vendor type “Residential” and the vendor “Cal Telephone”.

You can correct the problem, noted in the example above, several different ways. The easiest way is probably to transfer all the existing Vendor Types (normally a short list of names) in one transfer pass and use the new “Choose Items” button on the main screen to export and transfer just the rejected vendor in a second transfer pass. Since you can’t create duplicate List names, you don’t have to use the various filter criteria to limit the Vendor Type transfer to just the missing Vendor Type (Residential). You could also transfer all the Vendors again in the second transfer pass but using the new “Choose Items” button will save time, particularly if you have a lot of vendors.

After you have successfully transferred all the names in a particular list type (say customer, vendor, vendor type etc.), uncheck that list type on the “Select Type Data” screen (row 2) so that you don’t transfer all the names in that list type again when correcting other list types. Transferring the names again won’t cause a problem but it will take up time and make the “Import Status Report” longer than it needs to be.

When transferring accounts, you will get an error if an account Number is already in the destination company and the account Name for this account number is different from the account name in the source company. There are two ways you can correct this error. You edit the account number in the either company and erase it or change it to an account number that is not in either company. You can usually do this by adding a suffix, such as 9, to the existing account number.

You can also correct this problem by clicking Preferences in the utility and setting the preference to include account numbers with account transfers to “No”. Note that excluding account numbers doesn’t affect future transfers because all transaction transfers are made using account names instead of account numbers.

After the account number or preference is changed, transfer accounts again.

Make a backup of the destination company after all the lists have been successfully transferred.

Pass 1 Video

Pass 2

Transfer transactions other than Receive Payment, Deposit and Bill Payment Checks (don’t transfer the Lists again). (This is referred to as Pass 2). If the “Export Status Report” is over 150 to 200 pages long, we recommend that you use the date ranges to transfer a smaller quantity of data. You might transfer 3 or 6 months of data at one time instead of a whole years worth of data.

Identify all rejected transactions, if any, using the “Import Status Report” (View Import Report button on row 6) or the “Import Status Report – Rejected Items” report (click Reports>”Import Status Report – Rejected Items” to see this report). Review the error messages and correct any underlying problems causing the transactions not to transfer. The most frequent cause of rejects at this point is missing List Names. To correct for missing List names, go to the “Select Type of Data” screen and clear all check marks and check the List box for the List type(s) that need to be transferred (customer, vendor, account etc). Transfer either all of the names in the selected list type or use the “Additional Criteria” screen to filter the transfer to just the missing List Names.

After successfully transferring any missing List Names, transfer just the rejected transactions in an additional transfer pass or passes. Use the “Choose Items” button on row 3 of the main screen to export and re-transfer just the transactions that were rejected earlier.

The “Choose Items” screen lists only the Transactions (and Lists) that have been exported but not imported. Items will appear on this screen if they were rejected in a prior transfer pass in the current transfer session or if they have been exported but not transferred. The purpose of the screen is to make to easier to make corrections when some transactions are accepted and some are rejected. From this screen you can choose to re-export only the rejected/un-transferred items and transfer all of them at once instead of using the various filter criteria and being able to transfer only one or a few at a time. You can see a video clip of the new “Choose Items” process by clicking on the following link http://www.q2q.us/DTUChooseItemsFeature.html

As in the past, you can also use the From and To Reference Number fields and other filter criteria available on the “Additional Criteria” screen and the “Select Type of Data” screen to transfer just the transactions that were rejected on the first transfer.

Don’t transfer transactions that were accepted on the first pass because they will be transferred again and duplicated in your destination company without warning (or with a warning if they were transferred in the current transfer session).

If there were a large number of import errors, you may want to restore your destination company backup and import all your transactions again after correcting the cause of the rejects.

Make a backup of the destination company it this point.

Pass 2 Video

Pass 3

After all Invoices and Bills have been transferred, transfer Receive Payment Transactions and Bill Payment Checks, if any (this is referred to as Pass 3). Use the “Received Payments Detail” report and the “Bill Payment Checks Detail” report (click Reports>Saved Reports to see these reports) to identify all rejected transfers, if any.

The “Received Payments Detail” report (available from the Reports menu) will show which missing invoice(s) caused the Receive Payment transaction to be rejected. Look for an x in the far right “Err” column on this report. All missing Invoices will need to be transferred using the Ref Number and/or other filters shown on the “Additional Criteria” screen. In addition, the rejected Receive Payment transactions will need to be transferred again. You can use the “Choose Item” button on row 3 of the main screen (as discussed in previous paragraphs) or the filters on the Additional Criteria screen (row 3) to transfer just the rejected Receive Payment transactions.

The “Bill Payment Checks Detail” report (available from the Reports menu) will show which missing Bill(s) caused the Bill Payment Check transaction to be rejected. Look for an x in the far right “Err” column on this report. All missing Bills will need to be transferred using the Ref Number range and/or other filters shown on the Additional Criteria screen. In addition, the rejected Bill Payment Check transactions will need to be transferred again. You can use the “Choose Item” button the main screen (as discussed in previous paragraphs) or the filters on the Additional Criteria screen to transfer just the rejected Bill Payment Check transactions.

Some Bill Payment Check transfers may be rejected with the error message of “The transaction object xxx-xxx may only be provided once in this request”. This error occurs when an individual vendor has two or more Bills with the same transaction date and no reference number was entered on the Bills or the same reference number was entered on the Bills. To correct this problem, open the source company in QuickBooks and edit the same date/no reference number Bills being paid by the rejected Bill Payment Check (see the “Bill Payment Checks Detail” report for these Bills) and add a unique reference number to the Bills (you can just use 1, 2, 3 etc). Then edit the same Bills in the destination company and assign the same reference numbers to them that you assigned to them in the source company. After the reference numbers have been assigned to the Bills, transfer the rejected Bill Payment checks using the “Choose Items” screen or the filters on the “Additional Criteria” screen.

Pass 3 Video

Pass 4

After all Receive Payment Transactions, if any, have been transferred, transfer Deposit transactions (this is referred to as Pass 4). If any Deposit transfers were rejected, the “Deposits Detail” report (available from the reports menus) will show which Receive Payment, Invoice, or Sales Receipt transaction caused the Deposit transaction to be rejected. Look for an x in the far right “Err” column on this report. Any missing underlying transactions (Receive Payment, Invoice, or Sales Receipt) will need to be transferred and the rejected Deposit transactions will need to be transferred again.

Pass 4 Video