Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Missing transaction in GL posted batch

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I have posted the sales transaction entry batch with 6 transaction (invoices) in it. The transactions is perfectly posted till RM but when i check the batch transaction in GL, it shows only five transactions. The last transaction is missing. Please help me on this issue.

Thanks

Nishant  

*This post is locked for comments

  • RE: Missing transaction in GL posted batch

    Ok - so let me make sure I understand the complete picture:

    • A single batch with 6 transactions was posted from Receivables.
    • 5 of the 6 transactions posted successfully to the GL.
    • The 6 transactions show up in Receivables inquiry with an OPEN status
    • 5 of the 6 show up in the GL

    The only logical conclusion was either the transaction was deleted from the GL or an error was incurred during the posting process.   I think it'll be hard to determine "what" exactly happened, so the answer is to just create a JE in the GL for the missing RM transaction.

    You could also run the Reconcile to GL routine (Microsoft Dynamics GP >> Tools >> Routines >> Financial >> Reconcile to GL) and how the subledger ties to the GL.

    --Sean

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing transaction in GL posted batch

    No its the company transaction.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing transaction in GL posted batch

    Is the missing transaction an intercompany transaction?  I do not know about sales transactions but in purchasing transactions an intercompany transaction might look like it is missing from the original company when the intercompany operation creates the due to and due from and sends the purchasing entry to the destination company.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing transaction in GL posted batch

    Hi Sean,

    Thanks for the quick reply.

    The batch is not in the batch recovery window.

    I can see the transaction in inquiry window, yes the transaction show an open status in the RM.

    But the transaction batch which holds all the six transaction is posted in GL.

    Out of 6 transaction 5 transaction are posted perfectly but only one transaction is found missing in the GL.

    One more thing, I found that one journal entry is also missing in GL.

    I doubt might be the missing JE is the one which holds the missing transaction.  

  • RE: Missing transaction in GL posted batch

    Hi Nishant -

    Is their a batch in Batch Recovery with the transaction?   Are you able to see the transaction action in the Customer or document inquiry screen?   Does it show an open or work status?

    --Sean

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans