V300

Project Accounting for Construction

View:
2025R121 lessons 9 parts

V300: Project Accounting for Construction

Version: 2025R1
Category: Verticals

How to Use This Course

This training course provides a set of lessons that illustrate the processes of construction project management in a midsize company. The course consists of lessons that guide you step by step through the examples and explanations of the configuration and business process flow in Acumatica ERP Construction Edition. The course is divided into the following major parts:

  • Part 1 provides a brief overview of projects, describes how projects are integrated with the general ledger, and explains how the project costs are captured. The lessons of the part also explain how to work with subcontracts, track commitments to projects, and work with project-specific inventory.
  • Part 2 explains how the project is billed and how retainage is calculated and applied to financial documents related to construction projects.
  • Part 3 is dedicated to the preparation and correction of AIA reports.
  • Part 4 includes lessons about project payments and joint payment processing.
  • Part 5 is dedicated to the structure of the project budget. The lessons of the part explain how to create budget forecasts and track changes to them. Also, this part provides information about the tracking of potential budget overruns and the capture of budget overhead.

What Is in This Guide

The guide includes the Company Story topic and process activities. The Company Story topic explains the organizational structure of the company that has been preconfigured in the U100 dataset, as well as the company's business processes and requirements. Each of the process activities of the course is dedicated to a particular user scenario and consists of processing steps that you complete.

Which Training Environment You Should Use

All lessons of the course should be completed in an instance of Acumatica ERP 2025 R1 with the U100 training dataset preloaded; this dataset provides the predefined settings and entities you will need as you complete the activities of this course. You or your system administrator should prepare an instance of Acumatica ERP 2025 R1, as described in the How to Create a Tenant with the U100 Dataset section below.

What Is in a Lesson

Each lesson provides a story describing a particular user scenario and an overview of the relevant features that have been enabled in the system; configuration settings that are related to the described scenario are also listed. The lesson provides a brief overview of the process that should be performed to complete the described scenario, and instructions that guide you through the process in Acumatica ERP.

          The lessons are independent and can be completed in any order. However, depending on the
          sequence in which you complete the course lessons, the settings in the screenshots may differ from
          the settings in the system.

What Is in Additional Materials

In the Additional Materials part of the guide, you can find the following information related to the processes and scenarios covered in the corresponding parts of the guide:

  • Additional information related to the processes
  • Transactions generated as a result of the processes How to Use This Course | 8
  • Details about the reports, inquires, and forms you can use to review and gather information related to the processes
  • Explanations on how to perform mass-processing operations related to the processes

What the Documentation Resources Are

Acumatica ERP provides a wide variety of documentation resources, which you can access from this course, from the system, or from the Help portal. Links to related information are provided at relevant places throughout the course. The complete Acumatica ERP documentation is available on https://help.acumatica.com/ and is included in the Acumatica ERP instance. While viewing any form used in the course (or any other Acumatica ERP form), you can click the Open Help button in the top pane to bring up a form-specific Help menu; you can use the links on this menu to quickly access form- related concepts and activities and to open a reference topic with detailed descriptions of the form elements.

How to Create a Tenant with the U100 Dataset Before you complete this course, you need to add a tenant with the U100 dataset to an existing Acumatica ERP instance. You will then prepare the tenant for completing the activities. To complete this preparation, perform the following instructions:

  1. Go to Amazon Storage.
  2. Open the folder that corresponds to the version of your Acumatica ERP instance.
  3. In this folder, open the Snapshots folder and download the u100.zip file.
  4. Launch the Acumatica ERP instance and sign in.
  5. Open the Tenants (SM203520) form and click Add New Record on the form toolbar.
  6. In the Login Name box, type the name to be used for the tenant.
  7. On the form toolbar, click Save.
                  When you create a system tenant, you may be signed out aer its creation, depending on how
              many non-System tenants your Acumatica ERP instance already had:
  • If you started with one non-System tenant (to which you are signed in) and you create a new one, the system signs you out to switch from single-tenant mode to multitenant mode.
  • If the instance had multiple non-System tenants and you create another, it is already in multitenant mode. Instead of being signed out, you wait until the system completes the operation and then proceed.
  1. On the Snapshots tab, click Import Snapshot.
  2. In the Upload Snapshot Package dialog box, select the u100.zip file, which you have downloaded, and click Upload. The system uploads the snapshot and lists it on the Snapshots tab of the Tenants form. 10.Open the Apply Updates (SM203510) form and click Schedule Lockout. 11.In the Schedule Lockout dialog box, click OK. 12.Open the Tenants form again. 13.On the form toolbar, click Restore Snapshot. 14.If the Warning dialog box appears, click Yes. 15.In the Restore Snapshot dialog box, make sure that the correct snapshot package is being uploaded and click OK. The system will restore the snapshot and sign you out. 16.Sign in to the tenant that you have just created. How to Use This Course | 9
    17.Open the Apply Updates form again.
18.On the form toolbar, click Stop Lockout.

Which Credentials Should Be Used

To complete the lessons, sign in as the following users:

  1. Lesson 1: ewatson
  2. Lesson 2: ewatson, bsanchez
  3. Lesson 3: ewatson
  4. Lesson 4: ewatson
  5. Lesson 5: gibbs, ewatson
  6. Lesson 6: gibbs, ewatson
  7. Lesson 7: ewatson
  8. Lesson 8: bsanchez
  9. Lesson 9: ewatson, bsanchez 10.Lesson 10: ewatson 11.Lesson 11: ewatson 12.Lesson 12: ewatson 13.Lesson 13: ewatson 14.Lesson 14: bsanchez 15.Lesson 15: ewatson 16.Lesson 16: bsanchez 17.Lesson 17: ewatson 18.Lesson 18: wendell 19.Lesson 19: ewatson 20.Lesson 20: ewatson 21.Lesson 21: gibbs, bsanchez
    The password for each user is 123.

Which License You Should Use

For the educational purposes of this course, you use Acumatica ERP under the trial license, which does not require activation and provides all available features. For the production use of this functionality, you have to activate the license your organization has purchased. Each particular feature may be subject to additional licensing; please consult the Acumatica ERP licensing policy for details. Company Story | 10

Company Story

This topic explains the organizational structure and operational activity of the company you will work with during this training.

Company Structure

The SweetLife Fruits & Jams company is a midsize company located in New York City. The ToadGreen Building Group is a subsidiary of the SweetLife Fruits & Jams company. ToadGreen Building Group—which is located in New York—is a general contractor coordinating construction projects for governmental and commercial customers. The company has only one branch, ToadGreen Building Group, in which the corresponding projects are being managed and all construction-related tasks are recorded. This branch has a warehouse that holds the materials purchased for construction projects until they are transferred to project site.

Operational Activity

The company has been operating starting in the 01-2024 financial period. In November 2024, the company started using Acumatica ERP as an ERP and CRM system and migrated all data of the main office and retail store to Acumatica ERP. The equipment center has begun its operations in 01-2025 in response to the company's growth. In October 2024, the company received an investment and opened a subsidiary company for construction (ToadGreen). In February 2025, the company started its first construction project. The base currency of the company and its subsidiaries is the US dollar (USD). All amounts in documents and reports are expressed in US dollars unless otherwise indicated. Part 1: Project Commitments | 11

Course Structure

Part 2: Project Billing and Retainage...................................................................................................... 59

Part 3: AIA Reporting............................................................................................................................ 82

Part 4: Payments.................................................................................................................................. 98

Part 5: Project Budgets........................................................................................................................111

Part 1: Project Commitments

Part 2: Project Billing and Retainage

Part 3: AIA Reporting

Part 4: Payments

Part 5: Project Budgets