Cleaning up old invoices tables

Invoices with status Posted.

After completing the installation of LN 10.2 (or later) and the Data Upgrade process. The converted Invoicing tables, the ‘old’ tables, still contain the old Invoice data. This data can be removed.

  1. Start the Clear Obsolete Invoice Tables (cisli9205m000) session in LN.
  2. Specify the selection ranges and click Process. This removes all data in these tables:
    • cisli205
    • cisli206
    • cisli207
    • cisli208
    • cisli209

    We recommend that you run this post-Data Update Engine step any moment in time after the Data Upgrade Process has finished. The data in the tables that were mentioned earlier are no longer used by LN 10.2 (or later versions). It only consumes disk space which can be freed up.

    Run this removing process once, as invoices that are created with LN 10.2 (or later versions) will not exist in the tables mentioned earlier.

    Wherever applicable, the operations package such as Sales Orders, zoom to the new environment and no longer to the tables that were mentioned earlier.

    In addition, the Archive and Delete Invoicing Data (cisli3210m000) session is rewritten for better control of Invoice Data. With this session, the redundant Posted Invoice Lines (for example; table cisli245, cisli255 etc.) can be removed. This data is already available in the new Invoice Line table (cisli310).

    For new Invoices, the data is automatically removed from the tables cisli245 and parallel tables. For upgraded Billable Lines, the data is automatically removed from the tables cisli245 and parallel tables during the upgrade.