Difference between revisions of "Order Express - How To Data"
From eVision
(→Setting up Price Freeze) |
|||
| Line 1: | Line 1: | ||
| + | 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. | ||
| + | |||
| + | __FORCETOC__ <!-- Force the table-of-contents to appear even if there are fewer than 4 categories on this page. --> | ||
| + | |||
== Setting up Price Freeze == | == Setting up Price Freeze == | ||
Revision as of 11:33, 2 March 2021
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:
*
*
*
*
Update 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
