Manage alternate cost profitability
You can define and manage alternate cost codes for items and specify whether they are included in profit calculations. This is defined by the Track Status Profitability checkbox on the Alternate Costs page.
To view the cost profitability for the line item, follow these steps.
- Navigate to the Sales Order page.
- Fill in the necessary fields.
- On the action bar, select Release.
- On the Lines FastTab, go to the desired item line.
- On the action bar, selected Line > Related Information > Sales Line Alternate Costs.
The Sales Line Alternate Costs page opens.
You can view the following information for the related item.
| Field | Description |
|---|---|
| Document Type | Specifies the type of document associated with the alternate cost entry. |
| Document No. | Specifies the number of the document associated with the alternate cost entry. |
| Item No. | Specifies the item for which the alternate cost is defined. |
| Variant Code | Specifies the item variant associated with the alternate cost, if applicable. |
| Alternate Cost Code | Specifies the alternate cost code assigned to the item. |
| Alternate Code Description | Specifies the description of the selected alternate cost code. |
| Quantity | Specifies the quantity used to calculate the alternate cost. |
| Unit Cost | Specifies the unit cost used for the alternate cost calculation. |
| Unit of Measure Code | Specifies the unit of measure associated with the quantity and unit cost. |
The item lines with the alternate codes for which the Track Status Profitability checkbox has been selected only have values calculated, else the field values are blank.
To view the cost profitability for the items based on alternate costs in an order, follow these steps.
- Navigate to the Sales Order page.
- Fill in the necessary fields.
- On the action bar, select Release.
-
Select Actions > Functions > Alternate Cost Profitability.
The Select Alternate Cost list page opens and displays all the alternate costs for which the Track Status Profitability checkbox is selected.
-
Select the desired code and then OK.
The Alternate Cost Profitability page opens.
-
On the General FastTab, you can view details of the selected alternate cost code along with sales order information inherited from the related Sales Order Statistics page.
The following fields are related to alternate cost and profits.
Field Description Alternate Profit (LCY) Specifies the alternate profit assigned to the item. Alternate Cost (LCY) Specifies the alternate cost assigned to the item. Alternate Profit % Specifies the alternate profit percentage assigned to the item.
The alternate cost fields are calculated as follows:
Alternate Profit (LCY) = Sales Amount for Alt Cost Lines (LCY) − Alternate Cost (LCY)
Alternate Profit % = (Alternate Profit (LCY) / Sales Amount for Alt Cost Lines (LCY)) × 100
On the Line-Level Detail FastTab, you can view the item information associated with the selected code. The Alternate Cost Code field value is updated in the item line for which the Track Status Profitability checkbox is selected and the Alternate Unit Cost, Alternate Unit Margin, Alternate Margin % field values are calculated and updated.