Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Tracking Journals in Database After Posting

26 views
Skip to first unread message

Asrawi

unread,
Dec 13, 2009, 5:12:01 AM12/13/09
to
How to track on Ax 2009 Database Level the following scenario:
1- Add General Journal including 2 lines (Fist one for Customer & the Second
for Ledger) - In the database two lines are creaetd in table
LedgerJournalTrans
2- Post the General Journal mentioned above - In the database two records
have been created (the first one in the CustTrans and the second in the
CustTransOpen tables)

The problem is that there is no key value stored in either CustTrans Or
CustTransOpen referred to the records created in the table LedgerJournalTrans.

As Per MS msdn, the relationship between these three tables mentioned above
is clear, however the valus in the related columns in CustTrans and
CustTransOpen do not match with any key value in LedgerJournalTrans.

Relationship As per MS MSDN as follows:
LedgerJournalTrans.MarkedInvoiceCompany == CustTransOpen.dataAreaId
LedgerJournalTrans.MarkedInvoiceRecId == CustTransOpen.RecId
LedgerJournalTrans.CustTransId == CustTrans.RecId

Data in Database for the above mentioned scenario:
LedgerJournalTrans.MarkedInvoiceCompany = ""
LedgerJournalTrans.MarkedInvoiceRecId = 0 LedgerJournalTrans.CustTransId = 0
CustTransOpen.dataAreaId = NuLL CustTransOpen.RecId = 5637149084
CustTrans.RecId = 5637149090

Note: the variation of the values of the columns that should be related.

sams

unread,
Dec 13, 2009, 8:55:02 PM12/13/09
to
Asrawi,
For the relation between CustTransOpen and LJT use SpecTrans. SpecTableId
will be 212 (LJT), SpecRecId will be the RecId of the LJT record.
CustTrans to LJT you could use Voucher.

Zbysek

unread,
Mar 8, 2010, 8:09:01 AM3/8/10
to
As soon as you need to go down to ledger transactions from some upper module
(CustTrans, InventTrans, TaxTrans...), the reference I found in AX is only
voucher number and posting date :-(
Especially if you have some groupping of transactions on the sams ledger
account.
0 new messages