Validate Unit Cost with defined Vendor Contract Cost on Purchase Order

By | November 20, 2017

Here we have comes up with one more useful validation on Purchase Order screen that will help users who are working on vendor contract cost. Below is the detail description of this customization.

We have put validation on detail level Item Unit Cost that cannot be greater than the base price set from Vendor Contract Cost for Particular Item.

Suppose a user sets the base price of an Item as 500 from PO Vendor Contract Cost Screen for a particular Vendor then the base price set against the item of a particular vendor will automatically populate the unit cost as per the standard functionality.

As per the below screenshot, we have set base price from Vendor Contract Cost Screen to an item for a particular vendor.

The validation states that if the user setting unit cost greater than the base price set in Vendor Cost screen for that particular item of that particular vendor then the system will show below error and will not allow a user to set unit cost greater then base price set in vendor cost.

The main purpose of this blog is to provide our customers to validate item unit cost as per their requirement in P/O Entry and should not allow item which is not present in Vendor Contract Cost Screen.
About Us
Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix has unique solutions of Sage 300 integration with Sage CRM, and Magento eCommerce. We have the migration expertise of Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We work on the latest Sage 300c technologies and offer best-in-class Sage 300 | Sage 300c customization and development services.  This include upgrading old codes, creating new web screens, delivering new reporting tools like Sage Intelligence, PowerBI and SAP BO to Sage business partners, end users and Sage PSG worldwide.
For more details on Sage 300 | Sage 300c Services, please contact us at We will be glad to assist you.