How to add a record using the VendInvoiceLine_Project Data Entity using Power Automate

(1) Share

Report

Posted on by Mario C

Hello community,

I'm working on adding a record to the table VendInvoiceInfoLine_Project, which is associated with lines inside a Vendor Invoice. To do this, I created a custom Data entity based on VendInvoiceInfoLine_ProjectBiEntity. The main difference is that my custom entity is not read-only. However, every time I try to add a record, I got the same error: "Write returned RecId 0 for table row of type 'NPLVendInvoiceInfoLine_ProjectBiEntity'. Infolog: .\r\n", despite including all required fields.

Could someone help clarify how this table is linked to the vendor invoice? Below is an image for better understanding.

Thanks!

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mario,

Not fully sure, but I think that there is a record ID reference field on the table VendInvoiceInfoLine_Project. What exact fields have you added in your custom data entity? What identification to link to the invoice line have you implemented?

Was this reply helpful? Yes No
Mario C 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Andre,

I duplicated the data entity called VendInvoiceInfoLine_ProjectBiEntity, keeping the same fields and adding one called VendInvoiceInfoLineRefRecId from the VendInvoiceInfoLine_Project table. This new field is used to attach the project to the line. That's the only difference.

Thanks!

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mario,

I missed your update. Have you solved your challenge already? If not, the data entity framework is intended to not rely on (reference) record IDs. You mentioned you added the VendInvoiceInfoLineRefRecId, but what else did you do to fill this reference record ID with the correct value?

Was this reply helpful? Yes No