web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Karthik Sellamuthu Palanisamy Profile Picture
    Karthik Sellamuthu ... 1,202 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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."

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans