Introduction: In this blog, I will be attempting to highlight on Suggest Vendor Payment functionality in Payment Journals. Pre-requisites: Microsoft Dynamics Business Central Microsoft Dynamics NAV Demonstration: Last Payment Date: This date is the latest date which can be appeared on Vendor Ledger Entries for making the Payment. Entries that have Due Date or Discount Date before the Last Payment Date will be included in Suggest functionality. Last Payment Date Find Payment Discounts: Find all the Payments which will have discounts. If this field is TRUE then Suggest Vendor Payment functionality will include Payments with Discounts as well as Payments without Discounts. Find Payment Discounts Use Vendor Priority: While making payments, if you want to prepare the entries priority wise, then you will need to set the priority of Vendor under the Payments section. Use Vendor Priority   Priority field in Payment Section in Vendor Card By default, the priority is set to 0. If Vendor priority is not set which means that the Vendor Payments are to be processed in Alphabetically FCFS fashion. Available Amount: If the Available Amount is filled in which means that the maximum amount for the payments will be considered. Available Amount Skip Exported Payments: This boolean is used to skip those payments for which the Payment EFT file has been exported. This is generally used where the Payments are not supposed to be posted but the new payments are to be included in the list. Skip Exported Payments Check Other Journal Batches: This boolean field is used to skip all those payments which have already been included in the different General Journal Batches. This will avoid including duplicate payments. Check Other Journal Batches Summarize Per Vendor: This will make a single Payment per Vendor which will be applied to multiple documents. Also, this boolean will create separate payment entries for payments with different currencies. This feature cannot be used in conjunction with ‘Calculate Posting Date from Applied Entries‘ Summarize per Vendor By Dimension: This will create the entries for which the applied document will have the correct dimension. By Dimension Posting Date: Sets the Posting Date for the General Journal Lines. Posting Date is generally set to today’s date or date after the late payment date. Posting Date Calculate Posting Date from Applied Entries: Sets the Posting Date from Applied Entries based upon the Due Date of the Applied Document. Calculate Posting Date from Application Starting Document No.: Starting No. Series for the Payment Journal. This value will be set to Next No. after current Payment Journal Lines have been created in Payment Journal. This field is generally auto-filled. Starting Document No. New Doc No. per Line: This is used to create a separate Document No. for a separate entry line. When this is set to false, automatically a single Document No. is used for multiple entries of a single Vendor. New Doc. No. per Line Balance Account Type: Balance account type can be a G/L Account or Bank. Bal. Account Type Bank Account No. Used to generate only payments from a specific Bank Account. Vendor Filters: Vendor Filters are basically used to get only those payments related to a particular Vendor. Vendor Filters Conclusion: Thus, Suggest Vendor Payments can be a pretty good tool to deal with Payments where you don’t have to manually go and reconcile for the Vendor Purchase Invoices. There are a lot of variants to get the pending Payments with a lot of filters in Suggested Vendor Payments.

Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have changed. For Production the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Productionwhereas earlier the URL https://businesscentral.dynamics.com/<Tenant ID>/ For Sandbox the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Sandbox whereas earlier the URL was the same as current URLThis changes are mainly to distinguish between the multiple Production Tenants coming up in October with the 2019 Wave 2  Release. For now, both the Old and New Production Tenant URLs are operational.If you login through https://home.dynamics.com/  or through Admin Center it will redirect you through the New URL. I will keep you posted as soon as notice an updates. #msdynbc #msftadvocate #businesscentral #changeinurls #msdyn365bc

Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is no way of doing this until you write a code to delete the specific record. I also had a word with Microsoft Support Team who recommend taking this approach. Thus I have created a Generic Record Deletion Tool where you have to put your Table Number and Primary Keys to delete the specific record. Record Deletion Tool : https://github.com/olisterr/Data-Deletion-Tool/blob/master/Report%2050199%20DataDeletionReport.al Pre-requisites: Microsoft Dynamics Business Central Books & References: https://forum.mibuso.com/discussion/6922/how-to-setrange-and-find-a-record-with-recordref-datatype Demonstration: NOTE: This tool is available for free without any warranties. Use it at you own risk. 1. Global Search for the Tool: Searching for the Record Deletion Tool 2. Filter records by Table No. and Primary Keys: Filling in the Table No. and Primary Keys 3. During Record Deletion: Shows the Record Deletion Confirmation 4. After Record Deletion: After the Record is Deleted.   Conclusion: This Record Deletion Tool I have added as an extension to Olof Simren’s Data Deletion Toolkit (https://github.com/olisterr/Data-Deletion-Tool). This tool can be used after Post Go-Live to delete a record in Business Central Production Environment. Also, it can help you browse through the Table Data inorder to find a record. Hope this is useful to you. Let me know in comments.

