Sage 100

Need to know if anyone has suggestions on how to manage the following issue that we are trying to address without doing a modification. We are hoping that we've just looked at this so long, we are missing something obvious. V2013 Inventory items are set up with Lot Valuation. They have multiple warehouses. Each item has a primary vendor. They purchase product from different vendors. Vendor Price Level Maintenance has been set up for each item with the Standard Cost override amount. They generate Purchase Orders from the Sales Order and do sometimes change the vendor on the Sales Order. Purchase Orders populate with the correct cost. The problem: They enter Quotes in Sales Order Entry. As they enter the items they want to see the margin. The profit % that displays is based on the Average Cost. They want to see the Standard Cost that has been assigned to the vendor. The Average Cost will not be the same as the standard cost for several reasons: 1. They will purchase the item from 2-3 different vendors who all charge different costs 2. There will be cost changes periodically, and depending on a contract with the supplier, they may still get the old cost (yes, I am talking cost and not price here) for some orders 3. There are some customer's orders that generate a totally different cost from the supplier.

UDF populated by a script????

For one customer, we have a recurring VI job that zero's out the vendor's last cost so the system will use standard cost on POs, etc. For another client we have a similar VI job that replaces the vendors last cost with the standard cost to do the same thing. One of those methods may work for you.