Skip to main content
Answer

add Parent Child relationship to Projects.

  • June 4, 2021
  • 7 replies
  • 993 views

It would be very nice to be able to add separate subprojects (Child) to a Main Project to be able to track total revenue.  These would be projects where a change order wouldn’t make sense.  Say a main development project (progress billing), a separate child project for reoccurring billing of a maintenance contract. and a separate child project for T&M Billing.  Each of these has different revenue recognition needs and occur on different billing schedules but It would nice to be able to roll them up for reporting.

Best answer by Heidi Dempsey

@seastman20@lfreeman  You could use tasks for this.  Each task can have separate billing rules and the revenue budget can have separate line items for each task based on Account Group or Cost Code or Inventory Item, then on reports or even on the budget you can total by task.   Reach out to your partner for more information.

7 replies

  • Freshman I
  • April 6, 2022

We could really use something like this too. We will have one contract but two different areas of the company doing work and we need to track the revenue for each of those areas differently but need to invoice together. 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • April 6, 2022

Hi @seastman20 

You can add this as a Product Idea that can be voted on by the community and Acumatica will consider it for a future release. 


Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Answer
  • April 8, 2022

@seastman20@lfreeman  You could use tasks for this.  Each task can have separate billing rules and the revenue budget can have separate line items for each task based on Account Group or Cost Code or Inventory Item, then on reports or even on the budget you can total by task.   Reach out to your partner for more information.


Forum|alt.badge.img
  • Jr Varsity II
  • April 28, 2022

@Heidi Dempsey,

Unfortunately for some of us (Engineering Firm) the child project have multiple task. Since Acumatica does not allow for subtask our workaround was creating another field called parent project id. This is a selector of the project id. We then create a parent project plus the child project as projects in Acumatica. We then used the generic inquire screen to create an inquire that would link all the project together as seen in the screen shot below. Were P-16003.00 is the parent project and P-16003.01 &.02 are child with sum at the bottom. Hope this helps other and for Acumatica all it takes is to add another field to be able to do parent and child projects.

 


meganfriesen37
Captain II
Forum|alt.badge.img+12

We’ve also done something similar to @freboredo for another customer and added that extra project look-up field on the projects screen.  Then, we did some fun report updates so that you can run project balances with the parent/child projects reporting either consolidated or project by project.  

 


  • Freshman I
  • March 10, 2023

just added this as a product idea, please go upvote and comment with any additional tweaks or features you’d like to see! 

 

 


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • March 10, 2023

Deleted /sorry my bad. I had missed one of the comments. It had laid out my comment nicely.