| # Decoupling actual delivery and sales order line data Infor LN 10 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 A start was made to decouple actual deliveries from sales order line data, so that data is no longer stored twice. Primarily, technical changes were implemented. Functional changes were made only for commissions and rebates. Infor LN 10.2.1 Actual delivery data and sales order line data were fully decoupled. This reduces the data growth for customers and increases the performance for the sales order business process. For full decoupling, many technical and functional changes were implemented. The next sections describe the changes. Replace tdsls401 data by tdsls406 data Actual delivery information that is used in the Sales Order Lines (tdsls401) table was replaced by (aggregated) information from the Sales Order Actual Delivery Lines (tdsls406) table. Changing price and discounts after delivery Change Prices and Discounts after Delivery (tdsls4122m000) You can now use this session to change prices and discounts only for delivered sales orders lines of the Order Line type, which are also known as total lines. Changes on these total lines are synchronized to all actual delivery lines and sales order delivery lines that are not finally delivered. Change Prices and Discounts of Sales Invoice Lines (tdsls4132m000) You can now use this session to change prices and discounts for invoiced sales orders lines of the Order/Delivery Line and Back Order types. Remove split shipments When multiple shipments are received for an order line, the original line is no longer split into a total line with detail lines, but multiple actual delivery lines/invoice lines are inserted for the order line. The original sales order line is cumulatively updated with the delivered quantity. If a delivery is final and a back order is applicable for the order line, the original sales order line is no longer split into a total and detail line, but the back order line is linked to the original sales order line. New main table for sales deliveries Sales deliveries for items that are not delivered through Warehousing or Procurement, which you can specify in the Sales Deliveries (tdsls4101m200) session, are no longer based on the tdsls401 (Sales Order Lines) table, but on the tdsls426 (Sales Deliveries) table. Multiple deliveries per sales order line can be specified and, after confirmation, actual delivery information is created that can be invoiced and processed further. Link order activities to sales order actual delivery lines Order activities that take place after delivery are now shown by actual delivery line/invoice line. You can view the activity status of an order line in more detail. The following sessions were added or changed: The Sales Order Lines Monitor (tdsls4510m100) session was added. This session is displayed in a tab in the Sales Order (tdsls4100m900) and Sales Order Line (tdsls4101m900) sessions. This session shows the sales order line status. The Sales Order Lines - Monitor (tdsls4510m000) session is no longer used for zooming. To retrieve order line data, you zoom to the Sales Order Lines (tdsls4101m000) session. To retrieve invoicing or shipping data, you zoom to the Sales Order Invoice Lines (tdsls4106m100) session. The Sales Order Lines - Monitor (tdsls4510m000) session is now used as a stand-alone session for monitoring. Move turnover history from tdsls451 to tdsls456 Turnover history is no longer stored in the Sales Order Line History (tdsls451) table. This table now only shows intake and cancellation history. Turnover history is now logged in the Sales Order Actual Delivery Line History (tdsls456) table. Therefore, if the Log Order History check box is selected in the Sales Order Parameters (tdsls0100s400) session, turnover history for processed delivery lines is logged in the Sales Order Actual Delivery Line History (tdsls4556m000) session. If the Log Actual Order Delivery History check box is also selected in the Sales Order Parameters (tdsls0100s400) session, history for unprocessed delivery lines is also logged in the Sales Order Actual Delivery Line History (tdsls4556m000) session. Unprocessed history records are logged in the Sales Order Actual Delivery Line History (tdsls4556m000) session when: Actual delivery lines are inserted in the Sales Order Actual Delivery Lines / Sales Order Invoice Line (tdsls4106m000) session Consumptions are processed Invoice lines that require customer approval are approved The Sales Order History View (tdsls4650m000) session was added. This session provides an overview of all history. Note When tdsls451 turnover is used in customizations, or by external reporting applications and business analysis tools, make sure to perform the required changes. Sales statistics and retrobilling If you use sales turnover data to update the statistics or to calculate retrobilled price changes, calculations are now based on the actual delivery history. Sales turnover refers to all sales orders or schedules that are processed in the Sales Order Actual Delivery Line History (tdsls4556m000) session. Intake information that is required to process turnover information is retrieved from the last tdsls451 intake record. Return orders If a sales return order line must be linked to the original data and the Original Document Type is Shipment or Invoice, you can now select an Original Document No from the Sales Order Invoice Lines (tdsls4106m100) session. This session is required to retrieve the correct original data such as cost of goods sold, currency rates, and tax data. |