Our Sage 300 CRE certified consultants and systems/programming engineers are available to assist in the following disciplines:
Accounting
Companies in the building industry succeed in carrying out projects on time and on budget. Accounting is the backbone of which Dataworks can supports your growth.
Our collective experience in augmenting your staff with a skill set in essential areas as:
- Month end closing procedures and reconciliation.
- Certified Payroll
- Insurance compliance
- Lien processing
- WIP Reporting
- Financial Reporting
Training/Utilization Services: 80/20 Rule
Do you believe that 80 percent of the users use 20% of the software or that 80% of your companies application software needs is satisfied 20 % of the software.
Our position is a bit of both. Coupled with the ‘human element’, companies tend to stick with what they know and develop elaborate work arounds to get what they need.
At Dataworks we can assist in evaluating your current business process and utilization to determine how best to maximize your use of the software.
Policies and Procedures Review/Check-up
By having someone from the outside looking in can yield valuable insight into how both your accounting and operations are working.
We can perform a survey of selected processes and identify and recommend areas of improvement and best practices. In some cases it could be as simple as to document the existing workflow procedures.
Report Writing
Getting data/information out of your system is where the value of your system comes into play. We have various methods tools that can help you achieve this.
Out of box applications: Financial Designer, Inquiry/Report Designer
Third Party applications: Crystal, Microsoft SQL Server Report Services (SSRS)
Excel – Event 1 Excel based reporting
www.event1software.com
One key getting this information is to have it in the system, back to the 80-20 rule. The rule of thumb is that if the data is in the system you can report on.
What we need to be sure of is that what is in the system is good data. Hence the term GIGO.
Wikipedia Article
Data Extraction/ Warehousing
Dataworks will help define and create a Data Warehouse or work with an existing ware house consisting of a consolidated depository of relational data sourced from various applications.
Some of the benefits will allow us to present the information through consistent views/queries. This will support the decision making process through a centralized data model.
Mobile Workflow and Automation Solutions
There are some Sage 300 CRE users who want to maintain their company data locally and want to cost effectively deploy secure mobile workflow solutions within their local Sage server environment.
For these folks they were able to evolve and enhance Sage 300 CRE cost effectively and securely extend its data to your customers, vendors and employees via the web.
Ei Dynamics -
www.eidynamics.com
Extract Transform Load (ETL)
ETL bridge the gap between the core ERP and outside ancillary applications. These applications can move data either direction.
Recent Examples:
Direct Supply DSSIàAccounts Payable Invoice
This feed/Extract aggregates invoices received from the Provider’s electronic commerce Suppliers and automatically integrates into the Provider’s accounts payable system. Each product is assigned a GL code at the time of purchase so it will be properly assigned within the accounting system.
The ETL application takes the Extract, formats (Transforms) and imports (Loads) the AP invoice.
InTempo Accounts Receivable Invoice
Construction Equipment Rental System. Rental contracts can be customized for each customer, with periodic invoicing for long term rentals.
Payroll Employee 401K data extractà (Integrated Benefit files)
that conforms to Bank of America Merrill Lynch specifications.
Private Cloud Applications
Daily Project/Job production quantities and labor inputs. Provide Management with Job level and drill down budget verse actual information.
Labor hours are gathered and ultimately imported into Sage 300. The unimported time is reported as ‘virtual’ time while production quantities are entered at a task/activity level defined at each Job/cost code.
Client Server Applications
Insurance tracking and compliance reporting for property management companies.
Allows for the entry and maintenance of both tenant and vendor certificate information.
Record both the qualitative and quantitative insurance requirements of the company and the insurance certificates provided by the tenant or vendor. The statistical summary report will indicate, on a single page, how many leases are in compliance, out of compliance, or are completely lacking insurance.
Additional reports provide lease level detail to support the statistical summary.
IT/Server Site Survey Services
Dataworks has aligned itself with an established group of specialist that are focused on servicing Sage 300 clients.
If your business is considering a Sage 300 Construction and Real Estate implementation, or your existing Sage installation is not configured as desired, be sure to have Computer Specialists, Inc. complete a Site Assessment.
With excellent service and fast response times, CSI will be your company’s number one defense for information technology concerns. Let us take a look ‘under the hood’ to let you know the real status of your Network; a site survey conducted by CSI will provide the detailed information your organization needs to make a sound business decision regarding your computer network requirements.
CSI's Site Survey includes:
- Inventory all existing personal computers and file servers to include:
- CPU speed
- Amount of RAM
- Hard drive (total space & space remaining)
- Operating system version
- Inspect existing cabling for Gigabit rating.
- Is the cabling system labeled and is there a floor plan presentation?
- Test all network cabling.
- Printer inventory and current network printer configurations.
- Inspection of tape drive, tape media and backup methods currently in place.
- Inventory power protection devices and identify any additional requirements.
- Environmental concerns like ventilation, heat and location of equipment.
- Identify potential security concerns, both internal and external.
- Test Internet Line Speed
If you are interested in learning more about this service, please click here to fill out our IT request form and we will contact you.
Testimonials
"All of the custom applications you developed have saved us an unbelievable amount of time."
-Lance C.
"The custom applications which you have developed for us, allowed us to seamlessly integrate our process mapping and systems improvements programs in a timely and effective manner-Thanks"
-Jon B.
"The custom applications which were developed bridged the gap between our system's native abilities and our needs as an organization. This in turn has ensured timely and effective completion of our vital processes. "
-Greg G.
"The product you provided when you developed our Requisition and Purchasing system has exceeded our expectations."
-George W.
"To do the work of the custom applications you developed would take two full time equivalent employees."
-Robert P.
"I will explain what we need from a custom application and out comes something extraordinary. "
-Jim T.