Electronic Reporting - Model - Table method with parameter

(0) Share

Report

Posted on by Jasper Callens

Hi

I'm working on the model of an Electronic Report. In this model I would like to retrieve a CompanyInfo record by using the CompanyInfo.findDataArea and providing "DAT" as a parameter.

When I enter the following in the Formula Designer:
CompanyInfo.'findDataArea("DAT")'
I get an error:
Incorrect reference 'CompanyInfo/findDataArea("DAT")'

I thought of entering the CompanyInfo method without a parameter to see what error is given.
CompanyInfo.'findDataArea()'
The error in this case is:
Validation warning: Value of mandatory parameter 1 is not provided in 'CompanyInfo.'findDataArea()''.

Because this warning is provided/exists, I think that it should be possible to call such a method with a parameter... but I have no idea how.

Anyone have any experience with this or a similar issue and can provide a solution?

Thanks!

Categories:

Development / Customization / SDK

Data Integration

Financial Management

All responses (6)

Answers (1)

Verified answer

Jasper Callens 35 on at

Like (1)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hi Ludwig

I'm not sure what you meant by 'replacing the last term'.

I have however retrieved the correct syntax that has solved the issue:

Wrong syntax:

CompanyInfo.'findDataArea("DAT")'

Correct syntax:

CompanyInfo.'findDataArea()'("DAT")

Thank you for your help!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hi,

I think the notation is wrong.

Can you try: comp.'find()'.DataArea and replate the last term with DAT.

Alternatively, open the companyinfo table data source and bind your field with one of the available methods for finding the dataArea.

You can also make use of an user input parameter that asks the user for the data area id before running the report.

Will take a bit of testing if you have not used it before, but I believe that you can make that work.

Best regards,

Ludwig
Jasper Callens 35 on at

Like (0)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hello

I'm making some changes to the CODA-model (for research reasons).

Here you can see the model + Formula Designer of the new Calculated Field:

1) Model

2) Add Root calculated field

3) Set/save formula (and error)

I'm creating this calculated field as a test (to see if the method call works). That's why I am using the DAT company.

EDIT: I just checked the 'Collection Letter Model' but cannot see any table method calls that require a parameter. Is there anything specific on this model you had in mind?
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hello Jasper,

I see. Can you share some details of the model that you setup and the method selected?

In addition, have you checked and compared your setup with other existing (default) report models, such as the collection letter model?

Why is it that you refer to the DAT company?

Best regards,

Ludwig
Jasper Callens 35 on at

Like (0)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hi

Thank you for your reply.

We're using D365FO 8.1 with Platform version Update23 (7.0.5126.35370).

On LCS we cannot see any updates on Electronic Reporting.

I'm afraid that this is not the solution.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting - Model - Table method with parameter

Hi,

What D365FO version do you deploy. If you are working on an older one the find data area feature might not fully or correctly work. I remember that there were some issues in the past, which have been resolved with the latest PUs. Have you already checked LCS or tried to upgrade to the latest version?

Best regards,

Ludwig