Skip to main content

Invoice line history clean up​

ExFlow | Periodic tasks | Clean up | Invoice line history clean up

Purpose​

The Invoice History Clean-up Batch is a crucial component of maintaining an efficient and clutter-free invoices. This batch process focuses on removing information from the invoice Line History tab, specifically: Dimensions, Approvers, and Deleted Line History.

Graphical user interface, application Description automatically generated

Step by step process​

Invoice line history clean up​

  • Go to ExFlow – Periodic tasks – Clean up -Invoice line history clean up.
  • Input required number in the Transactions older than (Years).
  • Enable batch and run in the batch.
  • Select OK
  • After batch is ran, data will be deleted

medium

Graphical user interface, text, application Description automatically generated


Class​

EXF_cInvoiceLineHistoryLogCleanup

Affected tables​

  • EXF_tDocumentLineApproverLog
  • EXF_tDocumentLineDimensionLogHead
  • EXF_tDeletedLinesInvoiceHistory

Functional explanation​

The job removes invoice-line approval, dimension, and deleted-line history that is older than the selected number of years. Recent history remains available while older history is cleaned up.

Important note The default shown is 10 years, and the same cutoff is applied across all three history areas.

NameClassAffected Table
ExFlow AP - Log cleanupEXF_cLogCleanupEXF_tLoggingWeb
EXF_tDocumentLineApproverLog
EXF_tDocumentLineDimensionLogHead
EXF_tDeletedLinesInvoiceHistory
ExFlow AP - Import history data cleanupEXF_cImportTableLogCleanUpEXF_tImportTableLog (Only the contents of the XML / XMLRaw fields are cleaned for old records)
ExFlow AP - Web log cleanupEXF_cWebLogCleanupEXF_tLoggingWeb
ExFlow AP - Invoice line history cleanupEXF_cInvoiceLineHistoryLogCleanupEXF_tDocumentLineApproverLog
EXF_tDocumentLineDimensionLogHead
EXF_tDeletedLinesInvoiceHistory
ExFlow AP - Delete temporary journals separatelyEXF_cNoPostingAtArrivalDeleteTempJournalsLedgerJournalTable (Related journal transaction data is deleted indirectly through the standard LedgerJournalDeleteTransaction process)
ExFlow AP - Clean up duplicate attachmentsEXF_cDocuRefCleanupDocuRef