Office Connector Write

Sample Reports

The following Report Templates come with every copy of Office Connector Write. All Report Templates fall under the Limited Warranty for Packaged Excel Templates.

Report NameDescription
Write AP Invoice ApprovalThis solution provides a means to approve invoices within Excel. All unapproved invoices are listed using an Office Connector query. The approval status can easily be updated and then written back to Sage 300 Construction and Real Estate using Office Connector Write. This requires that the approval feature has been enabled within AP Settings.
Read more...
Write EQ Equipment MaintenanceThis template provides a quick and easy Excel-based method to update the maintenance data for EQ Equipment records.
Read more...
Write GL BudgetThis template can be used to view, create, or update a budget in General Ledger.
Read more...
Write GL Budget - CashThis template can be used to view, create, or update a budget in General Ledger.
Read more...
Write JC Cost To CompleteThis template provides a means to perform job cost forecasting in an Excel worksheet and then write forecasted values back to Job Cost for use with other reports.
Read more...
Write JC Cost to Complete (by Category)This template provides a means to perform job cost forecasting in an Excel worksheet and then write forecasted values back to Job Cost for use with other reports.
Read more...
Write JC Work In ProgressThis template is based on the "JC Work In Progress.xlt" template but provides additional functionality to write calculated values back to the job records for use with other reports.
Read more...
Write PJ Correspondence LogThis template can be used to quickly update correspondence records in Project Management. Records can be quickly filtered to locate the desired information and then information can be updated and written back to Project Management.
Read more...
Write PR EmployeeThis template provides a means to enter new employees or to view and update existing employee information from within Excel using a single consolidated entry form.
Read more...
Write PR Rate Table RatesThis template provides a means to update payroll rate tables from within Excel. New rates can be manually entered, or can be based on formulas or references to other worksheets. Once rates have been entered or calculated, they can be written back to Payroll using Office Connector Write.
Read more...
Write PR Union ItemsThis template provides a means to quickly and easily update union deductions and benefits from within Excel. Updated information can be written back to Payroll using Office Connector Write.
Read more...