 |
|
 |
The OX software makes information available from databases and other information systems in Microsoft Office 2003 and 2007. OX provide the formulas needed for calculations in Excel and in the other parts of Office the other needed functionality. OX unstable version is free to use for 30 days and supports for instance the OCRA 4.01 unencrypted MsSQL database and some other graph functionality. You can easily create "A" to "B" graphs in visio with OX. In Visio we also show intercompany transaction as a graph wich is a good tool to cut costs in a big company. Download unstable version here. Delivery of stable version will come as an email with a download link, please accept a few working days for delivery. We send our thanks to the needing OCRA customers that gave us insight in the database and economical understanding that made it possible to make the OX-OCRA connection. Support, education and extra development, if needed, is available to additional cost. Functionality 2009-08-17 _CompanyName _CompanyCurName _CompanyDrop _CompanyList _CompanyRefNo _ICT _GroupName _GroupId _GroupDim _GroupRefNoDrop _TreeId _DimName _DimActive _Dim5Drop _Dim6Drop _Dim7Drop _DimList _VersionName _VersionRefNoDrop _PeriodRefNoDrop _PeriodName _PeriodRefNo _PeriodReportEnabled _PeriodInputEnabled _PeriodStart _PeriodEnd _GetMonthName _GetMonth _GetYear _GoMonth _LastMonth _PeriodicityStart _PeriodicityEnd _QuarterStart _QuarterEnd _AccountNoDrop _AccountList _AccountText _AccountDim _AccountCategory _CurrDrop _CurRate _BaseCur _FlowStepNo _FlowStepName _FlowstepDrop _CFlow _CFlowPeriod _CFlowR12 _FD _FDPeriod _FDR12 _DSO _DSODaysAnnual _DSODaysHalfYear _DSODaysQuarter _CFAPackage _CFAData As OX is a multi-database platform it is of course possible to run multiple instances of databases and formula prefix is added at setup. With this you can develop reports to a test database and simultaneously compare to real data in some other database. The formulas above will therefore show up in Excel as PREFIX_CFAData for instance. |