08-28-2018, 12:45 PM
I have a usecase that is not completely thought through yet, but I would like to leverage one of the new report types to combine work with fun. Would this be applicable:
I need to get salesorders, for a certain time period and a certain user. That part is easy. I also need to get the inventorydetail records (or product lines) that belong to that salesorder, their related product name, quantity, sell price and cost price. Then, lastly I need to get all the related invoices per salesorder to determine the invoice with the latest date.
De we have something like reports with sub-items yet? Something like grouping? So basically top-level would be the salesorders, then beneath that the inventorydetail lines and the invoices.
As you can see I'm not 100% sure about the data I need yet, just want to experiment with the new report types.
I need to get salesorders, for a certain time period and a certain user. That part is easy. I also need to get the inventorydetail records (or product lines) that belong to that salesorder, their related product name, quantity, sell price and cost price. Then, lastly I need to get all the related invoices per salesorder to determine the invoice with the latest date.
De we have something like reports with sub-items yet? Something like grouping? So basically top-level would be the salesorders, then beneath that the inventorydetail lines and the invoices.
As you can see I'm not 100% sure about the data I need yet, just want to experiment with the new report types.