Hi Everyone,
Good Morning,
I need data from FSServiceOrder table based on the CustomerID and LocationID to the report.
For example:
Based on the SrvOrdType, RefNbr we have CustomerID and LocationID.
For this CustomerID and LocationID we have multiple data in the FSServiceOrder. So I need to get that multiple data into a sub report based on the filters CustomerID and LocationID.
So please help me out, how to get that multiple records based on the filters in same DAC.
FYI...Please see the below attached screenshots:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/cedabb00-a53f-40b3-adaf-02d4b74481a0.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/daf46c4f-5130-4057-b22d-688dd4b1e262.png)