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)
Disabling the flight in D365FO (CHD - Tier 1)
INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED) VALUES ('<FlightObjectName>_KillSwitch', 1) or INSERT INTO dbo.SYSFLIGHT...
-
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