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) / Batch always marked, e...
Microsoft Dynamics GP (Archived)

Batch always marked, even after clear Activity files

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

One of the GP users experiencing payable batch posting causing GP hang at almost end of the process. and then the Batch status becoming "Marked". Even after I have deleted Activity, SY00800,SY00801, DEX_LOCK, DEX_Session, and then I reset the MKDTOPST=0, BCHSTTUS=0  and then she post the same batch, and then GP hang again and resulting batch status become "Marked" again. This issue keep repeating even also happen for her other batch ID.

Does anybody experiencing this batch issue repeating change to Marked status?

BTW, the GP user access GP is via Terminal server, but this issue does not happen to any other users who are also accessing GP via Terminal server.

My suspect could be her default printer issue or her Windows Profile ? Please advice. Many thanks in advance.

[ Dynamics GP 10.0 SP3, SQL Server 2000 SP3, Windows Server 2003 standard Terminal Server ]

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    Can you have another user try to post the batch in question?  That would eliminate the batch itself as the issue.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    You said this user is working Terminal Server.  Are they in the building connecting over the firm's network or are they outside using the public Internet?  Could there be a time out issue?  (talk to a system tech that knows the firm's network).

  • William Kow Profile Picture
    William Kow 3,795 on at

    Understand that the GP access using the terminal server way is mainly for the unstable network to SQL or GP server.

    BTW, after the clear all those Activity and then generate Edit List the batch ID, and the result show error message :

    Error: Can't post a document that uses a duplicate vendor document number.

    Upon checking SQL for this Receiving Batch (POP10300 & POP30300), weird the same set of data do appear in WORK and HISTORY tables. See  POP10300 Screenshot   and the   POP30300 screenshot.

    Then I try to search for this Receivings transactions in Smartlist, but when I double click the record, it prompt warning message :   This document has been posted.

    So, I follow the KB Article ID 857082 to see if it can help, but there is no record in SY00800.

    Please advise. Many Thanks in advance.

     

     

  • Community Member Profile Picture
    Community Member on at

    Hi William (got it right this time!).  Are you saying that the exact same document exists in both work and history? If so, you have a data corruption problem. I would start by deleting the work transaction. Then run a check links on the Payables Transaction Tables and see what it throws up, if anything.

    Then satisfy yourself that the vendors account is correct, correct documents, correct balance etc. If it is, then all is fine. Looks like the posting was interrupted and the document was not cleared from the Work tables after posting.

  • William Kow Profile Picture
    William Kow 3,795 on at

    I believe that is an exact match for those duplicated documents exists in both work and history, and we have request the GP user to validate.

    Kindly advise me if is really the exact match, what are the other table that I also need to delete the duplication besides the POP10300 ?

    Many thanks.

  • Community Member Profile Picture
    Community Member on at

    Hi William,

    Can you delete the document through the GP interface (the transaction entry window)? This would be preferred, as the standard GP triggers will fire. If it won't let you delete from the transaction entry window, let me know.

    Best regards,

  • William Kow Profile Picture
    William Kow 3,795 on at
    I don't even able to find this transaction (Shipment+Invoice) in the entry window, but I can find it is Smartlist but when i double click the transaction, it immediately prompt "This document has been posted." and it show blank transaction in the Receiving Entry window. Thus, I just cannot delete duplication transactions in GP interface or any entry screen. Please advise, thank you.
  • Community Member Profile Picture
    Community Member on at

    Hi William,

    The other table you will be interested in are POP10310 (Purchase Receipt Line). I you need to delete the transaction from the POP10300 and POP10310 tables, then a checklinks afterwards will probably remove any other references from other tables.

    Query both these tables first, filtered on the receipt number, and see what is thrown up.

    Before you do any deleting back up your dynamics and companies databases.

    Best regards,

  • Community Member Profile Picture
    Community Member on at

    it might been better if someone could post a resolution to this.

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    Hi,

    I recommend first that you free up the batch by resetting the MKDTOPST=0, BCHSTTUS=0.

    Once done, print an Edit List of the batch.

    From the looks of it, you are trying to post a batch where transactions have issues.  Clearing activity and temp tables do not resolve this.  You need to determine what is causing the batch to fail.

    If the Edit List does not give you any errors, try creating a new batch and then transfer all transactions from the batch in question onto the new batch - then try posting again.

    Let me know if you have further questions.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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