Introduction: In this blog, how multiple Production Environment works. Prerequisites: Microsoft Dynamics Business Central Yammer subscription( to refer the yammer links ) Books & References: https://www.yammer.com/dynamicsnavdev/threads/360051585302528 Demonstration / Solution: 1. Creation of multiple Production Tenant and Login: Creating a Production Environment with different Localization When system is Preparing a Production Environment When you Login in https://businesscentral.dynamics.com, the system asks you to select the environment to log in If you use the https://businesscentral.dynamics.com/<PRODUCTION ENVIRONMENT NAME>, it directly takes you to the respective environment. 2. How licensing works for multiple Production Tenant.: As per Licensing for October 2019 which states that only One Production Tenant is available. Business Central October 2019 Licensing Guide –  Default Subscription Capacities After a conversation back and forth it was clarified that the licensing will be actually updated by April 2020 Wave 1 Release Refer: https://www.yammer.com/dynamicsnavdev/threads/360051585302528 Taking a level further as per discussion with, we, at CloudFronts have envisioned using multiple localization Production Tenant and then consolidate the Financial Reports. 3. How to leverage Intercompany – multiple localization Production Tenant and then consolidate the Financial Reports: For now, the consolidation of multiple legal entities in multiple Production Tenant is in backlog with no ETA provided. Let us see if we can do it manually in some way. Conclusion: Thus, this blog was just to give information about multiple Production Environment deployments, Default Subscription Capabilities and Intercompany consolidation of multiple production environments. I shall try to manually consolidate multiple production environments in my upcoming blogs.

Inventory Posting Group: Use to specify the type of Inventory or group the item. Inventory Posting setup: Use to combine Inventory Posting group with location codes. Each combination is then mapped to the inventory accounts, WIP account, and other variance accounts relating to inventory in the chart of accounts. Steps: Set up Inventory Posting Group In the search option, enter the Inventory Posting Group and then choose the related link. Select New. In the Code field, type a unique identifier. In the Description field, type description of Inventory Posting Group.   Steps: Set up Inventory Posting Setup In the search option, enter Inventory Posting Setup and then choose the related link. Select New to insert a new line. In Location Code Field, select the relevant location to combine with the inventory posting group. Select the relevant inventory posting group in the Inventory Posting Group Code field. In each relevant account field, enter the G/L accounts that will be used to post transactions to: Inventory Account: Specifies the number of the G/L account that item transactions with this combination of Location and Inventory Posting group posted to. Inventory Account (Interim): Specifies the number of the G/L account to which to post the transactions with the expected cost for items in this combination. WIP Account: Specifies the general ledger account number to which to post transactions for items in WIP inventory in this combination. Material Variance Account: Specifies the number of general ledger account to which Material variance transactions for items in this combination. Capacity Variance Account: Specifies the number of general ledger account to which to post capacity variance transactions for items in this combination. Subcontracted Variance Account: Specifies the number of general ledger account to which to post subcontracted variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post capacity overhead variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post Manufacturing overhead variance transactions for items in this combination.   Steps: Assign Inventory Posting group to Item In the search option, enter Items and then choose the related link. Open the Item card Expand the Cost & Posting FastTab, in the Inventory Posting Group field, enter the appropriate posting group. Conclusion: Inventory posting group and setup use to posts entry to the G/L account specified for the combination of inventory posting group and location code linked to the item line entry.

