Posts

GST Accounting Period does not exist for the given date error in Microsoft Dynamics NAV when run statistic in purchase order.

 above Particular error comes when Posting Date and Document Date are Blank in purchase order. enter any date then run statistic its work.

HOW TO CONVERT INSTALL.ESD TO INSTALL.WIM ON WINDOWS

  You can use the built-in DISM.exe command line tool to convert an ESD file to the WIM format. Open the command prompt as Administrator and go to the folder containing the ESD file.                                       cd c:\esd The install.esd file can contain several editions of Windows. Each Windows edition in the image file has an assigned index number (1,2,3,4,…). List the available Windows editions in your install.esd image file using the DISM.                         DISM /Get-WimInfo /WimFile:install.esd In this case, the install.esd file contains seven different Windows 11editions, indexed from 1 to 7. In this example, we will extract the  Windows 11 Pro  edition with index  6. dism /export-image /SourceImageFile:install.esd /SourceIndex:6 /DestinationImageFile:install.wim /Compress:max /CheckIntegrity

How to Fix Numeric Keypad Not Working in Windows 10 and 11

 Some times Numeric Keypad not working however num lock key is on. This problem arise because of mouse key on in Ease of Access Center. Here is the step of how to turn off mouse key in Ease of Access Center. Solution Go to Control Panel --> Ease of Access Center --> Make the keyboard easier to use where you find 'Turn Your Mouse Keys' check box under the title of 'Control the mouse with the keyboard'. please untick the check box and then click on apply and ok. Now check keypad will working.

How to Get Data Order by Month Name from SQL

 To Gate Data Order by Month Name You can Use the 'DATENAME' Function for extract Month Name from the Date Column and then use order by clause to sort the result by the month name. as per below example. Select column1, column2, DateName(MM, Date_Column) as MonthName  from Table1 order by month(Date_Column) In this example replace 'column1' and 'column2' with your actual column name and 'Date_Column' with actual column which has date value. Replace Table1 with actual Table. 'DateName'  function is use to extract Month Name from the date_column. Order By clause is use to sort the data ascending and descending order. In above example 'Month' function used for the sorting data by month name like January, February, March. 

How to get month name from date in SQL Server

Image
  There are two function available in MS-SQL Server. 1) DATENAME                We can use DATENAME() function to get Month Name from Date in MS-SQL Server. Syntax                                       2)FORMAT                We can use FORMAT() function to get Month Name from Date in MS-SQL Server. Syntax              

Run Command With Admin Privileges

  There are Two Method for Run Command With Admin Privileges. 1)Click on Start and type "CMD" in windows search where you find "Command Prompt" App. Right Click on "Command Prompt" and Select "Run As Administrator". Then Command Prompt Open with Admin Privileges where you can type command which run with Admin Privileges. 2)Press Win + R on Your Keyboard. In the Run Dialog box type your Command which you want to run with Admin Privileges then Press Ctrl + Shift + Enter and Programme run with Admin Privileges.