Author: ERP Consultors

We are leading Giants in the ERP Industry. We are specialists in Microsoft Dynamics NAV, Microsoft Dynamics 365 Business Central, and Microsoft Azure.

How to Install AL code extension in VS Editor

Install AL code extension in VS Editor: Step 1: While connecting VS editor with Business Central D365. First we install extension from the “VS Extension List”. Press “Ctrl+Shift+X” or Press “Extension” button as shown in the figure. Step 2: Type “AL” in the search bar and select “AL Language” from the extension list. Step 3: After …

How to configure GST Setup in Dynamics 365 BC

Configure GST Setup in Dynamics 365 BC: STEP-01: Open company in Microsoft Dynamics 365 Business Central STEP-02: On top of the right side, click on the “India Taxation”. Menu will show in the below screen. STEP-03: Select “Goods and Service Tax” button. Select “Auto Configuration” option. STEP-04: Select “GST Group” option Fill in information according to …

How to Fix 24 Hours or Military Time in BC D365

Fix 24 Hours or Military Time in BC D365: If Time values are -: Time1 = 11:30:00 AM and Time2 = 04:30:00 PM. Use Format property or function to change nature of timing in 24 hours or military timing. Time3 := Format(Time1,0,'<Hours24,2>:<Minutes,2>:<Seconds,2>’). Time4 := Format(Time2,0,'<Hours24,2>:<Minutes,2>:<Seconds,2>’). System will show Time3 is 11:30:00 and Time4 is 16:30:00. How …

How to Calculate the Current Fiscal Year

How to Calculate the Current Fiscal Year? There is no function that will give you the fiscal year. Here’s a code that will get the fiscal year according to the accounting period. Define two date variables Date1 and Date2. Define one record variable “Accounting Period”.  AccountingPeriod.RESET;AccountingPeriod.SETRANGE(“New Fiscal Year”,TRUE);AccountingPeriod.”Starting Date” := WORKDATE;AccountingPeriod.FIND(‘=<‘);Date1 := AccountingPeriod.”Starting Date”;IF AccountingPeriod.NEXT = …

How to Create New Database in Microsoft SQL Server

Create New Database in Microsoft SQL Server: STEP-01: Open Microsoft SQL Server. STEP-02: In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. Right-click on DATABASE and select the option “New Database” STEP-03: Enter the name of the Database. To create the database by accepting all default values, click OK. …

How to Create Purchases and Payables Setup in D365 BC

CREATE PURCHASES AND PAYABLES SETUP IN D365 BC STEP-01: Open Company in Microsoft Dynamics 365 Business Central. STEP-02: On top of the right side, click on the search bar, a pop-up window will open. In the pop-up window search for Purchases & Payables Setup, a drop-down menu will appear. In the drop-down menu, you have to select Purchases & Payables Setup. STEP-03: …