Kanika's Tech Blog

In previous blog, Blob was automated through Integration for importing files  but there is also one simple solution if customer wants blob on there system so that he can keep record of files through some commands called AZCopy Commands and then import file to Business Central. AzCopy commands are used to Copy a blob/file from Azure Blob Storage account to local folder. Syntax := azcopy copy "SAS Sinature" "Destination Path" --recursive Steps to perform: 1.Download AzCopy V10 Executable file. 2.Open Cmd and get to path where file has been downloaded. 3.Write azcopy command with SAS Signature which we can create from azure account through Get Shared Access Signature and paste in above syntax. 4. This way it will be downloaded in particular folder. We can automate this through task scheduler so that it can be updated in couple of minutes and customer can import updated file from folder to Business Central. Thanks for viewing!! 😊 You can check out my previous blog ...

Starting with my first Blog, I want to tell you that there may be some flaws but will try to refine it each and every time I write for you guys. So in this post, I have customized a button for importing bank statement on Bank Reconciliation by integrating it with Microsoft Azure Blob through XML Port. Basically  a   Bank Reconciliation  is a process that compares the cash balance on a company’s balance sheet  to the corresponding amount on its bank statement. Although some of the banks are linked online but some are not authorized to do so they either drop statements to some ftp or Azure Portals(or Blob Storage), then we can create a link through integration to import it automatically in Business Central.    Steps to follow: 1. Create a XML Port for the following Bank Statement as shown below: xmlport   50113  BankAcctestReco {     Format = VariableText;     Direction = Import;  ...