| # Decouple actual delivery and sales order line data Infor ERP LN 6.1 FP6 In Infor ERP LN 6.1 FP6, the following information is stored twice in different tables: Sales order actual delivery information in tdsls401 and tdsls406. Sales order turnover history in tdsls451 and tdsls456. New in Infor10 ERP Enterprise In Infor10 ERP Enterprise, a start is made to decouple actual deliveries from sales order line data, so data is no longer stored twice. This reduces the data growth for customers and increases the performance for the sales order business process. However, for the time being, primarily technical changes are implemented regarding this topic. Functional changes are only made for commissions and rebates. Commissions and rebates If, in the Relations (tdcms0110s000) session, the Calculation Method field is set to Sales Invoice, or Paid Sales Invoice, commission and rebate relations and the calculated amounts are relinked to the sales order actual deliveries when deliveries have taken place. The calculation of commissions and rebates is based on turnover information from the sales order actual delivery lines, as stored in the tdsls456 history table, instead of from the sales order line history table (tdsls451). To control how the commissions/rebates are calculated after sales order deliveries are executed, the new Calculation Method for Deliveries field is added to the Relations (tdcms0110s000) session. The following fields are also new: Actual Delivery Line Sequence Number Invoice Line Relation Sequence, which is the sequence number of the commission or rebate that is linked to the relation in the Sales Order - Relations (tdcms0140m000) or Sales Order Line - Relations (tdcms0141m000) session. These fields are added to the following sessions:
Session | Actual Delivery Line Sequence Number | Invoice Line | Relation Sequence
--- | --- | --- | ---
Sales Order Line - Relations (tdcms0141m000) | x | x | -
Rebates Calculated by Relation (tdcms3550m000) | x | x | x
Rebates Calculated by Order (tdcms2550m000) | x | x | x
Commissions Calculated by Relation (tdcms1550m000) | x | x | x
Commissions Calculated by Order (tdcms0550m000) | x | x | x
Commissions Paid to Employees by Relation (tdcms1151m000) | x | x | x
Commissions Paid to Employees by Order (tdcms0151m000) | x | x | x
Link Relation Team to Order Line (tdcms1241m000) | x | x | -
Close Commissions Reserved for Employees (tdcms2102m000) | x | x | -
Relations by Invoice (tdcms2502m000) | x | x | -
Commissions Calculated by Cumulative Sales (tdcms1500m000) | x | x | -
Rebates Calculated by Cumulative Sales (tdcms1505m000) | x | x | -
The following sessions are expired: Commission Agreement Parameters (tdcms0135s000). Now use the Commission Agreements (tdcms0135m000) or Commission Agreement - Grades (tdcms0635m000) sessions. Commissions Calculated by Order (tdcms0150s000). Now use the Commissions Calculated by Order (tdcms0550m000) session. Commissions Calculated by Relation (tdcms1150s000). Now use the Commissions Calculated by Relation (tdcms1550m000) session. Rebate Agreement Parameters (tdcms1135s000). Now use the Rebate Agreements (tdcms0135m100) or Rebate Agreement - Grades (tdcms0635m100) sessions. Rebates Calculated by Order (tdcms2150s000). Now use the Rebates Calculated by Order (tdcms2550m000) session. Rebates Calculated by Relation (tdcms3150s000). Now use the Rebates Calculated by Relation (tdcms3550m000) session. The following tabs are added to the Sales Order - Lines (tdsls4100m900) and Sales Order Line - Planned Deliveries (tdsls4101m900) sessions: Actual Delivery Lines The lines on this tab refer to the Sales Order Actual Delivery Lines / Sales Order Invoice Line (tdsls4106m000) session, in which you can view the actual delivery information for the sales order (delivery) lines. Relations The lines on this tab refer to the Sales Order Line - Relations (tdcms0141m000) session, in which you can view and link relations to sales order (delivery) lines. This tab is disabled if the Linking of Relations On fields are set to Sales Order in the Commissions/Rebates Parameters (tdcms0100s000) session. Related topics Overview of commissions and rebates |