• Invoices deleted

    By mistake I delete the complete batch of the invoices and I would like to know how to restore them can you help me??
  • 2023 SQL Premium configuration & backups

    Hello friends, We have begun working with our awesome consultant on our Sage 2023 Premium upgrade from an older Providex version of MAS. It's very exciting! We are at the point now where we need to get backups running for our new accounting system…
  • hosting platform? Backup is made to third-party solution ?

    Is user data backed up, and if so, is it backed up to a third-party solution? what about Hosting Platform, Can you provide detailed information about this ?
  • Save Time and Avoid Loss: Essential Data Backup Tips

    Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…
  • Test Company Update

    We are utilizing a test company which is a copy of our live file for verifying effects of journal entries and other transactions. Is it possible to update a previously created test company copy with up-to-date information from the live file? Or would…
  • Error Number 0x80040e14 Description ALTER DATABASE failed because a lock could not be placed on database

    This is a Go-Live upgrade, so obviously the test upgrade, and a subsequent "refresh migration" were able to go through. However, now that we are trying the final migration, with just the MAS_XXX company data (no system files) we are getting this - over…
  • Restore a company from third party backup system

    Hello, Can I restore one Sage company from a third party backup system such as Veritas Backup Exec... say I just need company ABC are there folders on Sage server I can just grab to bring it back to life...or do I need restore the whole server. …
  • Company Backups

    I think I know the answer to this but want to confirm.. If we run a backup/copy of a company before closing all modules expect G/L then couple days later run another backup/copy of same company just for G/L module with the same backup/copy company name…
  • Sage 100c Premium (SQL) Disaster Reocvery

    I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…
  • How do I create a backup company before year end processing?

    How do I create a backup company before year end processing?
  • Is there a way of getting an archive to load?

    Hi, I am pretty new to Sage 100 and I am still getting up to speed. We had a server crash at the office. I was able to reload Sage 100 and restore from backup. My problem now is getting into the archives for previous years that I do not have backups…
  • SQL mdf / ldf locations wrong after migration (v2020)

    I did a test migration last night (v2017 Premium to v2020 Premium, same server, both SQL instances are local), with the new instance's default data directory changed to the E-drive. When I installed v2020, the MAS_ABX and MAS_SYSTEM files were properly…
  • How can I archive payroll data?

    I'm very new to Sage and am slowly moving into an administrator role. I'm trying to find a way to archive payroll data so that I can remove the payroll module, as my company no longer uses Sage for payroll at all. I've searched online but I guess I'm…
  • Purge Data - SO_LastPurchaseHistory & SO_ARInvoiceHistoryLink

    I am starting the process of purging data from our company. This is the guide that I'm following: www.connerash.com/.../Sage100History-HowToPurge.pdf One thing I have noticed after purging records from AR, IM, and SO, is that there are tables that are…
  • Cannot Restore From Back Up

    Good evening, I'm having a bit of trouble restoring a file from back up. My client emailed me a CAB file and it's giving me this error: "This data has been updated to a new file format and is not compatible with this version of the software." Is…
  • Merged by mistake

    I accidentally merged two AR customers. Is there a way to fix that? If I created a second company code and entered all the information, how would I get the relevant invoices over to the new company code that they belong to? Hope you can help. Thanks…
  • How to Replace the "Production" Company from a Backup Company Made Using the Company Maintenance Function

    I created a copy of our production company (DUS) into another company called (BKP). Now, I want to copy the BKP company data back to the DUS company data, effectively restoring from the backup I made. When attempting to go into Company Maintenance and…
  • Re-opening a closed fiscal year

    I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.
  • Cannot copy Version 2019 data to another system?

    We do most of our custom development work for clients on our own system. (Build and test VI jobs, create and modify Crystal Reports develop custom forms, data troubleshooting, etc.) For the past 20+ years we simply copy the client data folder (MAS_xxx…
  • Purge Utility vs SQL Deletion: AR History

    Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…
  • Reverse Item Merge

    Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
  • Nightly backup failing

    FormerMember
    FormerMember
    The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.
  • Paperless Office Files and restoring to another server

    We are using Sage 100 Advanced V 5.20 OS Windows Server 2012 R2 We have a backup server where we have Sage 100 installed in case of disaster recovery. We copy the data files over daily. When I first migrated the data over all the Paperless Office…
  • Delete Sales Order detail

    Hi, I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object. Please anyone give hint to solve this issue. Given below is my code int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…
  • Sage 100 ERP advanced Experence with VM's on a large Arrays systems.

    I have a client that leases VM's on a Network Operation Center. That NOC has high end hardware such as HPE 3PAR from HP large storage array for storing the VHD's. The NOC guys tell me the hardware array itself does bit level snap shots hourly which…