Date Compress Resource Ledger Batch Job
Compresses resource ledger entries. The entries are combined so that they take up less space in the database.
Resource ledger entries can be compressed if they appear in closed fiscal years.
The compression works by combining several old entries into one new entry. For example, resource ledger entries from previous 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 to be 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 retained: Posting Date, Resource No., Resource Group No., Entry Type, Quantity, Total Cost, Total Price, and Chargeable.
With the Retain Field Contents facility, you can also retain the contents of additional fields.
The number of entries that result from a Date Compress Resource Ledger batch job depends on how many filters you set, which fields are combined, and which 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.
Options
| Field | Description |
|---|---|
Starting Date |
Enter the first date to be included in the date compression. The compression affects all resource 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 resource ledger entries from the starting date to this date. |
Period Length |
Select the length of the period whose entries are combined. Choose the field to see the options. If you selected the period length Quarter, Month, or Week, then only entries with a common accounting period are compressed. |
Posting Description |
Enter a text to accompany the entries that result from the compression. The default description is Date Compressed. |
Document No. |
Select the check box to retain the contents of the Document No. field. |
Work Type Code |
Select the check box to retain the contents of the Work Type Code field. |
Job No. |
Select the check box to retain the contents of the Job No. field. |
Unit of Measure Code |
Select the check box to retain the contents of the Unit of Measure Code field. |
Source Type |
Select the check box to retain the contents of the Source Type field. |
Source No. |
Select the check box to retain the contents of the Source No. field. |
Chargeable |
Select the check box to retain the contents of the Chargeable field. |
Retain Dimensions |
Choose the field and select the dimension information that 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. For more information, see Dimension. |
Note
When you select fields to retain, the more fields you select, the more detailed the compressed entries will be. If you do not select any fields, the batch job creates one entry per day, week, or another period, according to the period selected in the Period Length 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.