Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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.

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Lines Vanishing from Transaction Entry Window

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans