back to knowledgebase

Enforcing minimum margin percentage on quotes, sales orders or invoices

Updated: 15 March 2019 17:28:47 OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Invoice

It is possible to enable checking of each product row on a Quote, Sales Order or Invoice record that the margin percentage is above a specified level.

To enable this go to Settings > Additional Settings > Margin Validation Settings

Here you can enable authorisation on each module and specify a system default minimum margin percentage.

When margin validation is enabled you can set a minimum margin per product category, you can access this from Settings -> Picklist Settings -> Product Picklists -> Product Category.

When creating a product in OpenCRM you can specify a Minimum Margin %. When setting the Product Category the margin will automatically set. If the category selected has no related margin percentage configured and the Minimum Margin % field is left blank then the system will automatically set this to the default set under Margin Validation Settings.

You can override the category default by typing in a margin for the specific product.

You can choose which users are able to edit the Minimum Margin % on the product, you can choose to not display the field on the edit screen at all in which case the system will set the category or system default % automatically when the product is saved.

When creating a Quote, Sales Order, Invoice you can see the current Margin % for each product row, you may need to enable this column under Additional Settings if it is not currently displayed.

When saving the record each row will be checked against the margin % set on the related product, if any product row is below the margin set for that product you will see the warning below

If you choose to continue the effect will depend on your user permissions. If you are a Financial Admin or System Admin then the warning is advisory only and you will be able to continue as normal. If you do not have one of these permissions then the "Requires Financial Authorisation" check box will be flagged and your access to the record will be restricted.                                              

You will then need to seek assistance from a System Admin or Financial Admin who can unlock / approve the order for you.

Access to edit the "Requires Financial Authorisation" check box on the edit screen is controlled by user profile

To enable a Profile to access this field go to Settings -> Field Accessibility & Customise Search Screens. In order to approve the order a user will need to both have access to the field and have the aforementioned admin rights. To approve the order simply edit the record and remove the tick from the "Requires Financial Authorisation" field. Once saved the record restrictions will be removed. 

NOTE: If a standard user edits the record and saves whilst still below the minimum margins this will re-trigger the authorisation process.

Rate This Article
  • 1 star
  • 2 star
  • 3 star
  • 4 star
  • 5 star
Feedback and Comments
captcha code  


You may also be interested in: