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
FROM dbo.GENERALJOURNALENTRY AS T1 INNER JOIN
dbo.GENERALJOURNALACCOUNTENTRY AS T2 ON T1.RECID = T2.GENERALJOURNALENTRY AND T1.PARTITION = T2.PARTITION INNER JOIN
dbo.LEDGERENTRYJOURNAL AS T3 ON T1.LEDGERENTRYJOURNAL = T3.RECID AND T1.PARTITION = T3.PARTITION
Search Knowledge Base Articles
Export All Journal from D365
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... -
Update production order status
update ProdTable set ProdStatus ='5' where ProdId = 'PRO-005523'...