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.

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.

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.
|
|

|
|