Purge Selected
Inventory Files for Version 5.2x and 6.0x
Deleting outdated information from the inventory data files is
optional, but removing outdated information from the files reduces
file size and therefore improves system performance.
1._____ Backup data files.
2._____ Select the Purge Selected Files function on the Periodic
Processing menu.
3._____ To remove lots with a quantity of zero:
 | Print the Items Locations List on the Master List menu.
Select YES for Print Location Information? and Lot
Information?. |
| Enter the oldest sale date for a zero quantity lot that you
want to retain in the file in the Zero Quantity Lots with
Sale Dates Before? field. |
4._____ To remove outdated alternate items:
| Print the Item Detail List on the Master List menu. Select
YES for Print General Information? and Alternate Items?. |
| Enter the oldest date used for the End Date field for
Alternate Items you want to retain in the file in the
Alternate Items with End Dates Before? field. |
5._____ To remove outdated price promotions:
| Print the Promotional Pricing List on the Master List menu. |
| Enter the oldest date used in the End Date field of price
promotions you want to retain in the file in the Promotional
Pricing with End Dates Before? field. |
6._____ To remove outdated bin numbers:
| Print the Items Locations List on the Master List menu.
Select YES for Print Location Information? and Bin
Information?. |
| Enter the date of the oldest physical count you want to
retain bin numbers for in the Bins with Last Physical Count
Date Before? field. |
7._____ To remove outdated serialized history and serial numbers:
| Print the Item Locations List on the Master List menu.
Select YES for Print Location Information? and Serial
Information?. |
| Print the Serialized History Report on the Reports menu. |
| Enter the oldest date for invoices that you want to retain
serial numbers and history for in the Serialized History and
Number with Invoice Dates Before? field. |
8._____ If you selected to save lot history, to remove outdated
lot information:
| Print the Lot History Report on the Reports menu. |
| Enter the oldest invoice date you want to retain lot
information about in the Lot History with Invoice Dates
Before? field. |
9._____ If you are saving detail history, to remove outdated
inventory transaction information:
| Print the Transaction History Report on the Reports menu. |
| Enter the date of the oldest transaction you want to retain
information about in the Detail History with Transaction
Dates Before? field. |
10._____To delete outdated summary history information:
| Print these reports: |
 | ___ Inventory Movement Report |
| ___ Trend Analysis Report |
| ___ Valuation Report |
| ___ Gross Profit Analysis Report |
| ___ Cost Variance Report |
| ___ Sales Analysis Report |
| ___ Slow/Fast Movement Report |
| Enter the oldest fiscal period and year that you want to
retain summarized information for in the Summary History
Dated Before Period/Year? field. |
11.____ (OPTIONAL) Delete any inventory items you no longer need.
Use the Change File Size function on the Data File Maintenance menu
in Resource Manager to rebuild these files:
| ___ INAIxxx |
| ___ INKYxxx |
| ___ INLSxxx |
| ___ INUPxxx |
| ___ INBNxxx |
| ___ INLDxxx |
| ___ INQLxxx |
| ___ INVExxx |
| ___ INCJxxx |
| ___ INLOxxx |
| ___ INQTxxx |
| ___ INVIxxx |
| ___ INCSxxx |
| ___ INLPxxx |
| ___ INUMxxx |
| ___ INXTxxx |
12.____ (OPTIONAL) If you are using serialized and/or lotted
items, use the Change File Size function to also rebuild these
files:
| ___ INLSxxx |
| ___ INSNxxx |
| ___ INLTxxx |
13. ____ Run the Rebuild Item Quantities function on the Periodic
Processing menu to update the Committed, In Use, and On Order fields
in the Inventory Quantity Totals file, INQTxxx. These quantities are
recalculated based on the transaction files for all applications for
the company that are interfaced with inventory. All applications
that are interfaced with inventory must be at least at version 5.2x.
