Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Overview

This document is a quick reference how to work with Vendors in NAV. Vendor cards provide information about your suppliers. Vendor card is the centre of all tasks in the purchase process.

How to find

Navigate to Vendors using the search box and choose related link

Click on the +New button

For creating new vendor is important to choose Vendor Nos. in Purchases & Payables Setup.

If there is some configuration template set up, a list of templates come into view. Choose one of them. After these steps, empty vendor page appears.

Vendor Fast Tabs

Vendor card is divided into five Fast Tabs. Now, we will go through all of them.

General

Name

The name of the vendor is defined here.

Blocked

You can choose two options in this field:

  • Payments – choose it to disallow payments to vendor.

  • All – choose it to forbid all operations with vendor (including creating purchase orders etc.

Privacy Blocked

When you receive such a request from a vendor, you can mark his record as blocked due to privacy. Dynamics NAV will then discontinue the processing of that data subject’s personal data. When a record is marked as blocked, you cannot create new transactions that use that record.

Last Date Modified

This field contains date of last vendor card edit.

Balance(LCY)

You can see here total opened balance with this supplier. This number is the sum of all opened remaining amounts in Vendor Ledger Entries. Amount is in local currency.

Balance Due(LCY)

You can see here total overdue amount. This number is the sum of all overdue opened remaining amounts in Vendor Ledger Entries. Amount is in local currency.

HINT: You can add date filter by activating Limit Totals To with clicking first on Balance Due (LCY), than pressing Ctrl + Shift + F3 and change the view date. Now, you can see, which amount will be overdue e.g. next week.

Document Sending Profile

You can choose Document sending profile, but first of all, profiles have to be set up.

Search Name

In default field Name is copied here, but you can change it as needed.

IC Partner Code

The field is needed to Intercompany Communication (Extended package needed.) If this vendor is your intercompany partner, you should choose here code to set up intercompany transactions sending.

Purchaser Code

Specifies which purchaser is assigned to the vendor.

Responsibility Center

Specifies the code of the responsibility center, such as a distribution hub, that is associated with the involved user, company, customer, or vendor.

Address & Contact

This FastBox is used to enter contact information about supplier and his primary contact.

Address

Specify the vendor’s name.

Address 2

Specify additional line for vendor’s address.

Post Code

If you can find the required postal code in the Post Codes list, choose one. If not, you will have to create new one, see picture below.

Please, fill in all fields with asterisk. Country/Region Code will be filled in automatically if field Country/Region Code on vendor card is filled before that.

City

This field specifies a valid city. It’s filled automatically after choosing Postal Code from the Postal Codes list.

Country/Region Code

Choose valid Region Code. It’s filled automatically after choosing Postal Code from the Postal Codes list.

HINT: Try to fill in Country/Region code first of all address details. After that only Postal codes for required Country/Region code will be visible.

Show on Map

This inscription is an active link to online maps. You can see address you entered in online maps. For using this functionality, Online Map Setup have to be filled in proper way[1][LO1] .

Primary Contact Code

You can choose primary contact from contact list. Primary contact could be an employee of the vendor’s company, who is key person for you.

HINT: Be informed that primary contact will automatically appear on all documents you will create. Of course you can change it later.

First of all, you should create some contacts for the vendor. You can reach Contact List in two ways, see picture below.

Contact

Field is filled automatically when you choose Primary Contact Code. Of course, you can fill it manually, too. The name of the contact is filled into this field.

Phone No.

Field is filled automatically when you choose Primary Contact Code. Of course, you can fill it manually, too.

Email

Field is filled automatically when you choose Primary Contact Code. Of course, you can fill it manually, too.

Fax No.

Field is filled automatically when you choose Primary Contact Code. Of course, you can fill it manually, too.

Home page

Field is filled automatically when you choose Primary Contact Code. Of course, you can fill it manually, too.

Our Account No.

Specifies your account number with your vendor, if you have one.

Language Code

Specifies code of language which is used for all documents. Of course, documents have to be translated into this language. If they are not, your standard system language will be used for all reports.

Invoicing

VAT Registration No.

This field specifies VAT registration number for invoicing. By clicking on three dots you can check the validity of VAT registration number in VIES system.

HINT: For using VIES functionality VAT registration number validation have to be allowed in EU VAT Reg. No. Validation Service Setup. 

HINT: You can set VAT formats to avoid bad formatting of the VAT numbers. This setting is included in Countries/Regions list, see below. Letters are prefix and number of hashes = required number of digits in VAT number

GLN

Global Location Number. Identifies the Vendor in connection with electronic document exchange. For example, when sending documents in the PEPPOL file format, the value in this field is used to populate the EndPointID element in the Supplier group. The number is based on the GS1 standard, which is compliant with ISO 6523

Pay-to Vendor No.

You can choose another vendor you will pay to, instead of current vendor, if it’s needed.

Invoice Disc. Code

The same code as in No. field in General FastTab is automatically copied here.

Prices Including VAT

If this checkbox is used, all purchasing documents will have prices with VAT included.

Gen. Bus. Posting Group

It specifies the trade type to link transactions made for this vendor with the appropriate G/L account according to the General Posting Setup.

Examples: EU | Domestic | Export | Intercompany

HINT: If field Def. VAT Bus. Posting Group in Gen. Business Posting Groups list is filled, next field VAT Bus. Posting Group will be filled automatically. Auto Insert Default checkbox have to be checked

VAT Bus. Posting Group

Specifies the VAT specification of the involved vendor to link transactions made for this record with the appropriate G/L account according to the VAT posting setup. Examples: EU (Vendors from European Union except for Maltese one) | Domestic (Maltese Vendors) | Export (Any other countries)

Vendor Posting Group

Specifies the vendor’s market type to link business transactions made for vendor with the appropriate account in the general ledger. Examples: EU | Domestic | Foreign

Currency Code

Specifies currency which is used for all purchasing documents. Of course, you can change it later. Currency code have to be chosen from list of Currencies.

Payments

Prepayment

Specifies a prepayment percentage that applies to all order lines for this vendor. The number should be written in following format: 50 - > means 50 % prepayment.

Application Method

You can choose how to apply payments to entries for this vendor. There are two options:

  • Manual – ledger entry to apply can be chosen manually.

  • Apply to oldest – each payment will be applied to the oldest opened ledger entry.

Payment Terms Code

Payment term code have to be chosen from the list of Payment Terms. This code determines, which formula will be used to calculate the due date of purchasing documents. Possibility of payment discount is included here, too.

HINT: Due date of document is calculated from the Document Date, not Posting Date.

Payment Method Code

Specify, how to make payment to the vendor, such as with bank transfer, by cash or check.

Priority

You can choose priority for suggesting payments to vendor. Lowest number, except 0, have the highest priority. You can enter as many priority levels as necessary. If you don’t want to prioritize vendors, you can let this field empty.

Block Payment Tolerance

You can set up a payment tolerance to close an invoice when the payment does not fully cover the amount on the invoice in NAV. Checking this box will ensure that payment tolerance is not applied to this vendor.

Preferred Bank Account Code

Specify primary bank account, that will be used by default on payment journal lines for export to a payment bank file.

Partner Type

Specify if vendor is the company or a person.

Cash Flow Payment Terms Code

Specifies a payment term that will be used for calculating cash flow. A payment terms code represents a formula that calculates the due date, payment discount date, and payment discount amount. Cash flow payment terms are used if you have selected the Consider CF Payment Terms check box and the Consider Discount check box in the Cash Flow Forecast Card window.

Creditor No.

A Creditor no.  is a unique reference for organizations collecting payments by SEPA Direct Debit.

Receiving

Location Code

Default location code to receive goods from this vendor.

Shipment Method Code

Default shipment method code for this vendor.

Lead Time Calculation

Specifies a date formula for the amount of time that it takes to replenish the item. This field is used to calculate the date fields on order and order proposal lines. When the Lead Time Calculation field is filled in several windows, it is prioritized as follows:

  1. Item vendor card

  1. Stockkeeping unit card

  2. Item card

Base Calendar Code

You can assign a base calendar to vendors. Delivery and receipt dates on future, purchase order are calculated according to the calendar’s specified working days.

Any base calendar defined for the vendor affects how the dates are calculated and rounded to working days. Specifies a date formula for the time that it takes to replenish the item. It is used to calculate the Planned Receipt Date field, if calculating forward, and Order Date field, if calculating backwards. Accordingly, these two date fields on purchase order lines are calculated as follows under different conditions.

Calculation Direction

Vendor Calendar Defined

Vendor Calendat Not Defined

Forward

planned receipt date = order date + vendor lead time (per the vendor calendar and rounded to the next working day in first the vendor calendar and then the location calendar)

planned receipt date = order date + vendor lead time (per the location calendar)

Backward

order date = planned receipt date - vendor lead time (per the vendor calendar and rounded to the previous working day in first the vendor calendar and then the location calendar)

order date = planned receipt date - vendor lead time (per the location calendar)

Customized Calendar

Whether No is visible here, only Base Calendar is used for this Vendor. When Yes is visible here, the base calendar differs from the vendor’s one.  You can click to the Customized Calendar drilldown for add customized modification to the base calendar for that particular vendor.

  • No labels