Finance | Project Operations, Human Resources, ...

Unable to create a Purchase Order line item. The record already exists.

(0) Share

Report

Posted on by joelhtown80

Hi All,

The issue happens only on some of the POs being uploaded. I have set the For-Loop concurrency setting to 1 in order to import each record one at a time. Any idea on what's causing this?

Here are the steps:

1. Check if the PO already exists in F&O. There is none.

2. Created the PO header in PurchaseOrderHeadersV2. It was successful.

3. Check if there are line items for the PO in PurchaseOrderDetailsV2. There is none.

4. Delete all PO line items if any.

5. Created the PO Line item in PurchaseOrderDetailsV2. It was an error.

An error has occurred. Write failed for table row of type 'PurchPurchaseOrderLineV2Entity'. Infolog: Info: Cannot create a record in Purchase order lines (PurchLine). Purchase order: 7000097, 200./The record already exists..

Screenshot for step #3

Screenshot for step #5

Also checked if there are records after the step #5 hit the error. There is none.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you sending any line number?

Also, can you disable the "Set based" option for the data entity and then try?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Joel,

It could be related to a non-unique line number like mentioned by Ramit or maybe the flow is mixing data in various legal entities? I'm not able to see all details. I created a working Power Automate flow for purchase orders in the past. You can read my blog where you can also download my example: Let your Operations Flow - Excel to Purchase orders Example - Dynamicspedia
You can then check if you missed something in your flow.

Was this reply helpful? Yes No
joelhtown80 32 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here is a screenshot of the line item details I am trying to create. In this example, the PO only has 1 line item.

@Ramit, I am sending line number. Also, how do I disable the "Set based" option?

@Andre, are you referring to the Company (Data Area Id) when you say legal entities? If so, then the flow is not mixing it with various legal entities.

Was this reply helpful? Yes No