Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Export a single purchase in text or excel in NAV 2017

Posted on by 200

Hi,

       How to export a single purchase order data in NAV? Is there any development logic to be built in NAV?

Thanks in Advance..

*This post is locked for comments

  • Suggested answer
    Mohsin Abbas Profile Picture
    Mohsin Abbas 525 on at
    RE: Export a single purchase in text or excel in NAV 2017

    "SaveAsWord" the function name says it all.  If you dont want to do it with XMLPort, then exporting the report as .csv is the best option and it does not require any modification.

  • RE: Export a single purchase in text or excel in NAV 2017

    I have tried following code it works for word. but I need it for text. If I put .txt instead of .doc, notepad is corrupted..Its like decoded. I used this in purchase order actions...

           PurchaseHdr.RESET;

           PurchaseHdr.SETRANGE("No.",Rec."No.");

           Save12 := Rec."No.";

           REPORT.SAVEASWORD(REPORT::ReportName,('C:\'+FORMAT(Save12)+'.doc'),PurchaseHdr);

           MESSAGE('Document Created');

  • Suggested answer
    Mohsin Abbas Profile Picture
    Mohsin Abbas 525 on at
    RE: Export a single purchase in text or excel in NAV 2017

    In that case you can build an XMLport. On the request page of XMLPort you can apply filter on whichever PO No. you want to export.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Export a single purchase in text or excel in NAV 2017

    You can open a purchase order and Export to Excel and then save that file as .csv. Or you need to build an xmlport

  • RE: Export a single purchase in text or excel in NAV 2017

    In text format..

  • Mohsin Abbas Profile Picture
    Mohsin Abbas 525 on at
    RE: Export a single purchase in text or excel in NAV 2017

    Hi

    in which format do you want to export the PO ?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans