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) / Found the missing GL b...
Microsoft Dynamics GP (Archived)

Found the missing GL batch but can't be saved with its original Batch ID

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

SUMMARY : Managed to find the "missing" GL trx which is not yet post but its batch ID not listed in GL Batch, already run Checklink for Financial for all tables, but still can no be solved.

From Smartlist Account Transactions, I found a GL transaction(trx), double click to open found it status is still unposted GL trx, and this trx is from the posted SOP transaction, it has a GL Batch ID SLSTE00000344 but when I save it, prompted error :

Unable to save the transaction. The batch has been deleted.

But I managed to save it with different GL Batch ID SLSTE00000344X Both batch ID SLSTE00000344 & SLSTE00000344X are appear in Master Posting. But the SLSTE00000344 is with status "Busy" and this ID is not appear in GL batch - this batch ID is missing also.

So I tried to create this missing Batch ID SLSTE00000344 in GL Batch, it prompted :

This Batch ID already exists.

By the way, I have already run Checklink for financial all tables, and clear the Activity, SY00800,SY00801, DEX_LOCK, DEX_Session but not recover this trx.

Please help, how can I enable this GL batch saved with its original batch ID and to post it.

Many thanks in advance.

*This post is locked for comments

I have the same question (0)
  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Found the missing GL batch but can't be saved with its original Batch ID

    Please ignore my last post, because I managed to recover the missing GL transaction. There is :

    Re-run the clear  Activity, SY00800,SY00801, DEX_LOCK, DEX_Session tables after all GP users logout.

    Then Either to use Smartlist to locate the missing GL transaction or Navigate the Financial >Transaction Entry screen to find the missing GL transactions. And then one-by-one I save each of them to a new Batch ID and save them.

    Repeat again to retrieve those transactions, and save it back to it original Batch ID.

    Too bad, those original Batch ID is still not appear in GL Batch, but it appears in the Master Posting, and I post them in that Window. 

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

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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