error in importing PO lines via data management in PU33

(0) Share

Report

Posted on by Rahul Mohta

21,032

I have been importing PO lines however recently started getting error in importing PO lines via data management in PU33

Installed product version : 10.0.9 (10.0.383.20005)
Installed platform version : Update33 (7.0.5559.41422)

getting error as below

Results. update not allowed for field 'PurchPurchaseOrderLineV2Entity.PurchaseOrderNumber'

I have the same question (0)

All responses (8)

Answers (1)

Blue Wang on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

Hi Rahul,

PurchaseOrderNumber field in PurchPurchaseOrderLineV2Staging table is not allow edit.

Have you tested in other environments？

Was this reply helpful? Yes No
Rahul Mohta 21,032 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

yes did try with other environment and it somehow is coming only this environment

no code changes

no definite hotfix on LCS

reaching to MS support with a case

Was this reply helpful? Yes No
vince.perta 9 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

Have you found a resolution to this? We recently started experiencing the same issue.

We're on a slightly different version that you:

10.0.9 (10.0.383.10010)

Update33 (7.0.5559.35512)

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,032 on at

Like (2)

Report

RE: error in importing PO lines via data management in PU33

the fix is to check and remove any Bad data using below query and then import

SELECT *INTO [purchLineBackup] FROM purchLine WHERE purchLine.InventTransId = " "

Was this reply helpful? Yes No
vince.perta 9 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

Thank you. We did have one PurchLine with a blank InventTransId, and deleting it resolved this issue.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,395 Super User 2025 Season 2 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

Thanks for the feedback, Rahul. I have marked your answer as verified as you probably can't do it for your own questions.

So, in fact a missing mandatory field value was the cause for a misleading error message.

Was this reply helpful? Yes No
vince.perta 9 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

I think it's worth pointing out though, that the missing mandatory field isn't on the record being imported that is throwing the error, but rather on a record already in the destination table, preventing any other records from being imported.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,395 Super User 2025 Season 2 on at

Like (0)

Report

RE: error in importing PO lines via data management in PU33

Correct Vince! I should have mentioned that more clearly.

Was this reply helpful? Yes No