Archive for October, 2013

Sunsystems 4.4 – urgent required update – contact Synergy Software Systems

October 31st, 2013

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

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.


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


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

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
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

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

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

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.

British summer time ended for 2013

October 27th, 2013

Note U.K. is now 4 hours behind us.

Azure moves forward

October 24th, 2013

Many advances recently announced here are two that caught my eye.:

Windows Azure Backup Services. A simple offering for backing up Windows Server to the cloud.

Hyper-V Recovery Manager a service that uses Azure to coordinate the replication and recovery of private clouds that use System Center Virtual Machine Manager. For disaster recovery, the service will help users to replicate between two sites, (both of which can be on-premise).

New Internet top level domain names

October 24th, 2013

ICANN, the Internet Corporation for Assigned Names and Numbers announced new generic top-level domain names yesterday,

In addition to well known domians like .com, .net and .org there are four new variations for the end of a web address., ICANN said these will be available soon:.

شبكة, which is Arabic for “web/network”;
онлайн, Russian for “online”;
сайт, Russian for “site”;
游戏, Chinese for “game(s).”

This is the first time these new “strings” have been approved under the new policy that was initiated in 2011. (Companies such as Google have requested new names too, e.g. .YouTube and .lol.)

Gitex 2013 – Thanks for coming to meet Synergy Software Systems!

October 24th, 2013

A big thank you to our neighbours Globalis for the overall arrangements for the stand and the logistics.

An equally big thank you to all the staff who assisted both on the stand and behind the scenes to make this such a successful event for Synergy Software Systems.

We welcomed partners from BRSANYLYTICS, BI4Dynamics, Keyed-In, TCPOS and Zuchetti who helped to man the stands and to assist the many visitors.

And of course another big thank you to everyone who stopped by and made it all worthwhile – it may take us a day or two to follow up on all the inquiries!