Open the Date Compress Maint. Ledger window.

Combines maintenance ledger entries so that they take up less space in the database. You can compress entries from closed fiscal years only.

The compression works by combining several old entries into one new entry. For example, maintenance ledger entries from previous fiscal years can be compressed so that there is only one entry per fixed asset per month. The amount in the new entry is the sum of all the compressed entries. The assigned date is the starting date for the period that is compressed, such as the first day of the month if the entries are compressed by month. After the compression, you can still see the net change for each account in the previous fiscal year.

After the compression, the contents of the following fields are always retained: FA No., Depreciation Book Code, FA Posting Group and Document Type. With the Retain Field Contents facility, you can also retain the contents of these additional fields: Document No., Maintenance Code, Index Entry, Global Dimension 1 Code and Global Dimension 2 Code.

The number of entries that result from a date compress batch job depends on the number of filters you set, the fields that are combined and the period length you choose. There will always be at least one entry. When the batch job is finished, you can see the result in the Date Compr. Register table.

Warning
Date Compression deletes entries, so you should always make a backup copy of the database before you run the batch job.

Options

Field Description

Starting Date

Enter the first date to be included in the date compression. The compression affects all maintenance ledger entries from this date to the Ending Date.

Ending Date

Enter the last date to be included in the date compression. The compression affects all maintenance ledger entries from the Starting Date to this date.

Period Length

Select the length of the period for which combined entries are created. If you selected the period length Quarter, Month, or Week, then only entries with a common accounting period are compressed.

Posting Description

Enter text for the entries that result from the compression.

Retain Field Contents

Select if you want to retain the contents of certain fields even though the entries are compressed. The more fields you select, the more detailed the compressed entries are. If you do not select any of these fields, the batch job creates one entry per day, week, or another period, according to the period selected in the Period Length field.

Tip

See Also