Tuesday, 25 November 2025

Integrate ๐Ÿค– GitHub MCP Server in VS Code

๐Ÿš€ Using GitHub MCP Server in VS Code

Overview

This guide explains how to configure GitHub MCP Server inside VS Code so Copilot can interact with GitHub — such as listing repositories, creating branches, and creating pull requests — all through chat.

GitHub CLI (gh) is not required for this setup. 

✔ Prerequisites

Requirement                           Status
Visual Studio Code                 Installed
GitHub Copilot Extension      Installed
GitHub Account                      Required

๐Ÿ” Step 1 - Create PAT (Personal Access Token)

  1. Open: https://github.com/settings/personal-access-tokens?type=beta

  2. Click Generate new token

  3. Select Fine-grained token

  4. Repository Access → choose:
    ✔ All repositories
    or
    ✔ Specific repositories (recommended for security)

  5. Under Repository permissions, enable:

        Permission Access
            Contents     Read and write
            Administration     Read and write
     6. Click Generate toke
     7. Copy & save the token securely 
         (you will enter it later in VS Code)

๐Ÿงฉ Step 2 - Add MCP Configuration to VS Code

  1. Press: Ctrl + Shift + P

  2. Search:
    Open User MCP Settings (JSON)

  3. Paste this JSON and Save:

{
  "servers": {
    "io.github.github/github-mcp-server": {
      "type": "http",
      "url": "https://api.githubcopilot.com/mcp/",
      "headers": {
        "Authorization": "${input:Authorization}"
      },
      "gallery": "https://api.mcp.github.com",
      "version": "0.21.1"
    }
  },
  "inputs": [
    {
      "id": "Authorization",
      "type": "promptString",
      "description": "Authentication token (PAT or App token)",
      "password": true
    }
  ]
}

    

๐Ÿ”„ Step 3 - Reload VS Code

Use any option:

  • Press Ctrl + Shift + PReload Window

  • OR restart VS Code

VS Code will ask for:

Authorization Token

Paste the PAT you created earlier.


๐Ÿ” Step 4 - Allow MCP GitHub Tools (Safest Option)

When prompted:

⚠ Allow Tools from GitHub MCP Server?

Choose:
Allow Tools in this Session (best for security)

This ensures MCP is only active when you want it.

๐Ÿš€ Step 5 — Test in Copilot Chat

Open Copilot Chat and run: /tools

If the setup is correct, you will see GitHub actions like:

  • listRepositories

  • createRepository

  • getFileContents

  • createPullRequest

๐Ÿงช Example Command
 Create a private repository named "First-MCP" with a description "Repository created via Copilot"

 Note: if you failed to create a repo, then add more permissions on PAT, regenerate the Token, and save.

๐Ÿ›‘ Troubleshooting

Issue Cause Fix
403 Resource not accessible by PAT Token missing Admin or Contents access Update token permissions
No tools found VS Code didn't reload MCP config Restart / Reload Window
Token prompt missing Wrong JSON file edited Check Open User MCP Settings (JSON)
gh command not found GitHub CLI not installed Ignore — not required


Copilot MCP will:

  1. Connect to the GitHub MCP server

  2. MCP will assist with code-level corrections, completion of code, and create an AL object with NLP

  3. Create an issue, pull the repo, commit object/code, and merge via Copilot

  4. Issue Respond with:

    • issue number

    • issue URL

    • status confirmation


Copilot Chat in VS Code
No CLI, no terminal — just natural language.

Monday, 25 September 2023

Troubleshooting EDI: How to Keep the Data Flowing Smoothly


"Electronic Data Interchange (EDI) is a technology for exchanging business documents electronically between trading partners. It streamlines workflows, reduces errors, and improves efficiency. However, EDI connections can encounter problems. To troubleshoot, businesses can check network status, review EDI logs, verify EDI data, test the connection, communicate with trading partners, and monitor the connection. Here are some tips on how to troubleshoot EDI connections and resolve common issues."

Common EDI Connection Issues

Before we dive into troubleshooting, let's understand some common EDI connection issues. These include data transmission failures, partner setup errors, and format mismatches. Each of these issues can disrupt operations and impact customer satisfaction.

