Ledger Report for all companies

anirbancse

Hi Everybody!!!!!!!
I have a requirement of creating a report which will show all the ledger entries of a Customer/Vendor throughout all companies in the database if the Customer/Vendor is present in other companies as well. I know the "CHANGECOMPANY" function to use in this case. But can not understand that how I can run that dynamically for all companies present in the database. I have taken two dataitems i.e Customer & Cust. Ledger Entry. Any help will be much appreciated. Thanks in advance!!!

Regards,
Anirban

archer89

first copy the ledger entries from all companies in a new buffer table. fill it using changecompany to get all ledger entries from all companies. when doing that check if they all have different entry no. values. after that create a report on base of that new table. you could use the table as temp table in the report and fill it at runtime or fill the data into the table and remove all data each time you run the report as first step (onprereport).