Applies to Product -Dynamics 365 Supply Chain Management
What’s happening?
The customer is experiencing an issue with duplicate records in the external code conversion for Unit of Measure (UOM) in the ExtCodeValueTable. This results in the system incorrectly selecting the external code "AAA" instead of the intended "EA" when communicating with external systems.
Reason:
The presence of two records for the internal code "pcs" in the ExtCodeValueTable, specifically "AAA" and "EA," is causing the system to default to the incorrect external code.
Resolution:
To resolve this, the following custom script should be applied to delete the redundant record from the ExtCodeValueTable:
sql ttsbegin; delete_from ExtCodeValueTable where ExtCodeValueTable.recid = {RECORD_ID}; ttscommit; Info('Script clean up data');
Ensure that the correct record ID is used in place of {RECORD_ID} to delete the unwanted entry.