How can additional fields be provided for or existing fields be populated in an X3 budget setup to serve as the opening balances for reporting balance sheet items? Sage Intelligence is being used to render GL budget data for specific annual budget sets loaded in X3. The data rendered by SI does not provide any calculated opening balances and only one budget set can be specified at SI report run time.

A "generic" SQL query is used by SI to render the data to the report. The concept of budgets in X3 does not  appear to include the provision budget opening balances for reporting - yet a balance sheet comparing actual GL values with budgeted values would require these opening balances. The SQL query provides for the GL opening balances since they are by default available in the X3 database - but budget sets do not appear to have this facility in X3.

Does anyone have any suggestions?