Adding & Editing the Price Chart Master in Ginesys HO

Price Chart may be defined as a form where the price of multiple items are fixed for a particular vendor from a particular date.

GINESYS offers a comprehensive storage of vendor wise, item wise rates for items in relation to dates. In other words, GINESYS allows its users to create a vendor wise list of items whose rates are defined for a particular date. This flexibility allows our users to buy and sell their wares for maximum profitability by assigning fixed rates for a particular time period; ensuring that market fluctuations do not affect the bottom-line of their products. Price Chart offers the flexibility of maintaining multiple cost prices against one item allowing the tracking of cost prices with their respective Effective Dates.

In other words, suppose there are multiple vendors (V1, V2 and V3) who sell the same item to a GINESYS user but at different prices and at different times of the season. Then the Price Chart feature allows to fix and record buying prices from V1, V2 and V3 in such a way as to help determine the most profitable cost price from each vendor.

The details of all Price Charts are stored in this master and flow from it to all relevant transaction modules.

Add Price Charts

The Add button in the Price Chart Master grid view allows the inclusion of new Price Charts as and when required. On clicking the button, the Add Price Chart window opens up to include all relevant details of a Price Chart. 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 > Price Chart in Admin > Security > User > Roles .

Step-by-step guide

Following steps are used:

Go to Procurement > Setup > Vendors > Price Chart.
Click on the Add button open Add Price Chart window.

The following table shows the Field Names and provides a description of their functionality.

Field Name	Field Description
Type of Assignment
Pricing (Radio button)	Pricing will be the default selected option. Selection of Pricing option will display /enable `Price Information` block. Once selected, the user can assign prices to selected items for selected vendor.
Extinct (Radio button)	Selection of Extinct option will display /enable `Extinct Information` block. Once selected, the user can extinct the previously assigned prices to the selected items for selected vendor.
Vendor Details - By default Name, Class Type and City to be displayed in the grid, rest will remain hidden
Clear (Button)	Clicking on this button will clear all the selected/searched vendor/supplier name in the grid.
Add Row (Button)	Clicking on this button will add blank row for selection of vendor name.
Name (Dropdown list)	The name of suppliers / vendors are displayed in this mandatory field. It cannot be hidden. IMPORTANT Selection list to be provided for Name, whereas rest will be display field. Selection of name will populate respective information. Names of Employee, Others and TDS class types are not displayed in here.
Class Type	This is a display field which shows the Class type of the supplier / vendor selected.
City	This is a display field which populates the City from the suppliers billing address.
State	This is a display field which populates the State from the suppliers billing address.
Zone	This is a display field which populates the Zone from the suppliers billing address.
Contact Person	This is a display field which populates the Contact Person from the suppliers billing address.
Due Days	This is a display field which populates the Due Days from the Supplier master.
Item Details - Rows can be deleted if required
Clear	Will clear all the selected items in the grid.
Select Items	Item selection is done manually here.
Scan Items	Item selection by automatic scanning has been provided for item selection and population.
Import Barcode	Item selection is done here by importing barcode.
Barcode	The unique identifier for items provided by the user.
Division	Division name for selected item will be displayed here.
Section	Section name for selected item will be displayed here.
Department	Department name for selected item will be displayed here.
Article	Article name for selected item will be displayed here.
Category 1 to 6	Category 1 to 6 is displayed here.
Price Information - All fields will only be active when the selected assignment mode is Pricing
Effective Date	It is a mandatory field, in which system date will be displayed by default. IMPORTANT Note : Effective date cannot be less than system date. Effective date can be a future date.
Rate	It is a mandatory field, which can be zero but cannot be negative or blank. By default, Rate field will remain blank, for user input. Calculation parameters are provided as below, to allow users to manipulate the basic rate with markup or markdown function: Apply < Factor> % < mode > on item rate, < Round Off> in multiples of < Multiples of> Description of the optional fields Factor (Numeric Text field): Cannot be negative but can be zero Mode (Drop down list with fixed value set): Markup Markdown Round off(Drop down list with fixed value set): Upper Round Off (Default selected) Lower Round Off Multiples of (Numeric Text field): Cannot be negative but can be zero or blank. Calculate (Button) - Pressing the button will calculate the Rate on the basis of parameter values selected and update the calculated value in rate field. For example: Apply < Factor> % < mode > on item rate, < Round Off> in multiples of < Multiples of> where Item rate is 100; Factor is 6%; Mode = Markup; Round off = Upper and in Multiples of 7 Rate = (100+ 6% of 100) rounded to upper value in multiples of 7 = 112. However, with all other values remaining unchanged for round off becoming lower, the calculations would be as following- Rate = (100+ 6% of 100) rounded to lower value in multiples of 7 = 105. But changing the mode to markdown with same values and round off upper - Rate = (100 - 6% of 100) rounded to upper value in multiples of 7 = 98 Similarly with the mode Markdown with same values and round off lower - Rate = (100 - 6% of 100) rounded to lower value in multiples of 7 = 91 If Rate (basic rate) field is blank or zero than rate will not be calculated.
Delivery Days	It is an optional field, where the no. of days to be taken for purchase order delivery can be specified. Note: It cannot be zero or negative.
Populate Delivery days as per vendor master definition (Checkbox)	If selected/ticked then the field for Delivery Days will get disabled and the Delivery Days provided in vendor master will be populated.
Populate (Button)	If selected assignment type is Pricing`,` then - all selected items are populated with relation to each selected vendor and assigns rates and due days as per Effective Date provided in Price Information block. If the selected item code already exists in Price Chart for selected vendor then those records will not be updated. If selected assignment type is Extinct`,` then - This action will extinct all the pricing for all the selected items and for all the selected vendors.
Cancel (Button)	Clears all selected values; cancels the quick assignment option and closes the window.
Extinct Information - All fields will only be active when the selected assignment mode is Extinct
Yes/No	If yes is selected then all price charts of the combination of item and vendor would be extinct. For example, If the same item has three different price charts with 3 different effective dates for the same vendor, then on selecting "yes" all 3 price charts will be extinct.

Edit Price Chart

The records in the Price Chart 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.

Important

Note:

Supplier Name and Item Details are display fields showing the respective values for the selected records.
Item Details displays chained values for Barcode, Item Category 1 through 6.

The user can edit any of the details in the window, provided the following conditions are fulfilled:

Records can only be modified if their effective date is ≥ the System Date. Only those records can be modified whose Effective Date in the selected Price Chart is either the system date or a future date.
The Effective Date which are > System Date; can be modified to the System Date but not to a past date.
The user cannot modify an Effective date to another date that is already defined for the same items for the same vendor. For example, if two Price Charts have been defined for Item I001 and Vendor V1 for 20th March and 20th April. Then the effective date for the 20th March cannot be modified to 20th April.
Rate is a mandatory field and can be modified - it can be zero but it cannot be blank or negative value.
Delivery Days are an optional field and can be modified - it cannot be zero or negative value.
Price Charts can also be made extinct here.
Populate and Cancel buttons have the same functionality as Add Price Chart.