Issue with cross companies data with generaljournal entry table

(0) Share

Report

Posted on by Faqruddin

1,869

Hello,

The below code always excuting the data from default company dat. How can I get the data from USMF and other companies. Please advice

class TestJournalCode
{
public static void main(Args _args)
{
GeneralJournalAccountEntry genralJournalAccountEntry, genralJournalAccountEntryprev;
GeneralJournalEntry generalJounralEntry;
MainAccount mainAccount;
Date fromDate, toDate;
fromdate =str2Date(/1/21/2015/,213);
toDate = str2Date(/1/21/2015/,213);
// DataAreaId dataAreaId;
// List journallist = new List(Types::Class);
;

select crosscompany generalJounralEntry order by dataAreaId
where generalJounralEntry.DataAreaId == /USMF/
&& generalJounralEntry.AccountingDate >= fromdate
&& generalJounralEntry.AccountingDate <= toDate;

Info(generalJounralEntry.DataAreaId);
Info(generalJounralEntry.JournalNumber);

}
}

All responses (5)

Answers (1)

Verified answer

Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report

Issue with cross companies data with generaljournal entry table

Did you find any record in USMF company? No. Therefore your expectation that you loaded a record with USMF value in DataAreaId field is wrong.

Did you find any record at all? No. Your code pretends that a record was fetched and it's showing information about the record, but it's actually a lie caused by a bug. No record was found therefore there is nothing meaningful to show. You're confused because the bug in your code produces a meaningless output.
Faqruddin 1,869 on at

Like (0)

Report

Issue with cross companies data with generaljournal entry table

Thank you for your response. I checked there is no records founds. I use below scenario as well still there is no data found. And its strange in below query the dataareaid is USMF and in the output dat.
Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report

Issue with cross companies data with generaljournal entry table

All right, so that's the answer. Your code doesn't return any data from USMF company because no such a record exists. You forgot to check whether a record was found.
Faqruddin 1,869 on at

Like (0)

Report

Issue with cross companies data with generaljournal entry table

Please find output below.
Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report
Issue with cross companies data with generaljournal entry table

Does the query finds any record at all? That it doesn't is the only explanation I have so far.

Let me throw away all the unnecessary code and add the check:

GeneralJournalEntry generalJournalEntry; select firstOnly crossCompany generalJournalEntry where generalJournalEntry.DataAreaId == 'USMF' && generalJournalEntry.AccountingDate == mkDate(21, 1, 2015) if (generalJournalEntry) { info(generalJournalEntry.DataAreaId); info(generalJournalEntry.JournalNumber); } else { warning("No record found"); }

Please run it and let us know what it returned.