Clearing Rejected Entries on GL Post Entries Report

I am the new CFO with my company and new to Sage 300 CRE.  I am working on cleaning up a few things and I came across an area where I need some help.

On the GL Post Entries Report there are four separate entries that were made in the Billing module that were rejected by the General Ledger module for various reasons.  These all occurred in previous periods that have since been closed.  I have researched each of these items and found that separate adjustments were made to the General Ledger module to account for all four.  My problem is that the General Ledger Post Entries Report still includes these rejected items. 

How can I remove these rejected entries from the General Ledger Post Entries Report so that I don't have to see them everytime I post entries?  I know they have been resolved and just need them removed from the report.

Thanks,

Parents
  • 0

    I have the same issue, Bryan.  There are literally 7 pages of Rejected GL Entries from closed periods (starting as far back as the year 2000 and ending in 2013).  If I look under GL, change entries,  "new" file button as suggested by Barb, there are no "unposted entries to report".  Because of this, I am skeptical to rename the "NEW.glt" file as suggested by LWhitten.  I am interested in a resolve for this, if there is one. Thank  you!

Reply
  • 0

    I have the same issue, Bryan.  There are literally 7 pages of Rejected GL Entries from closed periods (starting as far back as the year 2000 and ending in 2013).  If I look under GL, change entries,  "new" file button as suggested by Barb, there are no "unposted entries to report".  Because of this, I am skeptical to rename the "NEW.glt" file as suggested by LWhitten.  I am interested in a resolve for this, if there is one. Thank  you!

Children
  • 0 in reply to Mzplumber

    Hi Mz,

    Sage does not recommend using Change Entries as this is permanent and irreversible. To remove entries from the GL new file you can follow the steps in one of the two articles below.

    In order to keep interfacing application in balance with GL, you would want to make sure any entries that came from other applications were corrected in those applications.

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=17875

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=17877

  • 0 in reply to Jesse Gordon

    What would be the problem with "Change Entries" > New File > Deleting the entries that I want removed from the GL that have not posted?  Will this affect the invoices created in Billing that were rejected in GL?

  • 0 in reply to Bryan Wates

    Hi Bryan,

    It depends on why the entries are in GL and why they aren't posting.

    Take a situation where and invoice is entered in billing with a 2013 accounting date by mistake when it should have been entered with a 2019 date.

    AR, JC and CN have no prior period posting restrictions, so the invoice posts to those applications and updates the receivables and revenue for the customer in AR, the job in JC, and the contract in CN (if applicable). 

    However, the totals in GL are NOT updated because the entries reject. New GL is out of balance with AR and JC. 

    The recommended fix for this is to void the invoice using the wrong (2013) date and re-issue it in billing using a 2019 date.

    This will leave you with 2 sets of entries in GL unposted with a 2013 date. The net total for all of the entries in each account would be 0.

    The problem with change entries is when someone makes a mistake when using it. If the entries are deleted from the new file using Change Entries, you can't get them back (unless you restore a backup, not usually a quick or easy thing). If you Move the entries or rename the file that contains them, you can easily get them back should you need to. Those options are both faster and safer in the case that the entries do need to be review at some point in the future.