Construction Business Order Tracking & AIA Reports with Microsoft Dynamics 365 Finance & Operations Solution from Brightpoint Infotech

Business Case

Brightpoint Infotech (BPI) understands that construction industry customers who desires to implement Dynamics 365 for Finance and Operations to track Contract orders, Work execution status by an individual task, Invoice schedule, Quality inspection, Project Equipment, Prepayment, Vendor retention and Sales tax along with American Institute of Architects (AIA) 702 & 703 Reports.

Introduction

ConstructPro, is one-stop solution for Construction industry. This solution provides functionality to track the construction project tasks by issuing to individual Contractor, Track the Project task completion percentage.
Sometimes, Construction company sub-contracts the project or partial work to Prime Subcontractor. Where Construct pro comes to the picture. Construction company can assign/delegate tasks from Work Breakdown Structure to Prime Contractor. To Track the WBS activities/task execution of work, Deliverables, Quality inspection and then once the sub-contractor reached to milestone then submit the work submission or completion percentage document for final inspection and payment proposal.

Microsoft Dynamics 365 Finance & Operations Solution

Pre-Requisites

  • Pre-requisite to have D365FO application
  • ConstructPro extension will be installed on the base app of D365FO
  • Project module should be configured and implemented in D365FO
  • Prime vendor records need to be created in D365FO
  • Contractor should be created.
  • Contract orders need to be created with WBS and this will interface with project

Microsoft Dynamics 365 Finance & Operations Solution

Overview on Key Features

Property Developer/General Contractor Management
  • GC/Sub-contractor information
Sub-contractor/General Contractor (GC) Purchase order
  1. Create prime contract order in D365 F&O
  2. Create work details
  3. Link to Project WBS to fetch list of activities
  4. Work break down of PCO lines with provision to link stage payments
  5. Percent of lumpsum split possible for PCO work breakdown
  6. Link to Invoice schedule & work execution master
  7. Vendor retention
  8. Payments – Prepayments
  9. Sales Tax
Equipment management
  1. Create FA as equipment
  2. Assign equipment to projects
  3. Record cost and sales price for equipment rentals
  4. Record hours utilized and costs for equipment usage
Work execution master
  • Provision to attach multiple deliverables & quality inspections to a single work line
  • Prime contract work details
  • Respective deliverables
  • Quality inspection requirements
  • Work submissions / Work completion tracking – Full or Partial
  • Work submission transactions entries when contractor submits deliverables or inspection reports etc. and claims a % of work complete

Change order

  • Capture amendments to contracts

Automation with Workflows

  • Automate and Route transactions
Quality inspections
  • Capture inspection requirements to approve deliverables.
  • Progress Billing feature and tagging to Quality check and Billing

Sub-Contractor Invoice Management

Prime contract work details and their corresponding stage wise invoice amounts Single page view of

  • Stages for which vendor can raise invoices
  • Work completion %
  • Pending work completion %
  • Amount to be paid based on current work completion %
  • Actual work completion for entire order and work line wise
  • Release retainage amount in middle of contract.
  • Multiple project invoice with multiple contracts with retainage and negative change order to hold the contract amount from invoicing
  • Reject partial invoice or partial billing after project inspection
  • Reversal of the progress billing & reported progress.

Reporting / Analysis

  • Earned value analysis
  • AIA 702/703 Reporting
  • Dashboards / analytical reporting

Benefits

  • ConstructPro caters features and functions of construction industry and Standard application does not support construction business
  • Organization has more control on project as broad visibility across project and task
  • Workforce can easily find their to do list on their dashboard
  • Managers can find project status and open actions on their Dashboard to manage operational decision
  • Keeps a close eye for Tracking deliverables and Quality inspection for the contract works
Property Developer/General Contractor Management
  • GC/Sub-contractor information
  • Subcontractor/ GC Purchase order
  • Prime contract order management in D365 F&O
  • Create and maintain work details
  • Link to Project WBS to fetch list of activities
  • Work breakdown of PCO lines with provision to link stage payments
  • Percent of lumpsum split possible for PCO work breakdown
  • Link to Invoice schedule & work execution master
  • Vendor payment retention
  • Payments – Prepayments
  • Sales Tax
Equipment management
  • Create FA as equipment in the system
  • Assign equipment to projects
  • Record cost and sales price for equipment rentals
  • Record hours utilized and costs for equipment usage
Work execution master
  • Provision to attach multiple deliverables & quality inspections to a single work line
  • Prime contract work details
  • Respective deliverables
  • Quality inspection requirements
  • Work submissions / Work completion tracking – Full or Partial
  • Work submission transactions entries when contractor submits deliverables or inspection reports etc. and claims a % of work complete
Change order
  • Capture amendments to contracts
  • Automation with Workflows
Quality inspections
  • Capture inspection requirements to approve deliverables.
Deliverables
  • Technical documents, Photograph proofs, Material samples etc. which can be coupled to work completions
Sub-Contractor Invoice Management
  • Prime contract work details and their corresponding stage wise invoice amounts
  • Single page view of
  • Stages for which vendor can raise invoices
  • Work completion %
  • Pending work completion %
  • Amount to be paid based on current work completion %
  • Actual work completion for entire order and work line wise
Reporting / Analysis
  • Earned value analysis
  • AIA 702/703 Reporting
  • Dashboards / analytical reporting


Leave a Reply

Captcha − 5 = 1