Announcements
I am having a problem with this statement in AX2012.
info(strFmt("%1",new DictField(tableNum(InventTrans), fieldNum(InventTrans, Qty)).name(DbBackend::Sql)));
It simply returns a blank value.
I have Syncronized the Database but I am still not getting a value from the statement.
It does work fine on other tables and field, like:
info(strFmt("%1",new DictField(tableNum(CustTable), fieldNum(CustTable, AccountNum)).name(DbBackend::Sql)));
This returns correctly the value "ACCOUNTNUM"
That was all ok, it actually turned out that the table InventTrans had its configuration key disabled, so the table was not available from AX.
And apparently if thats the case the function DictField.Name simply returns a blank string.
Hi Rudi,
In system documentation, check for table SqlDictionary. Open this in table browser and then check for values where tabId = 177 (For InventTrans). Then check for Name and SQLName columns
André Arnaud de Cal...
294,127
Super User 2025 Season 1
Martin Dráb
232,871
Most Valuable Professional
nmaenpaa
101,158
Moderator