Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

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

  • 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,640 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans