| | Decouple actual delivery and sales order line data Infor LN FP6 In Infor LN 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 Infor LN 10 In Infor LN 10, 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 - Deliveries (tdsls4101m900) sessions: Actual 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.
| |