Browse By Tags

  • Crew Rate Tables

    I am building new crew rate tables and desire to create individual adders to each labor rate, currently I have 20 plus added columns that are driven from the base rate. I am curious is there any way to download these columns of cost into the job cost…
  • Report All Job Cost Codes with description Sage18.11 to excel

    We recently upgraded from Pervasive to Sage 18.11. I am trying to update and also do some improvements in our existing database(Job Cost Codes or Job Phase,NOT PRICE CODE!). There are no way to make a report for all Job Codes plus Descriptions into…
  • Creating a new company from some of the historical data.

    I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail…
  • How can I store MAS authentication in an Excel ODBC link?

    I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…
  • Exporting from Sage 500

    FormerMember
    FormerMember
    We stopped using Sage as our ERP system 2 years ago. We still access the system for old orders, accounting information, etc... We are still paying to have this system up and running, supported, backed up etc... Is there a way to back up the entire Sage…
  • Exporting and Importing a Complete Item Record

    Background I wanted to export the ENTIRE record-set of items and wanted to import the same into a new Sage 50 company. This is not as easy as it should be and Sage doesn’t provide any support beyond a few articles that provide little more than the order…
  • upgrading SQL databases from prior SQL versions

    Aloha fellow Sage City dwellers. I've had trouble upgrading SQL databases after installing new SQL Instance for latest versions. No problem using Mgmt Console Tools to restore the backups, but Estimating locks up after failing to upgrade. Has anyone…
  • Items Report HELP

    I just want to know, how can I view summary of Items sold during a period. I have a Store and need to review in detail the item sold at the end of each month. And right now we are currently entering invoice by invoice to see what items were sold. Can…
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • Data Conversion 2013 Version to 2017 Version

    Data Conversion: Purchased Sage 50 (2017). Previously used 2013 version on another computer. Have copied the files to new computer (the system with the new 2017). Won't recognize files without 2013 installed on new system? Is 2013 version still available…
  • Combining Multiple Companies Into One Company

    We have 5 companies and want to combine them into one company. We want to do this ourselves rather than pay someone to do it. Does anyone have a "guide" for doing this? I need to know what all tables to use to get the various history files, etc., for…
  • Build / Rebuild Test Environment for Payroll Changes

    Are there any special procedures I should follow if I want to copy Sage 50 Quantum 2015 Payroll configurations and Employee Payroll setup from our Production company to a Test / Sandbox version of that Production company? We are making initial Payroll…
  • Sage 50 2014

    I just upgraded to the Sage 50 2014 last year. Can I continue to use this software and just upgrade the Payroll Service and Customer Support plan this year?
  • Can anyone get report 5-1-10-21 to print to excel from Sage 100 contractor version 19.2?

    We were running 18.3 and were able to print report 5-1-10-21 to excel, format each page to envelope and print them directly rather than print to labels, then affix them to envelopes, so we were more efficient using version 18.3. We just upgraded to…