Modul Revisjon Bruker Dato Beskrivelse
Total 247 brenamag 27.01.2011 Added Show dependencies under Field menu in Multi Report to show field formula dependencies.
Total 249 brenamag 03.02.2011 Opened Maintain Transactions in Total window for use bu customers.
TazettJobs 248 brenamag 03.02.2011 Fixed bug not allowing adding tasks in TaskManager.
Total 264 solvakje 04.02.2011 First 3.10 version
Derivat 263 solvakje 04.02.2011 First 3.10 version
Stocks 261 brenamag 04.02.2011 First 3.10 version
Total 250 brenamag 04.02.2011 Opened Maintain Transactions in Total window for use bu customers.
TazettJobs 271 brenamag 17.02.2011 Fixed error when inserting new record in Transaction Table.
UploadFile 268 brenamag 17.02.2011 Created FTP Upload client installation package for sending to customers.
Ledger 267 brenamag 17.02.2011 Corrected booking of unrealized agio on forex forwards in ledger.
Stocks 276 solvakje 18.02.2011 Property fund result payment did not calculate correct reference. When retrieving existing result payment, interest payment the list was not ordered on dates.
Stocks 275 solvakje 18.02.2011 Daily portfolio TWR calculation failed from stocks.
Reports 274 solvakje 18.02.2011 Taxreporting of historic fonsa file was not correctly handling negative risk, and deductable amounts.
Reports 273 solvakje 18.02.2011 Convertion of attention persons with ' in the name failed, now this is handles correctly
Stocks 277 solvakje 21.02.2011 The Secondary turnover did not work for the field Broker. Used old way of getting connecting string, witch is not handled on windows 7
Stocks 278 solvakje 25.02.2011 Added new addin for TazDataReader. Also added new table PendingTransaction and Transactions if this addin is activated.
Stocks 279 solvakje 28.02.2011 New stored procedures in total to insert transactions in table transactions and pending transactions.
XmlTableDef 281 haugskar 03.03.2011 Columns with the same name but different data types will now be generated as separate datadictitems, suffixed with table name
Stocks 280 solvakje 03.03.2011 Now the length of the field Broker is always 15. Also added trigger on stocksale and stockbuy table for delete,insert and update.
Service 283 haugskar 04.03.2011 Exit in SjekkTrigger if the xml datadict generation is running
Service 284 brenamag 10.03.2011 Added fields 'Delete Field' and 'Value For Delete' in General Import to handle deleting of transactions. 'Delete Field' is the field that contains a code that indicates that the transaction should be deleted. 'Value For Delete' is the value of the delete code. The transaction with Key field will be deleted in the destination table. If the deleting transaction has another key, a conditional formula has to be used in key to get correct key. Example : (CASE WHEN TRANSACTIONS.TICKET_STATUS='C' THEN COALESCE(TRANSACTIONS.TRANSACTION_ID_REF,TRANSACTIONS.TRANSACTION_ID) ELSE TRANSACTIONS.TRANSACTION_ID END)
Reports 285 brenamag 11.03.2011 Possible to edit properties of multiselected fields. Only changed properties will be set on all selected fields. Fixed formatting of percent fields to add % at the end of the value. Corrected line height on sub report lines on MultiReport.
Stocks 293 brenamag 15.03.2011 Added corporate action Subscription Right.
Stocks 291 brenamag 15.03.2011 Changing in how booking of unrealized from stocks is done.
InvestorLink 290 brenamag 15.03.2011 Allow import of derivatives in InvestorLink (both transactions and security information).
Reports 289 brenamag 15.03.2011 Allow changing of properties on more than one selected field at one time in MultiReport.
Service 288 brenamag 15.03.2011 Changed GeneralImport to handle import of derivatives.
Derivat 286 solvakje 15.03.2011 When updating an open future/option transaction, it could sometimes close the transaction automatically.
Stocks 301 haugskar 22.03.2011 Added field RecordType in Transactions
Stocks 300 brenamag 22.03.2011 Added TransactionId and TransactionIdRef in Transactions in Total.
Stocks 299 haugskar 22.03.2011 Added fields Sector and Industry in Instruments table
Stocks 298 solvakje 22.03.2011 New table Instrument
Stocks 304 haugskar 29.03.2011 Endret i feltdata for å tilpasse til DataDict.xml Endret trigger for insert i stockbuy og stocksale fra while til if
Stocks 303 solvakje 29.03.2011 Change CorporateAction new field ExpiryDate
Stocks 302 solvakje 29.03.2011 New trigger to transaction from stockbuy and stocksale
Stocks 305 solvakje 30.03.2011 Importing of hisstory of norwegian indexes failed, because it was checking if Volume was different from 0. Now it is checking on Value. This import is done from Netfonds.
Stocks 307 solvakje 01.04.2011 Added Triggers so Stocks is added to the instruments table in total.
Stocks 306 solvakje 01.04.2011 Changes in table instruments and proTransactions, and a new view called transactions. Also fixed the triggers.
Total 315 solvakje 06.04.2011 Added new menu item called Web View.
Reports 314 solvakje 06.04.2011 Now we can store the report as a View. The field is found on the report as Field " StoreAsView". Also need to active add in Web Portal to use it.
Derivat 313 solvakje 06.04.2011 When close of position in derivat is the same as the BuyDate, the calculated Profit/Loss was not calculated.
Derivat 311 solvakje 06.04.2011 Importing of rates of indexes for norwegian stock exchanges, did not work when importing historic rates.
Derivat 310 solvakje 06.04.2011 Fixed problems in Derivat. Closed transactions when editing currency rate is now fixed.
Derivat 309 solvakje 06.04.2011 About was not presenting the company name correct. _ instead of &
Reports 308 solvakje 06.04.2011 New window to use for checking reports available as Web Views
Stocks 322 brenamag 07.04.2011 Changed so formatting a column to 0.0 % gives e.g 2,3 % and not 2,3% as earlier (without space).
Stocks 320 brenamag 07.04.2011 Added parameter /NEWINSTANCE in startup of Tazett. Using this, will open a new instance of Tazett, and don't switch to an existing instance.
Stocks 319 haugskar 07.04.2011 Several changes in xml generation of table information
Service 318 brenamag 07.04.2011 Added ISOCode field in CountyCodes table in Service, and filled it with 3 char country code. This is used to map country from ProBroker.
Stocks 323 solvakje 08.04.2011 Added new button in TaxValues so it is easier to add Dividends in the taxvalues table.
Stocks 324 brenamag 12.04.2011 Added field for not splittings sale records when FIFO in Options, Stocks. If this field (DoNotSplitSales) is set, tha connection to buy will be stored in SaleTrans as for Average.
Stocks 326 brenamag 13.04.2011 Do not split sales when FIFO if this option is set in General Setup. Added ConnectionType field in the connection table, and stores FIFO there if this option are set.
Total 325 brenamag 13.04.2011 Allow copy of sub-reports on MultiReport.
Total 334 brenamag 15.04.2011 Drop all triggers before Repair/Update database is run, to prevent transactions to be triggered hen a field is changed.
Stocks 333 brenamag 15.04.2011 New method to store Short Sale. Unconnected sales are stored with sale amount as cost amounts. TransnumberBuy is set to -1001. This records will be included on the Transactions and Positions reports, and shows negative cost values on the sale. This is handlet in the Sale window, and in the connection tool.
Reports 328 solvakje 15.04.2011 Added new rounding rules for corporate actions. Also added possibility to store reports as Views.
Stocks 339 solvakje 18.04.2011 Added new fields in stockbuy, stocksale and pendingTransactions.
Stocks 338 brenamag 18.04.2011 Added ProPositions, but it's not in use.
Total 336 solvakje 18.04.2011 Code was somehow removed from the change before last change.
Total 335 solvakje 18.04.2011 Added Source column in ProTransactions
Stocks 342 solvakje 19.04.2011 Added new triggers to the table PendingPerformanceChanges
Stocks 341 solvakje 19.04.2011 Missing decleration of a variable
Stocks 340 solvakje 19.04.2011 Added corporate action for redemption of subscription rights.
Stocks 344 solvakje 20.04.2011 Added StoreProcedure getATransaction
Stocks 343 solvakje 20.04.2011 Added trigger from ProTransactions to the table PendingPerformanceChanges
Stocks 348 brenamag 26.04.2011 Added fields PortfolioBuy and BrokerBuy in DetailedTransactions. This fields can be used to see costvalues per Broker and per Portfolio.
Stocks 347 haugskar 26.04.2011 Removed BrokerBuy and PortfolioBuy from SaleTrans
Stocks 346 haugskar 26.04.2011 Added PortfolioBuy and BrokerBuy to SaleTrans table.
Stocks 345 brenamag 26.04.2011 Added field DefaultPortfolio in Intruments in Total.
Stocks 350 brenamag 27.04.2011 Increased TaxSymbol to 20 chars
Stocks 349 haugskar 27.04.2011 Changed Transactions and DetailedTransaction sql in SjekkTotal
Stocks 353 haugskar 28.04.2011 DetailedTransactions was splitting up the buys. Changed the join.
Stocks 352 solvakje 28.04.2011 Stored Procedure updated for SetTransaction and GetTransaction
Stocks 351 brenamag 28.04.2011 Added field Intrument in ProTransactions
Total 358 brenamag 29.04.2011 Fixed transaction connection on sales in Total.
Total 357 brenamag 29.04.2011 Added buy fields in ProTransactions.
Total 356 solvakje 29.04.2011 Added Index for PendingPerfomanceChanges
Total 355 solvakje 29.04.2011 Renaming of the rounding rules from DOWN,UP,ACTUAL to Down, Up, Actual
Stocks 354 solvakje 29.04.2011 Added new Storedprocedure to delete transactions in pending transaction. Also added instrument in the triggers for stockbuy and stocksale tables.
Total 364 brenamag 02.05.2011 Added view PerformanceInvestor if TZDataReader Add-In is registered. Also a new report Performance Investor is added, showing percent performance from previous performance date. All dates in the new table ReportDates is calculated.
Stocks 363 solvakje 02.05.2011 Performance was optimized for the field investor in stocksale window and in stockbuy window.
Service 362 brenamag 02.05.2011 Allow accumulated columns on graphs on reports.
Reports 361 solvakje 02.05.2011 Formula cloumn in Multireport was multipling amounts with amount with not the full value. Example 19,2478 was cut to 19,24 in the formula. Now we are using the whole number.
TazettJobs 360 solvakje 02.05.2011 Added execution of corporate actions in TaskManager.
Reports 359 solvakje 02.05.2011 Added optional parameters to the stored procedure GetReportView
Total 371 haugskar 03.05.2011 Changed buy values on sales in detailedTransactions to be able to show values for unconnected sales.
Total 368 solvakje 03.05.2011 Now we disconnect sales that are register after a corporate action, and reconnect thoose after the corporate action is executed. When the user tries to execute the corporate action, there is a question regarding if it should do it or not.
Service 367 brenamag 03.05.2011 Functionality in Service, Public Holidays for generation of ReportDates in the ReportDates table, used by Investor Performance in Total.
Service 366 solvakje 03.05.2011 Performance update for search function. MoveLast was called twice.
Service 365 solvakje 03.05.2011 Cost amount on Corporate action was not handled correctly on rounding.
Total 373 solvakje 04.05.2011 DoNotSplitSales setting crashed when value was null, so added Tall()
Total 372 solvakje 04.05.2011 removing variable name in totalbas, since it is present in bascommon.
Reports 375 solvakje 05.05.2011 Fixes on CorporateActions rounding rules.
Reports 374 solvakje 05.05.2011 Creation of DetailedTransactions crashed because of missing space in query
Stocks 378 solvakje 09.05.2011 Added new fields for Noted and ExchangeCode.
Reports 377 solvakje 09.05.2011 Added new fields in Stocks (Noted, InstrumentID, ExchangeCode). Also added buy values to the stockBuy Trigger. Also added missing code in the trigger to get ReportView.
Reports 376 brenamag 09.05.2011 Fixed transaction connection on sales in Total.
Reports 383 solvakje 10.05.2011 BrokerageBuy on sale transaction was wrong. Also when saving a record, we didn't display a new blank page. Also the calculated result sold was wrong, before save was clicked.
Reports 382 solvakje 10.05.2011 Adding Generate New Table to the tools dialog, instead of having it in the Corporate Action dialog
Stocks 381 brenamag 10.05.2011 Added report Position and Dividend. This report shows dividend amount based on asset and inserted dividend amount in Tax Values in Service.
Stocks 380 solvakje 10.05.2011 Now we don't show the buttons to start other modules, if the parameter SILENT is sent as a startup command. Also all the choices in Open menu is not visible, and the general Export is deactivated in the total module
Stocks 379 brenamag 10.05.2011 Removed PendingPerformanceChanges table with triggers on depending tables (not in use).
Total 396 brenamag 11.05.2011 Changed to positive Rate on Sales in Transactions. Added 0 as clearing in triggers.
Total 395 solvakje 11.05.2011 New version of Total
TazettJobs 394 solvakje 11.05.2011 New version of TaskManager with Corporate Action
TazettJobs 393 solvakje 11.05.2011 Rounding on CorporateAction did not work with rounding in TaskManager.
TazettJobs 392 solvakje 11.05.2011 Calculation of AverageValues is corrected when we have globDontSplitSales. Then average values is the total amount of the sum of buy records for the sale record.
TazettJobs 391 brenamag 11.05.2011 Changed Tax Dividend columns.
Service 390 brenamag 11.05.2011 Added ReportDates table in Service (again).
Stocks 389 solvakje 11.05.2011 Corporate Action symbols was not sorted correctly in the combo boxes. Also in Merging the second symbol did not have all symbols available.
Reports 388 solvakje 11.05.2011 Added new stored procedure EXEC [dbo].[getWebViewList] to the total module. This SP gets all available web view reports.
Reports 387 solvakje 11.05.2011 The menu item Maintain Fund was visible twice.Now it is just dislpayed 1 time.
Fund 386 solvakje 11.05.2011 Error in opening of RecordSet if the client was Window 7 when writing BBS file.
Fund 385 haugskar 11.05.2011 Lagt til setting for Last updated transactionId fra Probroker. Lagt til indeks for UserSettings.
Reports 384 solvakje 11.05.2011 Added StartDate as a parameter to start reports from command line.
Total 400 solvakje 12.05.2011 New version for the Nordea Data Reader Solution
Total 399 solvakje 12.05.2011 Just uppercase lower case problem
Fund 398 solvakje 12.05.2011 the stored procedure GetRate() was removed but still used in the Fund module. So replaced the function to use fn_historicRate instead.
Fund 397 solvakje 12.05.2011 Modified the Stored Procedure setTransaction to make it simpler to call.
TazettJobs 401 solvakje 18.05.2011 Fixes on corporate action for subscription rights and redemption.
Ledger 404 brenamag 19.05.2011 Change booking of unrealized agio from Forex to split in account 21 - Market value agio and 22 - Market value disagio.
Ledger 403 brenamag 19.05.2011 Change booking of unrealized agio from Forex to split in account 21 - Market value agio and 22 - Market value disagio.
PathSelect 402 brenamag 19.05.2011 Leser oppstartparametre (inkl. oppstartskatalog) fra ini fil.
Ledger 405 solvakje 25.05.2011 Export of Visma was corupted in the update 13.January.2011. This is now corrected.
Stocks 406 solvakje 26.05.2011 Added support for grouping on InvestorGroup level for detailed transactions report. Also fixed on the FONSA taxreporting from the stock module.
Stocks 415 solvakje 21.06.2011 Added a free text in the item Change Investor Code, so its possible to add a description on all the records that are affected.
Reports 414 solvakje 21.06.2011 Added OwnBy as a code to set the investor after sum. This was reported as an error from NEF when they where printing for example "Beholdningsoversikt
Reports 413 solvakje 21.06.2011 Removed formating on year rate field. Reason, some customers wanted more than 2 decimals.
Reports 412 solvakje 21.06.2011 Changed txt boxes to combo boxes for corporate actions.
Reports 411 solvakje 21.06.2011 Corporate Action TYPE_DEMERGING was not correctly when added as a task to Task Manager
Reports 410 solvakje 21.06.2011 The length of the fields Strategy and Activiy is now 50 characters.
Reports 409 solvakje 21.06.2011 Now the payment is printed in landscape. Also added support for copy the data to Excel with CTRL+C
Import 408 solvakje 21.06.2011 Fixed overflow in import routine. Also some minor performance upgrade because of if, if, is now if elseif ...
TazettFTP 407 solvakje 21.06.2011 Removed GetFileSize because it was very slow when getting filesize from the ftp server.
Stocks 423 brenamag 27.06.2011 Fixed PositionsInvestor query to handle correct Amount. Started SQL for general PositionsInvestor estimation based on all modules, not just Stocks.
Stocks 422 brenamag 27.06.2011 Allow conversion of SQL without any select statements with SQLConv.
Reports 421 brenamag 27.06.2011 Fixed bug switching values of PrintIfValue and Hide properties on Multi Report tables.
Reports 420 brenamag 27.06.2011 Added Strategic as a Limit Type in the Limits setup. Used for setup of preferred Limit.
Reports 419 brenamag 27.06.2011 Allow help columns in fixed views (SjekkQuery).
Reports 418 brenamag 27.06.2011 Fixed bug starting other Tazett modules from VB on the buttons with parameters.
Reports 417 brenamag 27.06.2011 Added option Multiply Values in Columns Setup, to multiply aggregated values on a aggregate column. Used for multiplying index values on a daily performance report.
Reports 416 brenamag 27.06.2011 Allow help columns in fixed views (SjekkQuery).
Total 427 solvakje 30.06.2011 CorporateAction was not handled correctly. The date on SQL SERVER was 2 days before the correct date.
Total 426 solvakje 30.06.2011 Time field is now longer to support american standard for time 11:00:00 AM and PM
Total 425 haugskar 30.06.2011 Lagt til RecoveryStatus i Address
Stocks 424 solvakje 30.06.2011 ca_trans_info symbol columns is now 30 characters. Corporate action symbols always have a description column.
Service 429 brenamag 05.07.2011 Added Remove Adviser and Set Adviser for addresses in Maintain Address, under Tools menu, Batch Change and Operation. This is used to batch change what Advisers that shall access the selected investors.
Total 428 brenamag 05.07.2011 Use SymbolLength setting for length of the Symbol field.
Derivat 430 solvakje 08.07.2011 Now the logon window is displayed in the taskmanager.
TazettJobs 436 brenamag 29.07.2011 Allow TaskManager to read from TaskManager.ini to read start parameters.
Stocks 435 brenamag 29.07.2011 Fixed error not estimating Agio on stock sales.
Ledger 434 brenamag 29.07.2011 Set start voucher number to 10000 as default when booking from Tazett-Derivat. Possible to select Not EEA as Country in Ledger-Account.
Ledger 433 brenamag 29.07.2011 Check if XML file exists when importing from XML files.
Ledger 432 brenamag 29.07.2011 Allow use of CompanyCode when export all investors in file, where ID from Investor is used for all export lines. Removed TAB character in Header line for General Export.
Derivat 431 brenamag 29.07.2011 Add record in LedgerSetup table if no records exists (cause error when saving General Setup in Derivat).
Total 438 solvakje 03.08.2011 Fixed printing of multireport. Did not print to one pdf file, when deciding to do that. The file just had the last pdf printed.
Total 437 solvakje 03.08.2011 LastError variable was not declared
Reports 442 brenamag 05.08.2011 Added Trade Index Weight columns on reports. This columns shows the Weight from Index Performance Setup. Corrected the Trade Index Code and  Trade Index Performance columns om reports. Included Trade Index Category columns.
Reports 441 brenamag 05.08.2011 Added column Index Weight in Index Performance. This is the percent weight of the index against the top level of the index. E.g : If there is defined an index for all Portfolios under a Investor, the Weight is the preferred index allocation for each Portfolio. Used to show deviations between actual portfolio weights and preferred weights. Used by attribution analysis reports.
Reports 440 brenamag 05.08.2011 Added column Index Weight on report Index Performance. Added Tazett defined function IndexPerformance to show index performance in a period for a selected index. Changed existing column Index Performance to Index Performance Percent.
Total 439 solvakje 05.08.2011 Missing default parameter i stored Procedur for SetTransaction
Stocks 464 brenamag 08.08.2011 New exe file
Stocks 463 brenamag 08.08.2011 No exe in SubVersion
Stocks 462 brenamag 08.08.2011 No exe in SubVersion
Stocks 461 brenamag 08.08.2011 No exe in SubVersion
Stocks 460 brenamag 08.08.2011 No exe files in SubVersion
Stocks 459 brenamag 08.08.2011 No exe files in SubVersion
Stocks 458 brenamag 08.08.2011 No exe files in SubVersion
Stocks 457 brenamag 08.08.2011 No exe files in SubVersion
Stocks 456 brenamag 08.08.2011 No exe files in SubVersion
Stocks 455 brenamag 08.08.2011 No exe files in SubVersion
Stocks 454 brenamag 08.08.2011 No exe files in SubVersion
Stocks 453 brenamag 08.08.2011 No exe files in SubVersion
Stocks 452 brenamag 08.08.2011 No exe files in SubVersion
Stocks 451 brenamag 08.08.2011 No exe files in SubVersion
Stocks 450 brenamag 08.08.2011 No exe files in SubVersion
Stocks 449 brenamag 08.08.2011 No exe files in SubVersion
Stocks 448 brenamag 08.08.2011 No exe files in SubVersion
Stocks 447 brenamag 08.08.2011 No exe files in SubVersion
Reports 446 brenamag 08.08.2011 Added Tazett defined function on reports : IndexPerformance(«RateField»,«ReportStartDate»,«ReportEndDate»). This function estimates index performance for sleected index set up in Index Performance in Total.
Reports 445 brenamag 08.08.2011 Added Weight field in Index Performance.
General Import 444 brenamag 08.08.2011 Removed bug in General Import.
Reports 443 brenamag 08.08.2011 Run reports as Aggregate report if all columns are aggregatable. To be aggregatable, a columns must only include SumFormula as help columns, and no other help columns. Alias on the columns result are allowed. Showing only aggregatable columns in Column Setup if Aggregate option are set under Sorting and Grouping. Removed / set Aggregate option when report are ran.
Reports 466 brenamag 09.08.2011 Fixed InterestPay columns on DetailedTransactions reports.
Total 465 brenamag 09.08.2011 Do not allow sub queries and aggregate columns in aggregate reports.
Derivat 469 solvakje 19.08.2011 New version of Derivat
Stocks 468 solvakje 19.08.2011 Added support to write % in the filed for WitholdingTax on StockSale
InstallationSQL 467 solvakje 19.08.2011 Added support to build a new version of InstallationSQL, since there was problem when importing databases, because of crash when importing the DateFormats.
Reports 472 brenamag 23.08.2011 Fixed bug setting properties on multiple fields with formating in MultiReport.
Stocks 471 solvakje 23.08.2011 New functionality in MultiReport so it is possible to dynamic change the picture in a MultiReport. This is done when writing a sql expression in the formula. The value in that expression is substituted with the «AddToFileName» in the FileName property if present.
InstallationSQL 470 solvakje 23.08.2011 New version of InstallationSQL
Reports 473 solvakje 24.08.2011 Fixed error regarding printing of multireport.This problem was related to InvestorGroup grouping on multireport.
Reports 474 solvakje 25.08.2011 When pressing Save Set in the report criteria, the sql is just created as a view(Not executed as before)
Total 477 brenamag 01.09.2011 Starter exe filer fra kunde område og ikke fra Utvikling når modulraden til høyre brukes fra VB.
Total 476 brenamag 01.09.2011 Changed Column Options for Opening values. Opening Interest Paid and Opening Interest Accrued is now one column, Interest. Both Interest Paid and Interest Accrued is automatic included in formula. Changed OpeningInterestAccrued to handle only  records with BuyDate before report start date.
Ledger 475 brenamag 01.09.2011 Fixed bug not showing rounding record for OptionDeals-Closed-1 transaction type in Ledger.
Total 478 brenamag 02.09.2011 Changed getWebView stored procedure to include fields GroupField, TopLevel and SubLevel.
Export 480 brenamag 06.09.2011 Nothing changed
Stocks 479 brenamag 06.09.2011 Fixed error when selling stocks for a FIFO investor, ending up with two sale records.
Import 482 brenamag 07.09.2011 Added FTP Site field fin TazettFTP client for downloading files from both TEFS and Tazett FTP server.
Reports 481 brenamag 07.09.2011 Allow subqueries in aggregate columns on reports.
Total 487 brenamag 08.09.2011 Allow use of views created from General Export in with sp_getReportView.
Reports 486 brenamag 08.09.2011 Allow use of views created from General Export in with sp_getReportView.
Reports 485 brenamag 08.09.2011 Allow use of views created from General Export in with sp_getReportView.
Total 484 solvakje 08.09.2011 Investor not quoted in Stored Procedure
Reports 483 solvakje 08.09.2011 Changes for GeneralExport to store query as a view in the database. Changes for Importing databases from ProInvest. Added new option to specify the schema to import from. Changes for views stored with reportEndDate and ReportStartDate. This is now replaced with a function GetReportStartDate and GetReportEndDate. Witch gets date value for each investor in the the table UserReportDates. The date is inserted in the stored procedure sp_getWebView
Total 490 brenamag 12.09.2011 Allow GetEstimatedTWR() function to get TWR from another Investor. Select nothing as Table argument, and fill in Criteria argument.
Total 489 solvakje 12.09.2011 The stored procedures did clip symbol, when symbol was larger than 15 characters, now symbol is increased to 30 characters length
Reports 488 brenamag 12.09.2011 Fixed bug saving Report Set in reports. Minor changes in General Export.
Service 492 brenamag 13.09.2011 Added window Web User Management if WebPortal add-in is registered, found in Service, under File, Open. WebUsers contain all users that can log on to Tazett web portal. WebUserAccess contains information of what investors the different users can see on reports.
Service 491 brenamag 13.09.2011 Added tables WebUsers and WebUserAccess, if WebPortal add-in is registered. WebUsers contain all users that can log on to Tazett web portal. WebUserAccess contains information of what investors the different users can see on reports.
Total 495 brenamag 14.09.2011 Added user management dialog for web users
Total 494 solvakje 14.09.2011 Update for stored procedure
Reports 493 solvakje 14.09.2011 Change in sp_getReportView. • Added new paramter UserID (integer) • If not Investor is filled out, then check on value in UserID. • Return all investors in the table WebUserAccess for the UserID if UserId is filled out, and only thoose records with Investor if Investor is filled out.
Total 496 brenamag 20.09.2011 Added ProReports menu under Reports. Reading ProReport.xml file containing user defined reports and user views from other database (ProBroker or ProInvest). See K:\Kunder\ProReport for example. Added functions for WebLogin based on WebPortal add-in: addWebUser(UserName,Salt,Hash) : UserID changeWebPassword(UserID,Salt,Hash) : Boolean loginWeb(UserName) : UserID,salt,hash
Total 499 brenamag 21.09.2011 New vbp files
Reports 498 brenamag 21.09.2011 Ädded Database Fields under Columns setup. Here will all database fields available on the report show in the column list.
TazettFTP 497 brenamag 21.09.2011 Added checkbox on files to download. Changed to version 310 as default.
Total 504 brenamag 27.09.2011 Changed how WebViews are saved.
Total 503 brenamag 27.09.2011 Added functionality for deleting user. Disabled Password. Password is set from management on the internet portal. Removed Change button.
Total 502 brenamag 27.09.2011 Handle Report Start Date and Report End Date in WebViews. Adding all sorting fields to WebViews. Do not return data from WebView if no Investor and UserID is set.
Reports 501 brenamag 27.09.2011 Added views PreviousPerformanceInvestor and PreviousPerformancePortfolio in Total. These views can be used on reports to calculate volatility and other analysis values.
Reports 500 brenamag 27.09.2011 Downloading databases from FTP can now be selected for each database.
Total 507 brenamag 28.09.2011 Shows Web View menu under Reports. Don't allowing save of Store As View on a report if the view already exists on another report. Don't show blank WebViews in getWebViewList. Added field Language in getWebViewList and the Web View window under Reports.
Total 506 brenamag 28.09.2011 Allow NULL as Investor parameter in the sp_GetReportView stored procedure. This is to allow reports entered with only UserID and no Investor.
Total 505 solvakje 28.09.2011 New code to support symbol codes when country code is in the back of the file.
Total 512 solvakje 03.10.2011 New versions of stocks,TaskManager and total.
Total 511 solvakje 03.10.2011 Added dummy menus so we can build Tazett TaskManager
Total 510 solvakje 03.10.2011 Now the creating of sorting is corrected, before we could have the same sort number. That is not legal if we create a view
Total 509 brenamag 03.10.2011 Added ViewAlias returned by getWebView function. Used to show user defined text on web, and not the name of the WebView.
Total 508 brenamag 03.10.2011 Changed to Mature as Type in Future Payment for mature payments, not Sale as before.
Reports 514 solvakje 06.10.2011 New Taxreporting for the erverv. New field called ERVERVSTYPE.Just implemented ERV, not the other types.
Total 513 brenamag 06.10.2011 Added stored procedure sp_getReportViewColumnTypes in Total. This SP returns the column setup for all the column in the ViewName parameter. Parameter : ViewName and Module (optional).
Reports 518 solvakje 10.10.2011 Please have the sSql like this!!! Corrected error in sp_getReportView, when using different modules than total, the COL_LENGTH function did not work for the field ReportDate, always returned NULL.
TazettJobs 517 solvakje 10.10.2011 Check on rate import is now checking if country code/stock code is in front or in the back of the symbol.
TazettJobs 516 solvakje 10.10.2011 Indexes was added on tables that did not exist. For this indexes, the WebPortal must be activated.
Fund 515 solvakje 10.10.2011 New version with Tax changes from Skatteetaten for the tax year 2011.
Total 519 solvakje 14.10.2011 Fixed error regarding grouping and sorting problem that we have had lately.
Total 524 solvakje 18.10.2011 Sort by columns are not added if it is after the group by value
Total 523 solvakje 18.10.2011 New version.
Reports 522 solvakje 18.10.2011 Standard Position Report is now fixed, was sort columns after Group By value.
Reports 521 solvakje 18.10.2011 Header on reports was not correctly printing information of the investor.
Reports 520 brenamag 18.10.2011 Added view PositionsSymbol in Total. Changed view PerformanceInvestor to aggregate from PositionsSymbol. The report Daily Performance Investor is much faster as a result of the new view.
Stocks 529 solvakje 27.10.2011 Removed this line of code, because else it is not possible to show the header Investor : 1 and then all the transactions, and an end line in the bottom. Before we needed to have a column with B to get this result as a summary.
Total 528 solvakje 27.10.2011 New version
Total 527 solvakje 27.10.2011 Now the problem with header address and grouping should be correct after adding sort column that are not added as a group field.
Total 526 solvakje 27.10.2011 BondType and StockType is now 50 characters instead of 30.
Total 525 solvakje 27.10.2011 When executing "Notice Co-ownership" the amount was not excluding transactions with Activity equal to "Omsetning". Also added rounding, so we don't show amount that are less than 0.5.
Fund 532 solvakje 28.10.2011 TAINT-91 Now the calculation of receivables securities and liabilities securities is now calculated with the currency rate that are in history, for accounts that have different currency account than the system.
Fund 531 solvakje 28.10.2011 Just small cap. to large cap.
Fund 530 solvakje 28.10.2011 Just fix again on sSQL to sSql
Bonds 533 solvakje 31.10.2011 TAINT-99 Now the symbol code is present in the combobox when we have a short sale.
Reports 534 solvakje 03.11.2011 Now I have deleted this files, because they should be in the Stock Module.
Total 540 solvakje 08.11.2011 Removed special code, don't see any reason for not running this code in release version also.
Total 539 solvakje 08.11.2011 Sector is now 50 characters in length. Issuer in the transaction view from Forex system is now populated with CounterPart Added new table in Total called CreateNewLink, this table should be used for regenerateing of linking transactions.
Reports 538 solvakje 08.11.2011 Fixed problem regarding grouping level Fixed problem with wrong rounding when aggregate report, to few zeros. Fixed correct replacement of the Weekday function in Access to SQL SErver
Reports 537 solvakje 08.11.2011 Removed Useless button.
Reports 536 solvakje 08.11.2011 TAINT-99 Now you must click on sales in the grid. Also removed some code that is never called. Also fixed problem when clicking on sales in the grid for negative numbers.
Reports 535 solvakje 08.11.2011 TAINT-99 Now you must click on sales in the grid. Also removed some code that is never called. Also fixed problem when clicking on sales in the grid for negative numbers.
Stocks 543 solvakje 09.11.2011 Now using Shell Execute when changing modules in all of the stocks modules. Shell could return error for some users.
TazettFTP 542 solvakje 09.11.2011 Now using Shell Execute in TazettFtp. Shell could return error for some users.
Total 541 solvakje 09.11.2011 New versions
Total 547 brenamag 10.11.2011 Changed Maintain History window to allow 30 characters in Symbol.
Total 546 brenamag 10.11.2011 Upgraded to .NET 4.0 framework and stuff.
Derivat 545 brenamag 10.11.2011 Changed size of OptionTicker field to 30 characters (from 50).
Stocks 544 brenamag 10.11.2011 Allow manually aggregated reports, and a combination of aggregated column and not aggregated columns on a report.
Total 548 solvakje 15.11.2011 Importing of Historic Rates failed, reason was that , was not handled, used Tall instead of Tall3.
Total 549 brenamag 18.11.2011 Added Stored Function fn_GetReportConstants to return report date based on report date constants. Used by web-views to return correct dates on reports.
Export 550 solvakje 22.11.2011 New function for replacing constants in the queries.
Total 554 brenamag 23.11.2011 New Total.exe
Reports 553 brenamag 23.11.2011 Changed GetReportConstant SQL function.
Reports 552 solvakje 23.11.2011 Error in Change Investor because deleted views where set to vbHourglass(11) instead of 0.
Export 551 brenamag 23.11.2011 Added option Run Server Side on export of databases. This  option is used if the databases is >2GB for one table.
Reports 555 solvakje 24.11.2011 Error in pdf printing of just one page in printing of MultiReport. EndDoc was never called.
Reports 559 solvakje 29.11.2011 Small fix for printing just one report.
Reports 558 solvakje 29.11.2011 BuyCost was not subtracted in the ProfitLoss (Fund) Also removed lines where amount is 0 for Bond funds. TaxReporting from stocks, was not correct when getting historic transactions.
Reports 557 solvakje 29.11.2011 Missing DATE_PREVIOUSMONTH in the code, was because of the previous check in.
Stocks 556 solvakje 29.11.2011 New versions
Stocks 561 brenamag 02.12.2011 Changed PerformanceInvestor view.
Total 560 brenamag 02.12.2011 Set CommandTimeout to 0 on updating rest
Total 564 brenamag 05.12.2011 Added Common attribute om all common Transactions columns used by all modules, and all Total columns. If not Show advanced is pressed under Column setup, only these columns will be shown.
Reports 563 brenamag 05.12.2011 Added Reset button on Column Setup on reports. Pressing this button causes the formula on columns on the report to be reset to the formula from the application running. This is done to get the last version of a column. Only columns not set to User column (U in Type) will be affected. Added option Show advanced in Column setup. Pressing this option causes all columns available to be shown. If this option is not selected, only columns set to Common in the application will be shown.
Ledger 562 brenamag 05.12.2011 Fixed problem File already open in Ledger exporting to Visma Business.
Money 565 brenamag 06.12.2011 Set Common columns to appear under Column Setup on reports in Money. All columns is shown if Show advanced is selected.
Total 567 solvakje 07.12.2011 Added new Field so we can check if Corporate Action is executing.
Reports 566 solvakje 07.12.2011 Added InvestorGroup support for printing catalog. Does not work when report is grouped by InvestorGroup.
Reports 573 solvakje 08.12.2011 PathParse, added support for InvestorGroup handling.
Reports 572 solvakje 08.12.2011 Changed CountryCode from ZIP_CODES.COUNTRY_CODE to PARTICIPANTS.COUNTRY_CODE
Reports 571 solvakje 08.12.2011 Was printing different inngangsverdi on the csv file, compared to what was sent to Skatteetaten.
Reports 570 solvakje 08.12.2011 When empty funds where available, we had empty lines in the file.
Reports 569 brenamag 08.12.2011 Changed the Positions report to include forex forward transactions with settlement date ON report date as cash transaction. Exclude them as forex transaction if settlement date > report end date.
Total 568 brenamag 08.12.2011 Clear charts on MultiReport to avoid a copy of previous chars if sub chart don't contain data. Format dates to Mmm. yyyy or yyyy if report interval is many years.
Reports 574 brenamag 13.12.2011 Set Common columns to appear under Column Setup on reports in Stocks. All columns is shown if Show advanced is selected. Fixed tAsset column to add values as ordinary sum, and not weighted sum.
Reports 576 brenamag 14.12.2011 Set Common columns to appear under Column Setup on reports in Ledger. All columns is shown if Show advanced is selected. Fixed tAsset column to add values as ordinary sum, and not weighted sum.
Reports 575 brenamag 14.12.2011 Added report Daily Performance Symbol in Total, showing dynamic Time Weighted rate of Return, based on Report Dates in Service. If no Report Dates are found, the user get a question if he wants to add report dates.
Reports 578 brenamag 19.12.2011 Included returning of investor date values in fn_GetReportConstant function.
Reports 577 brenamag 19.12.2011 Fixed aggregate bug if a column started with Max(.
Total 579 brenamag 20.12.2011 Added column Receivable Marketvalue on reports, showing the value of receivable to find the difference between marketvalue and cash from Money.
Fund 593 solvakje 22.12.2011 Added new heritage Type I. Also now heritage is sold pr transaction.
Stocks 592 solvakje 22.12.2011 New version because of tax to NEF.
Stocks 591 solvakje 22.12.2011 Support for multiple KS and AS structure.
Stocks 590 solvakje 22.12.2011 To avoid crash when new stock is 0 stocks. Also extra check to avoid problems with , and .
Stocks 589 solvakje 22.12.2011 Moved code so we can build InstallSQL
Reports 588 solvakje 22.12.2011 If there was crlf in a field in MultiReport, the formula would fail. Now it is possible to have enter after formula.
InstallationSQL 587 solvakje 22.12.2011 Added because of error in InstallationSQL Build
Reports 586 solvakje 22.12.2011 Lots of fixes on the taxreport for NEF.
TazRunScript 585 brenamag 22.12.2011 Updated project to 3.10
TazRunScript 584 brenamag 22.12.2011 Fixed bug in Manual Interest Payment not showing interest and security information when Symbol were selected after one registration.
Bonds 583 brenamag 22.12.2011 Set Common columns to appear under Column Setup on reports in Bonds. All columns is shown if Show advanced is selected. Fixed tAsset column to add values as ordinary sum, and not weighted sum.
Bonds 582 brenamag 22.12.2011 Fixed date formatting on graphs.
Stocks 581 brenamag 22.12.2011 New exe allowing MAX aggregate columns.
Stocks 580 brenamag 22.12.2011 Added logging in general export.
Reports 595 brenamag 30.12.2011 Added function BalanceInAccountOnTransDate in Money and report columns using this. Used to see balance on accounts based on TransDate from manual payment. This is used to be able to compare reports in Money and Total.
Total 594 brenamag 30.12.2011 Changed GetReportConstant function so it can be used on Tazett reports.
Reports 598 brenamag 04.01.2012 Allow adding columns in transactions currency in addition to columns in local currency.
Reports 597 brenamag 04.01.2012 Add debugging in interest calculation routine.
Stocks 596 brenamag 04.01.2012 Do not multiply with SumFormula on aggregate columns on report. Also removed sum on aggregate reports with SumFormula, since this sum will be wrong.
Reports 602 solvakje 05.01.2012 Added new field To Trace Heritage. Also the taxReport of Fonsa did not handle correctly Heritage.
Reports 601 solvakje 05.01.2012 TaxDeductable interest for 2010 added
Reports 600 solvakje 05.01.2012 procedure setTransaction added field Strategy, so we can add comments on a transaction.
Reports 599 solvakje 05.01.2012 Tax Deductable interest rate for 2011
Total 607 brenamag 06.01.2012 Fixed grouped on fields with blank values.
Total 606 brenamag 06.01.2012 Don't correct bond sale if no sales are found.
Reports 605 brenamag 06.01.2012 Allow use of Memo fields in Reports, Find.
Reports 604 brenamag 06.01.2012 Added Industry and Country field on Transaction based reports.
Total 603 brenamag 06.01.2012 Report can now be grouped on fields with blank values both in group field, headers and totals. Showing Missing table.fieldname as value. This is done because blank values caused the report to show wrong values.
Stocks 610 solvakje 10.01.2012 Show Turnover for Property Fund did not show correct values.
Stocks 609 solvakje 10.01.2012 Added Strategy in PendingTransactions table in Total.
Stocks 608 solvakje 10.01.2012 Lots of fixed in Property Fund Module, becuase of change to support multiple KS/AS structure.
Total 615 brenamag 11.01.2012 Changed IndexPerformance column formulas to not recalculate to percent, since the function used already calculates to percent.
Reports 614 brenamag 11.01.2012 Allow formulas in sorting when StoreAsView on reports.
Reports 613 brenamag 11.01.2012 Allow sorting and grouping on fields without values (blank fields). Text 'Missing Value' will appear in the report. Do not hide graphs on report if first report column is hided. Speed up report with many columns.
Reports 612 brenamag 11.01.2012 Do not save StoreAsView twice when import a report. Automatically save and store the view when import a report.
Reports 611 brenamag 11.01.2012 Allow blank Investor in Index Performance setup, to enter an index for use by all Investors.
Reports 616 solvakje 18.01.2012 Added Heritage Values so its easier to do tax reporting in the fund Module.
Reports 623 brenamag 19.01.2012 Fixed sorting bug on reports for grouped reports (handle first sort order).
Reports 622 brenamag 19.01.2012 Added TWR Periodic Performance columns in Total Performance Report.
Stocks 621 brenamag 19.01.2012 Changed column Tax Dividend pr Stock.
Total 620 brenamag 19.01.2012 Increased size of local variables in sp_getReportView function.
Total 619 brenamag 19.01.2012 Fixed bug not importing last rate from textfiles in History.
Reports 618 brenamag 19.01.2012 Allow showing only graph even for several graphs on reports (remove data lines from table).
Reports 617 brenamag 19.01.2012 Allow showing only graph even for several graphs on reports (remove data lines from table).
Fund 629 solvakje 20.01.2012 Some error because of the new tables for fonsa reporting
Stocks 628 solvakje 20.01.2012 Undo of corporate action could fail when using the old method when date format is not dd.mm.yyyy
Fund 627 solvakje 20.01.2012 New Version of Fund
Bonds 626 solvakje 20.01.2012 The grouping was not correct in the query for BondSale Payments in the last check in.
Bonds 625 solvakje 20.01.2012 Payment in Bond could fail when clicking "Show Records", this was because it used the MovePrevious command, witch is not always supported.
Reports 624 solvakje 20.01.2012 Fixes for FONSA reporting. Added new tables to store the values when generating FONSA file. Also added to new reports to the stocks system for FONSA reporting
Total 632 solvakje 23.01.2012 Total is now including the latest changes. Was problem with the report engine.
Stocks 631 solvakje 23.01.2012 Fixed problem with sorting in Access. Also fixed problem for the formula to insert MISSING on fields that are null, to get all the values in the report
Stocks 630 solvakje 23.01.2012 ExecuteWriteUpDown did not copy the broker on the new transaction
Stocks 634 brenamag 24.01.2012 Moved Annual Report from Positions to Tax Report.
Reports 633 brenamag 24.01.2012 Added Column Type Database Fields on reports, showing all available database fields on the report.
Reports 635 brenamag 26.01.2012 Corrected estimation of weighted values on report for aggregate reports. Corrected Opening Rate formula for correct weighted average opening rate.