Wednesday, January 19, 2022

Computed column view method with T-SQL statement in D365FO

 Converting to view computed column method.

T-SQL statment like this way.

return strFmt(@'select top 1 WHT.ACCOUNTNUM from WHSSHIPMENTTABLE as WHT

                           where WHT.WaveId = %1 order by WHT.RECID asc',waveId);

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...