CRM 2011 Update Rollup 15 – enhancements and fixes

November 12th, 2013 by Stephen Jones No comments »

Several issues are resolved in Update Rollup 15 for Microsoft Dynamics CRM 2011, which has just been released

There also some worthwhile enhancements:
• a new feature that is scheduled to be delivered with Microsoft Dynamics CRM 2013. This feature moves the CRM client-specific workload into its own process so that it no longer shares memory with the Microsoft Office Outlook process. This feature is also known as Process Isolation.
• an upgrade to Microsoft SQL Server for Windows CE 4.0 for better memory management, better caching, and connection enhancements.
• updates of the CRM for Outlook configuration files to make the CRM for Outlook SDF files compatible with SQL Server for Windows CE 4.0.
• reduces performance issues that are caused by large address books.
• limits the number of active open forms.
• provides a MAPI Lock time-out.
• hard codes a previous registry setting that prevented pinned views from pulling down information to local SQL CE cache. This new DisableMapiCaching setting defaults to a value of 1. For more information about the behavior of this setting, see Slow Performance When Pinning Views in Microsoft Dynamics CRM

Contact the Synergy Software Systems CRM support team for more information.

Basel 111 update

November 10th, 2013 by Stephen Jones No comments »

What is Basel III?
Simply put, the Basel Accords are a set of rules on banking regulations with regards to capital. These are extended by Basel III. This provides for a series of additions to the existing accords and are designed to limit the likelihood and impact of a future financial crisis. It requires banks to hold more higher-quality capital against more conservatively calculated risk weighted assets (RWAs), and to reduce excess leverage while ensuring sufficient liquidity during times of stress.

On the 19th November 2012, Abu Dhabi Islamic Bank (ADIB), one of the world’s leading Islamic banks, successfully issued us$1 billion-worth of additional tier 1 capital certificates, the world’s first Basel III compliant Tier 1 Sukuk issuance.

In 2012 the UAE Central Bank had indicatedthat it would begin enforcing the new capital and liquidity ratios for banks in the country from January 1, 2013,. However, on December 17, 2012, the Central Bank postponed these new regulations until further notice.

The Qatar Central Bank (QCB) last month sent a draft circular to banks on new Basel III capital rules, which build on the Basel I and Basel II documents and seek to improve the sector’s ability to deal with financial and economic stress, improve risk management and strengthen banking transparency.

The QCB circular, which included requirements for issuance of instruments such as hybrid bonds, is aimed at a quantitative impact assessment, which will form the basis for its decision.

Status?
Many companies have made moves to adopt while others are still dragging their feet

The report by the Basel Committee on Banking Supervision – to the G20 on Basel 111 in August 2013
indicates that the regulations are still evolving via consultation.

The core elements of the Basel III capital framework were finalised in 2010. Since then, the Basel Committee has largely completed the remaining components, including the capital frameworks for G-
SIBs and D-SIBs and the final standard for the LCR.

In June and July 2013, the Committee published a series of documents, including an updated
assessment methodology and higher loss absorbency requirement for G-SIBs. It also made substantial
progress in a range of areas of the Basel framework. Specifically, the Committee issued the following consultative documents:

Revised Basel III leverage ratio framework and disclosure requirements

Capital treatment of bank exposures to central counterparties;

The non-internal model method for capitalising counterparty credit risk exposures;

Capital requirements for banks’ equity investments in funds;

and Liquidity Coverage Ratio disclosure standards.

The Committee will finalise these documents after considering comments from stakeholders
and interested parties. Further work is also under way in relation to trading book capital requirements,
securitisation and the Net Stable Funding Ratio. It is intended that these policy reforms will be largely
completed during the course of 2014.

11th GCC Banking Conference

November 10th, 2013 by Stephen Jones No comments »

The two-day 11th GCC Banking Conference on the “Role of the GCC Banking Sector in
Supporting GCC Economies
”, held in the City of Abu Dhabi, UAE concluded last week with a Press
Conference headed by H.E. Sultan Bin Nasser Al Suwaidi, Governor of the Central Bank of the UAE. Senior officials of the Central Bank were also present.

