Billing Rate As
YouTube: How to Configure Billing Rate for ‘Do Not Allow Rate Below’ Validation in Sale Bill?
How to Configure Billing Rate for ‘Do Not Allow Rate Below’ Validation in Sale Bill?
In this tutorial, we'll learn how to enforce strict sales rate control by preventing billing rates from going below a predefined reference rate (such as MRP, Purchase Rate, Standard Rate, etc.), with flexibility in how the rate validation is applied (before or after discounts).
Access Sale Voucher Configuration
Navigate to Sale Voucher Configuration.
Select the relevant Billing Series.
Under the Other Settings - 3.
Locate the option labeled as:
Do Not Allow Rate Below
Select the reference rate type from the list (e.g., MRP).
Configuring the "Billing Rate As" Setting
Billing Rate As– Validates entered rate directly against the reference rate, ignoring discounts.
Billing Rate As – Discount – Validates the rate after applying discounts to ensure the effective rate does not go below the reference rate.
Process Overview:
Case 1: Billing Rate As = Billing Rate
The system checks the entered billing rate before discounts against the reference rate (e.g., MRP).
If the entered rate < MRP → Error message appears: "Billing rate cannot be less than MRP".
Discounts (e.g., CD%) can still reduce the effective rate below MRP without error.
Example:
MRP: ₹100
Billing Rate entered: ₹90 → Error Prompt
Billing Rate: ₹100, CD%: 20% → Allowed (effective rate ₹80)
Case 2: Billing Rate As = Billing Rate – Discount
The system checks the final rate after discounts against the reference rate.
If the final effective rate < MRP → Error message appears.
Example:
MRP: ₹100
Billing Rate entered: ₹90 → Error Prompt
Billing Rate: ₹100, CD%: 20% → Error Prompt (effective rate ₹80)
Benefits:
Prevents unintentional or unauthorized rate reductions.
Ensures compliance with company pricing policies.
Flexible validation method to suit different business needs.
Last updated