1. Saving and personalizing list views. Suppose we want to switch between pages and we want to add filters, so to achieve this we have to add filters every time we come back to that page, this feature was not available in the previous version of Business Central but now it has been added by the developers. We can save a combination of filters as our view and access it again and again.   2. Personalize actions and navigation on your Home page With the Business Central Wave 2 Release users can easily add their desired pages to their Role centers, making these pages easily accessible to the user. 3. Design for Extensibility. Users can adjust actions and action groups on their Role Center. Adjust the navigation menu items and grouping on a Role Center. Customize user profiles by designing page changes that will apply only to a specific profile in your extension.

1. Lock-free number series (Allow gaps in Number Series). Users can choose to mark number series to allow gaps in the series. These number series will be non-blocking, which will boost performance. Add notes and links to data Users can quickly add a note to the data they are currently viewing on the Business Central, these notes can be used if a user needs to add some note to the specific page. 3. Customize a user profile without writing code. (New fields have been added, Caption, Description, Use as Default Profile, Promoted). Users need not have to write code to change a user profile, instead, they can make changes to a user profile from Profile only.

Introduction: Recently In Business Central, I have observed the format for General Journals where the unnecessary fields are hidden in order to avoid confusion. Pre-requisites: Microsoft Dynamics Business Central Demonstration: There are 2 Views of General Journal in Business Central. 1. Limited field view: Limited Column View 2. All field view: Full Column View 3. Switching to Limited Field View: Switching to Limited Field View 4. Switching to All Field View: Conclusion: Thus, this limited view from all field view is helpful to avoid confusion during data entering but it has drawback. If you are entering Account No. as G/L Account and want to switch the Customer as Account Type, there is no way of doing it from Limited field view.This is because in General Journal functionality, Business Central automatically selects the Account Type from previous entry causing this drawback.

Docker is an independent container platform that enables organizations to seamlessly build, share and run any application, anywhere from hybrid cloud to the edge. Docker provides the ability to package and run an application in a loosely isolated environment called a container. The following steps shall help you to get Docker in place on your system. Steps: Visit the link- https://www.docker.com/products/docker-desktop, which will direct you to the Dockers website, after opening the link choose the “Download Desktop for Mac and Windows”. Now Create an Account for Docker or Login with credentials if you have an Account. After that go with “Download Docker desktop for Windows” and your download shall start soon. Install the downloaded “.exe” file and you are good to go with Dockers. Now look for “Docker Desktop is running”on your TaskBar with  Docker Icon. Open Powershell, and execute the command “docker info” and you shall see the docker information as below: Hope this helps!

1.Power-full filtering of Reports When running reports on Business Central, Users see a request page where they can add filters, this addition of filters was achieved by customization and coding. With the new Business Central Wave 2 Release users do not have to worry about customizing from the back end. Business Central Wave 2 comes up with hassle-free filtering of reports which is achieved before the report is run. Thus making it more efficient to use. The snapshot shown below is an example of previous report filters. This is how the business central wave has added filters. You just have to click the filters button and you can have multiple combinations of simple and complex filters. 2. Resize columns with fewer clicks. Columns play a major role in Business Central because the data to be displayed is dependent on how much visible that particular column is, In the earlier version of business central it was not possible to increase the width of a column to be displayed. With the new Business Central Wave 2 release, the developers have made it convenient for the users to increase the size of columns just with a single click and mouse drag.   Below is the snapshot of the previous Business Central. This picture shows how the column “Contact” has been increased. Hope this helps!