Overview
Beginning with QQube 6.1 we expanded the columns for Financial Summary Data Models - some of which have more than 256 columns by design.
We have accommodated those cases with alternative Access data models containing specific subsets of information, which still keeps the primary functionality intact.
Changes in Version 10
Version 10 added several traditional financial summary data models where you can create your own calculations. They are aggregated by day and allow actual "To Date" types of calculations.
These will obviously negate the need for worrying about 256 columns - because you will create the calculations you need.
Financial Data Model Replacement Chart
This table shows when the alternative FACT tables come into play.
- FACT tables ending with "_MA" are replacements that accommodate the 256 Column Limitation
- FACT tables ending with "_MA_57" are backwards compatible with QQube versions 5.7
| ANALYTIC | FACT TABLE USED |
| Balance Sheet | vf_FINANCIALBS |
| Profit and Loss | vf_FINANCIALPL_MA |
| vf_FINANCIALPL_MA_57 | |
| Trial Balance (Current) | vf_FINANCIALTB |
| Trial Balance Activity | vf_FINANCIALTBA |
| Statement of Cash Flows | vf_FINANCIALCASH |
| - | - |
| Balance Sheet (Class) | vf_FINANCIALBSCLASS |
| Profit and Loss (Class) | vf_FINANCIALPLCLASS_MA |
| vf_FINANCIALPLCLASS_MA_57 | |
| Trial Balance Activity | vf_FINANCIALTBACLASS_MA |
| Statement of Cash Flows | vf_FINANCIALCASHCLASS |
| - | - |
| Profit and Loss by Job | vf_FINANCIALJOBYTD_MA |
| vf_FINANCIALJOBRUNNINGTOTALS_MA | |
| Profit and Loss by Class by Job | vf_FINANCIALJOBCLASSYTD_MA |
| vf_FINANCIALJOBCLASSRUNNINGTOTALS_MA | |
| - | - |
| Profit and Loss w Actual/Budget/Forecast | vf_FINANCIALABF_MA |
| Profit and Loss (Class) Actual/Budget/Forecast | vf_FINANCIALABFCLASS_MA |
| - | - |
| Profit and Loss 52/53 Tax Year | vf_FINANCIAL5253 |
| Profit and Loss (Class) 52/53 Tax Year | vf_FINANCIAL5253CLASS |
What Was Replaced
This explains what has been replaced to accommodate Access Limitations. (FACT tables with a suffix of "_MA")
| ANALYTIC | STATUS |
| Balance Sheet | No Replacement |
| Profit and Loss | Removed Budget % of Sales Columns |
| Trial Balance (Current) | No Replacement |
| Trial Balance Activity | No Replacement |
| Statement of Cash Flows | No Replacement |
| - | - |
| Balance Sheet (Class) | No Replacement |
| Profit and Loss (Class) | Removed Budget % of Sales Columns |
| Trial Balance Activity | Removed "Last Period" shortcut columns. Removed Ending Debit and Credit Budget Amounts (Budget Ending Amount field remains) |
| Statement of Cash Flows | No Replacement |
| - | - |
| Profit and Loss by Job | One FACT table contains Year-To-Date (YTD) while excluding Running Totals (RT) and one FACT table contains Running Totals (RT) while excluding Year-To-Date (YTD) fields. |
| Profit and Loss by Class by Job | One FACT table contains Year-To-Date (YTD) while excluding Running Totals (RT) and one FACT table contains Running Totals (RT) while excluding Year-To-Date (YTD) fields. |
| - | - |
| Profit and Loss w Actual/Budget/Forecast | Removed Actuals % Sales, Budget % of Sales, and Forecast % Sales Columns |
| Profit and Loss (Class) Actual/Budget/Forecast | Removed Actuals % Sales, Budget % of Sales, and Forecast % Sales Columns |
| - | - |
| Profit and Loss 52/53 Tax Year | No Replacement |
| Profit and Loss (Class) 52/53 Tax Year | No Replacement |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article