web
You’re offline. This is a read only version of the page.
close
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) / Rogue GL entries
Microsoft Dynamics GP (Archived)

Rogue GL entries

(0) ShareShare
ReportReport
Posted on by Community Member

Doing some GL cleanup.

I have about 2500 batches with 1 to 2 transactions per batch. Sales deposits. Two line items per transaction. One a credit one a debit. line items nullify each other. I would post them off but one line (Random) is missing the account number...Considered deleting them from my GL1000/10001 and SY00500 tables. 

What do you think the best way to deal with the transactions are? 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Print the GL Edit list for the batches in question, put them in a file folder, and then Void or Delete the batches using the system.  The last option to consider would be to remove the transactions directly from the tables using SQL.  In rare cases SQL is involved in instances like this, we typically use it to fix problems with missing Trx data to enable the batch to be opened, printed and deleted in GP.

    OK, so I reread you post and noticed you're dealing with 2500 batches.  So you'd like to automate this process as best you can.  I would be inclined, even with the high number of batches to recommend using the software and not SQL to delete the batches.  Perhaps you could use a macro to open the batches in the batch window and delete them.  Whatever you do, you are going to want to test the fix in a test company, walk through it and document it thoroughly, prior to executing the fix.

    The most important thing is to get it right.

  • Community Member Profile Picture
    Community Member on at

    Thanks for the response REDBEARD. I have never created a macro within GP. NooB Admin. Can you provide some more information on how to accomplish this? 

    To me it seems easier to remove all the entries in SQL. Is there a protocol that I need to follow, or should I backup, test and push into production?

    Thanks

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    I wrote a blog post today, in your honor, which outlines how to use Macros.  A link to my blog is located in my signature, but I included a link to the specific post here;

    redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html

  • Community Member Profile Picture
    Community Member on at

    Thanks! Reading it now.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I answered my own question. I manually deleted all the entries in the GL1000/10001 and SY00500 tables. I then ran check links.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans