web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

...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

I have the same question (0)
  • Verified answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Freddy,

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

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    ‘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

  • Community Member Profile Picture
    Community Member on at

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

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at

    Hi Freddy,

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

    Thanks

  • Community Member Profile Picture
    Community Member on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans