Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / .csv template for Purc...
Microsoft Dynamics SL (Archived)

.csv template for Purchase Order Maintenance import

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, would anyone have a .csv template for uploading to the Purchase Order Maintenance screen? 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: .csv template for Purchase Order Maintenance import

    Hi

    Please check whether the POTran table has any rows with empty/duplicate value in index field. If yes then delete that record and try.  Normally this error will occur during index violation only.

    You can check the below Query

    Select PONbr, LineRef, LineNbr, InvtID, SiteID, OpenLine, ProjectID,PC_Status,ReasonCd From PurOrdDet Where PONbr ='XXXXXX'

    Note XXXXXX represents PONbr

    Hope this helps

    Thanks & Regards

  • Community Member Profile Picture
    Community Member on at
    RE: .csv template for Purchase Order Maintenance import

    Do you encounter any problems if you import records in PO then you enter an additional record from the purchase order maintenance screen? Like getting a message "Another process has already added the detail item. the system will automatically cancel your changes."

  • Karthik Sellamuthu Palanisamy Profile Picture
    Karthik Sellamuthu ... 1,196 on at
    Re: .csv template for Purchase Order Maintenance import

    Hi Chanm,

    Plz find the sample .csv file for PO. Please let me know if you have any concern about this,

     

    Action    Level0    Cpny id    PO Type    Vendor id    Status    PO Date               
    Action    Level1    Purchase For    Invt id    Site Id    Qty Ordered    UOM    Receipt action    Alternate ID    Trans Descr    Row ID
                                           
                                           
    PO    Level0    XX    OR    XXX    O    6/20/2008               
    PO    Level1    GI    MISC000001    SiteA    1200    EA    N    ItemA    Testing Item    699145
    PO    Level1    GI    MISC000001    SiteB    10        EA    N    ItemB    Testing Item    699146

    Thanks

    Karthik

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,274 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,939 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans