In our system we use Multibook and currently we have about 34 multicompanies in B34 (Lead Company). I have the problem when I want to SELECT FB34.STMT.ENTRY with only one Sub Company, it spend too much time because it select all sub companies and filter only B37.

So I need your help how to SELECT the file faster than this. I mean are there any way to select only the file B37 without using

SELECT FB34.STMT.ENTRY WIT CO.CODE EQ KH0013437

====

Time for select

jsh test5 ~ -->time SELECT FB34.STMT.ENTRY WITH CO.CODE EQ KH0013437

1018372 Records selected

usr: 134.96 sys: 26.10 elapsed: 16m40.74s
>

Hi,
What's the reason to select all entries for the company?

There are 2 enquiries in the system STMT.ENT.BOOK, STMT.ENT.VALUE which allow you get statement entries for particular account. You can also use som concat files for the processing of entries:

ACCT.ACCT.ACTIVITY
ACCT.ACTIVITY
ACCT.ENT.TODAY
...

Maybe it helps...

Because we want to make the report which will show the accrue interest of LD for one Month (Example: Start Date 20100501 and End Date 20100531) that's why we need to SELECT the STMT.ENTRY with BOOKING.DATE RG 20100501 20100531 and select for sub company KH0013437 from lead Company (KH0013400).

In T24 it have the concate files for store the STMT.ENTRY of Last Working Day (ACCT.ENT.LWORKDAY) and Today (ACCT.ENT.TODAY). So In T24 are there any concat file for store the STMT.ENTRY for Monthly ?

Our problem is selecting the file STMT.ENTRY and CATEG.ENTRY too slow.

Are there any files in T24 which store the STMT.ENTRY @ID and CATEG.ENTRY @ID as monthly? (Like ACCT.ENT.TODAY, ACCT.ENT.LWORK.DAY)

If have, please share to us ...

I would advice you talk to LD business consultant or post your request to T24 Functional forum. Such a report can be already in the system. The consultant can also advice you about the solution for LD.

There is also file CATEG.ENT.MONTH in the system where you can gather categ entries for the month. I don't know the concat file for monthly stmt entries. The simple local development can help you with gather stmt entries.

thanks for advice, AlexSave