Introduction: In this blog, I will depict how a checkbox can be inserted in an SSRS report. Pre-Requisites: 1. Microsoft Dynamics 365 Business Central 2. SSRS Reports Steps: 1. Create a placeholder in the Table and insert the character mentioned below. 2. Now select the Font as Wingdings. The following set of symbols can be seen on the Report Layout. 3. When the report is run from the Business Central the checkbox can be seen. Conclusion: Thus, by using the following technique checkboxes can be generated in the SSRS report.

Problem Statement: Well, my client is a Trader of Oils & Fatty Acids and has multiple legal entities to perform various sets of operation on the TRUCK-LOAD(a.k.a. Load). One legal entity creates the Load and schedules it, while another manages with the freight requirements. The information is not shared between both the legal entities. Thus, we need to store the data separately.   Pre-requisites: For Microsoft Dynamics NAV: – C/Side Development Environment – Multiple legal entity(Company) setup For Microsoft Dynamics Business Central: – Visual Studio Code – AL Language Extension – Multiple legal entity(Company) setup Solution Design: 1. Create two Tables say LoadCompany1 and LoadCompany2 with same fields 2. Set DataPerCompany property is to TRUE on both the tables. 3. In NAV/ BC, there are common tables but the data into the tables are different. Thus, the system has to manage different version for a single table based on an entity that you’re currently working on. In this case, I need to set data in different tables and synchronize data between them as shown below. Code: 1. In this case, to synchronize data, I’ve used TRANFERFIELDS function. Syntax: DestinationRecord.TRANSFERFIELDS(SourceRecord) 2. To change between working companies for the given table, I’ve used CHANGECOMPANY function. Syntax: Record.CHANGECOMPANY(CompanyName) Output: Inserting Loads Inserting Loads from Table Company1 Load to Company 2 Load   After processing, the system Inserts the Load from Company 1 to Company 2     Modifying Loads: There is an existing Load in Company 2   Modifying the Load in Company1 should modify the Load in Company 2 as well     And that’s how I achieved synchronization of data between two companies in Business Central. In the same way, we can also do the same task in NAV as well. Thanks. Happy weekend 🙂

Introduction: Here, I will demonstrate how a user can add data into reports by themselves from the Request Page in Business Central. Pre-Requisites: Microsoft Dynamics 365 Business Central Steps: Create a report and in the Report Page section enter a text variable which you want to display in the report. requestpage { layout { area(Content) { group(General) { field(Note; Note) { ApplicationArea = All; MultiLine = true; } } } } } 2. Insert this variable on the report layout where you want it to be displayed. 3. Click on the Action and the Request Page opens up where the data in the variable to be displayed on the report can be seen/entered. The user enters the data and clicks on Preview. The data can be seen on the report. Conclusion: Thus, this way user can enter data in report from the request page.

Introduction: While I was testing InterCompany Setup, I faced an issue probably a limitation of the CRONUS standard license which comes with standard NAV/ BC On-Premise installations. Whenever I created new multiple Companies in NAV, I got an error ‘Your program License doesn’t permit support maximum N non-demonstration companies‘. Pre-requisites: Microsoft Dynamics NAV 2018. Microsoft Dynamics 365 Business Central. Solution: I faced this error when I restarted NAV Client after creating a non-evaluation company. Thus, I cannot remove the company from front-end. I tried using Microsoft Documentation and found that it was actually possible (YAY!! 😁). Refer https://docs.microsoft.com/en-us/dynamics-nav/how-to–delete-companies. Instead, it kept ruining things more. The Server Instance would stop without any errors and NAV Windows Client would infinitely work trying to connect to the workspace. Finally, I found that using Windows Powershell with NAV Management module where it was possible to delete the Company from the back-end. NOTE:  1. The database shouldn’t be in Single user mode. 2. The NAV Server Instance should be in RUNNING state. Powershell Commands and Outputs: Recreating the error by creating new companies. Creating a new Company!   Changing to the new Company! Importing the NAVAdmin Powershell module which comes in the package when you install NAV/ BC On-Premise. Getting the list of Companies on the NAV Server Instance using PowerShell Removing the Company for a particular NAV Server instance Conclusion: I tried going into single user mode to delete the company from NAV Windows Client but it didn’t work  

Introduction: What is Admin Center in Business Central on Cloud? How to use it and what are the implications? Admin Center is one of the newest features of Business Central On Cloud. Here, you can manage your environments and performs tasks related to your environment. Demonstration: To goto Admin Centre, visit the URL https://businesscentral.dynamics.com/<TENANTID>admin To visit the Admin Centre you should have the Global Administrator permission in Office 365. Environments: Here you can see a list of Environments. You cannot Create to Delete the production environment. Only you can Create or Delete Sandbox Environments. Viewing details of the Environment: Click on the Environment Name: Upgrade Settings: You can set the Time to auto upgrade your Tenant Environment. Copying of Production on Sandbox: Notification Recipient: Notification Recipient is a person to notify in case there are some things to notify the user about. I thought it was with regards to Sandbox Upgradation but I didn’t get any updates during, before or after graduation. In fact, even when the Sandbox was not working it did not send an email. Telemetry: Telemetry shows the logs of Events that were triggered and shows the list of errors. Telemetry also shows which Codeunits were executed and at what time. This is a cool tool to know if there are any errors occurring when running your sandbox/production. It is like an Event Log for Business Central Conclusion: Thus using Admin Center you can get details about the Business Central. You can manage different environments, copy Production environment into Sandbox and Monitor the environments.

