Available Database Administration for Sage 100 Contractor

As a small business owner, you know that keeping your records up-to-date and organized is key to running your business efficiently. Sage 100 Contractor makes it easy for you to get the information you need to manage your contracts and track the progress of your projects. But what if you need to access that information from outside of your office? In this blog post, we’ll explore how you can use available database administration options to access Sage 100 Contractor from anywhere in the world.

Find-: Year End Discrepancy in T4 Summary and Remittance Report

What is the Sage 100 Contractor?

The Sage 100 contractor has access to the same comprehensive administrative tools as the Sage 50 contractor, but with a few enhancements. These tools are designed for contractors who need to manage and maintain their own databases.

The main enhancement is that the contractor has access to the Sage Contractor Administration (SCA) application. SCA is a web-based application that provides contractors with a wide range of administrative functions, including:

-Managing contracts

-Maintaining customer data

-Managing subcontractors

-Managing invoicing and billing processes

-Creating and managing reports

What are the Available Database Administration Functions?

The Sage Contractor database administration functions provide you with the tools necessary to manage your Sage Contractor database. This section provides an overview of each of these functions, as well as how to use them.

Database Administration Functions

There are six available database administration functions in Sage Contractor:

-Create a New Database: This function allows you to create a new Sage Contractor database.

-Configure an Existing Database: This function allows you to configure an existing Sage Contractor database.

-Manage Tables and Fields: This function allows you to manage tables and fields in a database.

-Execute SQL Statements: This function allows you to execute SQL statements in a database.

- Export Data: This function allows you to export data from a database.

How to Activate the Functions on a Sage 100 Contractor?

To activate the functions on a Sage 100 Contractor, follow these steps: 1. Log in to your contractor account.

2. Click Accounts and then Contracts.

3. Click the contract for which you want to enable the functions.

4. On the Functions tab, select Enable Functions.

5. Select the applicable options, and click Enable to activate them.

Find more-: Sage 100 Bank Reconciliation Problems

How to Configure the Functions on a Sage 100 Contractor?

When you are working with Sage Contractor, the ability to use the database administration tools is a huge advantage. This article will show you how to configure the functions on a Sage 100 contractor.

Sage Contractor is a module of Sage 100 which allows for contracting out services and products that are typically done by in-house staff. One of the benefits of using Sage Contractor is that it makes it easy to manage your own contracts and subcontractors. The contract management features in Sage Contractor make keeping track of who has completed what work incredibly easy.

One of the first things you'll want to do when configuring Sage Contractor is decide which database you'd like to use. There are two options: You can use either the internal customer database or an external system such as Oracle or Microsoft SQL Server. If you're using an external system, you'll need to create a connection to it and configure it in the contractor settings area of your account.

Once you've decided on your database, you'll need to decide on your contract types. There are three main contract types in Sage Contractor: Fixed Price, Time and Material Contracts, and Service Level Agreements. Each type has its own set of configuration options which we'll go over later in this article. Once you've decided on your contract types, you'll need to create some contracts instances and assign them to users. You can assign users directly from within the contractor settings area or through sage 100

Conclusion

As a business owner, it is important to be able to efficiently manage your data. One way to do this is through the use of databases. There are many different types of databases available, and the right one for your business depends on a variety of factors. If you're looking to find out more about available database administration for Sage 100 contractor, we recommend checking out our blog post. In it, we will discuss everything you need to know in order to choose the best database for your needs.

Find also-: Sage is not calculating the Income Tax deduction