D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

D365FO Positive Pay file needed i n CSV

  • 1.  D365FO Positive Pay file needed i n CSV

    Posted Sep 27, 2019 10:26 AM
    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: D365FO Positive Pay file needed i n CSV

    Posted Sep 30, 2019 10:00 AM
    Stoneridege software has a descent blog about this: https://stoneridgesoftware.com/exporting-text-format-positive-pay-file-in-dynamics-365-for-finance-and-operations/


    ------------------------------
    Ariff Damji
    LeMans Corporation
    Calgary AB
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: D365FO Positive Pay file needed i n CSV

    Posted Sep 30, 2019 10:08 AM
    Hi,
    Stoneridge has an article about generating Positive Pay text files in their blog.
    How to Generate Positive Pay Text Files in Dynamics AX
    https://stoneridgesoftware.com/how-to-generate-positive-pay-text-files-in-dynamics-ax/

    ------------------------------
    Randall Melonas
    Senior Programmer Analyst
    Decore-ative Specialties
    Monrovia CA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: D365FO Positive Pay file needed i n CSV

    SILVER CONTRIBUTOR
    Posted Sep 30, 2019 11:01 AM
    Edited by Retha Lambrechts Sep 30, 2019 11:02 AM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role