H.E. the Governor opened the press conference by providing a summary of the working
sessions of the Conference. The Governor answered questions addressed by the Press
regarding a number of banking and monetary topics, notably:

– The New Mortgage Loans Regulation
– The forthcoming Large Exposures Regulation and its components
– The forthcoming liquidity regulations
– The Macro-prudential policy
– The policy of opening branches of national banks in other GCC member countries
– Impact of the new Mortgage Loans Regulation on growth of the real estate sector
– SME financing program in the UAE
– Provisioning policy at banks operating in the UAE
– Regulations governing Islamic banks
– MOUs regarding Currency Swap Agreements signed with China and South Korea
– The forthcoming Financial Services Law

Earlier this year the IMF 2013 Article IV Consultation with United Arab Emirates press release stated:

The implementation of planned prudential regulations will help mitigate the risk of a build-up of banking sector vulnerabilities. With significant capital and liquidity buffers, banks show substantial resilience to shocks. Building on this strength, it will be important to preempt the build-up of new vulnerabilities. Swift implementation of the planned new prudential regulations for mortgage lending and loan concentration would mitigate the risk of rapid credit expansion and undue loan concentration to the real estate and GRE sectors in the future. These policies should be complemented by developing a more formal and transparent macroprudential institutional and policy framework. The proposed new Financial Services Law provides an opportunity to establish the legal base for such a framework. Developing the domestic fixed income market would support banks’ liquidity management as they prepare for the introduction of the Basel III liquidity norms, and would help the diversification of funding sources for corporates. The planned assessment under the Financial Sector Assessment Program (FSAP) will be a welcome opportunity to review the financial sector’s strengths and weaknesses. This assessment would also be a suitable occasion to conduct a review of the UAE’s Anti-Money Laundering/Combating the Financing of Terrorism policies.

It is good to see the conference addressing these matters in a timely manner – both for the good of the banking sector and for the U.A.E.

CRM 2013: Synergy Software Systems -Technical Considerations – Dubai

November 3rd, 2013 by Stephen Jones No comments »

Microsoft Dynamics CRM is designated as a Leader in the Sales Force Automation industry in the latest Gartner Magic Quadrant for SFA report. Microsoft’s vision is to provide a CRM solution that delivers an unbeatable combination of best-in-class usability, process excellence and agility. With the release of Microsoft Dynamics CRM 2013, complemented with Yammer, and Skype, CRM 2013 is the ideal solution for all your xRM needs! Customers choose Microsoft Dynamics CRM for many reasons:

familiar interface
low TCO,
workflow engine
extensibility vi the xRM platform
the Microsoft technology stack (BI, Outlook and SharePoint),
its flexible hybrid deployment model.

Synergy keeps pace with technology. Our experienced consultants ensure both successful implementation of Dynamics CRM 2013 and continued support and enhancements.

We would like to draw your attention to some Technical Considerations for CRM Administrators contemplating upgrade to CRM 2013:

Support is being removed for:
• Windows XP, to run either Microsoft Dynamics CRM for Outlook or the web application
• Microsoft Office 2003
• E-mail Router will no longer support:
– Microsoft Exchange Server 2003 for email routing and tracking.
– Microsoft Exchange Server 2007 WebDAV protocol for email routing and tracking.
(Microsoft Exchange Server 2007 Exchange Web Services (EWS) will still be supported.)

Support will be added for:
• Microsoft Exchange Server 2013
•. Microsoft Outlook 2013
• Active Directory Federation Services (AD FS) 2.2 (ships with Windows Server 2012 R2)

Legacy features that are no longer supported
With the launch of CRM 2013, Microsoft is officially dropping support for legacy CRM 4.0 features. These features were deprecated with Microsoft Dynamics CRM 2011 and will no longer work with this new version.

Dynamics CRM 4.0 features that will no longer be supported:
• CRM 4.0 plug-ins
• CRM 4.0 client-side scripting
• CRM 4.0 custom workflow activities
• CRM 4.0 web service API (also known as the 2007 web service endpoints)
• ISV folder support for custom web applications

