We are in the middle of implementation and are struggling to figure out how to setup Projects in a way that works for us. We are a bespoke manufacturer with some unique business challenges. Here's a scenario:
ABC Company purchases 3 different custom made items from us on a single order. We want to be able to track the profitability of the entire order, as well as the profitability of each individual item that we manufacture. In QuickBooks, we are using parent/child customer relationships to track this:
ABC Company is setup as the parent customer
ABC Company:Item 1 is setup as a child to the parent
ABC Company:Item 2 is another child
ABC Company:Item 3 is another child
In QB, we enter labour and expenses under the children and are able to get an overall job profitability report from the parent. In NetSuite, we have tried to follow this same structure using Projects and Subprojects but we are not able to see the overall profitability of the job. We are only able to see the profitability for the individual subprojects
We also tried setting up ABC Company as a project, with the individual items as tasks. I see where we can enter time on individual tasks and I've now figured out how to add project tasks to vendor bills, but I haven't figured out if there is a way to attach a task to a line item on our invoice to the customer?
Any advice or guidance would be greatly appreciated. Thanks!