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);
Subscribe to:
Post Comments (Atom)
Upload file CSV/TXT using SysOperation in D365 X++
Upload CSV/TXT using SysOperation X++ Contract: /// <summary> /// Contract class upload through excel for PO inbound journals /// <...
-
Posting Vendor invoice based on Product receipt public void postPurchaseInvoiceJournal() { VendPackingSlipJour vendP...
-
Restore .bacpac file to Development VM Steps: 1. Take Backup of AxDB database from Development VM 2. Open Command Pr...
-
BP: BPUpgradeCodeLateBoundCall : BP Rule: [BPUpgradeCodeLateBoundCall]:A late bound call callingForm.refresh is made. In source system (...
No comments:
Post a Comment