Skip to main content

Correct a lot to physical stock variance on a part

Steps to resolve a mismatch between the physical stock on a part record and the quantity of lots on the system.

A
Written by Andrew McNeice

In some cases, there is a mismatch between the physical stock on the part record and the quantity of lots on the system. You can use the Lot Control tab in the Supply Chain client to verify and correct this variance.

Follow the steps below that match your situation.


Verify the variance

To identify whether a variance exists, run the verification process first.

  1. In the Supply Chain client, open the Lot Control tab.

  2. Click Maintain.

  3. Click Verify.

  4. Enter a range of parts to check using the From Part and To Part fields.

  5. At the Verification failed prompt, click Yes.

📌Note: If the verification passes without a prompt, there is no variance to correct.


More stock in lots than physical, and the lots are correct

If the lot quantities are correct but the physical stock figure is too low, amend the physical stock to match.

  1. Click Amend Physical.

  2. Select an order type to use for the adjustment.

  3. Tab through to the Physical field — this will automatically be populated with the correct value.

  4. Check the value, then click Save to submit the changes.


More stock in physical than lots, and the physical is correct

If the physical stock figure is correct but there are not enough lots to account for it, create the missing lots.

  1. Click New.

  2. Populate the fields for lot detail.

  3. Click Save to commit the changes.

  4. Repeat these steps as required until all the required lots are created.


More stock in lots than physical, and the physical is incorrect

If there are more lots than the physical stock figure, and the physical figure is wrong, you'll need to correct the physical first and then adjust the stock.

  1. Click Amend Physical.

  2. Select an order type to use for the adjustment.

  3. Tab through to the Physical field — this will automatically be populated with the correct value.

  4. Check the value, then click Save to submit the changes.

  5. Once the physical and lots are in order, use a standard stock adjustment to correct the stock figure.

Did this answer your question?