Monday, December 16, 2013

Label ID is displayed instead of label text while adding vendor address in AX 2012


In order to resolve the issue you can try two options:
First Option:
1. 
delete the bad records from the following tables where it shows the label id instead of the text:
delete from dirnamesequencetranslation where description like '@sys%'
delete from LOGISTICSLOCATIONROLETRANSLATION where description like '@sys%'
delete from LOGISTICSLOCATIONROLE where name like '@sys%'
delete from LOGISTICSADDRESSCOUNTRYREGIONTRANSLATION where longname like '@sys%'

2. restart the AOS to avoid a AOS caching issue when running the next X++ jobs
3.  Create an X++ job with the following method calls
                   SysTranslationData::populateData(resourceStr(LogisticsLocationRoleData));
                   SysTranslationData::populateData(resourceStr(LogisticsAddressCountryRegionData));
                   SysTranslationData::populateData(resourceStr(DirNameSequenceData)); 


Second Option (if the first doesn't work) :

Use the following SQL scripts to address the data issues. 
 
DELETE LOGISTICSLOCATIONROLE WHERE NAME LIKE '@SYS%'

DELETE LOGISTICSLOCATIONROLETRANSLATION WHERE LOCATIONROLE NOT IN (SELECT RECID FROM LOGISTICSLOCATIONROLE) AND LANGUAGEID = 'en-us'

update LOGISTICSLOCATIONROLETRANSLATION set DESCRIPTION = (select name from LOGISTICSLOCATIONROLE where LOGISTICSLOCATIONROLETRANSLATION.LOCATIONROLE = LOGISTICSLOCATIONROLE.RECID) where LANGUAGEID = 'en-us'


No comments:

Post a Comment