Validate Item with defined combination of Vendor & Item on Purchase Order

By | January 12, 2018

Here we have come up with a 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 of Purchase Order Entry which we insert from Vendor Contract Cost Screen while setting the unit cost for the particular vendor of the particular item.
Suppose a user inserts a particular item and sets base price from PO Vendor Contract Cost Screen for a particular vendor then in PO Entry, if we insert the same combination of vendor & item then the system will automatically populate the item with its respective unit cost.
As per the below screenshot we have set base price from Vendor Contract Cost Screen for that particular item for the particular vendor.
Vendor Purchase Order
The validation states that if the user insert different item instead of the particular item present in Vendor Contract Costs of the same vendor itself or the different vendor then also the system will check whether the combination of Vendor & item exist in Vendor Contract Costs. If the combination of Vendor & Item matches with the Vendor & item defined in Vendor Contract costs then only the system will allow item to be inserted, else the system will throw below error message.
purchase order entry
The main purpose of this blog is to provide our customers to validate the Item and check whether the combination of Vendor & Item are present in Vendor Contract Costs or not.

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 some unique solutions of Sage 300 integration with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services to Sage business partners, end users, and Sage PSG worldwide.
For more details on Sage 300 Services, please contact us at accpac@greytrix.com. We will be glad to assist you.