Hi.
I have a query with GeneralJournalAccountEntry and GeneralJournalEntry tables, both have the data Shared (SaveDataPerCompany = false).
I've tried to create a view using a query filtering by SubLedgerVoucherDataAreaId field with currentCompany. (CurrentCompany is a standard value from sysQueryRangeUtil class)
But when I execute the view seem like it show the last execution.
I delete usage data but It doesn't work, looks like if I restart Axapta works fine but at the moment I change company the view show information of the last company.
I've tried to delete usage data before start the form but It doesn't work.
private void deleteSysLastValue()
{
SysLastValue sysLastValue;
/* delete_from sysLastValue
where sysLastValue.userId == curUserId()
&& (sysLastValue.elementName like "LedgerGeneralAccountJournalEntry*"
|| sysLastValue.elementName like 'GeneralAccountJournal*');*/
boolean lock = element.lockWindowUpdate(true);
element.design().resetUserSetting();
element.resetSize();
element.arrange();
if (lock)
{
element.lockWindowUpdate(false);
}
}
any idea?
