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

OData Batch request API - D365FO

 --batch_MultipleInvoices Content-Type: multipart/mixed;boundary=changeset_123 --changeset_123 Content-Type: application/http Content-Transf...