Sales Orders below/above Allowed Margin (tdsls4118s000)
Use this session to display sales order margin control log records.
Field Information
- Order
-
The number of the sales order, or sales schedule.
- Line
- Transaction Date/Time
- Login Code
- Sold-to Business Partner
- Internal Sales Representative
- Sales Office
- Item
-
The item for which a sales price is entered below or above the allowed margin.
- Margin Type
-
The margin type, which is defined for each user in the Margin Control Parameters (tdsls0120m000) session.
Allowed values
- Gross Margin Header
-
The target price and the total sales price are used to calculate the gross profit percentage. This percentage is evaluated against the margin limits, as registered in the Sold-to Business Partner (tccom4110s000) session. The target price for gross margin control at header level is the total standard cost of the goods, registered in the Item - Costing (ticpr0107m000) session, for a certain order or quotation.
- Gross Margin Line
-
The target price and sales price are used to calculate the gross profit percentage. This percentage is evaluated against the margin limits, as registered in the Items - Sales (tdisa0501m000) session. The target price for gross margin control is the standard cost of the item recorded in the Item - Costing (ticpr0107m000) session.
- Margin
-
The target price and sales price are compared and evaluated against the margin limits, as registered in the Items - Sales (tdisa0501m000) session. Depending on the value of the Target Price for Margin Control field in the Sales Order Parameters (tdsls0100s400) session, the target price is:
- The sales price recorded in the Items - Sales (tdisa0501m000) session.
- The suggested retail price recorded in the Items - Sales (tdisa0501m000) session.
- The standard cost of the item recorded in the Item - Costing (ticpr0107m000) session.
- The selling price found after a search action in Pricing .
- Upper Margin
- Actual Line Margin
-
The percentage that the net sales price of the line deviates from the target price.
- Lower Margin
- Excess Upper Margin
-
The percentage that the line exceeds the upper margin, which is calculated as follows:
Actual Line Margin - Upper Margin - Line Discount
-
The discount that applies to the sales order line.
- Below Lower Margin
-
The percentage that the line falls below the lower margin, which is calculated as follows:
Actual Line Margin - Lower Margin - Order Discount
-
The order discount related to the sales order header. LN uses the discount in this field to determine the net order price, which is compared with the target price.
- Target Price
- Target Price
-
The currency in which the sales order amounts are expressed.
- Based on
-
The price that is used as a target price in margin control.
- Net Price
- CMS Amount Price
-
The commission amount and/or bonus amount for the order line, converted to the unit price.
- Price Entered
-
The gross price for the order line. The gross price does not include the order line discount and the order header discount. For each sales price unit, this price is expressed in the home currency.