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) / 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

I have the same question (0)
  • 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,

  • 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

  • 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.

  • 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

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