OpenOffice.org scalc is the powerful spreadsheet application developed as an open-source application in partnership with Sun. This connector is an OpenOffice.org extension that can be installed directly to an OpenOffice.org installation.
This extension provides direct access to the webERP general ledger so that all general ledger reporting from webERP data can be done right from the OpenOffice.org scalc - spreadsheet application. The connector adds a new menu entry under Tools->Add-ons->Import webERP TB
Clicking on this new option brings up a dialog box to enter the webERP installation URL, the company database name to use. The range of periods to be reported on must also be specified together with a valid webERP username and password. The connector then imports the webERP Trial Balance for the period range selected, together with the budget information for the same period and creates a new sheet in the spreadsheet called "GL_Data". The data of the trial balance is then set as a named range "TB".
Using the standard vlookup spreadsheet function it is now possible to report on webERP general ledger directly from OpenOffice.org
The OpenOffice.org connector is available from the Logic Works web-store
