Fixing Trace Discrepancies
When there is a mismatch or difference between the trace quantity of a part and the inventory quantity of a part, the recommendation is to perform a Blank Tag Physical count on the Part, and/or run the Re-summarize option in Part Trace Maintenance for the part. It is not recommended to use any type of Fix Utility. Either of the methods below should be run in TEST first to verify the results. Prior to performing the procedure in the live database, it is recommended that a complete backup of the database be taken and made available in case there is a need to revert back to it.
If the inventory quantity is correct, the Re-summarize option in Part Trace Maintenance may correct the trace quantities.
All users must be logged off to perform this option. Only SYSADM or User with SYSADM Privileges can run this option.
In Part Trace Maintenance, pull in the Part ID. Go to Maintain > Re-summarize Trace Qty.
If the option is greyed out, a user is logged on to the database or trace is turned off.
If there are negative trace quantities seen in the Print Location Report from Part Trace Maintenance, the only way to correct these would be to use the Blank Tag Physical and count 0 for that trace ID.
1) Inventory, Part Trace Maintenance. Enter the Part ID.
2) File, Print Location Report. Run and save the report for the part to refer to if necessary.
3) Inventory, Part Maintenance. Enter the Part ID.
4) Maintain, Warehouse Locations. Note the Quantity for each Warehouse ID/Location ID.
5) Inventory, Physical Inventory Count.
6) Go to File, Initialize Physical Inventory:
a) Physical Count ID: User Defined
b) Warehouse ID: Select the warehouse(s) to be included in the count, leaving the location fields blank.
c) Ending Tag #: Set the ending tag number to be a couple of tags greater than the number of trace parts to be counted.
d) Create Blank Tags Only: Check
e) Select Ok.
7) Highlight the Physical Count ID row. Select the Enter Counts icon.
8) Check Automatic Advance to Next Tag.
9) Enter the first Tag #. Enter or select the Part ID, Location ID and Trace ID. In the Quantity field, enter 0 (zero) for the quantity to remove a negative trace ID
or enter the correct quantity for the part/trace. The Tag # will save and advance to the next blank tag. Keep entering the information for each part/trace combination.
When the last tag has been entered close the window.
10) Select the Review All Counts icon. After verifying the counts, close.
11) File, Print Tag Comparison. Print to retain a record of the adjustments made during the count.
12) Highlight the Physical Count ID row. File, End Physical Count.
a) Count Date: This is the date used for adjustments created.
b) Keep History: Check if desired
c) Unlock Inventory for All Tags: Check if inventory was locked during initialization.
d) Zero Part Locations without Tags: ***DO NOT CHECK***
e) Click Ok.
Sometimes it is necessary to actually perform the physical count twice - once to correct the trace inventory and once to correct the regular inventory.