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 (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)

Field Information

Archive or Delete

The method for processing the data.

You can select:

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

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. If after deletion a header without sequences remains, the header is also 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.

Archive
Original Company

The company for which the data is archived.

Archive-to Company

The archive company to which the data is transferred.

Note: This company is retrieved from the Archive-to Company field in the Implemented Software Components (tccom0500m000) session.
Archive up to Date

The date up to which the data must be archived.

Archive Common Master Data

If this check box is selected, general data from Common is archived.

Note: 
  • This check box is available only if the Archive General Data only via session Archive General Data check box is cleared in the COM Parameters (tccom5000m000) session.
  • You can also use the Archive General Data (tccom0250m000) session to archive general data.
Archive Sales Master Data

If this check box is selected, general data from Sales is archived.

Note: 
  • This check box is available only if the Archive General Data only via session Archive General Data check box is cleared in the COM Parameters (tccom5000m000) session.
  • You can also use the Archive General Data (tccom0250m000) session to archive general data.
Archive Text

If this check box is selected, texts are also archived.

Overwrite Text

If this check box is selected, texts that already exist in the archive company are replaced with the original text.