Views:

Applies to Product - Dynamics 365 Supply Chain Management

What’s happening?
Customers are encountering errors when attempting to create records in the On-hand inventory checks and Inventory transaction originator. The specific error messages include "Cannot create a record in On-hand inventory checks (InventSum) type: Reservation. The record already exists" and "Cannot locate data source record of type RetailVendTable."


Reason:
The underlying cause of this appears to be related to data corruption or conflicts during batch processing. Specifically, the error occurs when a transaction is reserved again in the same batch, which is not allowed. Additionally, the presence of existing records in the relevant tables may lead to conflicts when attempting to create new records.


Resolution:

  1. For the On-hand inventory checks issue:
  2. Run an on-hand consistency check for the affected item(s) to resolve potential data corruption.
  3. Navigate to the System administration module:
    • Go to Periodic tasks > Database > Consistency check.
    • In the Check/Fix tab, ensure the "Fix error" option is set correctly.
    • Focus on the 'Inventory management', 'Item', and 'On-hand' nodes.
    • Select the item(s) for which the consistency should be run and click OK to execute the check.
  4. For the Inventory transaction originator issue:
  5. Ensure that the inventTransId values are synced with the latest inventTransId from the inventTransOrigin table.
  6. Go to Inventory management > Inventory management parameters, find the Lot Id number sequence number, and navigate to the number sequence form.
  7. Update the Next field value to a larger value to avoid conflicts.
  8. If the issue persists, consider backing up the data, deleting the conflicting records, and re-importing the data as a last resort. However, be cautious as this may involve sensitive information and could impact business operations.
  9. If further assistance is needed, consult with the relevant support teams or escalate the issue as necessary.