Front Line Systems

Sage 300 Support, Sage 300, HighJump Warehouse Edge Consultants

  • Home
  • ERP
    • Sage 300 ERP
    • Sage 300 (Accpac) Cloud ERP
    • Sage 300 Demo
    • Sage 300 Support
    • How Much Does Sage 300 Cost?
    • ERP Resources
      • Change Your Sage 300 Partner
      • Increase Your ROI on Sage 300
      • Get Your Sage 300 Year-End Guide
      • Ultimate Sage 300 Guide For Sage 300 Users
  • WMS
    • HighJump Warehouse Edge
    • Warehouse Efficiency Resources
      • 10 Ways a Warehouse Management System Will Increase Efficiency
      • How Does Warehouse Automation Improve Inventory Management?
      • How to Improve Warehouse Performance?
      • How to Increase Picking Speed In Your Warehouse?
      • Tribal Knowledge and Your Warehouse Efficiency
    • HighJump Data Sheets
  • Add-Ons
    • AP Automation
    • Business Intelligence Software
      • Anvizent Analytics
      • Sage Enterprise Intelligence
      • Solver BI 360
    • Credit Card Processing
    • Manufacturing Software
      • AutoSimply Manufacturing Software
      • MiSys Manufacturing Software
    • Other Add-Ons
      • Sage CRM Software
        • Sage CRM Demo
        • CRM Software Consulting
        • CRM Software: Discover How To Use Outbound Call Lists in Sage CRM
      • Document Management Software
      • EDI Software for Sage 300 ERP (Accpac)
      • Hotel Management Accounting Software
        • Hotel Accounting Software
      • Sage HRMS
      • PrintBoss Software
        • Video: PrintBoss Software for Sage 300
      • Projects for Sage 300
      • Avalara Sales Tax
      • Service and Maintenance for Sage 300 ERP
      • Web Stores for Sage 300 ERP
  • Contact Us
    • Contact Us
    • Sage 300 ERP Consultants (formerly Sage Accpac) | HighJump WMS Consultants
    • Meet the Front Line Systems Team
    • HighJump Warehouse Edge Client Testimonials
    • What Our Sage 300 Customers Are Saying
  • Visit Our Blog

September 25, 2015 by Front Line Systems Leave a Comment

Stop Now! Discover Why Deleting Master Records in Sage 300 Leads to Bad Juju and Pressing Delete Now Will Cost You More Money Later.

First Things First…What is a Sage 300 Master Record?

A master record is the primary record in each Sage 300 module – Vendors for Accounts Payable, Accounts for General Ledger, Customers for Accounts Receivables, Items for Inventory Control, plus anything that is found in the setup folder for the module. So, if you go to Sage 300 Inventory Control and Inventory Control Setup – anything the customer sets up is a master record – Categories, Account sets, Price lists, etc.  (If it is something a user creates and it is not a transaction in Sage 300, then it is probably a master record.)

Why Deleting Master Records in Sage 300 Is a Big No No?

Talk to the hand manLet’s look at an example – When you enter an item in Sage 300 and sell that item – an order, shipment and an invoice are created in Sage 300. The invoice then goes to Accounts Receivable. Now it can be seen in the AR Invoicing Batch, Posting Journals and in the AR Customer Activity.

It then travels to the General Ledger. So, creating one item and performing one transaction against it, generates item history in approximately 20 different tables. If you delete the item master record you’ve now created a data integrity issue in all of those tables!

Oh No! I Deleted a Master Record (e.g. Customer, Vendor, Item etc.). What Now?

If you delete master records that have transactional history, then watch out for bad juju. When Front Line Systems upgrades your database (every two Sage 300 versions, or every 18 to 24 months), the deleted master records may cause the upgrade to fail. To ensure a smooth upgrade our team has to go back and rebuild those missing records (which costs you more money).

When Would It Be Okay to Delete a Record?

Our answer is NEVER. However, there is an exception. If you set up a customer or item incorrectly and don’t have any transactions against the record (haven’t sold anything, shipped or received anything) then you can delete the record without a problem.

What’s the Correct Way to Delete Records?

sage300erpDo not delete records that have transactions against them (including really old customers/items in the system). We realize that trying to search for customers or items when thousands of your clients or items are inactive can be painful. Especially if you’ve had Sage 300 for a long time. However taking shortcuts and just deleting the records is not the answer.

The best practice for deleting records is to mark the record (customer, vendor or item) as inactive on the appropriate screen as soon as you know the record is inactive.

If those inactive records are making it cumbersome to get around, you can have Front Line Systems purge the oldest data out of your system. Any records that are marked inactive during that time period, can be included in the data purge. Call Front Line Systems if you are interested in learning more about cleaning up your database.

For more information on Sage 300, visit us at www.flsinc.net or call Front Line Systems at 866-435-0243. Thank you!

About Front Line Systems

Front Line Systems is an ERP Consulting Firm (specializing in Sage 300) with headquarters in Minneapolis, Minnesota. We are dedicated to helping businesses solve their accounting, manufacturing and warehouse concerns. We believe that your business has an amazing capacity for innovation and growth and that technology can help get you there.

Front Line Systems is a technology partner that solves problems and creates solutions for the life of your business. We provide ERP Consulting, Warehouse Management Consulting, CRM Consulting Services etc. in Minnesota, Wisconsin, Virginia, DC, Maryland, Connecticut (New England) and serve clients across the US. Contact us at 866-435-0243 to get started today.

Filed Under: ERP Software, sage 300, Sage 300 ERP, sage 300 training

Leave a Reply

Your email address will not be published. Required fields are marked *

Quick Contact

Fill out my online form.

Sign Up For Our Sage 300 Tips & Tricks Newsletter

Register Below

* indicates required

Industry Solutions

Manufacturing
Service
Hotel Management
EDI
Document Management Software
Web Stores
The Cloud

Search For:

Read Our Latest Blog Posts

  • Sage 300 version 2022 product update 2 – What’s new?
  • What’s New in Sage 300 version 2022 – Product Update 1

Why Front Line Systems?

We believe that your business has an amazing capacity for innovation and growth and that technology can help get you there. Front Line Systems is a technology partner that believes in solving problems and creating solutions for the life of your business.   Learn More

Quick Links

Sage 300 Success Stories
Sage CRM Software
Hotel Software
Manufacturing Software
Meet the Front Line Systems Team
Warehouse Management Software (WMS)
Privacy Policy
Blog
Sitemap

Partnerships

Korber Partner

Sage Business Partner

Contact Us

Front Line Systems, Inc. is a Sage 300 and HighJump Warehouse Edge (a Körber product) partner. We are headquartered in Minneapolis, MN and have offices in Virginia and Washington DC. We serve clients across the United States. If you need Sage 300 support or would like a new warehouse management system don't hesitate to contact our team today.

Front Line Systems, Inc.
Phone: (866) 435-0243

Copyright © 2023 Front Line Systems, Inc.