The following describes how to edit the cost settings (pricing) that will be used when updating some of the System balance types. Note: You normally enter this information when you set up your company, but can edit the information when you so desire.
The Notebook in which you work to edit the cost settings is a collection of all costs by tables/files. Each unique area has it’s own notebook page, which includes the following:
- DIS control file: Sales order related costs and Stock rate cost
- Sales order type: Sales order type factors
- Transaction type: Inventory transaction related costs
- Business partner request resolution: Resolution costs for requests
Since all applicable costing is gathered into one notebook, the maintenance of these cost settings is simplified.
Some costs are automatically updated by the system during the actual event (e.g., sales order line cost and sales order cost are updated in the Balance file during invoicing). Other costs, however need to be manually updated. For such costs you run the Periodical balance update program. (See Start the periodical balance update for profitability analysis for instructions).
To access the applicable notebook do as follows:
- Select the Edit cost settings menu item from the Profitability Analysis sub-menu.
- You access the Cost settings window, with the DIS control file page displayed first:
DIS control file page:
On this page you enter the following:
- Order cost: How much one order will cost
- Order line cost: How much one order line will cost
Note: Depending on the sales order type for the order, the cost should vary (i.e. a standard order that is fully processed with all documents should cost more than a direct delivered order). There is, therefore, a direct correlation between the Order cost / Order line cost and the Sales order type table (see that page below for instructions on entering a factor for each order type). This factoring is ideal in the event that you need to increase/decrease your cost. You need only update the Order cost and Order line cost. The system will adjust the cost according to the factor for the applicable sales order type.
- Quotation line cost: Enter how much one quotation line will cost
- Stock rate: This field is used to update the Average tied up capital cost which is a System balance type.
Toggle to the Sales order type page
Sales order type page:
On this page you enter the Order cost factor and Line cost factor for one Order / Order line with the associated sales order type. Depending on the order type that is associated with an Order / Order line, the cost could vary. For example, a standard order which includes all documents should be more expensive than a direct delivered order. The factor entered for each order type will be multiplied with the Sales order cost, respectively Sales order line cost you entered on the DIS control file page.
By entering a factor, not only is your costing more accurate, but you also gain the advantage of only having to change the Sales order cost / Sales order line cost should a price increase/decrease be necessary.
Click in the applicable column for the applicable sales order type to enter the factor.
Toggle to the Transaction type page.
Transaction type page:
There are a lot of different warehouse costs for which there are transactions. In this page you map what cost will be charged if something occurs for the Inventory transaction type – thereby affecting the balance.
For the applicable Inventory transaction type, click in each of the following columns and select the applicable information:
- Balance type: Click in this column for the applicable Inventory transaction type. Pull down the drop down list and select from any of the available Balance types:
- Calculation method: The following three methods are available for calculating the cost for the balance type connected to the inventory transaction:
- Transaction cost
- Item cost
- Transaction and item cost
| Balance Type | Description |
|---|---|
| 112 | Damaged goods cost |
| 117 | Expired/obsolete items cost |
| 114 | Internal use cost |
| 115 | Miscellaneous warehouse cost |
| 120 | Rejected from production cost |
| 119 | Gain/loss returned goods cost |
| 111 | Stock handling cost |
| 116 | Sales samples cost |
| 113 | Theft/lost goods cost |
| 118 | Write off depreciation cost |
Pull down the drop down list in this column for the applicable inventory transaction and select that applicable.
- Transaction cost: Click in this column for the inventory transaction type and enter the applicable transaction cost.
Toggle to the Business partner request resolution page.
Business partner request resolution page:
This page displays the business partner request resolution costs (for a request). Per resolution code, you map the resolution cost (what it will cost to resolve the request) and how much it cost per worked hour (if applicable).
Click in the applicable column for the applicable resolution code to enter the cost.
Save and exit.