Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 300 Newsletter – February 2018 » Sage 300 Tip: Bank Services Clear History

Sage 300 Newsletter – February 2018

Keeping You Up-To-Date With Information About Sage 300

Sage 300 Tip: Bank Services Clear History

By: Shirley Crocker, Senior Business Analyst

As Sage 300 consultants, we encounter many questions with regard to Bank Services and the bank reconciliations. One issue is speed. If you have been using Sage 300 for a long time and/or have a lot of transactions that affect the bank, you may have noticed a significant delay when selecting the Reconciliation tab when using the Reconcile Statements function.

Prior to the release of version 2014, Sage 300 did not keep transaction history for bank services.  PIn versions 2014, 2016, 2017 and 2018, there is an option to clean out history.  We have had customers that have used the process outlined below and experienced significant speedups.  One customer went from a response time of taking almost 2 minutes any time a transaction was selected to 5 seconds!  Using the Bank Clear History function removes the following records from Bank Services:

  • Bank transactions. These are transactions created for your general ledger when you post bank reconciliations.

You specify the posting date through which to clear transactions. The program does not clear bank transactions posted after that date.

  • Bank entries. These are transactions recorded on the Bank Entry screen.
  • Printed posting journals. You clear reconciliation, transfer, and bank entry posting journals separately.

The program clears bank entries taking into account the minimum time you must keep them for each bank, which is specified for the bank record in the Days Before Eligible for Clearing field (on the Profile tab of the Banks screen).

The steps to clear out history are located below.  We strongly suggest that you contact your Sage 300 consultant to discuss the pros and cons of clearing history before taking these steps.  Additionally, please be sure to back up.  Once you clear history, it is gone it cannot be restored or recovered.   You would only need to perform the steps below if you are have performance issues in bank services only.

The process to clear history are as follows:

  1. Backup Sage 300
  2. Select Common Services, Bank Services, Bank Periodic Processing, Clear History

  1. Select Bank Transactions. Using the finder, select the bank code you wish to clean up in both the From and To fields.  Also, specify the posting date through which to clear transactions. The program does not clear bank transactions posted after that date.
  2. Select Bank Entries (transactions recorded on the Bank Entry screen). The program clears bank entries taking into account the minimum time you must keep them for each bank, which is specified for the bank record in the Days Before Eligible for Clearing field (on the Profile tab of the Banks screen).

-when this option is selected a warning pops up

-select Close

  1. Using the Finder, select the first and last entry sequence number you wish to clear

– using the Finder should reflect the dates of the entries for reference

  1. Select Printed Bank Entries Posting Journals. A warning per the screen below pops up
  2. Click Close on the Warning
  3. Use the finder to select the Posting Sequence numbers to use for both the From and To fields. Note that the process will only clear Printed Posting Journals.
  4. Select Printed Reconciliation Posting Journals. Use the finder to select the Posting Sequence numbers to use for both the From and To fields.  Note that the process will only clear Printed Posting Journals.

 

Please note that you can specify a range of bank transactions, bank entries, or posting journals to clear, or you can clear all records of a selected type.

Once you clear bank transactions and bank entries, you can no longer drill down to them from the General Ledger. However, if you do not clear these records periodically, the tables that accumulate them can become very large, potentially slowing your system to a noticeable degree.

As always, please reach out to a Net at Work Sage 300 consultant should you have any questions or would like assistance using this process.

« Return to Newsletter

In This Issue
  • From the Desk of the Sage 300 Practice Director
  • Captain Your Business with Sage 300 Business Intelligence
  • Sage 300 Subscription License Incentives
  • Solving Your Business Gaps: A Preview of Our 2018 Sage 300 Webinar Series
  • Sage 300 Tax Updates – Government Compliance
  • Sage 300 Tip: Bank Services Clear History
  • Automate with SYSTRONICS Revenue and Expense Deferrals™
  • Sage 300 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Sage 300 Webinar Series

    Tips for Sage Users to Improve Data-Driven Decision-Making
    March 28 | 2pm ET
    Register Here

    Recruiting & Quiet Hiring: What Quiet Quitting / Hiring Means for 2023 & How Technology Can Help
    March 28 | 2pm ET
    Register Here

    Sage-Integrated Document Management: From Chaos to Control
    April 7 | 2pm ET
    Register Here

    Sage Intacct Overview Demo
    April 7 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Sage Cloud Hosting: Moving On-Premise Sage 300 to the Cloud

    Building a Next Generation Finance Organization with Next Gen ERP Tools

    Reducing Manual Tasks in Your Sage Accounting & Shipping Processes

    Bridge Your Sage 300 Gaps

    Sage 300 Webinar Archive

    View our library of on-demand recorded webinars.

    Newsletter Archive

    Read our previous Sage 300 Newsletters here

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin