Your data contains duplicate list elements (2008/09 and later)

Legacy KB ID: 5575

Question

How do I resolve the message I received when running the Reckon Accounts Verify or Rebuild utility: "Your data contains duplicate list elements. Please view Qbwin.log located in your program directory for a list of the duplicate elements"?

Answer

Find the duplicate name and change it to make it unique

 

The issue

This message occurs when you have two or more identical names, items, or accounts in your lists.

 

Solution:

Open the QBwin.log file

1.      Desktop

a.      With your Reckon Accounts company file open, press the F2 key on your keyboard to display the Product Information window.

b.      Press CTRL+2 on your keyboard to open the Tech Help window.

c.       In the Tech Help window, click the Open File tab.

d.      Double-click Qbwin.log to open it

2.      Hosted

a.      On the floating toolbar, click the download icon

b.      In the Look In box select Q drive and then the Log folder

c.       Click on the verify_rebuild_data.log file (it should have the latest date) to download it to your local PC

d.      Open it with Notepad

In the QBWIN.LOG you have opened in Notepad:

press CTRL+End on your keyboard to move to the bottom of the document.

Gradually scroll up through the document until you see a message or messages similar to:

Error: Verify Name list. Duplicate name encountered. Name: [name] Records 55 (950) and 1052 (951).

In your data file that is opened in Reckon Accounts:

From the Lists menu, choose the appropriate list, and double-click the name to open an Edit screen.

If the duplicate name is an account, click once to select the account, then click the Account menu button, and choose Edit.

Change the name in some manner to make it unique (for example, capitalization, spacing, or punctuation), and click OK to save the change.

Edit any other duplicate list items that are found in the Qbwin.log.

When all the items have been edited, from the File menu, choose Utilities, and Verify Data. You should not receive the error message again.

 

If the list elements are tax payable accounts

Edit each tax payable account.

1.      If the type of account can be changed then change the name of the account to "Tax Payable Temp", adding a number for more than one account.

2.      If the account type can't be change and is greyed out then leave it as tax payable, THIS IS YOUR REAL TAX PAYABLE ACCOUNT.

3.      Move the sub accounts of any imposter tax payable accounts to the real tax payable account.

a.      move the mouse over the bullet next to the name of the sub account until it changes to a 4 way arrow,

b.      holding the left mouse button down drag the account into position.

When the imposter accounts are free of their sub accounts, check for the Tax Supplier in Lists > Tax Item List, and open a tax item (like NCG or GST) and take note of the Tax Agency field – in most cases it will be Australian Taxation Office.

Go to the Supplier Centre and right click your Tax Agency > Edit Supplier> Tax Agency Info.  If the Track tax on purchases/sales…. fields are Tax Payable Imposter accounts, change them to the correct Tax Payable account and click OK to save.

Next, in Chart of Accounts, click on a Tax Payable Imposter account to open the Registry.  On each transaction that shows here, double click on it to open it and enter a dot in the memo field and save it. 

When the register is empty then you can delete the Tax Payable imposter accounts

 

Need more help?

Ask the Reckon Community at: https://community.reckon.com/reckon.


How did we do?

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)