ACCT COST General Control Maintenance Records

The following control maintenance records belong to the COST area within the ACCT (Accounting) category.  

Central Warehousing Average Costing Enabled

Indicate whether the system calculates average cost, last cost, landed average cost, and landed cost, based on the inventory in all the branches included in the central warehouse and central purchasing environments. ClosedMore:

Options

  • Y - Central Warehousing and Central Purchasing - Computes the costs using cost information from the inventory in the parent and child branches in central warehousing and central purchasing environments.

  • W - Central Warehousing Only - Computes the costs using cost information from the inventory in the parent and child branches only in a central warehousing environment.

  • P - Central Purchasing Only - Computes the costs using cost information from the inventory in the parent and child branches only in a central purchasing environment.

  • N - Not Enabled - Computes the costs using cost information only from inventory in the parent branch.

Outcome of setting this control record

Determines how costing is calculated if you use a central warehouse model.

Default Value(s)

N - Not Enabled

Action if set to Null

Same as if set to N.

Additional Information

Also set the Include Item With Zero Average Cost in Average Cost Calculationcontrol maintenance record.

Cost Of Goods Sold Basis Name

Enter a basis name, commonly REP-COST, with which to populate the Basis field that corresponds to the COGS-COST global name in Price Line Maintenance. ClosedMore:

Options

Any cost basis name.

Outcome of setting this control record

Setting this control record ensures that the basis name assigned to the COGS-COST global name is the same for all price lines. You must then enter this name in the designated position in the Basis Names column in the Price Line Maintenance. Do not change this name after you have defined it.

Default Value(s)

None

Action if set to Null

Same as if set to DFLT-COST.

Additional Information

If you use AVG-COST as your COGS, be aware that the system does not recalculate AVG-COST based on either:

  • Issuing a credit for a product that was returned using a different cost than the original AVG-COST.

  • Canceling a purchase order that had incorrect product pricing.

    In the latter case, you can force the average cost to be recalculated by opening the purchase order, correcting the cost, and canceling and reissuing any open generations/backorders.

Note: You must correct any sales orders issued between the time the purchase order was received at the incorrect cost and the time the purchase order was corrected.

Cost To Use On Commissions OE Elements

Choose the cost type the system uses to calculate the commission on a commission plan view in Sales Order Entry. Use the control record to apply the cost, either COMM or GOGS.

Global Buy/Sell Basis Names

Enter each global cost or price basis name the system can use, a corresponding view level 1-9, and a corresponding nonstock indicator. ClosedMore:

Options

In the Global Basis column, enter a global cost or price basis name for each prompt in the left-hand column that your system uses. A global basis name refers to a cost or price that has a consistent meaning to all parts of the system. The list can contain up to 20 names. These names display in the Global column on the Price Line Maintenance window.

Do not change the Closedfirst eight names assigned during implementation.

Use and modify the user-defined prompts as needed. You can enter them in upper, lower, or mixed case.

  • DFLT-LIST

  • DFLT-COST

  • COGS-COST

  • COMM-COST (or GENR-COST)

  • REBAT-COST

  • SELL-BREAK

  • PURC-BREAK

  • DISP-COST

  • MIN-PRICE

 

In the VLvl column, enter a view level, 1-9, for each global basis name. The view level assigned to each global basis name works with the view level assigned to the following authorization keys for making price changes in sales order entry or transfer order entry:

When changing the cost for a group of products, the F10 list of choices contains the costs the user is authorized to change.

In the Incl Nonstock column, for each global basis name, indicate whether users can assign a value to this basis name on the Nonstock Entry window in sales order entry as follows:

  • D - Display. The global basis name displays in Nonstock Entry. The system updates the price sheet for the designated basis name with the value the user enters in the Nonstock Entry.

  • U - Update Only. The global basis name does not display in Nonstock Entry. The system updates the price sheet for the designated basis name with the value entered for the DFLT-LIST or DFLT-COST field, depending on whether the basis name is a price or cost basis.

  • N - Not Used. The global basis name does not display in Nonstock Entry. The system does not update the price sheet for the designated basis name.

Outcome of setting this control record

Defines the global basis names that are available throughout the system.

Action if set to Null

You cannot set the Include Nonstock column to D or U if the Global Basis field is empty.

Additional Information

  • Dflt List Prompt and Dflt Cost Prompt are set to D - Display and cannot be changed. If the price line for a nonstock product has the same local basis name assigned to more than one global basis name, and those global basis names have a D indicator, only the topmost global name from the Price Line Maintenance window displays in the Vscroll region on the Nonstock Entry window. The global basis names with a D indicator display on the Nonstock Entry window, along with the local basis name assigned to the global basis name.

  • If you are using the Strategic Pricing companion product, you also have a Strategic List and a Strategic Cost global basis available that takes the place of user-defined 9 and 10. If you are using Strategic Pricing, be sure to map your Strategic List and Strategic Cost to a local basis.

Include Item With Zero Average Cost In Average Cost Calculation

Indicate whether the system includes on-hand items with $0.00 average cost in the average cost calculation when additional inventory is received. The default is N.  ClosedMore:

Options

  • Yes - Includes on-hand items with $0.00 average cost in the average cost calculation. This allows for the current on-hand quantity to offset the new average cost calculated.

  • No - Does not include on-hand quantities with $0.00 average cost in the average cost calculation.

Outcome of setting this control record

Changes how average cost is calculated by including on-hand items with $0.00 average cost.

Default Value(s)

No

Examples

If set to Yes:

On-hand qty = 9 with current average cost = $0.00

Receive 1 with $10.00 cost

New average cost = $1.00 ($0.00*9 + $10.00*1) / (9 + 1)

If set to No:

On-hand qty = 1 with current average cost = $0.00

Receive 1 with $10.00 cost

New average cost = $10.00 (system did not include $0.00 average cost on-hand item)

Action if set to Null

Same as if set to No.

Additional Information

This control record affects both average cost and landed average cost.

Update Cost On PO From Tagged Return SO In Return Goods Queue

Indicate how you want to handle cost overrides from a tagged return sales order to the return purchase order.  ClosedMore:

Options

  • Y - Updates the cost on the original purchase order to the cost override on the return order.

  • N - Uses the cost on the original purchase order, regardless if the cost is overridden on the return order.

Outcome of setting this control record

Setting this record to Yes helps alleviate the potential for variances in your general ledger as the returned product is brought back into inventory at one value on the return but is deducted from the inventory general ledger on the return purchase order.

Default Value(s)

No

Action if set to Null

Same as if set to No.

Additional Information

None

Wells Fargo Payment Manager

See Setting Up Wells Fargo Payment Manager in the Wells Fargo Payment Manager online help for full details.