Archive and Delete Sales Orders (tdsls4224m000)

Use this session to delete, archive, or archive and delete sales order- and sales order line-data.

Note

The archiving functionality is available in this session only if the Sales Order Archiving Implemented check box is selected in the Sales Order Parameters (tdsls0100s400) session.
Sales contracts must be archived before sales orders can be archived
When all lines of an order are deleted, LN also deletes the sales order.
If Financials is implemented, for best results you must not delete order data in a fiscal year that has not been fully closed. If you perform matching, logistic transactions with financial transactions might become impossible.
When a sales order is canceled, you can only delete the sales order and the related tables. If only a sales order line is canceled, the line can be deleted and archived.

You cannot delete a processed sales order or sales order line if for a linked order (delivery) line:

The order (delivery) line is Canceled. Consequently, you must delete the sales order (delivery) line with the status Canceled in this session
The order (delivery) line is invoiced after the date you specified in the Delete up to Invoice Date field.
The order (delivery) line is not yet Processed.
The order (delivery) line has an unconfirmed backorder quantity.
The project of the order (delivery) line is not archived in the Archive/Delete Projects (tipcs2260m000) session.
The EDI invoice (if applicable) is not yet sent.

Invoked tables

This table shows the data that is archived and/or deleted:

Sales order headers
Sales Orders (tdsls400)
Sales Order Installments (tdsls010)
Sales Order Activities (tdsls413) (for position zero)
Sales Change Order Sequence Numbers (tdsls414)
Order (Line) Blocking (tdsls420) (for position zero)
Sales Order Promotion Link (tdsls436)
Sales Order Potential Premium (tdsls437)
Sales Order Premium Link (tdsls438)
Document Global Trade Compliance Information (tcgtc100) as linked to the header
Sales order lines
Sales order Lines (tdsls401)
Linked Order Line Data (tdsls402)
Sales Order Bills of Material (tdsls403)
Transfer Orders by Sales Order Line (tdsls404)
Linked Accessary Order Lines (tdsls405)
Sales Order Actual Delivery Lines (tdsls406)
Order Lines Shipping Constraints Related Sets (tdsls407)
Linked Order Line Data for Invoicing (tdsls408)
Sales Order Actual Delivery Line COGS
Sales Order Line Item Data (tdsls411)
Order Priority Simulations (tdsls412)
Sales Order Activities (tdsls413)
Sales Order Estimated COGS (tdsls415)
Sales Order Material Supply Line (tdsls416)
Sales Order Line Confirmations (tdsls419)
Order (Line) Blocking (tdsls420)
Sales Deliveries (tdsls426)
Sales Additional Cost Relations (tdsls427)
Sales Order Main Item (tdsls461)
Sales Order Line Components (tdsls463)
Sales Order Line Components Potential Back Orders (tdsls464)
Sales Order Line Components Estimated COGs (tdsls465)
Sales Order Line Components Actual Deliveries (tdsls466)
Sales Order Line Components Surplus (tdsls467)
Sales Order Line Components Actual Delivery COGS (tdsls469)
Specifications (tcibd420)
Document Material Price Agreements (tcmpr100)
Document Material Information (tcmpr110)
Document Global Trade Compliance Information (tcgtc100) as linked to the line
Additional Information (tcstl210)

Archive or Delete

The method for processing the data.

You can select:

Delete, if you want to delete the data.
Archive, if you want to transfer the data to the archive company.
Both, if you want to transfer the data to the archive company and then delete the data from the operational company.

Print Errors

If this check box is selected, and errors occur during the deletion or archiving process, an error report is generated.

Delete

Delete Canceled Lines

If this check box is selected, the canceled sales order lines are deleted.

Delete up to Order Date

The order date up to which the canceled sales order line data must be deleted.

Delete Processed Orders

If this check box is selected, the processed sales orders and order lines are deleted.

Delete up to Invoice Date

The date up to which the processed sales order data must be deleted. LN deletes all processed sales order lines of which the invoice date is earlier than the date as entered in this field.

Delete Orders without Lines

If this check box is selected, the sales orders to which no lines are linked, are deleted.

Delete up to Order Date

The date up to which the sales orders without lines must be deleted.

The specified date is matched with the order date.