Error when trying to create invoice header using power automate

(1) Share

Report

Posted on by Matt Smith - Cha Ltd

Good evening,

This had been working fine up until yesterday (with no changes to the power automate flow being released) but seem to get the below error, when creating a sales invoice header using power automate:

{

"status": 400,

"message": "ErrorCode: Unknown Function ID -541509721 was called. The object with ID 5475 does not have a member with that ID. CorrelationId: 3adaf157-f2c5-462c-8185-3f2b6da03924.\r\nclientRequestId: d6b5c7d4-57d7-4ac9-aa12-4b570d3e5bda",

"error": {

"message": "ErrorCode: Unknown Function ID -541509721 was called. The object with ID 5475 does not have a member with that ID. CorrelationId: 3adaf157-f2c5-462c-8185-3f2b6da03924."

"source": "api.businesscentral.dynamics.com",

"errors": []

}

Just wondering if anyone else has experienced the error before? I have raised a ticket with Microsoft Power Automate support, but they seem to think the issues rests with Business Central. We are using the online version. In production the above error is displayed, using Sandbox, the same connector work perfectly....

In the power automate flow we are just creating an invoice header with a customer number as the unique identifier. The next step in the flow creates the invoice lines (but fails prior to this step).

Very confused. Any pointers / help would be great.

Cheers,

Matt

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

5475 is the header page of the api. Tried this myself by passing only a customer number and that appears to be the main issue. You need to try passing in the ID instead, which is a guid value not shown on the page. Perhaps if you use a page published as a web service you can get the ID from there and pass the value into the existing flow structure. It’s not for this exact example but check out this blog on using a http trigger to get the data needed to pass it then into the BC connector. A few of the other posts mention a similar pattern: joshanglesea.wordpress.com/.../

Was this reply helpful? Yes No
Matt Smith - Cha Ltd 65 on at

Like (0)

Report

Hi Josh,

Thanks for the reply. The same business central connector 'create record' just passing a customer number when creating a sales invoice header seems to work fine in a sandbox environment, so its strange that it doesn't work in production. Its been working fine until the last few days. I have tried passing the customer guid also, but seem to get the same error. Would there be any restrictions or config that I can access regarding the header page of the api in business central?

Cheers,

Matt

Was this reply helpful? Yes No
Eion Robb 35 on at

Like (0)

Report

That's weird, I'm getting a similar error message "Function ID -541509721 was called. The object with ID 5475 does not have a member with that ID" even when just doing a standard GET to the salesInvoices v1.0 endpoint, but also only in Production. I thought maybe it was due to the $expand=salesInvoiceLines or any $filter's but even when removing all parameters it still errors out.

Was this reply helpful? Yes No
Verified answer

Eion Robb 35 on at

Like (1)

Report

So switching from the v1.0 API to the v2.0 API (recently released docs.microsoft.com/.../dynamics_salesinvoice ) resolves it for us, but seems kinda weird

Was this reply helpful? Yes No
T.Anderson 10 on at

Like (0)

Report

This solution also worked for me.

Was this reply helpful? Yes No
Thomas Franz 1,105 on at

Like (0)

Report

Thanks for all the helpful info. One question I'm struggling with is how to "append $schemaversion=2.0 to the request URL" in Power Automate. Any insight would be appreciated.

Was this reply helpful? Yes No
Eion Robb 35 on at

Like (0)

Report

Adding $schemaversion to the end of the url wasn't necessary for me, I'm wondering if the docs are just out of date since they talk about it happening automatically in a future version. The important bit was replacing "/api/v1.0/" with "/api/v2.0/" in the URL

Was this reply helpful? Yes No