# On what table do the posted journal entries go?

**URL:** <https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173>\
**Category:** Technical Forum\
**Created:** [July 21, 2015, 5:25am UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173 "2015-07-21T05:25:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ItsMeRussel](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@ItsMeRussel](https://www.dynamicsuser.net/u/ItsMeRussel)\
**Post date:** [July 21, 2015, 5:25am UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173/1 "2015-07-21T05:25:05Z")

</div>

Greetings!

Are the posted journal entries still stored on the LedgerJournalTrans table? or are they stored into another table?

Thanks,

Russel

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [July 21, 2015, 7:17am UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173/2 "2015-07-21T07:17:20Z")

</div>

The journal lines stays unless the journal name is marked as Delete journal lines after posting.

The effect of posting would be in other tables depending on the type of voucher transaction.

Example - related to Vendor, VendTrans, Ledger related tables (The tables varies with AX version which you not mentioned)

---

<div class="post-metadata">

**Author:** ![ItsMeRussel](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@ItsMeRussel](https://www.dynamicsuser.net/u/ItsMeRussel)\
**Post date:** [July 21, 2015, 1:45pm UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173/3 "2015-07-21T13:45:00Z")

</div>

Thanks Kranthi!

Therefore, the posted journals will always be inside the LedgerJournalTrans table unless I delete it. How about the deleted journals? Where are they going to be stored? Are they already gone for good?

I only do transactions inside the general ledger so I think that the type of voucher transaction is ledger.

By the way, the version I am working on is AX 2012 R2.

Regards,

Russel

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [July 21, 2015, 2:30pm UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173/4 "2015-07-21T14:30:45Z")

</div>

Journals are the origin for the transactions, once posted you may not actually need the journals.(that’s why you have an option to delete them)

The ledger transaction will be stored in,

GeneralJournal\* tables

This can really help you to understand these tables,

[https://technet.microsoft.com/en-us/library/hh292603.aspx](https://technet.microsoft.com/en-us/library/hh292603.aspx)

---

<div class="post-metadata">

**Author:** ![ItsMeRussel](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@ItsMeRussel](https://www.dynamicsuser.net/u/ItsMeRussel)\
**Post date:** [July 22, 2015, 1:49am UTC](https://www.dynamicsuser.net/t/on-what-table-do-the-posted-journal-entries-go/58173/5 "2015-07-22T01:49:14Z")

</div>

Thank you for this. [:)]