Joining LedgerJournalTrans to GeneralJournalEntry/GeneralJournalAccountEntry (1 to 1)

(0) Share

Report

Posted on by Community Member

Is there a way of joining the LedgerJournalTrans to the GeneralJournalEntry/GeneralJournalAccountEntry on a 1 to 1 level? Joining through Voucher appears to be a 1 to many relation.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report
Copy link

Link copied!

GeneralJournalEntry tables links to SubledgerGeneralJournalEntry table by the "GeneralJournalEntry" field in SubledgerGeneralJournalEntry table.

and yes it has 1 to many relationship based on voucher, dataareaid and trans date. this is valid.

can you explain what is your exact requirement is ? and what you are looking to achieve ?

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!
Take a look at this job, I hope it helps you to understant the relations between the tables:

static void tutorialAccesLedgerJournalTransVoucher(Args _args) { Ledger ledger = ledger::findByLegalEntity(CompanyInfo::find().RecId); LedgerJournalTrans ledgerJournalTrans; GeneralJournalEntry generalJournalEntry; GeneralJournalAccountEntry generalJournalAccountEntry; DimensionAttributeLevelValueAllView dimensionAttributeLevelValueAllView; DimensionAttribute dimensionAttribute; while select ledgerJournalTrans join generalJournalEntry index hint LedgerAccountingDateIdx where generalJournalEntry.Ledger == ledger.RecId && generalJournalEntry.AccountingDate == ledgerJournalTrans.TransDate && generalJournalEntry.SubledgerVoucher == ledgerJournalTrans.Voucher join generalJournalAccountEntry where generalJournalAccountEntry.GeneralJournalEntry == generalJournalEntry.RecId { info(strFmt("%1", generalJournalAccountEntry.AccountingCurrencyAmount)); //financial dimensions related to the voucher line while select dimensionAttributeLevelValueAllView where dimensionAttributeLevelValueAllView.ValueCombinationRecId == generalJournalAccountEntry.LedgerDimension join dimensionAttribute where dimensionAttribute.RecId == dimensionAttributeLevelValueAllView.DimensionAttribute { info(strFmt("%1 %2", dimensionAttribute.localizedName(), dimensionAttributeLevelValueAllView.DisplayValue)); } } }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I am trying to join the LedgerJournalTrans to the GeneralJournalAccountEntry on a 1 to 1 relationship for a display method.

I am using LedgerJournalTrans "Txt" field as a way to use description.

Was this reply helpful? Yes No
karthi.turaga 15 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please let me know if you have a solution.

Thanks,

karthik.

Was this reply helpful? Yes No