Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 216
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?
  • fshaikh Profile Picture
    fshaikh 216 on at
    Purchase Order status automatically converting to Cancelled when imported the PO Lines
    Hi @andre
     
    I am not using delivery remainder field. 
  • fshaikh Profile Picture
    fshaikh 216 on at
    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. 
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    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?
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans