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!
Managing the Margin Rule Master
- Aparajita Basu Roy
- Subhasree Banerjee (Unlicensed)
- Deepankana Roy (Unlicensed)
- Debrupa Datta (Unlicensed)
The margin is the difference in value of the purchase and the sale price; a positive margin means profit for the seller while a negative margin is an indicator of loss. The Margin Rule is basically a formula to be applied on the item cost for maintaining a stable profit against an item purchased from a particular supplier.
Once the margins are discussed and frozen, the users want the decided margins to be fed into the software after which the software will automatically ensure enforcement of the rules on every trade with the vendor. These set of margins are termed as margin rules. Margin rules can be set at a maximum of three levels 1) Vendor and 2) Article 3) Site. That is, the retailer can say that I want to enforce x % margin on purchase of every y Article from z Vendor.
Suppose an item, A001, is bought from Supplier S1 and the seller wants a profit of 10% on it. So the seller sets a margin rule in such a way that at a cost of 100 he'll be selling at 110. But if the cost price of the item increases to 110; his sale price must increase to 121 for his profit margin to be maintained.
The Margin Rule Master has multiple application operations - Add, Edit and Export to Excel.
The Add button in the Margin Rule Master grid view allows the inclusion of new Margin Rules as and when required. On clicking the button, the Add Margin Rule window opens up to include all relevant details of a Margin Rule. 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 > Margin Rule in Admin > Security > User > Roles .
Step-by-step guide
Following steps are used:
- Go to Procurement > Setup > Vendors > Margin Rule.
- Click on the Add button to open the Add Margin Rule window.
The following table shows the Field Names and provides a description of their functionality.
Field Name | Field Description |
---|---|
Rule InformationIMPORTANT In the same Margin Rule, Calculation Method cannot be different for Cost to MRP and Cost to WSP. In both the cases, it must be marked either as Markup or Markdown. In the same Margin Rule, Alert when.. condition cannot be different for Cost to MRP and Cost to WSP. The user can choose only one alert condition for one rule. | |
Rule Name | This is a mandatory field where the name of the Margin Rule to be created is given. Duplicate name of Margin Rule is not allowed. |
Description | This is an optional field to note any necessary description about the Margin Rule. |
Applicable From | |
From | The date (calendar) field has been provided to capture the dates from which the margin rule will be applicable. IMPORTANT
|
Till | It is a display field and does not contain any value for the last Date From defined. When new Date From is defined, then the previous Till Date is updated with the previous date of the new Date From value. |
Rule Interpretation | |
Effective Date | It is a display field showing the value of Date From of the currently selected Date Range.
|
Remarks | User can provide any required remarks. |
Cost to MRP | |
Calculation Method | This is the field which determines the process by which the margin will be calculated on the cost price. The two(2) radio options for this field are -
|
Cost will be taken as | The cost of an item may be its basic price or the price plus any charges it accrues before it reaches the buyer. So in considering the margin rule, it becomes important to decide which price will be treated as the actual cost price -
|
Consider Tax in Margin | Margin can be calculated either before application of taxes or after considering all taxes. There two(2) radio options: Gross of VAT - When the margin is calculated before VAT calculations. |
MRP will be taken as | The MRP can be calculated as RSP or MRP. If Calculation Method is set to There two(2) radio options: RSP - The Retail Sale Price is the price decided by the Retailer / Seller. It is decided after considering the profit margin, Default Value. MRP - The Maximum Retail Price of an item is the price decided by the producer of that item and cannot be changed by any other entity in the selling chain. |
Minimum Margin | The margin to be maintained for a consistent profit can be based on either percentage or absolute value. There two(2) radio options with user defined text fields: On Percentage <user defined factor> % - The margin is calculated as a percentage of the Basic or Effective price, Default Value. On Absolute Value <user defined value> - The margin is calculated as a definite user specified value |
Rule Status | The margin rule may be activated immediately or later by modifying the rule status. There two(2) radio options: Active - Applicable from the effective date. Inactive - Currently not applicable; Default Value |
(Checkbox) | The user needs an alert when his profit margin goes down or even when it goes up. If checked it will provide an alert whether the margin is either more or less than the specified value. |
Rule Interpretation | This section shows how the margin rule being created is to be interpreted when applied. For example, a margin rule may be set in the following way - While making any 'Stock In' type of entry: If user does not maintain <10%><Markup> Margin Between <Effective Cost> and <MRP> Then the system will <warn / block / ignore> (any one option) based on the user profile. Margin will be calculated as <Gross of VAT>. This rule is <ACTIVE> The above rule actually means that on an item of Effective Cost of 100, a markup margin of 10% i.e. 10 will be added to get the MRP and if this margin is not maintained; then the system will either ignore or warn or stop the transaction for that user depending on the user's profile. The margin will be calculated before application of VAT and the rule is applicable from the given effective date. |
Rule Calculation Formula | This gives the formula for calculating the margin based on the rule being set. Above example may be calculated from the rule in the following way: If <Effective Cost + 10% of Effective Cost > MRP> then the system will < Warn / Block / Ignore> the entry based on the user profile. |
Cost to WSP | |
Calculation Method | This is the field which determines the process by which the margin will be calculated on the cost price. The two(2) radio options for this field are -
|
Cost will be taken as | The cost of an item may be its basic price or the price plus any charges it accrues before it reaches the buyer. So in considering the margin rule, it becomes important to decide which price will be treated as the actual cost price -
|
Consider Tax in Margin | Margin can be calculated either before application of taxes or after considering all taxes. There two(2) radio options: Gross of VAT - When the margin is calculated before VAT calculations. |
Minimum margin to be maintained | The margin to be maintained for a consistent profit can be based on either percentage or absolute value. There two(2) radio options with user defined text fields: On Percentage <user defined factor> % - The margin is calculated as a percentage of the Basic or Effective price, Default Value. On Absolute Value <user defined value> - The margin is calculated as a definite user specified currency value. |
Rule Status | The margin rule may be immediately applicable or be activated later. There two(2) radio options: Active - Applicable from the effective date. Inactive - Currently not applicable; Default Value |
(Checkbox) | The user needs an alert when his profit margin goes down or even when it goes up. If checked it will provide an alert whether the margin is either more or less than the specified value. |
Rule Interpretation | This section shows how the margin rule being established is to be interpreted when applied. For example, a margin rule may be set in the following way - While making any 'Stock In' type of entry: If user does not maintain <10%><Markup> Margin Between <Effective Cost> and <WSP> Then the system will <warn / block / ignore> (any one option) based on the user profile. Margin will be calculated as <Gross of VAT>. This rule is <ACTIVE> The above rule actually means that on an item of Effective Cost of 100, a markup margin of 10% i.e. 10 will be added to get the WSP and if this margin is not maintained; then the system will either ignore or warn or stop the transaction for that user depending on the user's profile. The margin will be calculated before application of VAT and the rule is applicable from the given effective date. |
Rule Calculation Formula | This gives the formula for calculating the margin based on the rule being set. For example, a margin may be calculated from the rule in the following way: If <Effective Cost + 10% of Effective Cost > WSP> then the system will < Warn / Block / Ignore> the entry based on the user profile. The above formula actually means that on an item of Effective Cost of 100, a markup margin of 10% i.e. 10 will be added to get the WSP and if this selling price is greater than the WSP; then the system will either ignore or warn or stop the transaction for that user depending on the user's profile. |
FOOTER | |
Save | This button will save the Margin Rule. |
Close | This button will close the Add Rule window. |
The records in the Margin Rule Master may need to be modified to include more information about the margins or modify information already present in the system.
Pre-requisites
- The user's role must have the Modify application operation enabled for Procurement > Setup > Vendors > Margin Rule in Admin > Security > User > Roles .
Step-by-step guide
Following steps are used:
- Go to Procurement > Setup > Vendors > Margin Rule.
- Select a Margin Rule from the list.
- Click on the Edit option in the Action menu to open the Edit Rule window. Alternatively, double click on the selected Vendor to open the Edit Rule window.
The Margin Rule can be edited provided the following conditions are fulfilled:
- Modification of rules definition for previous dates is not allowed.
- Only margin rule definition of last recorded Date From is modifiable.
- Date range specified must be within connected accounting year.
- If modified Date From specified is less than equal to last entered Date From already provided then, then modification is not allowed.
- If modified Date From is greater than Date To already provided for the same record, then modification is not allowed.
- For past effective date, both date and rule cannot be modified.