BI Data Warehouse database should be created with the Recovery Model that is set on the Model database
When creating a brand new data warehouse database it is configured to use the Full Recovery model. It should be created with the recovery model that is set on the Model database. If I create a brand new database it takes recovery model set on the ...
Richard Cunningham
about 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
We have a customer that has created a BI report but he has to manually refresh it for every company they have. Having built-infunctionality to run BI reports for multiple entities would massively decrease his workload.
John Dunn
over 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
Nominal Removal of Previous Year Profit amp; Loss Transactions
Current option removes transactions based on Transaction date only. nbsp;In the scenario whereby the first period has been opened, transactions dated for the previous Financial year have been posted and Removal of previous year Profit amp; Loss ha...
Anthony Lester
about 10 years ago
in Year end
0
Idea Accepted - Gauging Support
Currently Memo Accounts are not available to use in Sage 200 BI. Only group and posting accounts are shown. Memo accounts are present in the Data warehouse. Can these be added for future use?
Ever since the option to Remove Profit and Loss transactions from the Year End screen was moved to the Account Maintenance screen it seems to be getting forgotten about by customers. Request to move it back the Year End screen
Andrew Siddles
almost 9 years ago
in Year end
0
Idea Accepted - Gauging Support
As many Sage 200 customers have been using Business Intelligence for potentially several years now there is no way to remove/shrink the size of the database for it other then creating a new database which then looses the As At cube information
Andrew Siddles
almost 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
Automated creation of a previous financial year in Standard/Education
I think it'd be beneficial to have a previous financial year automatically created when schools/standard customers are setting up their company for the first time. This would handy for those who have forgotten to post prior year journals so new op...
Guest
about 7 years ago
in Year end
0
Idea Accepted - Gauging Support
At the moment we can only use Product Group Code, which is fine for me as I can remember which is which. But my Directors want to see sales by Product Group Name, can this be added into a Cube?
Catherine Bywater
over 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
Original budget values not available in Business Intelligence
On the Winter 2017 enhancements a new feature was introduced for Original budget values on nominal accounts. It seems this is not currently available in BI.
Jamie Davies
almost 8 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
To be able to remove Profit & Loss transactions from previous year in Sage 200 after running Year End
In Sage 200 Online it is not possible to remove profit and loss transactions from the previous financial years like it is for On-Premise. In On-Premise, the option is under NL Period End Routines Account Maintenance. Sage Support advised that we w...
Guest
almost 9 years ago
in Year end
1
Idea Accepted - Gauging Support