CRM 2011 SDK tool no longer required
The Solution Down-level utility, specifically built for the Microsoft Dynamics CRM December 2012 Service Update, is not required for Microsoft Dynamics CRM 2013. Due to improvements to the solution framework, this tool is no longer needed.

Removal of CRM 4.0 client-side scripting
Microsoft Dynamics CRM 4.0 exposed global functions and form objects to form scripting with JavaScript. If you use any custom JavaScript within your current version of Microsoft Dynamics CRM, then it is important to verify that this customized code does not disrupt a smooth upgrade to the next version of CRM.

How to identify whether you are using legacy features?
There is a tool to help you to identify and to correct unsupported code prior to your upgrade. Please contact us for advice on how to download, install, and run the tools below on your Microsoft Dynamics CRM 2011 organization

What does it mean to you?

On-premise Customers
On Premise customers have nothing to worry about. However if you would want to stay up to date with technology and ensure that your organization is at the forefront of technology, then let us help you perform the migration with ease!

Contact: Bikram – 0097143365589

Sunsystems 4.4 – urgent required update – contact Synergy Software Systems

October 31st, 2013 by Stephen Jones No comments »

Required update for Infor SunSystems 4.4 users

Infor has implemented a required update for Infor SunSystems 4.4 customers with patch sets 16, 17, or 18 installed.

Warning messages—that the serialization key is expiring in one month or has expired—are not being displayed.

To address this issue, customers are required to install Infor SunSystems patch set 19.

31 October 13

October 31st, 2013 by Stephen Jones No comments »

Happy Halloween – also known as All Hallows’ Eve, a yearly celebration observed on 31 October, the eve of the Western Christian feast of All Hallows’ Day. It initiates the triduum of Hallowmas, the time in the liturgical year dedicated to remembering the dead, including saints (hallows), martyrs, and all the faithful departed believers
All Hallows’ Eve is a Christianized feast initially influenced by Celtic harvest festivals.

and

Happy Diwali – or the “festival of lights”, a five-day Hindu festival[4] which starts on Dhanteras, celebrated on the thirteenth lunar day of Krishna paksha (dark fortnight) of the Hindu calendar month Ashwin and ends on Bhaubeej, celebrated on the second lunar day of Shukla paksha of the Hindu calendar month Kartik. Dhanteras usually falls eighteen days after Dussehra.( In the Gregorian calendar, Diwali falls between mid-October and mid-November). For Jains, Diwali marks the attainment of moksha or nirvana by Mahavira in 527 BC. The name “Diwali” or “Divali” is a contraction of deepavali which translates into “row of lamps

and

Happy Hijri New Year

The Islamic year lasts for about 354 days and consists of 12 months. Muharram is the first month and some Muslims mark the start of the Islamic year on the first day of Muharram. first Islamic year beginning in 610 AD during which the emigration of Muhammad from Mecca to Medina, known as the Hijra – technically this year it falls on the 5th November – but please note the Public holiday has been amended to this Saturday so we will be open for business, and support on Sunday.

Rapid Development Applications – create your own web applications quickly in Dubai

October 30th, 2013 by Stephen Jones No comments »

Slash your development time and cost and minimize risk
Extend your business processes with this low cost, feature rich, development platform


Out of the box features;
Report Writer – Basic reports (rows / columns) and Charting
Error Management – System errors and workflow errors are tracked in the event log
Multi-Locale – Supports multiple time and date formats
Multi-Lingual – Rich language functionality available

Forms, Reports, Panels, Dashboards, Buttons..
Build forms easily with our drag and drop form builder
Create form sections and tab dividers
Multiple related data lists
File and image upload fields
Automatic validation (email, phone etc)
‘My Items’ lists automatically show users only items assigned to them or roles they are in
Export any view to Excel in a single click

