Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cannot trace Invoice

Posted on by 1,357

With reference to the caption subject line, one invoice which is missed while receiving cash in bank and knocking off from Account Receivable.

We receive error "This document number is used".

Can anyone please guide me how can I find the invoice?

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Cannot trace Invoice

    please take into consideration that certain network corruption might never be solved through a reconcile or check links. You may need to go through a lot of dirty work to handle the associated corruption.

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,357 on at
    RE: Cannot trace Invoice

    Thanks Mr. Saadi,

    Many thanks for the description. I have recommended my users to use wire to be on network. They are laptop users and having bad habit of using WIFI the router often drops the connection and reconnects without even letting us know. I believe GP users should use wired connection to avoid any data loss.

    I will be thankful if any better idea comes that avoid these glitches.

    Regards,

    Fahad

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Cannot trace Invoice

    In many cases, the next invoice number gets reset and then when the system tries to create new invoices, it finds the invoice existing in the RMKey table.  Yes, Checklinks will fix this.  You can also advance the next invoice number  but that can leave gaps.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Cannot trace Invoice

    Dear Mr. Fahad

    In GP, network issues ofter results with damaged data entry to multiple tables as the posting process consider various interconnected tables.

    GP Check Links, might be a solution in certain cases, and might not be on other critical ones.

    Therefore, consider the check links as a preliminary solution as it tries to examine other tables where the same information is supposed to be stored  and re-creates the damaged records. I recommend going for a reconcile as well in order to ensure that no differences remains.

  • Suggested answer
    Fahad Humayun Profile Picture
    Fahad Humayun 1,357 on at
    RE: Cannot trace Invoice

    Hi,

    I was able to resolve this problem by going to maintenance --- check links

    System verified and removed all the glitches that were stuck in between and made it available so it can be applied.

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,357 on at
    RE: Cannot trace Invoice

    Could anyone help me in this please? My Finance had made a billing entry and ran billing batches to generate AR from Project module. After receiving CASH from customer, while we were applying the document into Sales module some sort of network glitch came and we lost the document somewhere in the middle. But during this activity Dynamics GP also generated the document number for this.

    Now my Finance is unable to locate the document so they may complete the cash receipt.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans