Order Express - How To Data

This page contains answers to a variety of common data updates for Order Express overall and for specific clients. Please review the table of contents below to see if your question has been answered.

Setting up Price Freeze

• Open SQL Management Studio
• Find MFG database requesting change/update
• Find Table: OEAppSettings; Right Click - Edit Top 200 Rows
• Search for: where SETTINGNAME = 'AUTO_FREEZE_STATUS'
• Update value for AUTO_FREEZE_STATUS with status tag that MFG wants projects automatically Frozen

           If status tag is not set for Freeze Status; follow the steps below: 
             * 
             *
             *
             *

Updating TW Fuel Surcharge

• SQL database tab – OEVariables
• Search for variable name – FuelSurchargeMultiplier
• Update Value within Default Value
• Value is decimal value. So .10% should be listed as .010. 1% would be listed as .10