We need the costs that come through from PO’s onto our sales orders and service orders to show on the Daily Sales Profitability Report. So firstly - is there a magic fix like a setting or something that we can change in order to incorporate these costs into the line items in the invoice? That’s first prize.
If not, I have managed to create a GI to fetch the costs for the service order using the following joins, but I can’t find the same connections for SO:
I’m also just wondering if anyone has a more elegant solution than these GI’s? I’m sure there are many others who also need to see these PO’s included in job costs. In fact strictly speaking they only become costs once the items have been receipted so I should add another line for PC.
Then - last question. Because the same PO is linked to multiple lines of the service order, and I only need to show the cost once, I grouped by PO order number. But it is adding the two lines together, and I only want to show the cost once, do I need to do something in a calculation?
Best answer by MarciaW
View original