Posts

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

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

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

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

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

Composite data entity datasources insert

Image
  Examples: InventInventoryAdjustmentJournalEntryV2Entity InventInventoryAdjustmentJournalEntryCDSEntity Align the datasources in following way Primary datasource make it line one , So that system automatically inserts the line data and just before inserts the line data we insert the header data public class MCOInventTransferOrdersEntity extends common {        /// <summary>     ///     /// </summary>     public void postLoad()     {         super();         this.ProductName = InventTable::find(this.ItemId).itemDescriptionOrName();     }     /// <summary>     /// Executes logic for optimizing staging data before copy to target.     /// </summary>     /// <param name="_dmfDefinitionGroupExecution">     /// The definition group that should be processed.     /// </param>   ...

Run time add form controls (dynamic) - active financial dimensions dialog form

 [Form] public class HIGUpdateFinDimFromSalesHeaderToLines extends FormRun {     CustInvoiceTable custInvoiceTable;     List finLi,selectedFinLi;     FormBuildDesign        formBuildDesign;     void closeOk()     {         if(!custInvoiceTable.DefaultDimension)         {             throw Error("Dimensions not found on header");         }         else if( custInvoiceTable.InvoiceId)         {             throw Error("Changes cannot be made for invoiced orders");         }         else         {             DimensionAttribute      dimensionAttribute;             DimensionAttributeValue dimensionAttributeValue;     ...