on 02-19-2009 1:09 PM
Hi everyone,
I have two separate SAP Business One company databases and need to have consolidated reports for Balance Sheet and Profit and Loss from both (having separate balances for each and also a summary of the balances).
How can this be done using the development tools available for B1? Is there a stored procedure i can use to catch the event that creates the reports in then i can probably modify it to display from two databases? Or is there a template available somewhere for a report (e.g Crystal reports) that i can do this with?
hi
i do the same thing what you are asking. But i m doing that with a separate application using VB.net and table reference of SAP B1. and after that i will show that report in excel and pdf format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just as it has been said, from scratch, B1 can't do anything for you.
For several customers I had the same exact problem. The way I handled it, was to create a consolidation database and "replicate" the transactions in it (only account summary and without common (eg. group) operations).
Then, we used standard reporting on the consolidation database.
an other solution (not inesthetic) would be to use the reporting services, or something equivalent.
Regards,
Eric
Hello,
If you are using SQL Server 2005 Enterprise Edition, than an easier way to do this is use Integration Services.
Using SSIS you can create an integration package, which will take the requisite data from different databases, and tables, and present them to you as required in the form of one table. Than you can create a report on the basis of this table in SQL Server Reporting Services.
Do post me, if you require any help with using either of them.
Rahul
hi
in my application i just load all the companies in one list box from the sbo_common.
now i have to select one or more company which i want to show in report and then press Load Report button.
so now my sp will be execute and load data from that related tables and i have load them in a grid/tree. so you can now show report like in grid or tree format. and then i have to convert it into excel and pdf format.
hi
i just use one query to load all company
select dbname,CmpName from [SBO-COMMON].dbo.SRGC
but i m not using any kind of sp for financial report. i just gave u an idea that u can do that way.
My requirement is bit diff so i used a only query that will be generated dynamically in code only.
So you have to make sp as per your requirement.
Duncan,
The SAP Business One SDK and development tools are really not geared to handle/work with/format financial statements. If you are looking to get the data generated by a report from Business One, then you can use the ReportDataInfo object. You can also see a sample of "Catching ReportDataEvent" in the SDK Help documentation.
Beyond that you should look at using something like Crystal, XLReporter, FRx, etc.
Eddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.