Functionality to add a Name (Description) and a Short Name to non-standard Sage 200 Modules/Sources
When importing Sage 200 Customer or Supplier transactions, it is possible to specify a Source (Module) number in the 16-90 range to the Excel import file. At present, when the transactions have been imported, the description of Sources 16-90 will ...
To be able to restrict access to which cubes BI users are able to report on. Currently users have to given full access to all BI reporting data, even if available reports are restricted they are still able to create new reports on any data cube.
Tom Blatchford
over 6 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
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
Import Customer Transactions - Sales Receipts - Allow Bank Account to be specified
When using the Import Customer Transactions routine to import sales receipts, there is no option to specify which bank account should be used. The default bank account is used. When you enter a sales receipt via the Enter Customer Receipt routine,...
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?
Sales and Purchase Transaction Imports should prevent Fx Rate lt; 1.000000 if the Customer or Supplier Account is Base Currency
It is possible to upload transactions with FX rate of lt; 1.00000 even the account you importing into is base currency, thus potentially putting the Control A/C out of balance.
Allow Imported Transactions to be Pre-Authorised if PL Invoice Authorisation is Enabled
On all Sage 200 versions prior to 2011 if purchase ledger invoice authorisation was enabled for all (£0.00). Imported invoices were not looked at and were imported as Authorised. On version 2013 onwards this core functionality changed and if PL in...
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
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
