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

Advanced & Auto Bank Reconciliation in Dynamics 365 Finance

Image
  Introduction In any accounting software, it is always important to keep track of all real-time bank transactions and record them in the ERP. Since bank transactions are booked manually in the ERP, it is necessary to ensure that the bank statements and ERP records are matched on any given date. This is where bank reconciliation comes into play. Posted by : Hariharasudan Kandaswamy Reference : Cloud Fronts Bank Reconciliation Bank reconciliation is an activity done by any finance user for the purpose of reconciling book transactions w.r.t bank statements and ensuring that both are as closely matched as possible. D365 Finance offers two ways of performing bank reconciliations. One is by entering the bank statement amount manually and reconciling the ERP statements for each record against the amount. The other is by importing the bank statement into the system and letting the system match the records of the statement against the ERP based on a certain criteria. The blog is made with the
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             && dimensionAttribute.Name != Brand// Exclude specific dimension which should be not editable         join dimAttrSetItem            
Read more