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!

Finance and operations departments in a company are quite crucial as they help the business to flourish and reach heights. Companies, therefore, should do everything from their end to better the processes in these departments. Using an ERP solution is one of the wisest and best ways to do this job. Dynamics 365 for finance and operations is one of the best enterprise resource planning solutions that you can find in the market. It is one of the best products that Microsoft has created.  They offer some of the best features which you cannot find any other ERP software that you find in the market. But, if you want to enjoy the benefits that come from using this system, you should first learn how to use this software. Here is one more tip that will help you become efficient.  Many of us use Visual Studio for development whether we are developing it Using physical machines or virtual machines. While making any changes to existing code or to save your changes we must have to run VS with administration permission. So every time you right-click on file shortcut and select Run as administrator. So I came up with an inbuilt option in Microsoft Windows operating system after which you don’t have to repeat the steps which are mentioned above. Steps are as follows:- Right-click on your Visual Studio shortcut and select properties. Select the ” Advanced”  option. Tick on Check-Box for Run as Administrator and click on ok button. Click on the “Apply” button. And Then click on the “Ok” button. Now you are all set, Every time you open Visual Studio it will open with administrator permissions.

There are so many different ERP systems in the world. ERP simply means an enterprise resource planning system. While there is stiff competition, Microsoft Dynamics NAV integration is one of the best ERP systems that companies love using. It is because of numerous features that it offers to its clients. One of the reasons why people like it is because this ERP system allows you to sync their ERP with all other systems out there with ease. There is no need to touch any buttons to make this happen. The other name for Microsoft Dynamics NAV is Microsoft Dynamics 365 Business Central. Now, this is one of the many products that are part of the vast Microsoft Dynamics family. Introduction: In this blog, I will demonstrate how to Undo and then Redo Quantity Posting on a Posted Return Shipments in Microsoft Dynamics NAV / Business Central. This functionality is useful if user ships the wrong quantity or selected the wrong item for Purchase Return Order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if purchase credit memo is posted. 1. In the search option, enter Posted Purchase Return Shipment and then choose the related link. 2. Open the Posted Purchase Return Shipment that you want to undo. 3. Select the Posted Purchase Return Shipment Lines that you want to undo.   4. In Lines, click on Function button and choose to Undo return shipment action. 5. Choose Yes in pop up box. 6. A corrective line inserted under the selected Return Shipment Line. 7. The Return Quantity Shipped field on the related Purchase Order will be set blank once undo receipts. 8. Open the return order in question, and then choose the Reopen action. 9. Correct the entry in the Quantity field and Post the Purchase Return Order again. Conclusion: The functionality helps the user to reverse the Purchase return shipment so the user can Post Purchase Return Order with correction.

Introduction: In this blog, I will demonstrate how to undo a Quantity Posting on a Posted Purchase Receipt in Microsoft Dynamics NAV / Business Central. This functionality is useful if the user receives the wrong quantity or selected the wrong item for the Purchase order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if the purchase invoice is posted. 1.    In the search option, enter Posted Purchase Receipts and then choose the related link. 2.    Open the Posted Purchase Receipts that you want to undo. 3.    Select the Posted Purchase Receipt Lines that you want to undo. 4.    In Lines, click on Function button and choose Undo receipt action. 5.    Choose Yes in pop up box. 6.    A corrective line inserted under the selected receipt line. 7.  The Quantity Received field on the related Purchase Order will be set blank once you undo the receipts. Conclusion: The functionality helps the user to reverse the Purchase receipts so the user can post purchase order with correction.

Introduction: In this blog, I aim to provide how to set Mandatory Dimensions on Items, Customers, Vendors, and G/L Accounts and how to optimize this process using Configuration package. Pre-requisites: Microsoft Dynamics NAV. Microsoft Dynamics Business Central. Understanding of Dimensions in NAV / BC Theory: Automatic Dimensions can be added for the G/L Accounts, Customers, Vendor, and Items. The Value Posting can be selected as per the below Table. Value Posting Explanation Blank No posting restriction.Transactions can be posted with any dimension value or without a dimension value. Code Mandatory Any dimension value for the given dimension can be added. If dimension value is blank then NAV / BC will throw an error Same Code Only a single dimension value defined in Default Dimension can be used while posting. No Code Dimensions must not be specified on the transactions.   This also implies that you can add the Default Dimension, No-Dimension, Mandatory Dimension and Manual Dimension only when needed using the Default Dimension functionality.   Solution: 1. Apply Mandatory Dimension on Items: Go to Items > Select the Item and Open Card Page > Click on Dimensions Action. In the Default Dimension Table, Table No. for Items Table is 27 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 2. Apply Mandatory Dimension on Customers: Go to Customers > Select Customer and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Customer Table is 18 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 3. Apply Mandatory Dimension on Vendors: Go to Vendors > Select Vendor and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Vendor Table is 23 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 4. Apply Mandatory Dimension on G/L Accounts: Goto Chart of Accounts > Select the G/L Account and Open the Card Page > Click on  Dimensions Action. In the Default Dimension Table, Table No. for Chart of Accounts Table is 15 which is automatically selected. The value posting is also selected in the table based upon what option is selected. NOTE: You can give multiple Mandatory Dimensions as well 5. Using Configuration Package: In Configuration Package, add the Table 352 Default Dimension and Export the Excel. You can add the dimensions referring to the points 1-4 and insert you data in the Excel. Import the Excel Package and Apply Data. Conclusion: Applying manually for each Master Record can be tedious and time consuming. In this blog I tried to add few sample records so that we can take help of this samples to create our conditions and insert data into Excel and apply it on all the Master Records.

