Posts

Generate CAR report d365fo

Image
  Commands  Cd C:\ K: C:\cd K:\AosService\PackagesLocalDirectory\bin xppbp.exe -metadata=K:\AosService\PackagesLocalDirectory -all -model=EDF -xmlLog=C:\BPCheckLogcd.xml -module=EDF -car=c:\temp\CAReport.xlsx
Post a Comment
Read more

Power apps basic functions for d365 FO developers

  1.        Power Point basics - https://make.powerapps.com/   Model driven apps -   This type of app used for data entry purpose and to accommodate lot of functionalities and process Ex:- CRM , Projops App e.tc. 2.          Canvas app :-   This type of apps used for mobile/tablet compatibility   which have lesser functionalities and process EX:-   LMS Powerapp e.t.c   1.          Patch funciton -   it is used to trigger the F&O data entity with some data     Ex:-   Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])   2.        SubmitForm function – its   used to trigger the F&o data entity same like above function , But can be used on form only   SubmitForm(Form1);   3.        UpdateContext   - To ...
Post a Comment
Read more

Get Ledger journal transactions payment marked invoices for posted and non posted

// Code from customer payment journal report --CustPaymentJournalDP     private LedgerJournalTable ledgerJournalTable;     private LedgerJournalTable tmpLedgerJournalTable;     private LedgerJournalTrans ledgerJournalTrans;     private LedgerJournalTrans tmpLedgerJournalTrans;     private CustTrans tmpCustTrans;     private CustTrans custTrans;     private CustTransOpen custTransOpen;     private CustSettlement custSettlement;     private SpecTrans specTrans;     private LedgerJournalId lastJournalNum;     private AccountNum lastAccountNum;     private Amount sumPaymSettleAmountCur;     private CustPaymentJournalTmp custPaymentJournalTmp;     private RecId ledgerJournalTransRecId;     private Query query;  while (qr.next())         {             tmpLedgerJournalTable = qr.get(tmpL...
Post a Comment
Read more

SSRS report with multi selection lookups and multi parameters of contract

// Contract  [ DataContractAttribute,     SysOperationContractProcessingAttribute(classStr(KAPDilutionCalcWithParametersUIBuilder)) ] class KAPDilutionCalcWithParametersContract {     List selectedCustAcc;     List selectedItem;     List selectedDiv;       [         DataMemberAttribute('selectedCustAcc'),         SysOperationLabelAttribute("Customers"),         SysOperationDisplayOrderAttribute('1'),         AifCollectionTypeAttribute('return', Types::String)     ]     public List parmSelectedCustAcc(List _selectedCustAcc= selectedCustAcc)     {         selectedCustAcc = _selectedCustAcc;           return selectedCustAcc;     }     [         DataMemberAttribute('selectedItem'),         SysOperationLabelAttribute("Ite...
Post a Comment
Read more

Custom excel add in data entity on office menu in d365fo

 Form should implemetns the following class // Please check Custtable Form  logic  and for more complexity with template need to check LedgerJournalTransCustPaym form logic [Form] public class EMSChargebackBreakupDetails extends FormRun implements    OfficeIGeneratedWorkbookCustomExporter {  const str breakupLinesEntityOfficeId = 'BreakupLinesUnFilteredId';     const str breakupLinesFilteredEntityOfficeMenuId = 'BreakupLinesFilteredId';     OfficeGeneratedExportMenuItem filteredBreakupLinesEntityMenuItem;     OfficeGeneratedExportMenuItem unFilteredBreakupLinesMenuItem;  public void customizeMenuOptions(OfficeMenuOptions _menuOptions)     {        /* var dataEntityEnumerator = _menuOptions.dataEntityOptions().getEnumerator();              while (dataEntityEnumerator.moveNext())         {             OfficeMenu...
Post a Comment
Read more

Get File stream and changes the content and upload file stream again

//Convert downloaded url to string   System.IO.Stream   memoryStream = File::UseFileFromURL(DMFStagingWriter::getDownloadURLFromFileId(_uploadedStatement));                     memoryStream.Position = 0;                     System.IO.StreamReader sReader = new System.IO.StreamReader(memoryStream);                     // Set file contentn string                     str  fileContent = sReader.ReadToEnd();                     container conOld = str2con(fileContent,"\r\n");                     str newFileContent,contentStr;                     int i;                     boo...
Post a Comment
Read more

Create computed column in view or data entity with Sql statement

Image
    public static server str getHasBreakupDetails()     {         str expression;                  expression = '(select count(bl.RecId) from EMSChargebackBreakupLines bl join EMSChargebackBreakupHeader bh on bl.BreakupHeaderRecId = bh.RecId and bh.ChargebackRecId = ' +             SysComputedColumn::returnField(tableStr(SAKChargebacksInquiryView),identifierStr(SAKChargebacks),fieldStr(SAKChargebacks,RecId)) + ')'; // If condition & literal with numbers          return SysComputedColumn::if(             SysComputedColumn::equalExpression(             expression,             SysComputedColumn::comparisonLiteral(0)), SysComputedColumn::returnLiteral(0), SysComputedColumn::returnLiteral(1));     } Other examples public static server str getCBNum(Tabl...
Post a Comment
Read more