So the request was to add the Recurring Unit Price to the Generic Inquiry for Service Contracts [ScreenID: FS3057PL]. However, when I add the item to the results grid after joining the FSContractPeriodDet Table to the Parent Table: FSServiceContract, I get duplicate line entries on the GI. I have tried a few things to remedy this and can’t seem to figure it out. I tried grouping by the Service Contract ID, but it totals the amounts of the lines and that is not correct. There should only be one line per Service Contract.
Here is the GI:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/21073ee5-97a8-48b6-8910-c5b314ce78db.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1a16843a-68bf-4466-b606-1c6e0d8ca53c.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/655300e0-00c1-44dc-bbaa-adb5e817cf4f.png)
Here are the results:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3f398163-ac38-409c-b331-94da88e8794e.png)