Date Compress Whse. Entries Batch Job
Compresses warehouse entries, that is, combines them so that they take up less space in the database.
The compression works by combining several old entries into one new entry. For example, warehouse entries with the same location code, bin code, item number, variant code and unit of measure code can be compressed into one entry. If you specify in the request window, the serial number and lot number information can also be retained.
After the compression the contents of the following fields are always retained: Registering Date, Location Code, Zone Code, Bin Code, Item No., Quantity, Qty. (Base), Bin Type Code, Entry Type, Variant Code, Qty. per Unit of Measure, Unit of Measure Code, Warranty Date, Expiration Date, Cubage and Weight. With the Retain Field Contents facility, you can also retain the contents of the Serial No. and Lot No. The number of entries that result from a Date Compress batch job depends on how many filters you set, which fields are combined, and which 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. 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 will affect all warehouse entries from this date to the Ending Date. |
Ending Date |
Enter the last date to be included in the date compression. The compression will affect all warehouse entries from the Starting Date to this date. |
Period Length |
Select the length of the period whose entries will be combined. Choose the field to see the options. If you selected the period length Quarter, Month or Week, only entries with a common accounting period are compressed. |
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 will be. If you do not select any of these fields, the batch job will create 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.