Click the image above to watch our demo. Anne walks through a scenario similar to the one described above while giving a detailed explanation of the steps and options along the way.
When it comes to budgeting and forecasting, the combination of Info-Explorer and Optional Tables is a match made in heaven.
While these two products are discussed on other Solutions pages, we think the way they can be combined for budgeting and forecasting purposes warrants a Solution page of its own.
- Info-Explorer, Orchid's affordable yet powerful Business Intelligence (BI) product, is generally thought of as an intuitive analysis tool. While that's certainly true, its ability to manipulate data, apply top-down spreads or adjustments, then write-back to your Sage 300 database, makes it ideal for budgeting.
- Optional Tables provides an alternative way to introduce custom, multi-dimensional data structures within the Sage 300 database. It’s particularly well suited to holding budget and forecast data that doesn't have a "natural home". This data can be maintained in Microsoft Excel using the included Spreadsheet Add-in, or entered into a grid on a Sage 300-style information entry screen.
Sample Budgeting Scenario
- Use the Optional Tables Spreadsheet Add-in to build a detailed bottom-up budget at the level you need, e.g. Customer & Item rather than just GL level, and store it in an Optional Table 'Infoset' within the Sage 300 database.
- Pull both the Optional Tables budget data and Sage 300 actual sales data into an Info-Explorer cube, and perform slice and dice analysis.
- Within the cube make a top-down budget adjustment, using a spread formula to apply the change to Customer and Item budgets.
- Use Info-Explorer’s write-back feature to update both the Sage 300 GL budget and the Optional Tables detailed budget fields.