Proposal for updating preferred vendor in item record by lowest price
This proposal also covers the engagement scope of Jobin and Jismi IT Services LLP, as official implementation partner Of Oracle NetSuite.
Submitted To
Harilal Upendran Pillai
R M Consulting Engineers Ltd
Submitted By
Rijo John
Project Manager
Jobin and Jismi IT Services LLP
Submitted on 04/07/2022
Proposal Version 1.0
Table of contents
Page Break
Requirement
Client would like to implement the customization for setting up the lowest price vendors in requisitions record depending on the item’s pricing mentioned in the vendor record with currency related to each vendor. This should be reflected in requisition record dynamically.
Solution
We will be implementing a solution based on the functionality of the requisition record that the vendor in the line item is sourced from the item record where the preferred vendor will be set as default one.
We will develop a script for checking each items’ lowest price vendors and set as preferred vendor to that item. Upon creating a requisition record the lowest price vendor will auto populate in vendor field after selecting an item.
The script will execute every day twice for preferring the lowest price vendor in the item record. After confirming the lower price vendor, it’ll will set as preferred in the item record. Thus, whenever the requisition record created, the preferred vendor with the lowest price will be populated automatically.
Assumptions
- When a vendor is preferred in item record, it’ll auto populate to requisition record. (Standard functionality)
- If there is no vendor preferred for that item, then there will be no vendor populated in requisition record, user need to manually select the vendor from the drop down.
- When the record is created and approved, we may use it to create a purchase order. It is essential to have a vendor while establishing the purchase order. Then an alert message appears as “Select Vendor” in item list for creating purchase order.
- The subsidiary selected in requisition should be same as the vendor subsidiary, then only the preferred vendor will auto populate in requisition record.
- After created and approved the requisition record the purchase order can create, the status of the order will be in “Pending Approval “.
- There won’t be any changes occur to the already created requisition when the preferred vendor is changed in the item record after the requisition is created.
Risks
- The script is not executing in real time, we only schedule the script two times for preferring vendor. The items which are updated before script execution, will not get updated the lowest pricing vendor. It’ll only update when the next execution happens.
Time and Effort
Time Required:14 hr