Posts

Table find method to find item id's in x++

   static BASTradeAgreementTable find(ItemId          itemId,                            boolean          _forUpdate = false,                            ConcurrencyModel _concurrencyModel = ConcurrencyModel::Auto)     {         BASTradeAgreementTable  basTradeAgreementtable;         if (itemId)         {             if (_forUpdate)             {                 basTradeAgreementtable.selectForUpdate (_forUpdate);                 if (_concurrencyModel != ConcurrencyModel::Auto)                 {             ...

Reporting capabilities

Image
  As a developer, we might need to develop reporting to meet the needs of the business.    Therefore, we should understand the types of reporting in finance and operations apps and their capabilities so that we can determine the type of report that should be developed. Several reporting options are available for us to use, including SSRS, Power BI, and Financial Reporting question :  Which component belongs to which model?

Development and deployment process

Image
  **** All developers for the application work in an individual environment that includes the Visual Studio application. As a reminder, Visual Studio is the integrative development environment (IDE) that is used to develop for Dynamics 365. **** Deployable packages are created in Visual Studio and then deployed to sandbox, test, and production environments by using Lifecycle Services. When finishing your code and customizations in Visual Studio, you must make a few considerations. If several developers are on one project, you should perform a Get Latest process to merge all new code that has been checked in by the other developers, and then perform a local build to ensure that your code will not disturb what is in the Azure DevOps repository. When both processes have been performed, you can check in your code by using Team Explorer, which is connected to Azure DevOps. The code that is checked in will be built in Azure DevOps by using a build pipeline, and this will create a deploya...

X++ code to create sales order with dialog box parameters (Customer account number , site id, warehouse id , item number ) in D365 F & O

 final class BASSalesOrderCreation extends RunBase {     DialogField CusAccount, itemNumber, inventSiteid, inventLocationid;     CustAccount custAccount;     ItemId itemId;     InventSiteId SiteId;     InventLocationId LocationId;     SalesTable salestable;     Object Dialog()     {         Dialog dialog;         dialog = super();         // Set a title fordialog         dialog.caption( 'Sales Order Creation');         // Add a new field to Dialog         CusAccount = dialog.addField(extendedTypeStr(CustAccount), 'Customer Account' );         itemNumber = dialog.addField(extendedTypeStr(ItemId), 'Item Number' );         inventSiteid = dialog.addField(extendedTypeStr(InventSiteId), 'Site ID' );         inventLocationid = dialog...

classification of main accounts in d365 F & O

 classification of main accounts:   Asset   account                     liability account                     Expense   account                       Revenue account 100000-199999                         200000-299999                               300000-399999                            400000-499999 All Asset accounts should have a specific mandatory financial dimension which is a cost centre . All Liability accounts don't need any specific dimensions All Expense accounts should have a specific mandatory financial dimension whic...

Creating own legal entity and number sequence automatically in d365 F & O

 To Create a legal Entity go to organisation administration -> organisations -> legal entities Step1: Click on New Button. Step2: Give Company name (Sarath Technologies Pvt Limited), Legal Entity name (SKR) , country or region   (India) where the company is located. step3: click on Ok . This is how we can create our own legal entity in d365 f & O. To create number sequence for the legal entity go to Organisation administration -> number sequences -> number sequences  Under number sequence action pane there is a button group called New In that select Generate Button. Now a wizard screen gets opened. click on next and then next and then click on finish . our number sequence has been created for the new legal entity.

Financial Dimension -OverView

 Financial dimensions are present in DimensionAttributeValueSet table. DimensionAttributeValueSet is the main table where it contains business unit value, cost center value, DEPARTMENTVALUE,ITEMGROUPVALUE and so on ............ Item numbers are present in invent table . Product names are present in ecoresproduct table. sql query to fetch financial dimension values for a particulat item (product): select b.BUSINESSUNITVALUE,b.DEPARTMENTVALUE,a.ITEMID,b.ITEMGROUPVALUE,b.BUSINESSUNITVALUE from INVENTTABLE a join DimensionAttributeValueSet b on b.RECID = a.DEFAULTDIMENSION where ITEMID='0001';  ****** we can add custom dimension values to the standard financial dimensions for that go to   organisation administration ->  organisations -> operating units in Operating units we can add custom dimension values to the standard financial dimensions.