I have a sales kit called service and this have several components. On sales orders we use this as component pricing kit. So, the parent line value is zero and not GST on it but the component lines do.
Once it’s sold Our finance team need only the parent line to show on the AR invoice with the unit price and GST equal to the sum of all components’ unit prices and GST.
I’d like some help since I’m very new to ssrs report building. I need this summed GST and unit price fields for the kit components so that i can use them in my SSRS report under the parent line for AR invoice.