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) / Lines Vanishing from T...
Microsoft Dynamics GP (Archived)

Lines Vanishing from Transaction Entry Window

(0) ShareShare
ReportReport
Posted on by Community Member

I have a client that was entering a GL Journal Entry at the Transaction Entry Window. This was a payables entry with one Credit to Payables and several debits to expense accounts. When he went to post, he received an error message saying that his Debits and Credits didn't balance.

He called me and I noticed that the Credit Entry did not appear in the Transaction Entry Window. Oddly, it still showed a Credit Total that was equal to the amount he claimed to have entered. I had him make a line for the credit, but the Credit total doubled when he did so.

I assumed this was user error, deleted the transaction, and had him re-enter the transaction. The second time it went through without error. But he just called me, and it happened again with a Debit (still counting towards totals, still not showing among the other transactions).

Has anyone else seen this before? Any idea if this is somehow user error or if it is a glitch in GP?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Lines Vanishing from Transaction Entry Window

    He is using GP 2010, version 11.00.1799 if that helps.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lines Vanishing from Transaction Entry Window

    Since you had him re-entering the transaction with no errors, I would suspect this is an error that would result from certain user behavior. I have never seen such a case in which Dynamics GP deleting lines without user interference. Therefore, I would suggest you run the following script once this error is reported next time before trying any attempt to solve it from the application layer. Hope this helps !

    - - - -  The script below will provide a detailed and Grand Total view for the selected Journal Entry

    USE #DBName
    SELECT    
            ISNULL(CONVERT(NVARCHAR (32),BACHNUMB),'ALL') AS BachNumber,    
            ISNULL(CONVERT(NVARCHAR (32),JRNENTRY),'ALL') AS JournalEntry,
            ISNULL(CONVERT(NVARCHAR (32),ACTINDX),'ALL') AS Account_Index,    
            ISNULL(CONVERT(NVARCHAR (32),DEBITAMT),'ALL') AS Debit,         
            ISNULL(CONVERT(NVARCHAR (32),CRDTAMNT),'ALL') AS Credit,        
            SUM(DEBITAMT) AS Dr_Total,
            SUM(CRDTAMNT) AS Cr_Total
            FROM GL10001
            WHERE    JRNENTRY = '#JournalEntryNumber'
            GROUP BY BACHNUMB,JRNENTRY,ACTINDX,DEBITAMT,CRDTAMNT WITH ROLLUP
            HAVING            GROUPING(BACHNUMB) = 1   
                          AND GROUPING(ACTINDX)  = 1    
                          AND GROUPING(DEBITAMT) = 1    
                          AND GROUPING(CRDTAMNT) = 1
                    OR
                              GROUPING(BACHNUMB) <> 1   
                          AND GROUPING(ACTINDX)  <> 1    
                          AND GROUPING(DEBITAMT) <> 1    
                          AND GROUPING(CRDTAMNT) <> 1

    Your feedback is highly appreciated in order to dig for further details if required.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Lines Vanishing from Transaction Entry Window

    This SQL script did work but we were never able to find out what the issue was. He had saved the Trx to a batch while waiting for me to find out how to fix it, and it seems saving it to the batch erased the missing lines. It has not happened since then.

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