Orchid Optional Tables
Liberate your information from limitations Custom data stored within Sage 300 Includes Spreadsheet Add-In with Writeback
What is Optional Tables?
Optional Tables frees you from the limitations of your standard Sage 300 (Accpac) data. Use it when you need to record extra information, such as budgets and forecasts.
It lets you create new fields (facts) in any module of Sage 300 (including third party modules developed in the SDK), and link them through to multiple Sage 300 master files (dimensions). You are creating custom data structures within your Sage 300 database, stored as Optional Tables.
You then have the power to use this information in many ways: Manage KPIs, budgets, forecasts, actual results and non-financial data at any level; Report at the level you define, with the combination of dimensions and facts you specify, using financial, non-financial and your own custom data.
Included with Optional Tables is the Orchid Spreadsheet Add-in for Microsoft Excel®. You can read standard Sage 300 data and Optional Tables data, manipulate it in Excel, and write data back into your custom Optional Tables in Sage 300. As a budgeting tool, you can develop budget models within Excel, distribute spreadsheets for the collection of budget data, and centrally update Sage 300 with your budgets at the click of a button – while keeping a full history of budget revisions and changes with descriptive notes. Users do not need access to or training in Sage 300, they can complete their budgets in Excel.