Search Knowledge Base Articles

  • Update Voucher in LedgerJournal

    11/01/2020 3:22 PM
    update LedgerJournalTrans set Voucher = 'GL_JV-000003645' where Voucher = 'GL_JV-000003640'...

  • Delete Retail log

    11/01/2020 3:23 PM
    delete from crt.TABLEREPLICATIONLOG delete from crt.UPLOADSESSION...

  • Fix Posted Retail Statment for april -june-feb 2020

    05/07/2020 7:31 PM
    update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052141'update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052142'update RetailTransactionTable SET entryStatus= '0' where REC...

  • Update production order status

    08/07/2020 12:29 PM
    update ProdTable set ProdStatus ='5' where ProdId = 'PRO-005523'...

  • Export All Journal from D365

    22/04/2021 1:45 AM
    SELECT T1.ACCOUNTINGDATE, T1.SUBLEDGERVOUCHER, T3.JOURNALNUMBER, T2.LEDGERACCOUNT, T2.TRANSACTIONCURRENCYAMOUNT AS [Amount in Cuuency], T2.ACCOUNTINGCURRENCYAMOUNT AS [amount in sar], T2.TRANSACTIONCURRENCYCODE AS Currency, T2.TEXT AS Description...