webERP Add-on Software
OpenOffice.org Connector
Many businesses maintain company models in a spreadsheet as a convenient report writer for board reports showing the different divisions of the business in just the desired formatting colours etc. The vlookup function allows data from a trial balance to be retrieved into the appropriate place of the reports such that each month it is only necessary to import a fresh trial balance and all the monthly reports can then be run off. Using such a process it is possible to produce extensive management information accurately without endless reprocessing within days of the month or year end.
We have created an OpenOffice.org macro extension to directly access 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 in OpenOffice under Tools->Add-ons->Import webERP Trial Balance.
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 web-store