Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Missing Receipt on his...
Microsoft Dynamics GP (Archived)

Missing Receipt on history tables

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

One of the accountants recently came to me (IT Dept) asking for help because of a missing receipt. She is trying to tag the receipt numbers to a project tracking component called Encore. I started digging into it and found the receipt number in POP10500 and POP10600. When I searched on the history tables POP30300, POP30310 & POP30390, I could not find any records of this receipt. I do not know if for some reason they got deleted. I would appreciate some input or if someone has a solution.

Thank you.

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Missing Receipt on history tables

    Yes, it sounds like the record is corrupted beyond repair within the UI.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Receipt on history tables

    I just finished running check links and recon. Only one of two receipts showed up on the check links report as re-created. When I looked for the  "re-created", I only found it on POP10500, POP10600 and POP10300, no receipt lines table nor history tables. Manually creating the receipts seems like my last resort.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Missing Receipt on history tables

    Hello Diego Franco 

    I have seen such cases mostly related to posting corruption, the prerequisite to get things settled; as Mr. Frank has mentioned, is to start with the check links and reconciliation as well.

    If things didn't go well, you will have to evaluate the degree to which the records are corrupted and handle things manually. The following script may give you a wider picture of the specific PO and associated receiving details Purchase Order Receiving and Invoices Details – SQL Script

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Receipt on history tables

    I am actually running check links right now.. I'll keep you posted on the results

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Missing Receipt on history tables

    Have you tried running check links on the POP transaction tables?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Receipt on history tables

    I had checked those two tables before and nothing... sorry I guess I missed that piece of information, but no, it is not there.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Missing Receipt on history tables

    Is the receipt still sitting in POP10300 and/or POP10310?  It's possible it didn't move to history as it should have.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans