Skip to main content

Feedback Needed: Parent Child Projects Reporting

  • November 3, 2025
  • 3 replies
  • 83 views

 

Dear Community,

We’re preparing our reporting framework to support parent–child project hierarchies.

We want to hear your thoughts on how each existing report (from the list below) should look and behave when it’s run for a parent project versus a child project. Your input will help us avoid double‑counting, make drill‑downs intuitive, and keep financials audit‑ready across rollups.

What feedback we’re collecting:

  1. UI expectations per report: what should change when the report scope is a parent vs child project?
  2. Aggregation rules: what must be summed, averaged, recalculated, or eliminated at the parent level?
  3. Filtering & drill‑down: which filters, groupings, and drill paths are essential (e.g., Parent → Child → Cost Code → Transaction)?
  4. Gaps: any missing reports you rely on for parent-child project management that aren’t listed below.

Please evaluate your feedback against these parent–child project types:

  1. Parent Project – container
    • only aggregates cost and revenue from child projects
    • each child project is billed separately
  2. Parent Project – main contract
    • aggregates costs from child projects
    • parent project is billed directly

Consider the following reports (displayed in their current design):

  • Project WIP Adjustment 
  • Substantiated Billing
  • Subcontract Audit
  • Construction Bonding Report
  • Employee Hours
  • Project Profitability 
  • Project Cash Flow 
  • Project Variance
  • Project Committed Cost Summary 
  • Project Transaction Details
  • Project Financial Vision
  • Cost Projection by Date

 

Thank you in advance for your input!

3 replies

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 3, 2025

Thank you for reaching out to the community for feedback ​@alexeychaschin54! Please share your thoughts everyone!


mclarke88
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • November 5, 2025

Hi! The most common requirement I see from clients is the ability to have the billing rule run from multiple different projects to generate a consolidated AR invoice. 

 

This is probably a technically high complexity ask BUT could be super useful. Example: I’m a construction client with sites in Texas, Ohio, and Wisconsin and need three separate projects for tax reasons (AR or use tax need to default separately, and I have these managed by three different project managers who need to be accountable for unique profit margin expectations) BUT since we are doing work for a global company like Google, they expect a single AR invoice. They will not accept multiple invoices because it is a pain for their AR team to process the paperwork. 


Forum|alt.badge.img
  • Jr Varsity II
  • November 20, 2025

We modified our Acumatica to be able to do parent and child project since we needed the ability to be able for some reports to start by the parent project and allow us to then drill down to the child project then the task and then a dashboard of transaction detail . Below is an example of the project summary which with three inquire link to acomplith this. I start with the project as a parent and then drill to to each project then to the task level. There is also a need to be able to see all the total invoice (ar) and ap by the parent project but also filter by the child project. We been able to use generic inquiries to be able to acomplish our reporting needs that I could show privately.

 

Regarding the report mention above below is a summary of the information requested.

Project WIP Adjustment  - Child level to enter

Substantiated Billing – filter by Parent or child

Subcontract Audit – filter by parent or child

Construction Bonding Report – keep at the Child level

Employee Hours - filter by parent or child

Project Profitability - start at parent drill down to child then task

Project Cash Flow - start at parent drill down to child then task

Project Variance - start at parent drill down to child then task

Project Committed Cost Summary - start at parent drill down to child then task

Project Transaction Details - filter by parent or child

Project Financial Vision - keep at the Child level

Cost Projection by Date - keep at the Child level