Introduction: The Import from Excel on the Configuration Package page is used to import data from excel.  It can be used to even before a configuration package is created. To avoid confusion and unnecessary retries when using these actions, you can now use the Config. Package Import Preview page to get an overview of the Excel file content to be imported. The page opens when you choose the action and shows the list of configuration packages and tables, organized on different sheets, in the Excel file that you are trying to import. The page also explains if the Import from Excel action will create a new configuration package or update the existing one, and if the action will create new configuration package lines (tables) or update existing ones. Pre-Requisites: Microsoft Dynamics 365 Business Central Steps: To import the Purchase Order Data : Open the Config. Package Card page. Select the table for which you want to import data, and then, on the Tables tab, choose the Import from Excel action. 3. Locate and open the file that you want to import data from. 4. On the Config. Package Import Preview page, review the content that will be imported. The Config. Package Import Preview page provides an overview of the Excel file content to be imported. It also indicates if a new configuration package is created or the existing one is updated, and if new configuration package lines (tables) are created or existing ones are updated. Choose the Import Action. 5. A new Package is created on the List page and the data in the configuration package can be viewed by clicking on the package. Conclusion: Thus, this way the data from the Excel is now imported into configuration package and with the help of Configuration Package Review page the data that is imported can be reviewed and checked.

Problem Statement: While I was working on some custom EFT project, I thought of using XMLPort as it is the safest and easiest method to get the data successfully directly from the tables. Unfortunately, XMLPort is not supported to work on WebClient and I was stuck with writing code to do exactly what XMLPort would do.Also, another issue that Business Central d extension support is using File methods i.e Open, Write, Close, etc.   Introduction: In Business Central even if you’re not given explicit rights to deal with files directly there are streams using which we can be downloaded as files. Enough of introduction, let’s start working now! Pre-requisites: VS Code AL Language Extension Microsoft Dynamics Business Central. Demonstration: 1. Creation of File Contents: In this case, I’ve simply text string ‘Hello World!’ Although it’s perfectly possible to create more complicated strings such as XML contents using a combination of loops and text manipulating functions as needed.     2. Creation of Streams: Using  TempBlob.Blob.CREATEOUTSTREAM(Var_OutStream) initialize the OutStream.       Using Var_OutStream.WriteText(Var_FileContent) write the text to the BLOB       Using TempBlob.Blob.CREATEINSTREAM(Var_InStream) read the contents of BLOB to InStream variable.   3. Downloading the contents of the Streams to a file: Using DownloadFromStream(Var_Instream,FileName.FileExtension) download the contents of the InStream to a file.     Output:   Conclusion: That’s exactly how I was able to create a Custom Text File and download it in Business Central. You can even try with any type of text-based exports.

Introduction to OCR: OCR (Optical Character Recognition) is used to automate the data entry process for vendor invoices When a purchase invoice is received from the vendor, the client stores the invoice either in a file or manually does the entries in excel sheet With the use of Microsoft Dynamics 365 Business Central, invoices can be stored on cloud in the system OCR service setup: OCR service setup needs to be done in order to process the automation which is done through Kofax, which is a process automation software provider. The client should register to avail the following functions at the given price: Trial Basic Premium Documents 75 100 100 Validity(months) 2 1 1 Price (USD) Free $60 $105 Price per extra Invoice No extra invoice after 75 $0.56 $1.12 Specifications: Yes Yes Yes ·         Online correction ·         Header/Footer capture Yes Yes Yes ·         Line item capture Yes No Yes   To avail this service the user needs to get registered under Kofax. (www.kofax.com) Registration process includes providing details such as: name, email, mobile no, Company name, address and so on. Fig 1. Kofax sign up page Once the registration is complete Kofax sends an authorization key to the user on his mentioned email. Fig 2. Registration mail from Kofax The key is later used to send the invoices to the service provider to scan the invoice and receive it back. (without the authorization key, OCR process cannot be completed) Fig 3. OCR service setup OCR process: For mail received invoice save the pdf invoice in the computer and for printed copy of invoice click a picture of the invoice which should be a clear and visible picture. Go to incoming documents in Microsoft Dynamics 365 Business Central. Click My incoming documents Fig 4.  Click on new and then create from file Fig 5. Creating Invoice from File This will ask to choose a file from your computer Choose the file pdf saved earlier in the computer Check all the details of the vendor invoice Click on OCR and then send to OCR service Fig 6. Sending the document to OCR service  Click on receive from OCR service Fig 7. Receiving the document from OCR service The details on the invoice will be entered as per the heads in the document Check all the financial details as per the invoice to verify Fig 8. Checking the financial information Click create document and the document will get stored in the system Fig 9. Creating the document as purchase invoice Check for errors and warnings in the document Fig 10. Checking for errors and warnings To correct the error, click on OCR and under that correct the OCR Fig 11. Option to correct the OCR Correct the mistakes and select “Send OCR Feedback” to send the corrections to the OCR service, so that the mistakes will not repeat   You can check the document in the purchase invoice Open the created document Enter the vendor invoice number for reference which will be star marked Now post the document with an option to print the document as well Fig 12. Final posting of the purchase invoice Check for the document in the posted purchase invoice by searching for the vendor invoice number.