Skip to main content

Notifications

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) / Transactions Missing
Microsoft Dynamics GP (Archived)

Transactions Missing

(0) ShareShare
ReportReport
Posted on by Ahmed Abd ELHady 241

Microsoft Dynamics GP 2013 R2 in Bank Reconciliation the Adjusted Book Balance not Equal the Adjusted Bank Balance after tracing from SQL and GUI i find that there is a transaction in Payable May cause this dentifrice so i decided to void the transaction from payable there is no transaction in void open or historical the transaction viewed in Transaction by Document and does't appear in Transaction by vendor i don't know what shall i do this second Transaction do the same thing but in Receivable please help 

*This post is locked for comments

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Transactions Missing

    Hi Ahmed!

    As the document is only appearing in the Transaction by Document number while not showing up in Transaction by Vendor this shows there could be possibly some data damage. The Transaction by Document number pulls from a different table than the Transaction by vendor.

    There could be a chance that it had posted through to bank rec but did not post correctly to Payables management. I would recommend creating a case with Microsoft Dynamics GP Support so we would be able to have a closer look into the issue.

    ~Thomas Newcomb

    ------------------------

    Dynamics GP Support

    ------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Transactions Missing

    In case you are not being able to void the corrupted document, how about recording a reversing entry manually. For instance, if the corrupted document is an invoice, you can simply record a credit memo in order to reduce the balance accordingly. Of course, the document should not post to GL.

  • Ahmed Abd ELHady Profile Picture
    Ahmed Abd ELHady 241 on at
    RE: Transactions Missing

    ok MR\ Mahmoud the Payment not applied to invoice and reconcile to GL is correct the issue that i'm not find the document in void and i make Check link even Recompile with SQL Maintenance so i tried every thing as i know please Help ASAP

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Transactions Missing

    Hello Ahmed

    Initially, I would like to mention an important point as related to the reconciliation task, instead of manually looking through the transactions, you can simply use the reconcile utility provided on (Dynamics GP > Tools > Routines > Financial > Reconcile to GL); the main purpose of this tool is to reconcile the sub ledger against the general ledger and provide a detailed excel report for the matched, unmatched and potential matched transactions.

    Now as you have already identified the problem, you are on the right track. I would suppose that this transaction is fully applied which prevents you from voiding it directly. In case so, check the payment to which it is applied, void the payment in order to release the invoice and then you can have invoice available for voiding. So I suspect that the fully applied point is the root cause which you need to consider.

    More importantly, in case this transaction that you identified is causing the variance, you need to stop the posting to GL when voiding the transaction, because voiding the transaction will create a reversing journal entry on the GL level.

    Please never hesitate to share any further inquiries,

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans