SAASInventory

Archive Discontinued Items

Archiving removes discontinued items from active inventory views while preserving complete transaction history and records. Unlike deletion, archiving maintains historical data for reporting, auditing, and compliance while decluttering day-to-day operations.

ActionPath
View archived itemsInventory > Archived Units
Archive an itemItem Master > Mark item as discontinued > Archive appears automatically
Run archived inventory reportReports > Search for “Archived Inventory” (Report 141)

Understanding Archiving

When you mark an item as discontinued (DC flag = 1), it becomes eligible for archiving. Archived items:

  • Remain in the database with complete transaction history intact
  • Are hidden from active views like Inventory Overview and standard reports
  • Can be viewed via dedicated reports for historical analysis and audits
  • Support attribute corrections even after archiving (added v5.7.6)
  • Cannot be received or issued but preserve all past transactions

Archiving is ideal for inventory cleanup when you want to remove obsolete items from daily operations without losing historical records for accounting, compliance, or reference purposes.

When to Archive vs Delete

ScenarioUse ArchiveUse Delete
Item no longer stocked but has transaction history
Seasonal items not currently active
Duplicate items after consolidation
Test items created during training
Items required for historical reports/audits
Items with zero transactions ever recorded

Archive when you need to preserve historical data for discontinued products, obsolete SKUs, or items with past transactions that may be referenced in audits or reporting.

Delete (via item merge or database cleanup) when items were created in error, have no transaction history, or are duplicates that should be consolidated.

Archive Process

1. Mark Item as Discontinued

Before archiving, the item must be marked as discontinued:

  1. Open the item in the Item Master (Inventory > Overview > click Item ID)
  2. Set the DC (Discontinued) flag to Yes
  3. Save the item record

Items marked as discontinued automatically appear in the Archived Units view.

2. What Gets Preserved

When an item is archived, the system retains:

Data TypePreserved
Item Master RecordFull item definition, attributes, costing
Transaction HistoryAll receipts, issues, moves, and adjustments
Purchase OrdersHistorical PO lines and receipts for the item
Shipping OrdersHistorical SO lines and shipments
Work OrdersAssembly and BOM records where item was used
Lot RecordsLot history with locations and dates
Serial NumbersComplete serial assignment history
Audit TrailAll changes, corrections, and modifications

3. What Changes

After archiving (marking as discontinued):

  • Item no longer appears in Inventory Overview (Active filter)
  • Item excluded from reorder alerts and replenishment calculations
  • Item hidden from standard reports unless explicitly included
  • Item cannot be added to new purchase orders or shipping orders
  • Item appears in Archived Units view (Inventory menu)

Accessing Archived Data

Archived Units View

The primary interface for viewing archived items:

Location: Inventory > Archived Units

This view provides the same search, filter, and export capabilities as the Inventory Overview page, but displays only discontinued items. You can:

  • Search by Item ID, Description, Category, or Supplier
  • Filter and sort all columns
  • Export to CSV or XLSX for analysis
  • Click Item ID to view full item details and history
  • Apply attribute corrections to archived items (v5.7.6+)

Archived Inventory Report (Report 141)

For detailed reporting on discontinued items:

Location: Reports > Search for “Archived Inventory” or navigate to Inventory Reports

Key Features:

  • Shows all items marked as discontinued
  • Includes current stock levels (if any remaining)
  • Displays last transaction dates
  • Supports filtering by Category, Supplier, or Warehouse
  • Can be scheduled for periodic review
  • Export to Excel for archival documentation

When to Use:

  • Quarterly or annual inventory audits
  • Compliance reporting requiring discontinued item records
  • Historical analysis of product lifecycle
  • Verification before physical disposal of remaining stock

Accessing Archived Transactions

Historical transactions for archived items remain accessible through standard transaction reports:

Report TypeAccess Method
Receipt HistoryReports > Receiving Reports > Filter by Item ID
Issue HistoryReports > Issue Reports > Filter by Item ID
Point in Time InventoryReports > Inventory Reports > Specify date range
Audit TrailReports > Admin Reports > Select item and date range

All transaction reports include archived items when filtering by specific Item IDs or date ranges, ensuring complete historical visibility.

Restoring Archived Items

If you need to reactivate a discontinued item:

  1. Navigate to Inventory > Archived Units
  2. Click the Item ID to open the item record
  3. Change the DC (Discontinued) flag to No
  4. Save the item

The item immediately returns to active status and appears in standard inventory views and reports.

Best Practices

Annual Review: Schedule periodic reviews of archived items to identify candidates for physical disposal or permanent removal if no longer needed for compliance.

Documentation: Before archiving, document the reason in the item’s Notes field (e.g., “Discontinued Q1 2026 - Replaced by Item XYZ”).

Remaining Stock: Issue or transfer any remaining stock before archiving. The Archived Inventory report will show if discontinued items still have quantity on hand.

Attribute Corrections: If you discover data errors in archived items during audits, you can still apply corrections (feature added v5.7.6) to maintain accurate historical records.

Export Records: For items being archived due to regulatory retention periods ending, export full transaction history to Excel before potential future deletion.

On this page