Posts

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

Consume odata/web api d365fo and parsing json content

// Two types of content type url will have usually , //1. normal URL encocoding(means adding parameters in url link)   //2. multiform-data(values needs to specify on webforms to accesss data ) //Check RetailCommonWebAPI and do find references how they are consuming odata API    class ALMMenaiHRMSIntegrationService {     str accessToken,responseJsONData;     RecordInsertList recIns;     public void  getAuthToken()     {         RetailCommonWebAPI  webApi;         str                 rawResponse;         RetailWebResponse   response;         URL loginURL;         str contentType;         Map docFields = new Map(Types::String, Types::Class);         webApi = RetailCommonWebAPI::construct();         loginU...

Get voucher transactions,settlement , and other details from customer , invocie other posted transactions via GJentry and subledger entry

   //From here the code is common for all posted transactions if Project invoice one then we need to join with projinvoicejour instead of vendinvoicejour like this way GeneralJournalAccountEntry accEntry; SubledgerVoucherGeneralJournalEntry subGjEntry ;  LedgerDimensionPreviewTmp   ledgerDimensionPreviewTmpLocal; while select maxof(GeneralJournalEntry) from  subGjEntry                         where subGjEntry.AccountingDate == vendInvoiceJour.InvoiceDate                         &&     subGjEntry.Voucher ==  vendInvoiceJour.LedgerVoucher                          join sum(TransactionCurrencyAmount),LedgerDimension,maxof(Text),maxof(IsCredit) from   accEntry group by accEntry.LedgerDimension               ...

Caller form refresh task refresh #task

    FormDataSource fds;     FormRun fr;         #Task  fr  =element.args().caller();     if (fr != null)    {        fds = fr.dataSource();        PurchTableDlv = fds.getFirst(1);         ttsbegin;         PurchTableDlv.selectForUpdate(true);         PurchTableDlv.update();         PurchTableDlv = fds.getNext();         ttscommit;         fr.task(#TaskRefresh);     }     element.closeOk();                    

Find credit note original sales order on sales order invoice report

 [ExtensionOf(classStr(SalesInvoiceDP))] final class HIGSalesInvoiceDP_Extension {     protected void populateSalesInvoiceHeaderFooterTmp(CustInvoiceJour _custInvoiceJour, CompanyInfo _companyInfo)     {         CustInvoiceTrans custInvoiceTrans,custInvoiceTransOrig;         SalesLine salesLine;         InventTransOrigin  transOrigin,transOriginOrig;         InventTrans inventTrans;         next   populateSalesInvoiceHeaderFooterTmp(_custInvoiceJour,_companyInfo);         salesInvoiceHeaderFooterTmp.BuyerAddress = _custInvoiceJour.deliveryAddress();         salesInvoiceHeaderFooterTmp.BuyerName = _custInvoiceJour.DeliveryName;         salesInvoiceHeaderFooterTmp.CompanyAddress = strReplace(salesInvoiceHeaderFooterTmp.CompanyAddress,"\n",",");         salesInvoiceHeaderFo...

ODATA API test with postman app

Image
  F&O   ODATA   API Consume   through Postman   To consume F&O API , Majorly need follow below steps 1.    Firstly we need to get access token with static URL 2.    And then we need to push data(JSON Body) with access token as a authorization token ,F&O URL   Get   access Token Static URL -    https://login.microsoftonline.com/ Command -   POST Body KEY  VALUE client_id CLIENT ID value from app registration grant_type client_credentials resource D365FO URL client_secret SECRET KEY from app registration         Tenant_id                                will provide from azure app   ...

Integration concepts / patterns d365fo

Image