cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
QuickBooksHelp
Intuit

A memorised report does not open or opens a different report

Learn how to fix issues with your memorised reports not opening or opening unintended results. 

Some users recently found that they were unable to open memorised reports after upgrading from QuickBooks Desktop 2018/Enterprise 18 to QuickBooks 2021/Enterprise 21.Updating QuickBooks 21/Enterprise 21 to the latest release and performing a Rebuild Data after updating will repair these damaged memorised reports.

Currently upgrading files from QuickBooks 2018/Enterprise 18 to QuickBooks 2021/Enterprise 21 (R6) will no longer cause this issue.

Perform the troubleshooting steps in this article when a memorised report does not open or a different report opens.

The Verify Data utility (File > Utilities > Verify Data) may add these messages to the Qbwin.log file:

  • ERROR--Error: Verify Memorised Report List: TotUsed is XX, expected XX Error: Verify Memorised Report list: Display index invalid.

  • LVL_ERROR--Memorised Report recnum XXX (Name of Report) contains corrupted formatting data. recnum 140 -- This memorised report must be deleted.

This can occur if the memorised report or the memorised report list is damaged. Instead of opening the report that you want:

  • Nothing happens because the location does not exist or is empty.
  • A different report opens because the instructions point to a different location.

Solution 1: Basic Data Damage troubleshooting

  1. Re-sort the Memorised Reports list.

    1. From the Reports menu, select Memorised Reports, then choose Memorised Reports List.
    2.  Go to Memorised Reports, then select Re-sort List.
    3. Select OK when you get the prompt "Are you sure you want to return this list to its original order?"
  2. Run the Rebuild Utility which repairs transactions and list damage in your company file (although limited to the damage it is programmed to fix).

    1. From the File menu, go to Utilities > Rebuild Data.
    2. Select OK if you receive a warning message to backup your company file.
    3. Your computer may display the message QuickBooks is not responding however, as long as you can move your mouse indicator, wait for it to complete.
    4. Select Ok when you get the message Rebuild has completed.
    5. Run Verify Data to check for remaining data damage. If the second verify fails, proceed to Step 3.
  3. Use the QBWin.log to find and resolve data damage.

    1. Find QBWin.log from the Product Information screen.
      Note: If you are working with a support agent, on the Tech Help window (before you open the file), choose Send log files to Intuit support. This will send the files to a repository that will enable the agent to view your log files.
    2. Open the log file.
    3. Search for (CTRL+ F, then type) BEGIN VERIFY and locate the most recent one (logs are in date order with latest at the end).
    4. Find LVL_ERROR. Copy and paste error into help search.
    5. Follow directions to resolve issue.
    6. Run Verify Data and repeat if additional errors are found.

Solution 2: Recreate the Memorised Report group

  1. Back up the QuickBooks company file.
  2. From the Reports menu, select Memorised Reports > Memorised Report List.
  3. From the Memorised Report drop-down arrow, select New Group.
  4. Enter Z Do Not Use in the Name field, then OK.
  5. Move all the reports that do not work to that group:
    1. Right-click an affected report, then select Edit Memorised Report.
    2. Select the Save in Memorised Report Group checkbox.
    3. From the Save in Memorised Report Group drop-down arrow, select Z Do Not Use.
    4. Repeat for all affected memorised reports.
  6. Create 15 to 20 new memorised reports and save them in the Z Do Not Use group.
    Note: The new reports should occupy the damaged slots in the Memorised Report List. The number of reports required varies by file.
  7. Select the Memorised Report > Re-sort List > OK on the message that follows.
  8. Close and reopen QuickBooks.
  9. Recreate and memorise the reports you need.
Important: If you delete reports that don't open from the Memorised Report List, then undamaged reports will move up into the empty slots and they may become damaged

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us