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?
Allow selection of Product Group, Stock Codes and Price Bands when Exporting Prices to CSV
Currently if you need to perform a large update of sales prices - the easiest option is to use the Export Prices option, modify the CSV/EXCEL and use Import Prices to import the modified CSV to update the prices. This works fine on a small scale, ...
Paul Daly
over 8 years ago
in Stock
0
Idea Accepted - Gauging Support
Unfortunately in the current Sage 200 Professional API there doesn't appear to be an endpoint that would provide an approximation of the data stored in dbo.StockItemPeriodBalance. Altough these tables have great data within them. One example,of Pe...
Guest
almost 6 years ago
in Stock
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
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
Phantom Items - At the moment stock balances can be entered for Phantom items via the standard import routine. However if you do this by mistake there&s no way to remove the stock quantities. The stock opening balances routine should stop you ...
Guest
almost 10 years ago
in Stock
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