This functionality helpful to correct posted Sales invoice if user make mistake or want to do any changes. You cannot correct posed Sales invoice which are partially or fully paid. In search bar enter Posted Sales Invoice and chose the related link. Select and open Posted Sales Invoice which you want to correct Click on correct button on Posted Sales Invoice form. Once you click on correct then you will get below pop up. Choose yes to continue. New Sales Invoice with same information will be created. Make the changes whichever are required and click on post button to post Sales invoice. In Posted Sales Invoices form, you can check new posted sales invoice. Choose Show Corrective Credit Memo to view the posted Sales credit memo that voids the initial posted Sales invoice.

Transfer order mainly use for Transfer inventory from one location to another location. Below are the steps to create transfer Order In the Search box, enter Transfer Orders, and select the link Click on New button to create new transfer order. Select the Location in Transfer from Code field from where you want to ship the Inventory Select the Location in Transfer to Code field from where you want to receive the Inventory. Direct Transfer: If select yes then the transfer does not use as in-transit location. When you transfer directly, the Qty. to receive field will be locked with the same value as the quantity to ship. Select the Item, quantity on Transfer order lines. If Direct transfer is no then Select the Location in In-Transit Code field which is used for mainly material is shipped from one location but not received in another location. On Action tab, click on post button to ship the Inventory from one location. Select ship in message Box and click on OK. You can check Quantity which are shipped in Quantity Shipped field. Then again click on Post button to receive the inventory in another location. Select Receive in message box and click on OK. You can check transferred shipment in Posted Transfer Shipments. You can check transferred receipts in Posted Transfer Receipts. Conclusion:  Transfer orders involve posting items as shipped from one location and posting them as received at the other location.  

There might be a case where the vendor sends a single invoice for multiple purchase orders receipts, in this scenario we will see how to post one invoice for multiple purchase receipts of the same vendor. You can use Combine Receipt function to Invoice more than one purchase receipt. In search option, enter Purchase order and then choose related link Click on New button to create Purchase Order. Enter all necessary information on Purchase order which are required and click on Post button. Select receive and choose OK button to post purchase receipt. Repeat steps from 1 to 4 to create multiple Purchase order and post purchase receipt. Now in search option, enter Purchase Invoices and choose related link. Click on New button to create Purchase Invoice. Select Vendor in Vendor Name field. On the LinesFastTab, choose the Get Receipt Lines. Select multiple receipt lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added purchase receipt lines. To post the invoice, choose the Post action.    

There might be a case where the company sends a single invoice for multiple Sales orders shipments, in this scenario we will see how to post one invoice for multiple sales shipment of the same customer. You can use Combine Shipment function to Invoice more than one sales shipment. In search option, enter Sales order and then choose related link. Click on New button to create Sales Order. Enter all necessary information on Sales order which are required and click on Post button. Select ship and choose OK button to post Sales Shipment. Repeat steps from 1 to 4 to create multiple Sales order and post sales shipment. Now in search option, enter Sales Invoices and choose related link. Click on New button to create Sales Invoice. Select Customer in Customer Name field. On the LinesFastTab, choose the Get shipment Lines. Select multiple Shipment lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added sales shipment lines. To post the invoice, choose the Post    

Introduction: In this blog, I want to depict how a table structure can be integrated into an Email in Business Central using the HTML tags. Pre-Requisites : Microsoft Dynamics 365 Business Central HTML Steps: Create an Email Structure using the SMTP Mail setup Codeunit and pages. The body that is to be attached to the Mail will be the table structure that will be created using HTML tags. The HTML tags used are as follows: <th> : To create the heading for the table <tr>: To create the rows for the table <td>: To input the data for the table Code for the table structure and mail is as follows: SMTPSetup.CreateMessage(”, SMTPMailSetup.”User ID”, Rec_Contact2.”E-Mail”, ‘Scheduling Report’, ”, TRUE); SMTPSetup.AppendBody(MailBody); SMTPSetup.AppendBody(‘<br>’); SMTPSetup.AppendBody(UserDetails); SMTPSetup.AppendBody(‘<br>’); SMTPSetup.AppendBody(‘<table border=”1″>’); SMTPSetup.AppendBody(‘<tr>’); SMTPSetup.AppendBody(‘<th>Purchase Conformation</th>’); SMTPSetup.AppendBody(‘<th>Vendor Name</th>’); SMTPSetup.AppendBody(‘<th>Vendor Ref:</th>’); SMTPSetup.AppendBody(‘<th>Product Name</th>’); SMTPSetup.AppendBody(‘<th>Estimated PU Date</th>’); SMTPSetup.AppendBody(‘<th>PU Date</th>’); SMTPSetup.AppendBody(‘<th>PU Time Begin</th>’); SMTPSetup.AppendBody(‘<th>PU Time End</th>’); SMTPSetup.AppendBody(‘</tr>’); SMTPSetup.AppendBody(‘<tr>’); SMTPSetup.AppendBody(‘<td>’ + Format(“Blanket PO No.”) + ‘-‘ + Format(“Blanket PO Line No.”) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(Name) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(VSO) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(ProductName) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(EstPUDate) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUDate) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUStartTime) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUEndTime) + ‘</td>’); SMTPSetup.AppendBody(‘</tr>’); SMTPSetup.AddCC(Rec_UserSetup.”E-Mail”); SMTPSetup.Send; 3) The table output looks as follows when the mail is sent:               Conclusion: Thus, using the basic HTML table tags a table structure can be integrated into the Email functionality of Business Central.