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
This will assist support on the product, I needed to on several occasions try to find how data has got into the system when a customer is sure the data was not imported. It would be great if when a item is imported into sage via one of the standar...
Guest
over 10 years ago
in Database
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?
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
Narrative field to exist in trader ledger transaction tables
To display the narrative on reports and layouts, e.g. Purchase Remittance, requires the inclusion of the NLPostedNominalTran/NLDeferred NominalTran/NLPendNominalTran table(s) (depending on system configuration) by joining on the UniqueReferenceNum...
Guest
over 7 years ago
in Database
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
Expand SYSNominalAuditTrail table to Include SYSAccountingPeriodID
Expand SYSNominalAuditTrail table to Include SYSAccountingPeriodID as this would allow us to determine what Period a transaction was posted to which currently isn't possible in this area.
Andrew Siddles
about 8 years ago
in Database
0
Idea Accepted - Gauging Support
Improve traceability in SYSFeatureErrorLogging when deleting a bin location
When a bin location is created against a stock item, SQL SYSFeatureErrorLogging shows &Add New Location for item: ABBuiltIn/15/0/2& If you amend the name of the bin, SQL SYSFeatureErrorLogging shows &Edit Location for item: ABBuiltIn/1...
Guest
almost 11 years ago
in Database
0
Idea Accepted - Gauging Support
Currently if running a Report Set and send via Email from Sage 200 B.I. you can only specify SMTP Server or IP Address, This is fine if you have an internal repay server, but cannot be used if you are using Office 365 or Gmail for business etc.. w...
Jo Kirkup
over 2 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
