SOE COST General Control Maintenance Records

The following control maintenance records belong to the COST area within the SOE (Sales Order Entry) category. COST should not be confused with pricing. For pricing control maintenance records, see SOE PRICE General.

Always Log The First Non-Zero Cost For Products

New in Release 9.0.3

Indicate if you want to log the first non-zero cost for products. More:

Apply Rebates From Sell Group Rebate Table

Use this record if your company applies rebates for sell groups. When a customer orders a product, the price is typically derived from the item's price sheet and the active sell matrix. However, you can set up rebate tables at the sell group level to apply rebates to products in a sell group.

The system checks the sell matrix for active sell group rebates, then checks for defined rebate tables for the product's sell group. If the product's sell group has defined rebate tables, the system uses the most recent table relative to the order's pricing date to apply the rebate. More:

Base Minimum GP% Price Check Off COMM-COST

Use this record if you have overrides in either Price Line Maintenance, Product Maintenance, or User Maintenance that limit a user’s ability to lower a price on an order based on a gross profit percent (GP%). You can have the system use commissions cost (COMM-COST) instead of the cost of goods sold (COGS) value. More:

Best Cost Check Through All Matrix Cells For Sales Orders

Use this record to have the system check the entire pricing hierarchy for the best cost override to determine the cost on a sales order. This record applies to both commissions costs (COMM-COST) and cost of goods sold (COGS). This control maintenance record does not apply to direct sales orders and does not change pricing. More:

Copy COST To COGS For IAO Items In SOE

Use this record to indicate if you want the system to copy the COST value to the cost of goods sold (COGS) value when a user adds an inventory account override (IAO) item to a sales order. This record only applies to adding an item to a sales order not orders in Purchase or Transfer Order Entry. You must set up an IAO cost for each branch. An IAO item is a stock or nonstock product that has been assigned an Inventory Account Override. More:

Direct COGS Always Vendor Price

Use this record to indicate if the system should use vendor costs on the sales order side of a direct order. More:

Disallow Copying Of COGS Or Cost To A New Sales Order Bid

Use this record to restrict users from copying cost of goods sold (COGS) or Cost information from an existing sales order to a new sales order bid regardless of their permissions. More:

Global Basis Used For In-Stock Cost Calculation on Rebates

New in Release 8.7.9

Select the global basis you want to use to calculate cost comparisons for rebates as follows. Eclipse calculates COST using this basis compared to the cost calculated by the override, if the Best Cost Check flag is set to All in Price Maintenance. If the Best Cost Check flag is set to All and this control maintenance record contains a selection, then Eclipse checks if the stock cost is lower, meaning better, than the override entry. The system then ignores the cost overrides in the hierarchy and the stock cost is used.

Include Item With Zero Average Cost In Average Cost Calculation

Use this record if your company runs reports using average cost or if your Cost of Goods Sold basis is set to Average Cost. By default, the system includes on-hand items with $0.00 average cost in the average cost calculation when additional inventory is received. This control maintenance record affects average cost and landed average cost. More:

Include Tagged Quantities In Cost Calculation

Use this record if your company runs reports using average cost or if your Cost of Goods Sold basis is set to Average Cost. Indicate which tagged quantities the system includes in the cost calculation. Use this control maintenance record to keep inventory value and your G/L in balance. Click More for more information. More:

Log The First Non-Zero Cost For Products

New in Release 9.0.3

Indicate if you want the system to keep track of when a cost changes from zero to the first non-zero cost. The default is No.

Note: Enabling this control maintenance record may effect the speed at which your system checks costs.

Notify User When COGS Is Changed During Order Processing

Use this record if you want to notify a specific user when the cost of goods sold (COGS) is changed on an order during order processing. More:

Recalculate COGS And COMM-COST When Changing Bid To Open Order

Use this record if you want the system to recalculate the cost of goods sold (COGS) and the commissions cost (COMM-COST) that were not manually overridden when a bid is changed to an open order generation. Costs that are manually overridden retain their cost calculation if you set this record to K.. More:

Recalculate COGS And COMM-COST When Recalculating Price On Invoice

Allows Recalculate COGS And COMM-COST when recalculating price on invoice. Options are Yes or No.

Small Project Job Setup

New in Release 9.0, Updates in Release 9.0.1, 9.0.2, 9.0.3, 9.0.4 and 9.1.0.

Use this record to apply or change options for Small Project Jobs (SPJs) transactions. More:

To See Standard Global Basis When Costing, User Must Have Level

Use this record if you want the standard global basis to display when costing. Use the levels set up in the COGS.EDIT authorization key in conjunction with this control maintenance record to assign views. More:

Update Cost On Sales Order From Tagged Purchase Order

Use this record to indicate if the system should update costs on a sales order containing items that are tagged to a purchase order for procurement when a price change is made to the tagged purchase order. More:

Update Cost On Sales Order From Tagged Return Purchase Order

For each branch, indicate whether the system updates the cost on a sales order tagged to a purchase order created from the Return Goods Queue with the cost on the purchase order. Set the control maintenance record for each branch. More:

Update Cost On Sales Order From Tagged Transfer Order

Use this record to indicate whether the system updates the cost on a sales order containing items that are tagged to a transfer for procurement when a change is made to the Transfer Received Price of the tagged transfer. More:

Update Generic Cost During Processing

For each branch, indicate whether the system updates the Generic Cost (formerly labeled COMM-COST) that is filed with each transaction whenever the cost of goods sold cost (COGS-COST) of a transaction is updated in processing. More:

When Costing, Do Not Show Basis With Level Below

Set the lower boundary for viewing costs based on the view level assigned to each basis in Price Line Maintenance for the products in a price line. More: