Dynamics AX/D365FO Technical

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:                                                                         ...

Links to explore about LCS & D365FO http://d365technext.blogspot.com/ https://sandeepchaudhury.wordpress.com/tag/d365fo/

X++ Code to read XML file in D365FO Hi Guys, The below code will help you to read an XML file from Local File Path and insert into Table.         XmlDocument         xmlDocument;         XMLParseError       xmlError;         XmlNode             rootNode,bodyNode;         XMLNodeList         tagsList;         XmlNamedNodeMap     map;         int                 j;         RecordInsertList    recordInsertListCust;         CustomerTableTmp    customerTabletmp;         Str        fileName =@''D:Temp\customer.XML";                       xmlDocu...

  public void getFinancialDimensions()     {        DimensionAttributeValueSet  dimAttrValueSet;         DimensionAttributeValueSetItem  dimAttrValueSetItem;         DimensionAttributeValue     dimAttrValue;         DimensionAttribute          dimAttribute;         LedgerJournalTable          ledgerJourTable;         VendTable                   vendTable;         CustTable                   custTable;               ledgerJourTable = LedgerJournalTable::find('');//JournalNum         vendTable = VendTable::find('');//AccountNum         custTable = CustTable::find('');//Accoun...

Links for lookup in D365 FO https://community.dynamics.com/ax/b/nareshsdynamicsaxblog/archive/2017/04/27/d365-ax7-form-design-control-level-event-handler-methods-onlookup http://www.prashanthnagaraju.com/2017/07/overriding-onlookup-form-method.html http://axhelper.com/?p=23559

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...

Directing Reports to Email: https://blogs.msdn.microsoft.com/dynamicsaxbi/2012/03/09/how-to-directing-reports-to-email/ PowerBI Links : https://blogs.msdn.microsoft.com/dynamicsaxbi/2016/12/12/power-bi-content-from-microsoft-and-your-partners/ https://blogs.msdn.microsoft.com/dynamicsaxbi/2016/06/23/authoring-and-distributing-power-bi-reports-with-dynamics-ax7/