Creating an XML file or CSV file for Purchase Order using code and sending it to vendor's email address

(0) Share

Report

Posted on by Sulav Thapaliya

Hello All,

I have this requirement to fulfill where I have to create either csv file or xml of selected purchase order and that created file should be mailed to the e-mail of vendor presented in that purchase order.I have already created an action in purchase order called "Send Order to Vendor" but how can i write a code to create either csv file or xml file.

Any help will be appreciated

Thanks In Advance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Tina Menezes 2,582 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You have to code in this way to create an csv or xml file.

FileName:=FileManagement.ServerTempFileName('csv');

PurchaseHeaderTable.RESET;

PurchaseHeaderTable.SETRANGE("No.",PONumber);

IF PurchaseHeaderTable.FINDFIRST THEN BEGIN

REPORT.SAVEASEXCEL(405,FileName,PurchaseHeaderTable);

END;

Here FileManagement is a variable of type codeunit FileManagement and FileName is a variable of Text

For attaching in xml format

REPORT.SAVEASXML(405,FileName,PurchaseHeaderTable);

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot Tina

I will try this..

Was this reply helpful? Yes No
Suggested answer

Marcellus 2,735 on at

Like (0)

Report
Copy link

Link copied!

Hi Sulav,

Take a look at these two articles on MSDN:

Walkthrough: Exporting Data from Tables to XML Documents

Walkthrough: Exporting Data from Tables to CSV Files

The two articles will show you how to build your xml port and how to develop a codeunit to execute them

If you have not used XML ports before you may want to look at this too: https://msdn.microsoft.com/en-us/library/dd338846(v=nav.90).aspx

Saurav Dhyani posted a very good article about sending smtp emails from NAV on his blog: https://saurav-nav.blogspot.co.uk/2017/05/microsoft-dynamics-nav-2017-email-from.html

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In addition to my previous answer, if you want to also know the procedure to send email with your .csv or .xml file of selected PO as an attachment, you can refer the below link of Saurav Dhyani.

https://saurav-nav.blogspot.in/2013/08/send-mail-with-attachment-from-navision.html

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

You can use XMLPORT for exporting the data in required format

Was this reply helpful? Yes No