Purchase Order status automatically converting to Cancelled when imported the PO Lines

(0) Share

Report

Posted on by fshaikh

218

I first imported a purchase order header through excel using Data entity, it got imported correct with the /Open Order/ status.
After that, I imported Purchase Order Lines for the same Purchase order through excel data entity. Lines got imported too, but all the lines' status converted to Cancelled in turn converting the purchase order status to /Cancelled/ too.

Now, it is un editable on both header and lines.

What to do? Or, any idea why this is happening?

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 299,913 Super User 2025 Season 2 on at

Like (0)

Report

Purchase Order status automatically converting to Cancelled when imported the PO Lines

Hi fshaikh,

Do you have columns in the Excel file for one or two fields showing a delivery remainder? If so, do these have a zero value? If so, provide the correct quantity to be delivered. You can also remove these columns from your Excel file.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Purchase Order status automatically converting to Cancelled when imported the PO Lines

Hi fshaikh,

Can you please share the list of columns you are using for import?

Also, did you try using Excel add in ? Is that also giving same issue?

Was this reply helpful? Yes No
fshaikh 218 on at

Like (0)

Report

Purchase Order status automatically converting to Cancelled when imported the PO Lines

Hi Saurabh,

Yes I tried Excel add in.

The list of columns are

I didn't put anything in line status field.

Was this reply helpful? Yes No
fshaikh 218 on at

Like (0)

Report

Purchase Order status automatically converting to Cancelled when imported the PO Lines

Hi @andre

I am not using delivery remainder field.

Was this reply helpful? Yes No