Preparing for Troubleshooting

To troubleshoot EDI connections, check the network status of your own and your trading partner’s system. Use commands like ping, traceroute, or telnet to test connectivity and latency. If there are network issues, contact your network provider or your trading partner’s network provider. Check firewall settings and make sure EDI ports are not blocked or restricted. There are multiple ways to connect the system like SFTP, HTTP, AS2, FTP, Etc. Data transmission failures, partner setup errors, and format mismatches can disrupt operations and impact customer satisfaction. Also, Refer logs are key to understanding if it's a "Connection" issue OR a "Data layer" issue.

Troubleshooting Steps

  1. Identifying the Problem: The first step is to pinpoint the exact issue. Is it a technical problem or a configuration error? Understanding the nature of the problem before proceeding.
  2. Analyzing Logs: The second step in fixing EDI connections is to review the EDI logs of your own and your trading partner’s system. The logs provide information about the status, errors, and messages of transactions and documents. Use commands like ping, traceroute, or telnet to test connectivity and latency. Look for anomalies, discrepancies, or failures and identify the root cause. Compare the logs with expected specifications and standards.
  3. Verify the EDI data: The third step in fixing EDI connections is to verify the EDI data of your own and your trading partner’s system. The data refers to the content and format of transactions and documents. Use any tools like EDI Mapping or EDI Translators available in the market to verify the data. Check for errors, inconsistencies, or missing information and correct them. Ensure the data matches agreed-upon requirements and rules.
  4. Test the EDI connection: The fourth step in fixing EDI connections is to test the EDI connection of your own and your trading partner’s system. The connection refers to the method and protocol of transmission and processing. Use any tools available in the market for EDI Testing or EDI Simulator to test the connection. Test different aspects of the EDI connection, including message validation and data mapping. This helps you isolate the problem and test potential solutions.
  5. Communicate with your trading partner: The fifth step in fixing EDI connections is to communicate with your trading partner and coordinate efforts. Share the results of your troubleshooting and ask for feedback and assistance. Agree on best practices and procedures for resolving issues and preventing recurrence. Maintain clear communication with your trading partner and document actions and outcomes.
  6. Monitor the EDI connection/ transaction: The sixth step in fixing EDI connections is to monitor the EDI connection of your own and your trading partner’s system. Track the status, performance, and quality and report anomalies or problems. Evaluate the effectiveness and efficiency of the connection and look for ways to improve it.

Best Practices:

  • Maintain up-to-date documentation: Ensure that you have accurate records of your EDI configurations and partner information.
  • Regularly monitor EDI systems: Implement monitoring tools to catch issues before they escalate.
  • Implement redundancy and failover solutions: Redundancy ensures that your EDI connections stay operational even in the event of a failure.
  • Establish a support team: Create a dedicated team responsible for addressing EDI-related issues promptly.

Real-life case study:

In this scenario, the medium-sized manufacturing company and the major retailer have established a successful business relationship through the use of EDI. The EDI connection allows for seamless exchange of orders, invoices, and shipment notifications, which helps to manage the supply chain and fulfill orders efficiently and accurately. By following the troubleshooting steps and collaborating closely with their trading partner, the company was able to quickly identify and fix the issue, avoiding disruptions and maintaining customer satisfaction.

Conclusion

In conclusion, troubleshooting EDI connections may seem complex, but with the right approach, it can be manageable. By following these steps and best practices, you can not only diagnose and resolve issues swiftly but also enhance the reliability of your EDI connections.

Wednesday, 20 June 2018

Sales Invoice Creation thorough Jobs and resources.

Sales Invoice Process

Create Masters

Job Card

To create New Job, click on Financial Managementร Job ( Click on New Button)

Job Card

Mandatory Fields on Job card
  • ·         No.
  • ·         Description
  • ·         Bill-to Customer No. (Bill- to Name, Bill -to Address should flow from Customer Card)
  • ·         Invoicing Type = FMB
  • ·         Job Posting Group = REV-ON

Attach 16 Dimensions on Job Card

We attach 16 Dimensions on Job card so that they can flow on Sales Invoice.
To attach 16 Dimensions, click on Dimensions button available under Navigate section of Job header.

