Reporting on S3 Lines
Posted: 08 Aug 2018, 12:59
I'm trying to report on S3 service lines we use when we do a service repair. Often the customer has had goods at the same time as a service so S3 lines go on product invoices for ease, so I can't use the standard reports for Service Invoices to report on.
I have a report I use which works well to report on customer activity but currently picks up stock lines only. Would I be able to devise a report, or integrate it to my existing report - as the same customer will order products as well as have repairs so would be good to report on the whole of the customers activity - that would report on these S3 service sales?
Does the answer lie in expressions? Joins? I'm at a loss.
Thanks
I have a report I use which works well to report on customer activity but currently picks up stock lines only. Would I be able to devise a report, or integrate it to my existing report - as the same customer will order products as well as have repairs so would be good to report on the whole of the customers activity - that would report on these S3 service sales?
Does the answer lie in expressions? Joins? I'm at a loss.
Thanks