Forum Discussion

nduro's avatar
nduro
Experienced User
4 years ago

Invoice Number search through 'Find Transactions' not finding the correct record

When we sometimes try to search a Invoice Number through "Find Transactions" it is not finding the correct record even though it exists and it automatically diverts to some old invoice number.

 

eg. We searched for 276411 which is in the system as a Quote, but Find Transactions will not find it?

 

Any ideas?

 

Thanks Nathan

  • Yanike_S's avatar
    Yanike_S
    4 years ago

    Hi nduro 

     

    Currently, as no accounts are being affected by a quote, the transaction will not appear in the Find Transaction>>Invoice list. 

    A workaround would be to go Sales>>Sales Register>>Select the Quote tab and select a transaction in the list. You would then select the CTRL + SHIFT + F keys this will bring up the advance search option. If you type in the search box, the program would search that table for any records relating to that field. So if you enter in the quote number this will bring up the relevant quote which can be clicked on to open.

  • Yanike_S's avatar
    Yanike_S
    MYOB Staff
    4 years ago

    Hi nduro 

     

    Thanks for your post.

     

    Have you tried clearing the AccountRight cache?

     

    Deleting Cache files

    1. To open the Run Box use the Shortcut Keys, Windows Key + R.
    2. In the Run Box type with no spaces %localappdata%/myob


    3. This brings up File Explorer, double click the folder AccountRight.

    4. Double Click the folder that matches the AccountRight version Since 2021.1 the latest release installed will use the Current folder.

    5. Double click into the Cache folder


    6. In this folder are the cache files, you can delete (or rename to old.name.cache)

    The Cache Files are named similar to:

    companyFileCache_localhost16977MyCDFFileNameHere.cache

    Please Note: This will not lose any data

    If this doesn't solve it, could you please give me some more information. Does it happen to all invoice numbers? How are they dated? Could you give me a screenshot of the Find Transactions screen, showing the searched number and old number it diverts to?

    • nduro's avatar
      nduro
      Experienced User
      4 years ago

      Hi Yanike_S 

       

      Thanks for that. I tried clearing the Cache on all local desktops but didnt help.

       

      I have narrow the situation down to only when trying to search for a number that is a QUOTE. It will not find it.

       

      Maybe "Find Transactions" search cannot find quote numbers? Its odd if that is the case and how else would you search for a quote number to find it.

       

      Screen shot attached showing example.

       

      If I try to search for Quote Number 00276416 (Dated 1/7/2021), Find Transctions cannot find it and reverts automatically to an old 2016 invoice number 00193277.

       

      • Yanike_S's avatar
        Yanike_S
        MYOB Staff
        4 years ago

        Hi nduro 

         

        Currently, as no accounts are being affected by a quote, the transaction will not appear in the Find Transaction>>Invoice list. 

        A workaround would be to go Sales>>Sales Register>>Select the Quote tab and select a transaction in the list. You would then select the CTRL + SHIFT + F keys this will bring up the advance search option. If you type in the search box, the program would search that table for any records relating to that field. So if you enter in the quote number this will bring up the relevant quote which can be clicked on to open.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.