The Event 1 Software LCP Tracker template is powered by Sage Office Connector Query for Sage 300 Construction and Real Estate and designed to be used for weekly payroll reporting. The Event 1 Software LCP Tracker Excel template provides a method for users of LCP Tracker to quickly and efficiently gather payroll data used by the LCP Tracker Labor Compliance website. Once payroll data has been assembled into an Excel workbook, the LCP Tracker customer web-portal provides a means for the Excel workbook to be uploaded and processed. Records that meet the minimum criteria are uploaded into the LCP Tracker database. All of the new records are then checked by LCP Tracker’s Validation Engine and notices are created for any records that need more data or corrections. Data can then be reviewed and corrected within LCP Tracker’s customer web-portal.Contact Us
Office Connector Financials allows Sage 300 CRE customers to produce and share visually appealing financial reports for future months as well as more than 25 previous periods while offering the ability to drill into the detail behind your financial information. Using Excel you can format and arrange information as you prefer, including graphs, charts, create Excel formulas and allow controlled interaction with financial information for your stakeholders.Introduction to Office Connector Financials
In-Depth Review of Office Connector Financials
Sage Office Connector includes the following modules:
To learn more about Sage Office Connector:Click Here
The Event 1 Software LCP Tracker template is powered by Liberty Reports for Sage 100 Contractor. This template is designed for certified payroll reporting. This template can be used to create an upload for LCP Tracker which is a web-based subscription software that collects, verifies and manages prevailing wage certified payroll reporting. It can be used to print a variety of certified payroll report formats or create uploads (including the XML upload file required by California). The LCP Tracker customer web-portal provides a means for the Excel workbook to be uploaded and processed. Records that meet the minimum criteria are uploaded into the LCP Tracker database. All of the new records are then checked by LCP Tracker’s Validation Engine and notices are created for any records that need more data or corrections. Data can then be reviewed and corrected within LCP Tracker’s customer web-portal.Contact Us
Liberty Reports for Sage 100 Contractor comes with many useful reports including several you may find compelling for financial reporting including templates for a Trial Balance, Financial Statement and Ledger Transactions.
Additionally we have created several useful Knowledge Base articles on financial reporting strategy for Sage 100 Contractor:
Learn about the templates provided on the Liberty Reports Desktop
Click below to see examples of specific financial reports included in the Liberty Reports Desktop.Trial Balance
To learn more about Financials for Sage 100 Contractor:Contact Us
Using the Liberty Reports add-in, Excel becomes the environment in which you design and run your business reports. Use your existing Excel skills to produce highly effective and interactive results! Accessing your data is made easy. There is no need for you to create data sources or build SQL queries. Simply select your database, supply login credentials, and you’re ready to begin your Excel-based reporting.Learn More
Looking to sharpen your report writing skills? Don't miss our session on Monday, May 14th at 3:30 - "Executing an Effective Report Writing Strategy" (Track 26-Session 04).
- Knowledge Level: Beginner, Intermediate, Advanced
- Who Should Attend: Controllers, Executives, Consultants, IT
- Prerequisites and/or Advance Preparation: Applicable to Crystal, Report Designer, Inquiry Designer, Office Connector or Liberty Reports. Familiarity with report creation or desire to improve on the planning, creation, testing and maintenance of Reports.
- Learning Objectives/Description: Learn the three stages of effective report creation - Discovery and Planning, Design and Testing, Delivery and maintenance.
Don't forget to check out track 22 which features 10 different Office Connector courses which are listed below. For more information on TUG sessions, visit the TUG website.
TUESDAY, MAY 14TH, 2019
Session 1 | 9:00am – 10:30am – “Using Office Connector Starter Reports & Intro to Office Connector Query Lab”
WEDNESDAY, MAY 15TH, 2019
Session 5 | 9:00am – 10:30am – “Office Connector General Ledger Entries/Budgets Import Lab”
Session 7 | 1:45pm – 3:15pm – “Office Connector Write & Import Lab (1 of 2)”
Session 8 | 3:30pm – 5:00pm – “Office Connector Write & Import Lab (2 of 2)”
THURSDAY, MAY 16TH, 2019
Session 9 | 9:00am – 10:30am – “Office Connector Managing Commitments Lab (1 of 2)”
Session 10 | 10:45am – 12:15pm – “Office Connector Managing Commitments Lab (2 of 2)”
Session 11 | 1:45pm – 3:15pm – “Intermediate/Advanced Office Connector Concepts (1 of 2)”
Session 12 | 3:30pm – 5:00pm – “Intermediate/Advanced Office Connector Concepts (2 of 2)”
FRIDAY, MAY 17TH, 2019
Session 13 | 9:00am – 10:30am – “Office Connector Financial Functions Lab (1 of 2)”
Session 14 | 10:45am – 12:15pm – “Office Connector Financial Functions Lab (2 of 2)”