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