We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
Adding & Editing Vendors in Ginesys HO
- Aparajita Basu Roy
- Deepankana Roy (Unlicensed)
- Subhasree Banerjee (Unlicensed)
- Debrupa Datta (Unlicensed)
A vendor is a party in the supply chain that makes goods and services available to companies or consumers. The term "vendor" is typically used to describe the entity that is paid for goods that are provided, rather than the manufacturer of the goods itself. Also known as a supplier, a vendor, is an individual or company that sells goods or services to someone else in the economic production chain. In information technology as well as in other industries, the term is commonly applied to suppliers of goods and services to other companies.
The details of all Vendors are stored in this master and flow from it to all relevant transaction modules.
The Add button in the Vendor Master grid view allows the inclusion of new vendors as and when required. On clicking the button, the Add Vendor window opens up to include all relevant details of a vendor. The new record can then be saved and reflected in the master.
Prerequisites
- The user's role must have the Add application operation enabled for Procurement > Setup > Vendors > Vendor in Admin > Security > User > Roles .
Step-by-step guide
Following steps are used:
- Go to Procurement > Setup > Vendors > Vendor.
- Click on the Add button to open the Add Vendor window.
The following table shows the Field Names and provides a description of their functionality.
Field Name | Field Description | ||||||
---|---|---|---|---|---|---|---|
Vendor Information | |||||||
Vendor ID | Mandatory field which has to be manually entered by user. It cannot accept duplicate values, i.e. no two vendors can have same ID . | ||||||
Name | Supplier name has to be entered in this mandatory field. | ||||||
Alias | Optional field where some kind of identifier may be put in to make identification of supplier easier later. | ||||||
Detail Information | |||||||
General (Tab) | |||||||
Information | |||||||
Company Type - | This displays the Business mode of the vendor and should not to be confused with Mode of Operation. This is a drop down list in which there are the following six options of which any one has to be selected:
| ||||||
Industry Type - | This specifies the economic segment to which the vendors' company belongs. This is a drop down list in which there are the following five options of which any one has to be selected:
| ||||||
Product Type | This is an optional field where the user can specify the vendor's product type i.e. what the vendor deals in. For example, apparel or jewellery or books etc. | ||||||
Brand Name | This is an optional field where the user can specify the product's brand name. | ||||||
Director / Owner name | This is an optional field for the user to specify the company's owner name or director's name. | ||||||
General | |||||||
Class Name | This is a mandatory field where value has to be selected from a drop down list.
| ||||||
Class Type | This field automatically displays the class type of the vendor once the Class Name is selected above. | ||||||
AR Ledger | This is a mandatory field where value has to be selected from a drop down list. The list displays those ledger type 'AR/AP' which are not extinct. | ||||||
Transporter Name | This is an optional field where value can be selected from a drop down list. The list displays ledger type 'Transporter' which are not extinct. | ||||||
Remarks | This is an optional text field that can be used to note any needed information. | ||||||
Billing Details (tab) | |||||||
Contact person | This has two related fields; Name (name of the contact person) and Mobile Number (mobile number of the contact person). These are mandatory fields. | ||||||
Address | This has seven related fields:
Address , City and Pin code are user inputs; however, City can be selected from the lookup. Rest of the fields are automatically displayed on selection of City. | ||||||
Phone Number | In this section, three (3) Office numbers of vendor can be recorded along with his Fax Number and his Residence Number . | ||||||
This section has the option of recording 2 Email ids of the vendor. | |||||||
Website | The vendor's website link can be recorded here. | ||||||
Shipping Details (tab) | |||||||
Contact person | This has two related fields; Name (name of the contact person) and Mobile Number (mobile number of the contact person). These are mandatory fields. | ||||||
Address | This has seven related fields:
Address , City and Pin code are user inputs; however, City can be selected from the lookup. Rest of the fields are automatically displayed on selection of City. | ||||||
Phone Number | In this section, three (3) Office numbers of vendor can be recorded along with his Fax Number and his Residence Number . | ||||||
This section has the option of recording 2 Email ids of the vendor. | |||||||
Website | The vendor's website link can be recorded here. | ||||||
Copy Billing Address (button) | The button allows copying of the Billing Address details into the corresponding fields to avoid redundancy. | ||||||
Procurement (Tab) | |||||||
Item Settings - These settings are designed to help the user set pricing policies at the item creation level | |||||||
Create item with RSP as <user defined value> % Markup on Std Rate, <Round off basis, user defined> in Multiples of <user defined value> | This field states how much markup on the current standard price is applied on the items' RSP. User can also select applicable round off basis (i.e. if it would be Upper - When Upper is selected then if the Price is Rs. 100.65 then it will take the next upper rounded value like Rs. 101. Lower - When Lower is selected then if the Price is Rs. 100.33 then it will take the last lower rounded value like Rs. 100. Round - When the Round is selected it it will take the nearest rounded value. For example - If the price is Rs. 101.55 then it will take Rs.101 and if the price is Rs. 101.40 then it will take Rs.100 | ||||||
Create item with WSP as <user defined value> % Markup on Std Rate, <Round off basis, user defined> in Multiples of <user defined value> | This field states how much markup on the current standard price is applied on the items' WSP. User can also select applicable round off basis (i.e. if it would be Upper Round off , Lower Round off , or Nearest Value ) and the multiples in which it will be rounded when purchased from this entity. | ||||||
Price Settings - These settings are designed to help the user find the actual cost prices of the item | |||||||
Populate Item Basic Price | This is a drop down list with the following values of which any one has to be selected:
| ||||||
If item not found in Price Chart, calculate Basic Price as Below: Apply <User defined value>% Markdown on Item <User defined value from list of price types> <Round off basis, user defined> in Multiples of <user defined value> | In case cost of items purchased from the entity are not found in the Price Chart, then their rates will be derived from the calculations of the values in these fields. e.g. Apply The various types of rates are -
| ||||||
Payment Settings - These settings are designed to help the user set parameters for discounts in purchase | |||||||
Allow Cash Discount in AP Voucher, on Full Payment of Purchase Invoice (Checkbox) <User defined value>%, if paid within <user defined value>days | If selected, it allows a cash discount on full payment of invoice value; with a user set percentage of discount if the payment is made within a specified number of days. Alert
| ||||||
Document Settings - These settings are designed to help the user set the information required for the transaction. | |||||||
Tax Region | Optional field for which value has to be selected from the drop down list of non-extinct Tax Regions. | ||||||
Tax Group | Optional field for which value has to be selected from the drop down list of non-extinct Tax Groups. | ||||||
Trade Group | Optional field for which value has to be selected from the drop down list of non-extinct Trade Group. | ||||||
Purchase Term | Optional field for which the value has to be selected from list of non-extinct Purchase Term. | ||||||
Purchase Form | Optional field for which value has to be selected from the drop down list of given non-extinct Purchase Forms. Note: For Local trade group, the form is not applicable and the selection is disabled. | ||||||
Allow Consignment Purchase (Checkbox) | When selected this will allow consignment purchase from this particular vendor. | ||||||
Order Settings - These settings are designed to help the user set the parameters for placing an order | |||||||
Purchase Order Booking Currency | Optional field for which value has to be selected from the drop down list of given non-extinct currencies. By default, base currency will be populated. | ||||||
Deliver the order <User defined value> days | This field records the maximum number of days within which the delivery should be made. Optional field; can be any user defined value. | ||||||
Buffer time allowed <User defined value> days | This field records the extra number of days allowed over and above the Delivery days specified above. Optional field; can be any user defined value. | ||||||
Purchase Order Limit | This field records the maximum amount for which a Purchase Order may be placed with this particular vendor or jobber. It may be overridden by users by explicit choice. | ||||||
Incoming Logistics - These settings are designed to help the user set the logistics parameters for Procurement. | |||||||
Gate Entry Applicable (Checkbox) | If selected, Procurement will require gate entry documents to be processed. | ||||||
Logistics Applicable (Checkbox) | If selected, Procurement will require logistic documents to be processed, when goods are moving inward. It enables several other checkboxes as below -
There is note at the bottom to draw attention of the user that Shipment tracking can be done through a separate portal. | ||||||
Sales (tab) - These details will be required if the supplier is ever treated as a customer | |||||||
Document Settings | |||||||
Trade Group | A display field for non-extinct Trade Groups. | ||||||
Sales Term | A display field for non-extinct Sales Term. If trade group is already selected the associated sales term will be displayed in the lookup and must be assigned by selecting it; similarly selection of Sales Term will also populate the trade group for the term as Vendor Trade Group. | ||||||
Sales Form | Optional field for which value has to be selected from the drop down list of given non-extinct Sales Forms. Note: For Local trade group, the form is not applicable and the selection is disabled. | ||||||
Price List Name | Optional field for which the value has to be selected from list of non-extinct Price List. IMPORTANT
| ||||||
Credit settings | |||||||
Credit Rating | Optional field for which the value has to be selected from list of non-extinct Credit Rating. E.g. User with very good payment track record has a higher credit rating. | ||||||
Invoice due date to be considered from <User defined value> days | Optional field with user defined value; the invoice will be considered as due from the number of days defined here. E.g. If the value in this field for a particular customer is 2 days; then the invoice raised on 1st of any month becomes due on 3rd of that month. | ||||||
Interest charged for delayed payment <User defined value>% | Optional field with user defined value; the buyer can be charged a penalty interest of the specified percentage on his due amount in case of delay in delivery, depends on user discretion. | ||||||
Credit Verification | |||||||
Credit Rule violation depends on | Optional field for which the value has to be selected from list of rules. The rules are:
Important information For Credit Rule - Credit Limit Only The Credit limit amount and the Tolerance percentage will be checked for validation. In case of AP vouchers, only this Credit Rule is applicable. When this rule is applied Credit Limit field will become a mandatory field, but tolerance will remain as non-mandatory field. Only the Credit limit amount and the Tolerance percentage will be checked for validation. In case of AP vouchers, only this Credit Rule is applicable. For Credit Rule - Overdue When this rule is applied Overdue days field will become a mandatory field, but Overdue amount will remain as non-mandatory field. No.of Overdue days and Overdue amount will be checked for validation. For Credit Rule - Credit Limit and Overdue Both of the above-mentioned rules will be applied for validation purpose. The Credit limit amount, the Tolerance percentage, No. of Overdue days and Overdue amount will be checked for validation. However, in this particular credit rule, violation of any of the validations (Credit Limit or No. of Overdue days) will cause further related actions to be continued with warning or be suspended. For Credit Rule – None No validations will be applied, when none is selected as the rule. | ||||||
Invoice credit limit set to Rs.<User defined value> with Tolerance of <User defined value>% | Credit Limit - The amount till which the customer can buy on credit. For example, Credit limit is defined as 5 lakhs, then the customer can make purchases up to this amount without making any payments. Tolerance - A buffer value to the provided credit limit. For example, Credit limit is defined as 5 lakhs, and tolerance is 10%. The applicable credit limit will now become 5 lakhs and 50 thousand. | ||||||
No. of days Overdue date <User defined value> | Overdue Date - Number of days beyond which if payment of any document is due for a customer, further delivery/sale process to be restricted for the customer. For example, Max overdue days is specified as 10 days and current date is 20th October. If there is any sales invoice which became due for payment before 10th of October, then user will be restricted to create any further delivery or sale document. | ||||||
Overdue Amount <User defined value> | Overdue amount - Buffer amount to be allowed even beyond overdue days. Suppose overdue days is specified as 2 days and overdue amount is 10000. If there are only two documents of Rs. 4000 each, which became due 3 days back. Even then DC or Invoice creation would not be barred. But if the overdue amount went beyond, like if there would have been 3 documents of Rs. 4000 each which became due 3 days back, then DC creation and Invoice creation would be barred for that customer only when the Overdue Amount limit has been crossed. Note: In aforesaid example, profile setting for credit verification is considered to be set as ‘Stop’. | ||||||
Agent Details | |||||||
Agent Name | Name of the agent referring the customer. | ||||||
Commission <User defined value>% | Percentage of sale value to be paid to the agent as commission. | ||||||
Outgoing Logistics | |||||||
Logistics Applicable (Checkbox) | If selected, Procurement will require logistic documents to be processed, when goods are moving inward. | ||||||
Finance (Tab) | |||||||
Statutory (section) | |||||||
Registration Numbers | |||||||
CIN No. | Corporate Identity Number or Company CIN No. of the Customer's company is to be captured here | ||||||
PAN No. | The Permanent Account Number of the customer is to be recorded here. | ||||||
VAT No. | Value Added Tax or VAT registration number and the date of registration of the customer are noted here. Since its a renewable document the date (calendar) field has been provided to capture the dates. | ||||||
GST Category | This field records the category of GST the customer provides.
| ||||||
GST Identification No. | The GST Identification No of the customer is to be recorded here. | ||||||
GST State | This field records the sate o | ||||||
CST No. | CST = Central Sales Tax; The customer's registration number for payment of CST. The registration number and the date of registration are noted here. Since its a renewable document the date (calendar) field has been provided to capture the dates. | ||||||
Excise No. | Excise Control Code number is a PAN linked 15 digit alpha numeric registration number, the registration number and the date of registration of the customer are noted here. Since its a renewable document the date (calendar) field has been provided to capture the dates. | ||||||
Service Tax No. | The Service Tax Code Number is a 15-digit PAN linked number of the assesses. The customer's Service Tax registration number and the date of registration are noted here. Since its a renewable document the date (calendar) field has been provided to capture the dates. | ||||||
Service Tax Category | This field records the category of service the customer provides. | ||||||
SSI No. | Small Scale Industry Registration Number is provided by Ministry of Micro, Small and Medium Enterprises. | ||||||
Micro & Small Establishment No. | Micro & Small Establishment Number is provided by Ministry of Micro, Small and Medium Enterprises. | ||||||
Bank Details | |||||||
Bank Name | Name of the Bank where the customer has the account used for transactions with the GINESYS user. For example, One customer may use a SBI account for transactions while another may prefer a private bank. | ||||||
Account No. | The transacting Account number of the customer. | ||||||
MICR Code | MICR stands for Magnetic Ink Character Recognition, a technology which allows machines to read and process cheques in a short time. MICR code is usually a nine digit code. | ||||||
IFSC Code | An IFSC or the Indian Financial System Code is an 11 digit code in alpha-numeric format used by the Reserve Bank of India to identify all the Bank branches within the NEFT (National Electronic Funds Transfer) network uniquely. | ||||||
RTGS Code | Real Time Gross Settlement (RTGS) is an electronic form of funds transfer where the transmission takes place on a real time basis. The beneficiary account receives the funds transferred, on a real time basis. | ||||||
Cheque Label | Account name in favour of which cheque to be drawn for payment. | ||||||
Ledgers (section) | |||||||
Purchase Ledgers | |||||||
Purchase Ledger | The Purchase Ledger is the ledger where the financial posting related to that Customer happens. The drop down box will list all non-extinct General type of ledgers. The list will display Name , Nature , Type , SL Applicability and Site Applicability of the ledgers. | ||||||
Sub Ledger | If the selected ledger is sub ledger applicable, then this field is enabled and becomes mandatory. The drop down box will list all non-extinct sub ledgers tagged to the selected ledger. The list will display Name, ID, Class Name and Ledger Name . | ||||||
Purchase Return Ledger | The Purchase Return Ledger is the ledger where the financial posting related to that Customer happens. The drop down box will list all non-extinct General type of ledgers. The list will display Name , Nature , Type , SL Applicability and Site Applicability of the ledgers. | ||||||
Sub Ledger | If the selected ledger is sub ledger applicable, then this field is enabled and becomes mandatory. The drop down box will list all non-extinct sub ledgers tagged to the selected ledger. The list will display Name, ID, Class Name and Ledger Name . | ||||||
General Ledgers (section) | |||||||
Allow to Transact with These Ledgers - Apart from AR/AP ledger, if the customer has to do other financial transaction, then the respective ledger needs to be tagged in this block. Only the General type ledgers selected here will be allowed for transaction with the selected customer. | |||||||
Add Row (Button) | It adds a blank row at the bottom of the list. | ||||||
General Ledger Name | The values in this field are selected from a drop down list, which displays the Name , Type and Site Applicable of the non-extinct General nature ledgers. | ||||||
Extinct | If selected, it will extinct the tagging of the respective General Ledger with the customer. | ||||||
Applicable Sites | |||||||
Site Name | This displays the selected sites applicable for the selected General Ledger. Site can be selected through the Select Site button. | ||||||
Site Type | This displays site type of applicable sites. | ||||||
Extinct | Since selected sites cannot be deleted, the extinct option has been provided. If required the General Ledger - Site tagging can be made extinct. | ||||||
Select Site (Button) | On clicking, this button a window opens which lists all sites and site types from which user can select the sites for which the selected General Ledger will be applicable. Clicking on the IMPORTANT
| ||||||
TDS (section) Although it is customary to deduct TDS for services rendered, yet jobbers and other service providers often apply and get certain relaxations on the TDS rate based on various criteria. These are attested by the exception certificates awarded by the government to a specific service provider for a particular financial year. Such details of a service provider is captured in the Exception Details section of the TDS tab. | |||||||
TDS Applicable (Checkbox) | If checked, it enables the entire section. | ||||||
Specify TDS Source | The source name for TDS calculation must be selected mandatorily from the drop down box. The source name is an identifier for the different TDS heads of Corporate and Non Corporate type. It is displayed from TDS Source Definition. | ||||||
TDS Information - | |||||||
Add Row (Button) | It adds a blank row at the bottom of the list. | ||||||
Organization Unit | Name of the Organization Unit has to be selected from the drop down list. | ||||||
TDS Name | Name of the tax to be deducted from TDS Section Definition. | ||||||
Section | Display field which is automatically populated once TDS name is selected. | ||||||
Exception Details - | |||||||
Date From | Calendar field, must take value within current financial year. Only last date entry TDS Name wise can be modified. | ||||||
Date To | Calendar field, must take value within current financial year. Only last date entry TDS Name wise can be modified. Note: | ||||||
Certificate No. | The Government of India issues a Certificate to some entities for Lower Deduction of TDS. The Certificate Number is an optional field to capture this detail if present. Duplicate number is not allowed. | ||||||
Max Limit | The maximum amount till which the exception rate of TDS provided in the next column will be applicable. For example the TDS Rate for commercial entity may be | ||||||
TDS Rate | The rate at which the TDS will be deducted as long as the service amount is within the exception limit. Important information It cannot be :
| ||||||
Production (Tab) | |||||||
Manufacturing Settings | |||||||
Allow Manufacturing Unit Stock Point selection (Check box) | If selected, user can select stock point of manufacturing unit at the time of creating Purchase orders. | ||||||
Maximum overdue days | Number field; the maximum days to be allowed before any action is taken on an overdue order. | ||||||
Overdue Action | A LOV what action which determines would be taken once an order is overdue. | ||||||
FOOTER | |||||||
Save | This button will save the Customer details. | ||||||
Close | This button will close the Add Customer window. |
Important Note
Agents and Transporter are created from the Vendor master only.
The records in the Vendor Master may need to be modified to include more information about the vendors or modify information already present in the system.
Prerequisites
- The user's role must have the Modify application operation enabled for Procurement > Setup > Vendors > Vendor in Admin > Security > User > Roles .
Step-by-step guide
Following steps are used:
- Go to Procurement > Setup > Vendors > Vendor.
- Select a vendor from the list.
- Click on the Edit option in the Action menu to open the Edit Vendor window. Alternatively, double click on the selected Vendor to open the Edit Vendor window.
The user can edit any of the details in the window, provided the following conditions are fulfilled:
Important
Note: Vendors, once created, cannot be deleted. They can only be made extinct. Selecting the checkbox (This record is extinct) makes the Vendor extinct.
For Incoming Logistics Applicable, deselection of Check box is only allowed if -
- Record for incoming logistics entry of the Vendor is not pending to be received and any option among Permit, Bale wise quantity or Shipment tracking is not applicable for the Vendor.
For Incoming Gate Entry Applicable, deselection of Check box is only allowed if -
- Record for incoming gate entry of the Vendor is not pending to be received.
In General Ledger Tab for Applicable Sites, tagging cannot be made extinct if -
- Any of the tagged sites has transactions with the tagged general ledger and Vendor then such tagging cannot be made extinct.
From Version 12.4.5 onwards
Under TDS Information block, a new column has been introduced for TDS Type in Vendor, Customer, Employee and Other sub ledger master.
The TDS Name can be quickly chosen by the new TDS Type column in the drop-down list.