About Us   Contact Us   Exchequer   Support   Solutions  

Spreadsheet Tools -OLE/COM Server

This technology is primarily used by Enterprise to link Microsoft Excel dynamically to the rich financial management data held within Enterprise.

By utilising this technology, vital decision support data, such as general ledger actuals and budgets, stock sales and margins, customer buying trends and much more, can be instantly retrieved onto any Excel spreadsheet.

Spreadsheet Tools


There is no need to go through transaction files to accumulate data; live values from Enterprise are linked dynamically. Over 250 Add-In functions are supplied with Enterprise's financial modules.

This facility is ideal for producing board level management accounts, budgeting, forecasting, cashflow analysis, consolidations and financial modelling.

In addition to this, an optional OLE SavePack is available, which provides a further 200 functions for updating specific data within Enterprise from an Excel spreadsheet.

Using these functions you can set budgets in your spreadsheet that seamlessly update the budgets inside Enterprise. You can also create journal transactions, ideal for calculating and posting inter-company, cost-allocation or depreciation journals.

OLE/COM

Time sheets can also be entered via an Excel template and posted directly through to Enterprise's job costing module. Finally, most data fields within the customer, supplier and stock databases can be updated from Excel, providing a powerful tool for maintaining records or performing instant price updates.

The power of this technology cannot be emphasised enough. Its impact on analysis and presentation with your organisation, without the need for clumsy importing and exporting, extends the reach of your accounting system beyond your wildest imagination.

The scope of its use is truly staggering, as many thousands of Enterprise users have discovered to their advantage.


 Next Steps -
  » Contact Us
  » Request Callback
  » Get a Brochure
  » Presentation CD

Site Copyright 2006 © Kamarin Computers Ltd.
Head Office: Kamarin Computers, 12 The Metro Centre,
Wellbeck Way, Shrewsbury Avenue, Peterborough, PE2 7UH
Tel: 01733 297100 Fax: 01733 297109 Email: info@kamarincomputers.co.uk