Data Compression and Archiving

Aggregated Inventory for LS Central keeps track of inventory movements at the store level using the Aggregated Inventory Entries. This data can grow rapidly and cause poor performance. With Aggregated Inventory, you can have the data compressed and archived on a regular basis. Aggregated Inventory Entries that meet specific criteria are grouped, compressed, and archived in batches. And if needed, you have the option to undo these batches. The system can then decompress and restore the entries that were previously archived.

To compress and archive Aggregated Inventory Entries

By default, Aggregated Inventory Entries having identical item number, variant, location, and unit of measure are compressed into a single entry. Only entries that have been compressed are archived. If an entry does not have any other matching entry, it will not be compressed or archived.

Click the icon, enter Aggregated Inventory Entries, and select the relevant link.
Select one entry in the list. Typically, you would select the last entry. The selected entry and all older entries will be considered for compression and archiving.
Click Actions - Functions - Compress and Archive.

You can automate this task to run on a regular basis by setting up a scheduler job for Codeunit ID 10059486 Aggr. Inv. Archive Mgt. Use the DateFormula parameter to define a date filter. By default, all Aggregated Inventory Entries are considered for compression and archiving. If the DateFormula is defined, only entries prior to and equal to a specific date are included.

To compress and archive by Posting Date

By default, Posting Date is not a criteria for compression. Aggregated Inventory Entries having different Posting Dates are compressed into a single entry. You can configure the system to include Posting Date as a compression criteria:

Click the icon, enter Retail Setup, and select the relevant link.
Open the Aggregated Inventory FastTab that has the following fields:

Field	Description
Compress by Posting Date	Determines if Aggregated Inventory Entries are compressed and archived based on the Posting Date. The Posting Date Compression Level specifies the compression level.
Posting Date Compression Level	Specifies the compression level when Compress by Posting Date is active. Options include compress by day, week, or month.

To compress and archive by Dimensions

By default, Dimension is not a criteria for compression. Aggregated Inventory Entries having different Dimensions are compressed into a single entry. You can configure the system to include Dimension Set ID as a compression criteria:

Click the icon, enter Retail Setup, and select the relevant link.
In the Aggregated Inventory FastTab, turn on the Compress by Dimensions field.

To view Archived Batches and Archived Entries

Every time the system runs the compress and archive task, it creates an Aggregated Inventory Archived Batch and assigns all Aggregated Inventory Archived Entries to this unique batch. Aggregated Inventory Archived Batches store the whole history of compression and archiving and can be used to revert the history and go back to a specific point.

Click the icon, enter Aggregated Inventory Entries, and select the relevant link.
On the Aggregated Inventory Entries page, select Related - Entry - Show Linked Archived Entries or Related - Entry - Show All Archived Entries.
On the Aggregated Inventory Archived Entries page, select Related - Entry - Show Linked Archived Batches or Related - Entry - Show All Archived Batches.

To undo Archived Batches and restore Archived Entries

Aggregated Inventory Entries are compressed and archived in batches. Therefore, Aggregated Inventory Archived Entries can only be decompressed and unarchived in batches, based on the last in first out logic.

Click the icon, enter Aggregated Inventory Archived Batches, and select the relevant link.
Select one batch on the list.
1. Click Actions - Functions - Undo the most recent Archived Batches.
  Unarchive and decompress entries belonging to the selected batch and more recent batches. These Archived Entries and Batches are removed, and related entries are moved back to the Aggregated Inventory Entry table.
2. Click Actions - Functions - Undo all Archived Batches.
  Unarchive and decompress all entries. All Archived Entries and Batches are removed and all entries are moved back to the Aggregated Inventory Entry table.