Positive Pay file in D365FO using XSLT File

-
Hi All,
This post regarding PositivePay file preparation using XSLT in D365FO.
The PositivePay Process generates a file that is based on the logic within the transfer file(XSLT)
We can prepare a  Positive pay file in two ways.
1.Using XSLT File
2.Using BankPositivePayExport Class

Once you prepare XSLT file, upload into PositivePay File Formats Form in D365Fo for a particular bank.

Without writing any piece of code we achieve below requirement with the help of XSLT.

There is already sample file available from Microsoft blog but how we can customize as per requirement will see now.

Assume that below is the requirement.
   
Header Format:


Details Format:

                                                                            
Based on the above requirement we need to Prepare the XSLT file.
    
 XSLT File:


 The above XSLT file gives below output:


Limitation: Once you click on PositivePay file option on respective BankAccount.It will give the text file but you need to save manually.

Have a great day!

Thanks.








Comments

Post a Comment

Popular posts from this blog

x++ code to add hyperlink to a field in D365FO

-
Here is a way to provide hyperlink for field. 1.Create an Extension class to the form as below. [ExtensionOf(formStr(TestHistory))] public final class  TestHistoryForm_Extension { } 2.Copy onPostRun form eventhandler and write code as below.     [FormEventHandler(formStr(TestHistory), FormEventType::PostRun)]     public static void TestHistory_OnPostRun(xFormRun sender, FormEventArgs e)     {         FormStringControl   formCtrl = sender.design().controlName(formControlStr(TestHistory,TestHistory_Voucher));         formCtrl .registerOverrideMethod(methodStr(FormStringControl, jumpRef), methodStr(TestHistoryForm_Extension, JumpRefId), sender);     } 3.write definition for JumpRefId method public void jumpRefId(FormControl _formControl)     {         MenuFunction    menuFunction;       ...
Read more

x++ code to get Vendor Email Address based on Purpose in Dynamics 365 for Operations

-
public static  Email   getVendorEmailAddress()     {               VendTable  vendTable;         DirPartyLocation dirPartyLocation;         LogisticsElectronicAddress elecAddress;         LogisticsElectronicAddressRole elecAddressRole;         LogisticsLocationRole locRole;         Str vendNum;              vendNum='205181';//Vendor Number                 select firstonly  DirPartyLocation                     where dirPartyLocation.party ==  VendTable::find(vendNum).Party//Vendor Number             join   elecAddress                     where elecAddress.Location == dirPartyLocation.Loca...
Read more

x++ code to get Customer Address based on purpose in ax 2012

-
static void  customerAddress(Args _args) {     DirPartyPostalAddressView           dirPartyPostalAddrlocal;     DirPartyLocationRolesView           dirPartyLocationRoleslocal;     LogisticsLocationRole                   logisticsLocRole;     select firstOnly   * from dirPartyPostalAddrlocal order by RecId desc         exists join dirPartyLocationRoleslocal             where dirPartyLocationRoleslocal.Location   == dirPartyPostalAddrlocal.Location                 && dirPartyLocationRoleslocal.Party     ==     CustTable::find(_accountNum).Party//_dirpartyRecid                 //&& dirPartyPostalAddrlocal.IsPrimary == NoYes::No         exists j...
Read more