How to duplicate, skip or overwrite existing transactions

You can set an option in the Axis importing options so that in it will either, duplicate, skip it or overwrite if the transaction already exists.  According to which option you select then Axis will do the following:

  • Duplicate - when importing transactions and Axis finds that the transaction reference number already exists then Axis will create a new transaction with the same reference number. For example there will be two invoices with the number 1001.
  • Skip - when importing transactions and Axis finds the transactions already exists it will skip importing the transaction. For example invoice 1001 will not be imported if there already is an invoice with a number of 1001
  • Overwrite - when importing transactions and Axis finds a transaction already exists with the same reference number it will delete the transaction from QuickBooks and will replace it with the transaction it is importing.  For example the existing invoice of 1001 will be deleted and a new invoice with reference number of 1001 will be created.

To set the option, follow these steps:

  1. Open Axis and the import tab
  2. In the group labelled Conflict options select either Duplicate, Skip or Overwrite

Note:

  • If Autonumbering is selected then the import process will default to the setting of Duplicate
  • It is not possible to use this option for importing Time Entries into QuickBooks as there is no reference number for time entries in QuickBooks.
  • In MYOB it is not possible to Overwrite a transaction as the MYOB interface does not support Delete or Update.
  • Overwriting transactions that are linked to other QuickBooks transaction will remove the linking

Article ID: 113, Created On: 10/21/2011, Modified: 10/21/2011