Discount warning message on Sales Order based on the “Allowed Discount” field

As seen in our previous blog, we discussed about warning message validation on credit note as per the financial year. Today we are going to discuss another customization on the Sales Order screen which is very useful to users in their business process for customer transactions.

One of our client has requested to have some warning alerts for users when discount defined at customer master does not matched with the discount given during sales order creation. So to achieve this, we have added new customized field name as “Allowed Discount” on customer master. Please refer below screen shot:

New Stuff: Duplicate PAN Number Validation on Customer Master in Sage X3

[Allowed Discount field in Customer Master]

Let say suppose, user has added ‘Allowed discount’ amount 10 in the customer master. In this case, user can enter discount value either 0 or 10 during Sales order creation. If user enter discount other than that then warning message will get pop-up. Lets see by doing the sales order transaction.

In above screenshot, user has added allowed discount as 10 for customer C01010001. Now when user tries to create sales order and enter discount amount as 8, customization checks the discount value defined at customer master which is 10 and does not match with it so warning message get pop up “User has provided discount, hence the order requires approval. Kindly review and approve the same to proceed.”

[Discount field in Sales Order] [Warning message]

So even if Sales order with multiple products will work in similar fashion. Suppose sales order has 5 different products and user has given same discount at each line, then order will get created without any warning but if any one of the line has different discount value then warning message will appear as shown in the above screen shot. But please note that, it will not restrict users to create sales order as warning message is just for user information.

By using this customization, users can identify whether discount given at sales order is correct or not.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.