Unanswered

Create a puchasing invoice in Business Central

(0) Share

Report

Posted on by Gilles12

150

I am creating purchasing invoice into Business Central with Power Automate. It works well when creating records directly in the related tables (purchaseInvoices and puchaseInvoiceLines), but is there a way to pass through the "Incoming Documents" feature so that the invoice file can be attached, or more generally is there a way with Power Automate to attach the invoice to the created record? I did not find any action in the Business Central connector to push the document, nor to create an "incoming document" record.

Thank you.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Gilles12 150 on at

Like
a
(0)

Report
Copy link

Link copied!

I have found the solution with the table attachments.

Was this reply helpful? Yes No
Miss_Bishan 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gilles12 ,

Thank you for posting this question and sharing your solution.
I am also working on a similar flow, but I encountered the error message: 'ErrorCode: BadRequest Control 'vendorName' is read-only.' I suspect the flow must select the vendor name from BC.
Could you please share how you resolved this issue with the read-only column?

Thank you.

Was this reply helpful? Yes No
Gilles12 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Miss_BI.

In this flow from a project a few weeks ago, I searched the vendor on the name in the 'vendors' table, got the ID of the vendor, and provided it in the record created in the 'purchaseInvoices' table. It's a GUID so you probably know the method in Power Automate to insert a GUID.

Yes I think to remember the vendor name was read only. For new vendors, I was using a predefined default vendor name (I was searching the ID of the default vendor also).

Unfortunately I have no longer access to the Business Central environment, so I can't show you more precisely.

I hope this helps and I don't hesitate if you have other questions.

Regards,
Gilles.

Was this reply helpful? Yes No
Miss_Bishan 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply.

I tried a workflow similar to your idea, and it worked. But I'm concerned that looping through the vendor table might take more time as the number of entries grows.

Was this reply helpful? Yes No
Gilles12 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Miss_BI.

No no, looping is not a problem, at least in this scenario, because the criteria is on to the vendor name. Looping (List Rows) to search a record in Power Automate is the only possible Dataverse action to use for the purpose of search, when you don't have the GUID, even if you have only one record to return. On the vendor name, it will never return several srecords (except if you use some contain function or similar, but it's a different scenario and in this case you would never avoid looping like in any system). With the vendor name, you get it or not, so the List Rows returns 0 or 1 record only (except if in your system you have several times the same vendor names, which would not be normal).

Was this reply helpful? Yes No