Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Delete empty invoice.
Microsoft Dynamics GP (Archived)

Delete empty invoice.

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

...There was some user creating an invoice, and all of a sudden by any particular reason the connection lost itself.

Now I can see the invoice number sequence in GP, but I can not take a view of it in SOP Entry. This one is in consulting option. How can I rid off this ghost invoice? So you might get the idea with this picture I already uploaded!. By the way there is not any details in it.

Thanks guys!.InvocesGP.png

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete empty invoice.

    Hi sir,

    Sorry I'm late, yes in fact I did follow the BABU BASKARAN's tip. But thanks to you I learned something new with your steps.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Delete empty invoice.

    Hi Freddy,

    I wonder if you have solved the issue with the invoice.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete empty invoice.

    Thanks for the fast response, when everyone go home I stay to try both of them, thank you guys.

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Delete empty invoice.

    ‘Check Links’ doesn’t usually solve this kind of problems. The following steps should solve the issue you are having with the corrupted invoice:

    • Run this SQL script:

    UPDATE SOP10100
    SET BCHSOURC ='Sales Entry'
    WHERE SOPNUMBE = 'FAC0000103736' AND SOPTYPE = 3 AND BCHSOURC = ''

    • Now you should be able to bring in that invoice in the 'Sales Transaction Entry' window.
    • Next you have 3 options:
      • Keep the document:
        • Fill in all missing required fields from the Sales Transaction Entry window.
        • Save the document.
      • Delete the document:
        • Fill in all missing required fields from the Sales Transaction Entry window.
        • Save the document.
        • Delete the document.

      • Void the document:
        • This step is optional: fill in all missing required fields from the Sales Transaction Entry window.
        • Void the document.

    I have noticed you are running a Spanish localised version of GP, you might need to update the SQL script with the translation of 'Sales Entry' into Spanish. You can find out which string is used in the column BCHSOURC of the table SOP10100 looking at other SOP documents that are not corrupted.


    Note: It is recommended to do a backup before updating any data using SQL scripts.


    I hope this help

  • Verified answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Delete empty invoice.

    Hi Freddy,

    Have run checklink against SOP, this should fix this kind of issue.

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