Share
ReportHello Everyone,
I am making a drillthrough report for which i want to join GeneralJournalAccountEntry Table with Cust Table .
*This post is locked for comments
I have the same question (0)
You’re offline. This is a read only version of the page.
5
Hello Everyone,
I am making a drillthrough report for which i want to join GeneralJournalAccountEntry Table with Cust Table .
*This post is locked for comments
I have the same question (0)
Hi,
Please use the following job/code to establish relationship between GeneralJournalAccountEntry and CustTable.
All responses (
Answers (
static void CustTable(Args _args)
{
CustTable custTable;
CustTrans custTrans;
GeneralJournalEntry generalJournalEntry;
GeneralJournalAccountEntry journalAccountEntry;
DataAreaId companyId;
DirPartyTable party;
companyId = curext();
while select journalAccountEntry
join generalJournalEntry
where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
&& (generalJournalEntry.SubledgerVoucherDataAreaId == companyId))
join AccountNum, RecId from custTrans
where ((custTrans.Voucher == generalJournalEntry.SubledgerVoucher)
&& (custTrans.ReportingCurrencyAmount == journalAccountEntry.ReportingCurrencyAmount))
join AccountNum, Party from custTable
where (custTable.AccountNum == custTrans.AccountNum)
join Name from party
where party.RecId == custTable.party
{
info(strfmt("Name: %1, Account: %2", custTable.name(), custTable.AccountNum));
}
}
