Field/Parameter issue

​@ElvinT You can try checking other Service reports to see if there is similar use and then copy this. If not then you can try the option of =Report.GetFieldSchema('FSServiceContract.BillingPeriod' but there is no guarantee this will work either. What this means is that the field isn’t able to be used in this way and you may need to find a different field. Or if the field you’re trying to use is dependent on another field, then you need to include this dependent relationship in the function for the parameter.

For examples of the dependent relationship you can check the ARInvoice parameter for RefNbr and see the format is like, =Report.GetFieldSchema('ARInvoice.RefNbr,DocType') where the RefNbr is dependent on the DocType to populate.

I’m not familiar with the Service Contract Billing Period field though, so I’m not sure if you can find this in another similar FS field or if this type of parameter just won’t work because there are not supported fields which display this, in which case you would need a custom DAC that could do this.

Thank you!

Does the fact that BillingPeriod is (Nonexistent in DB) ensure that will need to create a custom DAC. Sorry not super familiar with this.

Correct, I hadn’t checked the actual DAC to see if it was Non-Existent, but that certainly explains why it wouldn’t be seen! If there are other DACS that have it then they might be able to be used instead. I checked and FSServiceContract has this but it is not a selector type field, but it still shows up. I’m certain there’s a field that can work, might have to dig through some FS tables to find it and the DAC Schema Browser can be a good place to do that.