1) Please download the sql below:
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:
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) Click on the menu button get data again.
You can also download the Aschedule tool from below: