Define query flags to be used against transactions
When querying Transactions in Sage 200 you can use any characters except F, W and U as these are system defined. Our customer would like a screen in Sage 200 where you can set up definitions for other characters so that the query flags are consist...
The ability to add the analysis codes from stock to BI will be extremely useful especially when looking at stock movements. It is something that has never been included and feel it would definitely help numerous customers.
On SL and PL, would be nice in the drop down box to be able to change columns showing- i.e remove Dept + CC from the drilldown box if they are not used by the company
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
Currently if you raise a PO for a stock item and link that to a project/project item the resultant Purchase Invoice has no Project Analysis information when using the drill down option in PL Transaction Enquiry. It would be very useful if Sage cou...
Edgar, Steve
almost 7 years ago
in Transaction Enquiry
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
Include an option on both the sales and purchase ledger transactions enquiry screen to drill down to the original sales order or purchase order that generated the transaction.
Guest
over 10 years ago
in Transaction Enquiry
0
Idea Accepted - Gauging Support