Introduction: Purchase Quotation use to purchase items or services, and want to receive competitive offers from multiple vendors. In Purchase quote, vendors provide the prices and delivery times for the quantities of items that they specify. In the Search box, enter Purchase Quotes, and select the related link. Click on new to create new purchase quote. In … Continue reading Purchase Quotation Dynamics NAV →

Introduction: In this article, a workflow response is created in the standard purchase order workflow. This response sends an email to the vendor after release of the purchase order i.e when the send approval request of the purchase order is approved by the authorized approver, the status of the purchase order changes to Released  afterwhich … Continue reading Send Email with attachment to the vendor as a response in Purchase order workflow in NAV 2017 →

Introduction: In my previous blog, I had mentioned the steps required to setup ACH payments to vendors in NAV. For more details of my previous blog, click here. After all the setups are done, the next step will be to Export and Transmit the ACH payment file. In this blog, I will be giving the … Continue reading Automated Clearing House (ACH) payments to Vendor Bank Accounts in Microsoft Dynamics NAV →

Introduction: Transfer order are mainly used for Transfer of inventory from one location to another location. Below are the steps to create transfer Order In the Search box, enter Transfer Orders, and select the link Click on New button to create new transfer order. Select the Location in Transfer from Code field from where you want to ship … Continue reading Transfer Order in Dynamics NAV →

Dynamics NAV 2017 gives the possibility to define own product attributes (e.g. colour or size) and assign them to the corresponding item, so the user can refine and structure his article range much better. Till NAV 2016 Item Categories were a simple List Where we can specify the Categories and some other default parameters but … Continue reading Item Categories in NAV 2017 →

Introduction: Automated Clearing House (ACH) payments to vendors can be done through Microsoft Dynamics NAV. To do ACH payments, setup is required to be performed basically in four areas: Company information, Bank Account card, Vendor card and Vendor bank account. Pre-requisite: Microsoft Dynamics NAV 2017 (North America NA version) Purpose: In this blog, I will … Continue reading Setups required to perform Automated Clearing House (ACH) payments to Vendor Bank Accounts in Microsoft Dynamics NAV →

Introduction: This article gives a step by step process to import a .csv file in Dynamics NAV 2017 for Bank Reconciliation. Pre-requisites: Microsoft Dynamics NAV 2017 Microsoft Excel Steps: 1. Browse to Data Exchange Definition page, and click on new to create a new data exchange setup. This setup enables us to import a specified … Continue reading Import a .csv file for Bank Reconciliation in Dynamics NAV 2017 →

A blanket purchase order is  purchase agreement between the company and a vendor. It typically involves one item with multiple shipments at predetermined quantities, price and delivery dates. Scenario: Purchase person orders 1000 units of item that will be delivered 200 units for each week. Steps: 1) In the Search box, enter “blanket purchase orders”, … Continue reading Blanket Purchase Order Dynamics NAV →

Introduction: This article is to import data from the Excel file into existing NAV table. This import matches the excel entries with the existing NAV table and modifies the records of the table on import of the excel file. To accomplish this, we create a report using Excel Buffer as the DataItem. Pre-requisites Microsoft Dynamics … Continue reading Importing Excel file in Microsoft Dynamics NAV using Excel Buffer →

Introduction: In Microsoft Dynamics NAV, Lookup Form on a field corresponding to a particular selected option of another field can be displayed in the Request page of a report using C/AL code. In this article we are going to see the procedure with the code required to achieve the same. Pre-requisites: Microsoft Dynamics NAV 2017 … Continue reading Displaying Lookup Form on a field based on a particular selected option of another field in Request page of a Report in Microsoft Dynamics NAV →