Export a single purchase in text or excel in NAV 2017

(0) Share

Report

Posted on by anandb313@gmail.com

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

I have the same question (0)

All responses (6)

Answers (0)

Mohsin Abbas 525 on at

Like (0)

Report

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

Hi

in which format do you want to export the PO ?

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

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

In text format..

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,233 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mohsin Abbas 525 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

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');

Was this reply helpful? Yes No
Suggested answer

Mohsin Abbas 525 on at

Like (0)

Report

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.

Was this reply helpful? Yes No