How do I remove unposted and unwanted transactions from the General Ledger new file using File Tools?
Description
Cause
Resolution

Important Considerations:

Use caution when performing the following actions:

  • Renaming the New.glt while it contains unposted batches
  • Moving batches that don't net to zero by account and date

Performing either of those can make General Ledger not balance with interfacing applications, or can make reconciling between applications difficult. Contact your Sage Business Partner for help with reconciliation issues.

Additional considerations:

  • If the transactions were entered in General Ledger, they can be removed even if they do not net to zero, if you have verified that the batch is not partially posted
  • Make the correcting entries in the application of origin before attempting to move/rename, and confirm the in/out washing entries both exist in the new.glt
  • If the entries cannot post (out of balance batch or dates outside of GL posting dates), and a journal entry has been made, then the batch may be removed, but the interfacing application may appear out of balance

 

To remove General Ledger transactions from the New.glt file:

 

  1. Make a backup of your data:
    1. Always make a backup of your data before starting this process. See How to Back up Company data with System Administrator including SQL Replicator.
  2. Confirm entries to rename:
    1. Have other operators exit all Sage 300 CRE applications.
    2. In General Ledger, from Tasks, select Post Entries.
    3. Click Ranges, select the batches you want to keep. Click OK.
      • Note: You must post all batches you want to keep. Don't select batches you don't want to post. If all batches you see are ones you want to remove, click Cancel twice and skip to step 6.
    4. Click Start to post entries and print your journal.
    5. Review the journal. Verify all entries you want to keep posted successfully.
    6. Review the contents of your new file:
      1. From Reports, select Entries, Entries by Batch.
      2. Select New. Click OK.
      3. Preview the entries in the new file. Confirm you want to remove all of them.
      4. Print the report if desired. Click Close.
  3. Rename the General Ledger New File using File Tools:
    1. From the General Ledger Tools menu, select File Tools. In any estimating application, from File, select File Tools.
    2. Select Rename. Click Next.
    3. Next to the File to rename box, click Browse.
    4. Browse to and select New.glt. Click Open.
    5. In the New file name box, type the new name. For example, if you want to change the name the New.glt file to Old.glt, type Old. The system adds the correct file extension to the name entered.
    6. Click Next to begin the validation process. The following validation occurs:
      • Scan file system to build file list - Uses the selected folders and files to build a list of files to rename.
      • Validate data files - Scans the selected files and folders to verify that the data structure is intact, and all required data components are present.
      • Check for files that might be overwritten - Verifies if any files in the file list already exist.
      • Ensure files are not in use - Verifies if any files in the file list are in use.
      • Verify space is available for the operation - Verifies if enough disk space is available.
      • Note: A green circle indicates the validation completed successfully. A red circle indicates the validation completed with exceptions. Any exceptions appear in the window so that you can fix the issue prior to continuing the process. You can only rename one file at a time, so these validation processes are generally more applicable to other File Tools operations such as backing up data files.
    7. Click Next.
    8. Review the file that you are about to rename. The State column indicates whether you decided to include or skip the file. You can include or skip files:
      • Select a file and click Skip to exclude the file and change the State to Skip.
      • Select a file and click Include to include the file and change the State to Include.
      • Click Include All to include all files and change their State to Include.
      • Click Skip All to skip all files and change their State to Skip.
    9. Click Next.
    10. Verify that the information in the Execution Summary window is correct. If not, click Back to make corrections.
    11. Click Next to rename your files.
    12. Review the Operation Journal window.
    13. If you want to print your journal, select Summary or Detail from the list depending on the details needed. Click Save to save your journal to a text file. Click Print to print your journal to a printer.
    14. Click Finish.

Notes:

  • If you use File Locations (File, Company Settings, File Locations), your New.glt file may have a different name. If you see multiple new files but cannot see the .glt extension, your workstation is set to hide file extensions. Click Cancel. Verify your settings and then repeat steps 6 through 8.
  • Create a blank new.glt by going to Tasks, Record Entries. Say Yes to the pop-up message "The new.glt file does not exist, do you want to create it?". If you don't do this, the next person in a task that will affect the new file will get the pop up.

 

Sage My Assistant can notify you when there are unposted entries in your GL New file. Whether it's scheduled or on-demand, the system can email you when those entries are unposted and give you the details about those entries. Contact our Sales team at 1-800-858-7095 or by email at [email protected] for more information.

Need more help?

Chat now

 

Steps to duplicate
Related Solutions

How do I move unposted and unwanted transactions out of my General Ledger new file using the Move option?
How do I rename a file using File Tools?
I need to post transactions in General Ledger after renaming the New file
Can I still use File Tools to make a backup in 17.1 and later?