Purchase Order Validation Based On Vendor Contract Costs

By | July 27, 2023

The Vendor Contract Cost screen in Sage300 ERP is useful for defining unit price in relation to certain Items and Customers. The user also has the choice of selecting a single or multiple unit price.

When you enter purchase orders, receipts, invoices, re-turns, and credit/debit notes, vendor contract charges show up as default entries. Purchase Orders displays the item cost entered in the P/O Options screen as the default cost if there is no contract cost for an item and vendor.

In the Purchase Order Entry, Receipt Entry, Invoice Entry, Return Entry, and Credit/Debit Note Entry screens, you may check the contract costs for all Vendors in the Unit Cost item Finder.

The Contract Costs screen is comparable to the Inventory Control module’s I/C Item Pricing screen. You can set basic expenses and selling prices for one or more units of measurement as well as percentage or flat-rate discounts based on purchasing.

We have done numerous customizations in Sage 300 screens to facilitate custom business flow over the Sage 300 standard processing. One such customization related to Purchase Order and Vendor Contract costs is done. This customization helps validate the Purchase Orders by restricting the User to use such Items which are not defined in the Vendor Contract costs screen.

New Stuff :- Custom Crystal Reports with Optional Field Filtering

User will set unit price against Item and vendor in the Vendor Contract screen. During transaction Validation will be applied on the Item and Vendor. If a transaction has Items and Vendor that are not present in Vendor Contract Screen, validation will throw an error else unit price will be fetched from vendor contract cost screen.

Vendor Contact Screen with Item mapped with Base Unit Cost.

Vendor Contract Costs screen
Fig1: Vendor Contract Costs screen

In Purchase Order screen while creating Purchase order user will have to populate same combination of Item and vendor to generate the PO.

 PO Order Entry screen
Fig2: PO Order Entry screen

If the combination of Item number and Vendor does not match the Vendor Contract Cost screen, it will show an error as below when the item is selected.

Error message UI
Fig3: Error message UI

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, 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 offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM 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 and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.