Adding & Editing the Price Chart Master in Ginesys HO
- Aparajita Basu Roy
- Deepankana Roy (Unlicensed)
- Subhasree Banerjee (Unlicensed)
- Debrupa Datta (Unlicensed)
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.
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 Once selected, the user can assign prices to selected items for selected vendor. |
Extinct (Radio button) | Selection of Extinct option will display /enable 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
|
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 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):
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
However, with all other values remaining unchanged for round off becoming lower, the calculations would be as following-
But changing the mode to markdown with same values and round off upper -
Similarly with the mode Markdown with same values and round off lower -
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 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 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. |
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
andItem 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
andCancel
buttons have the same functionality as Add Price Chart.