Process and Workflow
Every action you could ever need:
Assign jobs to users and roles
Email using HTML templates
Setup timeouts and escalation driven by custom business calendars
Update records
Query Active Directory information
Call web services
Use decisions to control the flow on data or users choices

Data Focused WorkflowWorkflow can generate documents, integrate with other systems, update records
Custom activities can easily be added to use the .net libraries from third parties (like Dynamics AX ) to integrate with their systems

Event workflows
Every update to a record triggers a change or a create event
In the workflow designer processes are created automatically for objects
So when for example a sales order gets updated in the workflow we can check which fields were updated
We also have access to all the old values before and after the update

Interface workflow
Use the workflow tool to define a series of steps that when a user enters data on a field or selects an item from a dropdown. We call this feature active forms:
Active forms makes a decision based on the current user
It loads information on the template selected then hides a group of fields and shows other fields
It then runs calculations relevant to the template selected and makes some fields on the form required and others not
This same workflow can also trigger popups to prompt users for specific data or confirm that they understand instructions

Dashboards and Panels
Dashboards and panels show your users exactly what you want them to see
Custom dashboards with grids, charts, links and html Panels let you setup mini dashboards inside other sections of the application
Each role only sees their own dashboards and panels

Technical FeaturesInstall behind your firewall or on our SaaS 70 hosted service
Supports single sign-on and Active Directory integration
Web farms supported
Full globalization of all interface, applications and data
Deploy full applications or small changes from development to production
Track user actions and process events
Encrypt any field on any form
Granular permissions manage everything from row level security to who sees which forms in a workflow

API – ability to extend the key visual and business logic areas with custom .net code
Integration
Can be configured to load data from other odbc compatible databases (leverages sql servers linked server technology)
Additional sources can be added by making new activities for the workflow designer
Reports generated can be made available to be called via web services and also exported to csv for basic integration with accounting systems. (e.g. daily or weekly export of invoices to be loaded into QuickBooks)

Hekaton- SQL 2014

October 29th, 2013 by Stephen Jones No comments »

Hekaton, what is it?

This is SQL Server 2014’s In-Memory OLTP technology, to make data operations run much, much faster on SQL Server.

It will run database workloads entirely from main memory, using memory-optimized table structures. This will replace the relational standard locking model with an optimistic concurrency model based on time-stamped row versions. The Hekaton engine also uses new, ‘latch free’ data structures.

For the database developer, these differences in database and tables means the loss of some important bits features of relational model – for example Hekaton tables don’t ( at least not yet) support either FOREIGN KEY constraints or CHECK constraints, nor are there aren’t any DML triggersr. Constraints allow a relational designer to enforce relational integrity and data integrity. Without those controls, ‘bad data’ can get into the Hekaton tables so for several classes of database and data, this is likely to be a show-stopper.

So it will not be easy to move a current database to he new ‘Hekaton SQL 2014. the database will need a redesign to replace table variables with Hekaton tables. Is there where Microsoft will go with its erp systems?What does that mean for upgrades?

SQL 2014 is also likely to support parallel processing/Estimates of performance improvements vary from 30x to 200x faster. Such improvements are likely to prove more important than other considerations.

FATCA Update – UAE

October 28th, 2013 by Stephen Jones 3 comments »

The IRS final version of Form W-9 adopts the modifications made to the exempt payee box in a prior draft to accommodate the use of Form W-9 by foreign financial institutions that document U.S. account holders under Code sections 1471-1474 (i.e., the statutory FATCA provisions).

Rather than merely checking a box to indicate a payee’s exempt status, the new Form W-9 requires an exempt payee to provide a code designating the category of exemption for which it qualifies and whether it is exempt from domestic (i.e., Form 1099) reporting and / or FATCA (Form 8966) reporting.

Definition of a US person for US tax purposes under FATCA
Both individual and corporate customers can be classified as US persons under the Fatca rules. A US citizen, including an individual born in the US but resident in another country, who has not renounced US citizenship;
A tax resident of the US, including a US green card holder;
A person who spends a significant number of days in the US each year;
A non-US entity that is controlled by a US tax resident or US citizen;
A US partnership, corporation, estate or trust.

