Search Knowledge Base Articles
Update production order status
update ProdTable set ProdStatus ='5' where ProdId = 'PRO-005523'
Did you find this article useful?
Related Articles
-
Update Voucher in LedgerJournal
update LedgerJournalTrans set Voucher = 'GL_JV-000003645' where Voucher = 'GL_JV-000003640'... -
Delete Retail log
delete from crt.TABLEREPLICATIONLOG delete from crt.UPLOADSESSION... -
Fix Posted Retail Statment for april -june-feb 2020
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052141'update Reta... -
Export All Journal from D365
SELECT T1.ACCOUNTINGDATE, T1.SUBLEDGERVOUCHER, T3.JOURNALNUMBER, T2.LEDGERACCOUNT, T2.TRANSACTIONCUR...