Script to import Bacpac (Tier 2(SIT,UAT) ..Tier 5(prod) DB in Tier 1 instance -D365F&O

 Command to import bacpac file in Tier 1 instance

SqlPackage.exe /a:import /sf:H:\hari\D365Fobacpac\Sandboxbackup.bacpac /tsn:localhost /targetTrustServerCertificate:True /tdn:AXDB_UAT /p:CommandTimeout=24000 /TargetEncryptConnection:False


Posted by : Hariharasudan kandaswamy


Comments

Post a Comment

Popular posts from this blog

Create a Tile in a D365FO Workspace with X++ - Microsoft Dynamics Finance and operations

Image
  Tiles : There are two ways through which we can create tile one by personalizing form and another through code. In this example   we’ll use code The diagram below  summarizes the operations we will perform to add a tile to a workspace Posted by : Hariharasudan Kandaswamy These are the steps we’ll do : Create an AOT Query object Create a simple list form to show the query results Create a menu item to call the form Create a tile to call the menu item Add the tile to a workspace Create an AOT Query object Create a project and add a query called “ DeliveredSalesOrdersQuery ” Add SalesTable as datasource in “ DeliveredSalesOrdersQuery ”. Set dynamic fields property to “Yes” Add range in it for showing sales orders whose status is delivered. Save the Query Create a simple list form to show the query results Add a  Form  object and call it “ DeliveredSalesOrderInquiry “ Add  DeliveredSalesOrdersQuery  as Form Data Source Apply  “Simple list”   pa...
Read more

X++ Code to fetch GST, SGST, IGST Sales amounts in D365FO -Indian GST calculation logic

 X++ Code : Syntax : this.calcGST("GSTTYPE" , InvoiceId) GST  Type : SGST,CSGT,IGST Assigning logic : this.calcGST(" SGST ",_ewaybillsales.invoiceid); Core Code Logic : public container calcGST(str _Type ,Invoiceid _invoiceid)         {             TmpTaxDocument tmpTax;             SalesCalcTax PurchCalcTax;             SalesTotals salesTotals;             ITaxableDocument taxableDocument;             ITaxDocumentComponentLineEnumerator lineEnumerator;             ITaxDocument taxDocumentObject;             ITaxDocumentMeasure taxMeasure;             ITaxDocumentMeasureEnumerator taxMeasureEnumerator;             ITaxDocumentMeasureValue partyTaxMeasureValue;       ...
Read more

Disable editing of specific financial dimensions on form -Microsoft Dynamics Finance and operations(D365FO)

Posted by : Hariharasudan kandaswamy [FormEventHandler(formStr(Custtable), FormEventType:Initialized)] public static void Custtable_OnInitialized(xFormRun _sender, FormEventArgs _e) {     DimensionEntryControl dimControl = _sender.design().controlName(identifierStr(DimensionEntryControlTable));     DimensionEnumeration dimensionSetId = DimensionCache:getDimensionAttributeSetForLedger();     DimensionAttributeSetStorage dimensionAttributeSetStorage;     DimensionAttribute dimensionAttribute;     DimensionAttributeSetItem dimAttrSetItem;     const str Department= 'Department';     const str Brand= 'Brand';     dimensionAttributeSetStorage = new DimensionAttributeSetStorage();     while select dimensionAttribute         where dimensionAttribute.Name != Department // Exclude specific dimension which should be not editable             && dimensio...
Read more