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 20 days ago
    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
    ------------------------------
    Conference-AXUG_200x200


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

    Posted 17 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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

    Posted 17 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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

    SILVER CONTRIBUTOR
    Posted 17 days ago
    Edited by Retha Lambrechts 17 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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