Microsoft Dynamics AX (Archived)

link table between general journal account entry vs ledger journal trans

(0) Share

Report

Posted on by agus

1,174

hi expert,

i'm having issue relate to link table between generaljournalaccountentry table and ledgerjurnaltrans.

in the detailed trial balance report, I want to display Document Number field from Journal entry lines in the report . but still have not found what's the linkage between of those tables.

please help

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Agus,

Please have a look at the whitepaper that can be downloaded from the following website:

technet.microsoft.com/.../hh292603.aspx

Hope it helps,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

kindly pay a visit at following object to know relationships among these table

AOT\Classes\CustVendPDCManager\settleClearingTransactions

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

hi sihaib & Ludwig,

thanks for advice, after checked by technical, it still does not have connection between generaljournalentry & ledgerjournaltrans table.

any other solution? I just want to display doc No in detailed trial balance report.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

yes there is no direct connection between the two.

but we can make join and can make a connection. which document number you are referring to?

are you talking about document number of ledgerjournaltrans ...??

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

Document number in ledgerjournaltrans, and in that table 1 have added some fields as well.

I thought if it work to get document number in ledgerjournaltrans, my additional tables are also can be populated in this report.

Was this reply helpful? Yes No
D365 beginner 634 on at

Like (0)

Report

Hi Agus,

Did you create a job for the above ? I have the same requirement now. Can you share please, if you have done it.

Thanks

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report

Hi Agus!

I've posted an example in this thread https://community.dynamics.com/ax/f/33/t/207784

Was this reply helpful? Yes No