Marie you can open the XML in Excel and then save it as a CSV keeping in mind that Excel will change the amount and date formats to its default. If you need that in a specific format for the bank then you have to modify it before saving it as a CSV file.
I also followed the Stoneridge option but it still didn't save the file for me as a ".CSV" file. I had to do a modification in the code by extending class
BankPositivePayExport, method getFileExtensionFromURL:
protected str getFileExtensionFromURL(SharedServiceUnitURL _sourcefile)
{
str fileExtLocal = next getFileExtensionFromURL(_sourcefile);
if(fileExtLocal)
{
fileExtLocal = ".csv";
}
return fileExtLocal;
}
Please note that the above method was for us only extendible from v10 PU28.
------------------------------
Retha Lambrechts
The Master's Craft Flooring Company
West Plains MO
------------------------------
Original Message:
Sent: Sep 27, 2019 10:25 AM
From: Marie Walters
Subject: D365FO Positive Pay file needed i n CSV
Hello,\
I am trying to set up positive pay. I have set it up per the instructions provided by Microsoft and have used the XSLT file example they provided. My issue is that our bank (Regions) requires that format of the file sent to them be in CSV. When I use the example XSLT file from Microsoft, the file output is XML. Has anyone had the same issue and have a fix for this?
#FinanceandOperations #Technical #Focus-D365UG/AXUG
------------------------------
Marie Walters
GSP Marketing Technologies
------------------------------