Using Operating System Commands
The Operating System Commands menu provides four ways to access the operating system and execute commands directly from your QAD application. Use them as a convenient way of viewing and manipulating information.
• Use Exit to Operating System (36.22.1) to invoke a UNIX or Windows command session. To return to your QAD application, enter Exit.
• Use Program/Text File Display (36.22.4) to display the content of an ASCII file, such as a program or print file. If the file is not in the current directory, specify the path. Add this function to the User Menu so that users can generate reports to a file and quickly review the content.
• Use Disk Space Inquiry (36.22.13) to execute an operating system command to display statistics regarding the current database file size.
Using Delete/Archive Utilities
Audit Detail Delete/Archive
To delete data from an audit log, use Audit Detail Delete/Archive (36.23.1). This program works differently from other system delete/archive functions. It does not delete each record specified. Instead, for each unique combination of user ID, table, and field, it keeps the latest record and deletes/archives the rest.
Use this function to produce a report of records before deleting them. See
Audit Detail Delete/Archive for an exact procedure.
GL Transaction Delete/Archive
General ledger transactions created in operational functions such as purchasing, inventory control, manufacturing, and fixed assets are stored in the unposted transaction table until they are posted. Review unposted transactions using Unposted Transaction Inquiry (25.13.13).
You can delete and archive transactions created in these operational modules using GL Transaction Delete/Archive (36.23.2). Use this program when:
1 You are not using QAD Financials.
2 You implemented other modules prior to implementing Financials. Before implementing General Ledger, delete the GL transactions in the unposted transaction table since these are already reflected in the beginning balances you enter.
For a standard implementation, GL Transaction Delete/Archive is used only during early stages of implementation. After transactions of a particular type (PO, IC, WO, or FA) have been posted to the general ledger, no further transactions of that type can be deleted or reloaded.