SI-CRE-TOOL15 Update Project Contracts

Applies to

• Product version: Velixo NX
• ERP: Sage Intacct
• Functional area: Financials, Budgeting, Project, Other
• Industry: Construction
• Plan: All
• Template type: Production Report template

Description

The SI-CRE-TOOL15 Update Project Contracts template is tailored for the construction industry. Its main goal is to make updating important contract details from Excel to Sage Intacct more efficient. This tool simplifies contract management by enabling bulk updates, ensuring accuracy, and reducing the time spent on manual data entry.

Important: As this template enables bulk updating of Project Contract records, please always check your modified data prior to writing data back to Sage Intacct.

Coverage

This workbook includes the following sheets:

Typical audience

The typical users of this type of report are Finance professionals: Accountants, CFOs, Controllers and Project managers.

Features

The following features are used by this report. To use this report, please ensure that your Velixo license includes all of them, (or contact Support or Sales):

• List functions
• Query functions
• Writeback functions

Preview

Download this template

Download

💡Having trouble downloading this file?

Simply right-click on the link and select Save link as

Documentation

The SI-CRE-TOOL15 Update Project Contracts template is built for simplicity, versatility, and efficiency, making it easy for users to update key contract details. Specifically designed for the construction industry, this tool allows for quick mass updates of contract data directly into Sage Intacct. With built-in writeback functionality, it ensures fast and accurate transfer of updates from Excel to Sage Intacct, maintaining data consistency and minimizing manual effort.

Filters

• Location: a dropdown list containing all active locations on Sage Intacct.
• Project: a dropdown list of all available projects in the Sage Intacct instance and serves as the sole filter in the template. If no project code is selected, the template will display all available project cost codes within the Sage instance.

Data Table

To ensure a seamless writeback process to the Sage Intacct instance, the template includes a data table divided into two categories:

• Read-only data value: this category includes data that cannot be edited, ensuring critical information remains accurate and consistent. The column headers for this data are distinguished in blue for easy identification. To view all available attributes of a project contract more comprehensively, users can collapse the grouped columns in Column M.

• Editable data values: this category includes data that users can change as needed, providing flexibility within the template. The column headers for this data are highlighted in dark blue. The editable data values mirror the format used in Sage Intacct record forms, ensuring users are familiar with the interface.
  
  

User Guide

Using the report

Now that we've covered the report overview, let's dive into a step-by-step guide on effectively utilizing the report.

• Set the Connection Name on the Options sheet: crucial for all processes, set the Connection Name on the Options sheet by updating cell A2. Ensure it matches the name used during Velixo application login.

• Update the Options Sheet: as the foundation for the filters on the main report, keep the Options sheet up to date. It should always and automatically capture the latest dimensions and structures from your Sage Intacct instance.

• Proceed to the primary worksheet and select the necessary filters corresponding to the project you wish to refresh the data for.
  • Location
  • Project

• Selecting a filter will automatically update the table. Modify or update the existing details in the editable columns as needed.

• Once you've updated the table, initiate the Velixo writeback process.

• After a successful upload, the status in Column A (Writeback Status) will change to 'Line uploaded'.

Important: To prevent Velixo from uploading blanks when details in editable values are removed, ensure you only update necessary projects and their attributes. Leave unchanged items as they are.

Version History