Job Card

Dimension Card

Create Job Tasks

If there are multiple sub contracts available under Main contract, we create multiple Job tasks (per one subcontract). In NTI case, we need to create only one Job task per job.
  • To create Job task, click on Job Task Lines button under Home section

Job Task Create
Job Task Lines
Mandatory fields on Job Task Lines
  • ·         Job Task No: = Job No
  • ·         Description = Project Name

Create Resources

To Create New Resource, click on Resources ร  New Button
Resource Card
Mandatory Fields on Resource card
  • ·         No: = Work type code
  • ·         Name: = Work type Name
  • ·         Type: = Person
  • ·         Base Unit of Measure: = PH
  • ·         Gen. Prod. Posting Group: = ( as per nature of resource)

Transactional Details

Create Job Journal Lines

For each line of invoice, we need to post separate Job Journal Line.
To create Job journal lines, click on Departments ร Jobs ร Tasks ร Job Journals
Job Journal
Job Journal Lines

Mandatory Fields on Job Journal Line (Please arrange fields on below sequence for your convenience)
  • ·            Line Type: = Contract
  • ·         Posting Date: = Sales Invoice Date
  • ·         Document No: = Auto Populate
  • ·         Job No.: = Project Code
  • ·         Job Task No.: = Project Code
  • ·         Type: = Resource
  • ·         No.: = Work type Code
  • ·         Description: = Work Type Name
  • ·         Description2: = (You can keep it blank)
  • ·         Unit of Measure: = PH
  • ·         Quantity: = (As per detail)
  • ·         Unit Price: = (As per detail)
  • ·         Line Amount: = Auto populate
  • ·         Gen. Bus Posting Group: = Gen
  • ·         Gen. Prod Posting Group: =  ( Auto populate from Resource card)
  • ·         Sub Contract: = (should be unchecked)
  • ·               Task type: = Main Task
   If there are 3 lines for a invoice, you need to create 3 lines in one go, select 3 lines and post them together.

      Create Sales Invoice through Job Planning Lines
        
          The lines which are posted from Job Journals will be stored in Job planning lines
          To open Job planning lines, click on Job ร  Job Task Lines

Jobs
       
     Select a Job task and click on Job Planning Lines
Job Planning Lines
     Click on OK.
Sales Invoice
      Note: Sales invoice is generated by above process, you can find generated sales invoice in list.
      16 Dimensions have been assigned on the invoice by Navision.


Tuesday, 22 May 2018

Installation of Dynamics NAV 2016

How to Install Dynamics NAV 2016 Client 

This guide will show you how to install the Dynamics NAV 2016 Client with or without the Development Environment.


1. Navigate to the installer, right click and select “Run as Administrator”.

2. Click “Next >”.

3. Click “I accept >”.

4. Click “Choose an installation option”.

5. Click on “Customize …” below the “Client” option.

6. If you just want the Client installing, click “Next >” and go to step 7.
If you want the Development Environment as well, carry on to step 6a
.

6a. Expand the Client option >> click on the dropdown for “Development Environment (C/SIDE)” >> click “Run from My Computer” >> click “Next >”.

7. Here you can select what service Dynamics NAV 2016 will connect to. If you want to skip this step if you already have it set up, by filling in: Server Name, Service Name & Client Services Port. If you have Help Server connections details as well, carry on to step 7a. If not, click “Apply” and skip to step 8.

7a. Scroll down and enter the Server and Port for your help server. Then click “Apply”.

8. Installing.

Note: A command prompt screen may pop up for a brief moment. No action is needed.

9. The Installation will then be complete and you can click “Close”.


Tuesday, 6 March 2018

Navision Objects

Navision Object

Basic Objects in MS Dynamics NAV

   There are seven objects in Navision. which is used by developers, as a developer you can edit existing objects and create new objects that is based on that are already in the system.

