1) Please download the sql below:

mSCOA DataExtract SP 6_2 MSCOA.sql

2) Open the database in sql management studio.

3) Run the script.

4) Test it in sql  for 2018-2019:

EXEC [dbo].[_AS_SP_DataExtract] 
 @StartYear = 2018
,@PrintStartYear = 2019
,@DataType = 'Draft Budget'			---Select 'Draft' Union all Select 'Original' union all Select 'Adjusted' union all Select 'Actuals' union all Select 'Virements'
,@IncludeVirements =0 
,@Actuals =0
,@IncludeCommitments =0								
,@ReportType ='DataExtract'	

5) Go into sage evolution

6) Go into the Report manager

7) Download the .AL file below:

8 ) Import the report.

9) run the report with the default settings:

Updating the A schedule for 6.2

Note before starting, push in the budgets into the MPBM. (When running the get data, the information on the Accounts budgets will be wiped). This way you will not lose progress of the capturing of Draft budgets.

1) Open the Excel

2) unhide the sheet "SQLs"

3) Replace the content of cell B2 with the following code:

EXEC [dbo].[_AS_SP_DataExtract] 
 @StartYear = 2018
,@PrintStartYear = 2019
,@DataType = 'Draft Budget'			---Select 'Draft' Union all Select 'Original' union all Select 'Adjusted' union all Select 'Actuals' union all Select 'Virements'
,@IncludeVirements =0 
,@Actuals =0
,@IncludeCommitments =0								
,@ReportType ='A Schedule'

4) Please download the sql below:

mSCOA DataExtract SP 6_2 MSCOA.sql

5) Click on the menu button get data again.

You can also download the Aschedule tool from below: (with these steps all ready applied)