Archiving Logistical Data

Introduction

Before you archive data, you must complete various tasks to ensure the maximum number of records will be archived and that they are archived correctly. One general rule always applies: do not archive data if the fiscal year has not been fully closed.

How and when operations management data can be archived is determined by the options under Block deleting of in the Reconciliation Groups (tcfin0120m000) session. A balance must be made between the importance of being able to audit data from the financial transaction back to the logistical transaction, and the flexibility to remove data in operations management. For more information, refer to the User's Guide for Reconciliation and Analysis (U8942* US).

Data preparation

Generally, you can only delete or archive data if it is processed completely in LN. The archiving session checks whether a record has the correct status, and whether all previous steps in the procedure have been completed before removing the data from the operational tables. This guarantees no data is removed that has not been completely processed, which may cause data inconsistency.

Before you archive logistical data, run the following sessions:

  • Process Delivered Sales Orders (tdsls4223m000)
  • Process Delivered Sales Schedules (tdsls3223m000)
  • Process Delivered Purchase Orders (tdpur4223m000)
  • Process Purchase Schedules (tdpur3223m000)
  • Process Commissions/Rebates sessions
  • Close Orders (Production, Warehousing) sessions
  • Process Hours and Expenses (bptmm1203m000)

These sessions will often be part of your normal day-to-day business processes; if so, you are not required to run these sessions.

Data checks

Before archiving data, you must check whether the data in your operation is consistent and not corrupt. If data corruption exists, you must repair this data before you archive data.

For best results, you must also run several check reports. You can use these reports to view the results of running a specific archiving session. The same report with the same selection must return the same result when run in the archive company.

The following list provides some useful check reports:

  • Records per table
  • Item issue by period
  • Inventory transactions by order
  • Cost price calculation
  • Job shop orders
  • Hours history by employee

To remember the print selection, create a screenshot of the print session.