Date Compress General Ledger Batch Job

Compresses general ledger entries, that is 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, general ledger entries from previous fiscal years can be compressed so that there is only one credit and one debit entry per account per month. The amount in the new entry is the sum of all the compressed entries. The date assigned 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: Posting Date, G/L Account No., Gen. Bus. Posting Group, Gen. Prod. Posting Group, Gen. Posting Type, Amount, and VAT Amount. You can also retain the contents of these additional fields: Document Type, Document No., Job No., and Business Unit Code.

The number of entries that result from a Date Compr. G/L Budget Entries batch job depends on the number of filters you set, the fields that are combined, and the period length you choose. There is always at least one entry. When the batch job is finished, you can see the result in the Date Compr. Registers window.

Warning

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

Note

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.

Options

Field	Description
Starting Date	Enter the first date to be included in the date compression. The compression affects all general 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 general ledger entries from the Starting Date to this date.
Period Length	Select the length of the period whose entries will be combined. To see the options, choose the field. If you selected the period length Quarter, Month, or Week, then only entries with a common accounting period are compressed.
Posting Description	Enter the text that will accompany the entries that result from the compression. The default description is Date Compressed.
Document Type	Select if you want to retain the contents of document type even though the entries are compressed.
Document No.	Select if you want to retain the contents of document number even though the entries are compressed.
Job No.	Select if you want to retain the contents of job number even though the entries are compressed.
Business Unit Code	Select if you want to retain the contents of business unit code even though the entries are compressed.
Retain Dimensions	Choose the field and select which dimension information you want to retain when the entries are compressed. The more dimension information that you choose to retain, the more detailed the compressed entries are. Note If you do not select dimensions to retain, you will not be able to report by dimensions after the batch job has been run.
Quantity	Select to retain the total of the quantity field.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.