|
Utility
|
Menu
|
Description
|
|
Rebuild Invent Records
|
4.25.1
|
Lets you rebuild InventM records from location detail (ld_det) records. You should run this utility in a single-user mode.
The system uses InventM records to store multi-item pallet data. Since multi-item pallets are unique to QAD Warehousing, other system functions may not create InventM records. Some warehouse locations may have ld_det records with the same ld_ref record. This indicates that the ld_det records belong to the same pallet, and therefore, should have InventM records so that the properties of multi-item pallets apply.
|
|
Recalculate Location Full %
|
4.25.2
|
Lets you run a report to recalculate the full percentage of locations. You can also update the database with the results.
|
|
Rebalance Expected In/Out Qty
|
4.25.3
|
Lets you recalculate balances if you think there are mistakes in the order quantities. You can also update the database with the results.
|
|
Container Creation Utility
|
4.25.4.
|
Lets you create a container level below a pre-shipper.
|
|
Populate Order Whse Maint Tables
|
4.25.5
|
Use this option when first installing or installing a revised QAD Warehousing software. It takes all outstanding orders in the system and populates the appropriate database tables with updated information.
|
|
Incomplete Hanging Tasks Report
|
4.25.6
|
Lets you check for outstanding warehouse tasks that must be confirmed by warehouse staff.
|
|
Hanging lad_det Report (No Task)
|
4.25.7
|
Lets you check for detail allocations without any referenced tasks.
QAD Warehousing has tasks that add fields to the location detail (lad_det) record that indicate expected quantities in and out of warehouse locations. If processing is disrupted or system errors occur, tasks may no longer exist in the system, but ld_det records may still indicate that they do. When this occurs, stock can remain at a location while the system awaits the transaction to move it. Use this utility to synchronize the lad_det records with actual tasks.
|
|
Persistent Procedure Inquiry
|
4.25.8
|
System administrators and developers can use this inquiry to check whether QAD Warehousing triggers have been fired for warehousing transactions.
|
|
External Device Session Inquiry
|
4.25.9
|
Lets you view data on RF user sessions.
|
|
Inspection Workfile Delete/Archive
|
4.25.10
|
Lets you delete stranded inspection records. The utility optionally deletes or archives obsolete inspection workfile records. The system creates the records during receipt processing when the Quality/Inspection module is active.
|
|
Delete Planned Order Whse Tables
|
4.25.11
|
Lets you delete warehouse order management detail records for planned orders that are unused by the system. If you installed QAD Patch R1GP, run this utility immediately after you install the patch.
|
|
Delete Task List Workfile Record
|
4.25.12
|
Lets you delete inactive task list records. Previously, the system stored linked transaction-task or transaction-alternate task records in two tables. The system now creates records for both tasks and alternate tasks in a single table. You can use the utility to delete old records. Indicate Yes when prompted to continue to delete the records
|
|
Recalculate User Task Times
|
4.25.13
|
Lets you recalculate user task times in batch mode. The system recalculates the value of the UserD table, which stores the average task completion time by user. You must set the Active field in Labor Management Control to No to manually recalculate user task times with this utility; otherwise, the system recalculates the task times automatically.
|
|
Populate Item-Site Location
|
4.25.14
|
Lets you repopulate the Item-Site Maintenance (4.4.9) Location field with data from the removed Site Location field from the same program. If you installed QAD Patch R1K5, run this utility immediately after you install the patch. Indicate Yes when prompted to continue to repopulate the Location field with Site Location field values
|