Why should the UAE bother about FATCA?
There are millions of international financial transactions flowing through global financial entities on a daily basis. Fatca was enacted on March 18, 2010 to ensure that US citizens pay the relevant US tax on their worldwide investments. It requires FFIs to sign an agreement with the US authorities and to identify, classify and report details of their customers who are from the US and, in certain circumstances, to withhold tax .
The incentive for FFIs to comply with Fatca is that otherwise a non-refundable 30 per cent withholding tax will be applied to US source income from January 1, 2014 and also to gross proceeds of sale of US investments from January 1, 2017.

To date the US has entered into discussions with around 85 countries that will need to follow one of these model agreements. There is the probability that the UAE will enter into such an agreement and discussions are ongoing

While compliance could be burdensome, costly and may be in conflict with local laws, non-compliance is similarly risky from a funding, competitive and client-facing perspective. From a commercial standpoint, for FFIs who are dependent on raising funds in the US, there is no real choice but to comply.

Will there be an Impact on UAE financial institutions ?
Undoubtedly!.FATCA will affect the vast majority of UAE financial institutions: banks, insurance companies, custodial institutions, hedge funds, mutual funds, superannuation funds, trustees, investment companies and managers, securitization vehicles, and private equity firms.

Some FATCA requirements and considerations
The implementation of FATCA is effectively the end of this year. In order to be able generate reports for 2015 data will need to be captured from 1 Jan 2014. Financial institutions have to consider;
Whether they will be subject to FATCA
Whether to review their investment strategies of accounts that provide exposure to US sourced income or assets.
How to identify US account holders. What due diligence procedures are needed to ensure a financial institution is capable of identifying US persons and what internal systems are able to monitor the various disclosure thresholds provided for under FATCA.
How to collect specific data to identify US persons who have invested in either non-US financial accounts or non-US entities.
Whether FATCA disclosure requirements conflict with UAE privacy laws e.g. should a Financial institution first obtain the consent of US account holders before disclosing information which might contravene UAE privacy and confidentiality laws
Who in a financial institution will take executive responsibility for Fatca compliance.
What plans should be put in place to train customer-facing teams to deal with customer inquiries.
How to conduct a thorough analysis and how to map subsidiaries and branches in other jurisdictions. For example do you have joint venture arrangements? Can you identify those subsidiaries in which your ownership exceeds 50 per cent to determine who will be responsible for Fatca compliance?

How to prepare mandatory information on US accounts in appropriate report forms that are not yet agreed and circulated.
When and whether a Financial institutions should withhold 30% on payments to those who refuse to declare their obligations to pay US tax.
The risk of examination by US tax authorities or being declared “off-limits” to US businesses and banking institutions if a UAE financial institution fails to comply with FATCA’s disclosure, reporting, and withholding requirements.
Who will bear the potential risk of FATCA withholding tax in legal documentation. What risk allocation issues may arise due to FATCA.
Legal documents may need to be updated with include representations and warranties that give protection to financial institutions against FATCA withholding tax.

What IT system changes are needed?
How will you capture any additional data? In which language?
Do you need to store and to search supporting documents?
Are any issue management, case management or workflow approval or notification processes needed?
What is the process for generating the required reports?

Ask about our solutions:
BRS Analytics to simplify and automate the reporting process and to support supplementary ad hoc inquiry
Filehold document management easily integrates into your banking systems
Dynamics CRM for customer profiling and case management
Integration and BPM tools to provide cross platform coordination of data and processes

Al Hijri New Year

October 28th, 2013 by Stephen Jones No comments »

The UAE Cabinet has announced the Al Hijri New Year holiday for the private and public sectors will be on Sunday November 3. Work will resume on Monday November 4.

The Hijri New Year, also known as Islamic New Year is the day that marks the beginning of a new Islamic calendar year, and is the day on which the year count is incremented. The first day of the year is observed on the first day of Muharram, the first month in the Islamic calendar.

Please note that Synergy offices will be closed on Sunday.