Seven objects in NAV are:
  1. Table: It describes how data is stored in the database and how it is retrieved. table is the most important object because most objects types are depend on them.
  2. Page: It enable user to view, add, change or delete record in a table.
  3. Report: It display and print summarize information. Use report to print documents such as invoice.
  4. Codeunit: It is an organized block of programming code, it manage by single process. Codeunits are similar to containers for code. it can hold functions that are repeatedly used throughout large application projects. 
  5. Query: It Defines relational data model for efficient querying of underlying Microsoft SQL Server database.
  6. XMLPort: XMLport object that can use to export data from or import data into Microsoft Dynamics NAV 2016. XMLport can manipulate the data in XML format or text format.
  7. Menusuits: MenuSuites contain menus that enable users to navigate and perform actions in the Microsoft Dynamics NAV Windows client.
Object Designer 




See more: Navision Objects 


Monday, 19 February 2018

#1 Dynamics NAV - Table Object

Table Object In NAV 2013 R2

Table Overview

         Tables are the most fundamental objects in Microsoft Dynamics NAV. They store records that are collected through pages. for example customers, sales, and inventories. These records are then presented to users through pages and reports.

About Table
       Records in Microsoft Dynamics NAV databases are stored in tables. A table can be visualized as a two-dimensional matrix, consisting of columns and rows. Each row is a single record, and each column is a field in that record.
    A table consists of table data and the table description. The table data contains the actual records and their fields. The table description specifies the layout and properties of the table and the fields.
     The table description is not directly visible to the user. When a developer creates a table, he or she assigns the table name, ID number, and fields. This establishes the table description.
      Field characteristics, such as field name, ID number, data type, and initial value together with the primary and secondary keys (used to sequence data) are also part of the table description.

    The table description contains properties, triggers, fields, and keys. The “Table Components and Their Relation” figure shows components of the table description and how they are related.
Table Description


Properties of Table

  Field No, Name, Caption, CaptionML, Datatype, Field Class, Min-Max Value, Table Relation, EDT(Extended data type), Width, etc
  this are important properties to work on table object.

Data Type

BLOB, Boolean, Code, Date, Decimal, Integer, Option, RecordID, Text, TableFilter, etc.

How to create Table in Object designer:

Steps:
  1. Go-to tool menu: > Click Object Designer> Click table object> New table
  2. In table window appears has fields that enters data in fields i.e
               1) Field No.
               2) field Name 
               3) Data Type & Length
               4) Description 
   and Save Table ID & Table Name.

Customer Table in Table Designer

Customer table and its Property 

Save the ID of table in between 50,000 to 90,000 any where save. this are customize tables & other table ID's are standard tables i.e parent level tables OR predefined tables.

Save the table and run it(Ctrl+R)


Saturday, 10 February 2018

Its all About Navision !

About Microsoft Dynamics NAV...

Defination: NAV is an ERP software suit for midsize organization, The NAV system offers specialized functionality for manufacturing, Distribution, Government, Retail, & other industries.

Versions of Navision:
  • Dynamics NAV 2009: 2009, 2009 R2
  • Dynamics NAV 2013: 2013, 2013 R2
  • Dynamics NAV 2015: 2015
  • Dynamics NAV 2016: 2016
  • Dynamics NAV 2017: 2017
  • Dynamics NAV 2018: 2018

NAV 3- Tier Architecture:

1) Roletailored Client: RTC is the client tier, which includes a NAV windows client and web client.
2) Nav Server: Nav Server is the middle or server tier, which managing all bussiness logic and communication.
3) SQL Server: SQL server is the R2 database components, is the data tier. the database tier consists of an application database.

NAS (Navision Application Server)
   NAS is a .net-based windows service application that manages communication between NAV Client & NAV database is SQL Server.

C/SIDE and C/AL:
  C/SIDE - Client/Server Integrated Development Environment
        C/AL is the programming language that used within the development environment for Microsoft Dynamics NAV, and the development environment is called as C/SIDE.  
  C/AL - Client/Server Application Language 
        C/AL is a database specific programming language and it primarily used to retrieve, insert, and modify the records in the dynamics NAV Database.

Object Designer 

       Object designer area which contains 7 objects through development and access to all the application object.
There are 7 object in NAV
        1. Table                                          
        2. Page                                           
        3. Report                                       
        4. Codeunit
        5. Query
        6. XMLport
        7. Menusuit

RoilTailored Center | RTC Client Side 

Object Designer