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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Can't Void Posted/...
Microsoft Dynamics GP (Archived)

Can't Void Posted/unposted Invoice In SOP

(0) ShareShare
ReportReport
Posted on by Mounir Ahmed 237

When a sales clerk posted an invoice in SOP and it have an error currency exchange rate time, it's stuck and didn't allow anyone to access sop module, so I deleted it from temp tables  SY00800, SY00801, Y00500, TEMPDB..DEX_LOCK. 

Sop Module returned to work fine, but this invoice shown in smart list with posting status column as "Unposted", but when click it get a massage "This document has been posted" in Sales Transaction Entry, also it didn't appear in inquiry by customer or document or posted transaction

check link and sales reconcile didn't work 

Can I delete this Transaction or void?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Can't Void Posted/unposted Invoice In SOP

    Please have a look on the below link.

    dynamicsthoughts.wordpress.com/.../user-idbatch-id-stuck-while-postingreconcilingdeleting-etc-in-dynamics-gp

    Hope this helps!!!

  • Verified answer
    soma Profile Picture
    soma 24,410 on at
    RE: Can't Void Posted/unposted Invoice In SOP

    Also follow the below link to check your data available on all the appropriate tables.

    support.microsoft.com/.../852623

    Hope this helps!!!

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Can't Void Posted/unposted Invoice In SOP

    Mounir, if my guess is right, this invoice is still not posted yet. Run the following query and check the values for columns "BACHNUMB" & "BCHSOURC".

    SELECT BACHNUMB, BCHSOURC FROM SOP10100 WHERE SOPNUMBE = '<enter invoice number here>'

    If BACHNUMB is the user ID who tried posting this invoice and if BCHSOURC is "*Sales Entry", then rest assured that your invoice is intact, but stopped abruptly. If this is what the issue is, then run the below UPDATE query to restore the document back to "unposted" status.

    UPDATE SOP10100 SET BACHNUMB = '<proper batch ID>', BCHSOURC = 'Sales Entry' WHERE SOPNUMBE = '<enter invoice number here>'

    You may also follow the instructions mentioned on the link provided by Soma. But do not run any DELETE queries yet. Above UPDATE may resolve this issue.

    Once you have restored the invoice back, you can then void it or even post it if you still want to.

    IMPORTANT: Take backup before you perform ANY SQL operation.

    Hope this helps.

  • Mounir Ahmed Profile Picture
    Mounir Ahmed 237 on at
    RE: Can't Void Posted/unposted Invoice In SOP

    Thank you Soma and  Vaidy for your attention

  • Suggested answer
    Maria Carrero Profile Picture
    Maria Carrero 150 on at
    RE: Can't Void Posted/unposted Invoice In SOP

    Check if a journal entry is already created for the document in history GL or Work GL module.

    If the journal entry is posted, you can delete the batch.

    If the journal entry is not created. Try print the batch. If you cannot open the batch and recovery neither, you should update this way:

    UPDATE SY00500 SET MKDTOPST = 0, BCHSTTUS = 0

    WHERE BACHNUMB= 'BatchNumberName'  AND BCHSOURC = 'Sales Entry'

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans