Payroll Fact Sheet – Dynamics Ax 2012 R3 – localised for U.A.E and G.C.C

August 4th, 2014 by Stephen Jones No comments »

The Payroll module is customized within Dynamics Ax for Gulf countries and is fully integrated with Dynamics Ax Human Resources, Self Service Portal and Finance modules.

• Define employee payment details in recruitment module during offer letter
• Define entitlements: either for all employees, or for a group of employees
• For an individual employee define (annual leave days, carry forward days, air ticket frequency, number of tickets, gratuity rules, bonus rules)
• Define salary components for: either all employees, a group of employees, or for individual employee.
• Define each component in any currency and this can be a different currency for each component.
• Employees request/record leaves\vacations and absences with workflow approvals
• Loans and advances, and recoveries
• Pension/Gosi calculation
• Gratuity accrual/payment rules can be easily defined
• Labour law rules can be easily defined, e.g. days of sick leave fully paid in each service year
• Define Air ticket entitlement definition, accrual and payment
• Payroll calculation is based on a timesheet. Create a working time sheet based on shifts, leaves and absences
• Payroll ad-hoc additions\deductions can be uploaded from an Excel file
• Create payroll journals and post to finance module
• Reporting – Synergy’s ‘out of the box’ report pack for payroll reports .
• A cube for Power BI analysis
• Wage protection system (WPS) file generation if required (non-free zone U.A.E. companies. (The WPS requirement is expected to be introduced across the Gulf in future. These files can be encrypted.)
• Bank transfer file
• Close payroll period
• Standard features include export to Excel; ability to import from Excel file salary components (for example, company wide change of basic pay once in a year) or to import timesheet details, document attachments).
• Employees self-service to apply for leave and to see pay slips in enterprise portal
• HR Enhancements e.g.: Personal Identification documents details, Arabic fields, personnel thumbnails


Dynamics Ax 2012 R3 Payroll – localised for G.C.C. – Synergy Software Systems, Dubai

August 4th, 2014 by Stephen Jones No comments »

Synergy Software Systems is the oldest Dynamics Ax partner in the region (since Ax version 2.5) and is the regional member for Ax Pact, and is also on the Microsoft Council.

We have provided advanced HR and Payroll solutions with integrated T@A across the region. Our Customers include mutli-nationals with complex shifts and payroll calculations in industries like: Oil and Gas, Retail, Construction, Hospitality.

In Dynamics Ax 2012 the AOS server license now included for the first time: HR modules the ESS portal, Timesheet booking, and Expense Management , Questionnaire module and Case management.

At the same time the cost of adding employee records was dropped and the development sdks for both X++and ESS are included., This is both a major cost reduction and increase in functionality for new customers or for those upgrading.

Dynamics Ax 2012 HR is now a cost effective, feature rich, compelling proposition either as part of an integrated erp solution or as a standalone system.

The HR module has also been more tightly integrated with Production shop floor control, and Project Accounting to support skill and calendar based employee scheduling.

Globally the statutory requirements for HR and Payroll differ widely e.g. taxation, visas, pension and gratuity rules. Company policies and practices also differ with incentives, bonuses and allowances.

Historically we have implemented specialist solutions integrated to Ax – partly for functionality, partly due to cost.

Previously few Ax consultants have had much exposure to HR modules because few customers felt the investment was worthwhile. Synergy however implemented Dynamics Ax HR for global companies in both Ax 4, and Ax 2009. We have also implemented stand alone specialist HR and Payroll solutions and advanced T@A solutions for more than a decade.

There are many Ax payroll solutions in the market (but few successfully implemented) so why Synergy Software Systems?

We have not based our solution on trying to rework a USA system . We have built it bottom up from long years of local experience of the requirements.

We have looked at many Ax partner offerings and they all lack what we consider essential features for this market, particularly for project based and shift based operations. Ash for example whether it supports multi-currency, or rostering. Our solution is built, and supported by seasoned professionals with around 6 man years of effort .

Contact Bikram for more information:

0097143365589

Dynamics Ax 2012 R3 Retail in action

August 3rd, 2014 by Stephen Jones No comments »


See the powerful capabilities of the Microsoft Dynamics AX for Retail solution in a live POS station environment

Watch walk through scenarios a retailer may experience day-to-day with customers. See:
– a touchscreen point of sale with a barcode scanner,
– a receipt printer, a line display,
– a cash drawer in action.

Many features of Microsoft Dynamics AX for Retail demonstrated such as:

– Ability to locate inventory from the store no matter where the product is actually located.
– Process data on a global level and make it available to local retail stores
– Purchase and process gift cards
– Ability to track and manage purchases made by loyal customers
– Ability to manage customer returns

Dubai Construction – BIM mandate – Synergy Software Solutions, Dubai, has the answer

August 2nd, 2014 by Stephen Jones No comments »

We introduced BIM to the region back in 2008.

Dubai Municipality has mandated the use of BIM for architectural and MEP works for :
According to this important document (number 196 – dated Nov 18, 2013), Dubai’s Municipality formally informs all design and construction companies operating in Dubai that it has decided to mandate/dictate BIM for architectural and MEP works for
(a) all buildings 40 stories or higher;
(b) facilities/buildings that are 300,000 sqft or larger;
(c) all hospitals, universities and other similarly specialized buildings; and
(d) all buildings that are being delivered by/through an international party.

The announcement also states that this decision to mandate BIM is based on the (proven) ability of BIM tools and workflows in improving construction quality, enabling collaboration between project participants across project phases, lowering costs, reducing time, unifying specifications/standards, facilitating QTO and cost planning.

It also stated that this decision is preliminary – stage 1 to come into force on January 1, 2014. Finally, the document states that consultants – architects, engineers and similar,( no mention of contractors) – are legally responsible to fulfil this dictate.

Dubai’s BIM mandate comes in the wake of increasing global adoption of BIM.
– – The EU made BIM a mandate in January 2014.
– In Singapore, BIM is mandatory for all public housing projects.
– IN U.K. government contracts will mandate BIM from 2016
– It has had widespread adoption in Scandinavia and the USA for many years.

Once International Construction companies adopt BIM in one country they will soon rollout to other countries and that factor will also force an increase adoption here by all contractors, architects etc.

Construction is one of the few industries where productivity has decreased almost year on year for the last 40 years. More congested cities. tighter planning and Health and Safety legislation may be contributing factors but the low adoption of enterprise IT relative to other industries is the major factor. This reflects an industry that often thinks on a project basis, and this has a high labour turnover which discourages long term investments and training. This e with longer term vision are reaping the rewards of BIM.

Design out mistakes before they reach site, integrate plans across the supply chain, and the savings are obvious yet BIM offers much more. Collaboration from the outset between all of the design disciplines – the client, contractor, specialists and suppliers – is fundamental to ensuring the best design, construction and operating solution and the BIM models and BIM workflows help to achieved this “right first time”.

According to the 2012 McGraw Hill North America BIM SmartMarket Report, the percentage of companies using BIM jumped from 17 per cent in 2007 to 49 per cent in 2009 and to 71 per cent in North America 2012 with 74 per cent of contractors now using BIM compared to 70 per cent of architects.

BIM solutions were used in iconic projects such as Shanghai Tower in China, Freedom Tower in New York. However BIM has also been successful in recent regional projects of various scale and size such as::
– the King Abdullah Sports City complex in Jeddah,
– Masdar’s headquarters at Masdar City,
– Al-Mafraq hospital in Abu Dhabi,
– the Midfield Terminal Building – Abu Dhabi International Airport (MTB-ADIA),
– the museum projects at Sadiyaat island

In all projects BIM adoption ensures that projects are completed more quickly, more accurately, more safely and at less cost than comparable non-BIM projects. A recent study from McGraw-Hill Construction found that BIM adoption is growing dramatically by contractors and that more investment is planned.

Two UK academics, Prof Nashwan Dawood and Dr Mohamad Kassem from Teesside University, have been awarded a grant of $940,000 to lead a research project aimed at developing “a whole life cycle information flow approach enabled by BIM protocols and technologies” for Qatar’s construction industry. The two UK academics will work with Qatar University and HOCHTIEF ViCon to deliver the project. The project research team has been collecting data and interviewing engineers and project managers on some of the major projects underway for the 2022 FIFA World Cup. The project will seek to identify the root-causes of poor information flows and the approach undertaken will be industry and client-led. There is an ambition to develop Qatar as the centre of excellence in the Gulf for advances in the management of information in construction projects.

A recent NBS BIM survey, reveals that 95% of construction professionals are now aware of BIM and usage among those professionals will jump from 54% to 93% within three years. However a recent ITP BIM breakfast meeting few attendees were willing to raise their hands to indicate that they had a full understanding of BIM.

Contractors, who particularly benefit from BIM, are beginning to insist that their consultants — including architects — must also work with BIM. This trend will accelerate due to government pressure to reduce costs, and energy consumption and to improve health and safety, and on-time completion and competitive pressure will force smaller contractors to adopt BIM. Many of those contractors will similarly insist that their supply chains also use BIM.

There is the feeling in Dubai that after years of fairly lax regulation on project management – which had undoubtedly resulted in a large amount of substandard projects, not to mention delays and budget overspends – the use of BIM can only serve to benefit Dubai’s construction industry

Understandably many are put off BIM adoption because of the anticipated costs, or perceived complex technology issues and the culture change needed to maximise the benefits. So ask about our AEC Construction solution that is an end to end solution that also encompasses estimation tendering and operations as well as BIM and at an affordable price with fast deployment.

The Solution

1. The construction industry needs integrated system support for challenging processes from project bidding to completion and client billing with dynamic project cost and time analytics to support a timely, high quality, decision making process.
2. To take control of the project management and stabilize the business you need controls and accountability around the clock.
3. AEC Engineering Apps, integrated with: Auto CAD, STAAD Pro and Microsoft Project facilitates the full construction lifecycle: plan, estimate, budget, and schedule, design and execute your projects with works accounting.
4. Rapidly make world class Bar Bending Schedules and designs.
Don’t take our word for it try a LIVE Trial on any of our 11 modules at
5. AEC’s proven applications help you to undertake the key construction business functions: drawings, planning, budgeting, procurement, inventory, equipment management and operations.

Find out for yourself – call Yudhi – 0097143365589

Windows “Threshold”

August 2nd, 2014 by Stephen Jones No comments »

A recent update on product Direction in the Redmond Channel partner site said that
“Threshold” is the internal code name for an update wave Microsoft is rumored to be developing for: Windows, Windows Phone and Xbox One.

Threshold is slated to have an April 2015 release

“If all goes according to early plans, Threshold will include updates to all three OS platforms (Xbox One, Windows and Windows Phone) that will advance them in a way to share even more common elements.”

Threshold is expected to have three SKUs.
•”Modern Consumer SKU: A frequently updated WinRT operating system supporting ‘modern’ or Windows Store Apps on but not focused on Win32 ‘legacy’ apps.

•”Traditional Consumer SKU: A frequently updated operating system optimized to support the use of a keyboard and mouse combination.

•”Traditional Enterprise SKU: A traditional desktop OS capable of running Windows Store Apps that will only be offered to organizations opting for volume licensing.”

It seems likely that Threshold will officially be called “Windows 9” . We anticipate the return of the Start menu, and the ability to run Windows Store apps ( “Metro” apps) inside Windows on the desktop.

SQL Server 2012 Service Pack 2 Cumulative Update #1

July 30th, 2014 by Stephen Jones No comments »

SQL Server 2012 SP2 Cumulative Update #1 updates Service Pack 2 to include the fixes from SP1 CU#10 and a few from CU#11, including the fix for the online index rebuild corruption issue

•KB Article: KB #2976982
•Build # is 11.0.5532
•Currently there are 45 public fixes listed (46 total)

Relevant for builds 11.0.5058 -> 11.0.5531.
Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or SP1 (any build < 11.0.5058), or any other major version.

SQL Server 2014 Permissions: CONNECT ANY DATABASE

July 30th, 2014 by Stephen Jones No comments »

In a recent blog post New SQL Server 2014 Permissions: CONNECT ANY DATABASE Edward Pollack, explains a new feature in SQL2014 which is paraphrased here.

CONNECT ANY DATABASE is a simple server-level permission that provides access to all current and future databases. When combined with:

– VIEW SERVER STATE, a login can monitor server and database metrics via a host of dynamic management views.

– or with SELECT ALL USER SECURABLES, a login can view data in all databases (read-only).

Many professions have restrictions over what employees are allowed to view, e.g. hospitals, where HIPAA greatly influences the flow of information. CONNECT ANY DATABASE provides database-level permissions without giving any access to the objects within. This also allows for scenarios where access is granted to all databases, but only for specific tasks, such as selecting all data, updating, deleting, etc. Security scenarios that used to be cumbersome to implement are now simplified. No need to create users in all databases for a login, nor to assign specific database-level permissions to ensure that a service account or monitor can do its job correctly.

for more information see – 2014/07/29 http://www.sqlservercentral.com/articles/Security/111116/

Eid Mubarak

July 27th, 2014 by Stephen Jones No comments »

As we head into the long weekend we wish all our readers Eid Mubarak.

Synergy offices will be closed Fri, Sat, Sun, Mon , Tue and will re-open on Wed 30th August.

(Blessed Eid ( عيد مبارك‎,) is a traditional Muslim greeting reserved for use on the EID festivals. Muslims often use the phrase Eid Mubarak after performing the Eid prayer).

Budget time is nigh – make life easier with Prophix – Synergy Software Systems, Dubai

July 27th, 2014 by Stephen Jones No comments »

Budgets usually mean late nights, and weekends. Spreadsheets are great for individuals but with multi-company, multi-department and multi-cost centres, and multiple budget versions issues arise from the spreadsheet proliferation:

– How to manage the distribution, notify users, confirm receipt, review, validate and approve?

– How to aggregate the data at multi reporting levels without complex look up formulas or tedious cut and paste and risk of manual error?

With a large user base involved in the budget process, inevitably some mails don’t get read, or the work slides, or a key person is off sick, or on holiday, or at an exhibition. So how do you track who has submitted their budget? How to auto generate notifications and expedite overdue submissions? How do approvers know that spreadsheets are received for their review? Is the budget right first time? If not, then how do you version control and compare versions?

Use in built tools to create budget templates, and to spread budget numbers, budget top down or bottom up, base on prior year seasonality, or derive from cost drivers.

Use the detailed planning module for e.g. Manpower planning budgets by individual pay elements, or e.g.for capex budgets. Add comments. Create graphical workflows and see a colour coded dashboard display of budget completion progress status with drilldown to individuals.

Usually there are different versions and now the number of spreadsheets is doubled- how is version control maintained, how easy is it to compare numbers and to drill down and across and between versions , or compare this year and last year, or compare across companies and departments, or lines of business?

Watch this 10 minute video to see better a way to mange your budget processes and to cut down on that on those that out of hours working and budget deadline pressures. Let the CFO spend more time analysing the numbers and less time on administrating the the process. Once your budget is in place you can sue the same numbers to effect budget spend controls to report actual v budget, to project long term plans or to reforecast.

The current version is Prophix 11 SP1, released in February 2014. This version includes new capabilities to further automate and improve planning and reporting processes, enhance the user experience, and align with new technologies.

Prophix 11 includes support for mobile on-demand access to reports through Prophix Mobile for the iPad and iPad mini, a new user interface that is familiar to business users, and the ability to manage large workflow projects with many contributors.

Key future technical priorities include:

Prophix Cloud, a deployment option for a Prophix-managed application and technical infrastructure.

– A thin client based on HTML5 to achieve a unified user experience across a variety of desktops and mobile devices.

Prophix Mobile functionality to connect to workflow in Prophix to respond to exceptions and approve tasks, ad hoc analysis, and support for other mobile devices based on technological demands.

BASEL III for dummies

July 23rd, 2014 by Stephen Jones No comments »

The Basel Committee on Banking Supervision (BCBS) is a group tasked with providing thought-leadership to the global banking industry (http://www.bis.org/bcbs). The BCBS has released volumes of guidance over the last decade to promote stability within the financial sector. The Basel Committee thus influences financial regulations globally.

In June 2011, the BCBS released “Basel III: A global regulatory framework for more resilient banks and banking systems.” This new set of regulations includes enhancements to previous rules and will have both short and long term impacts on the banking industry.

BNP Paribas Fortis presents this 10 minutes animation on Basel III for non-specialists. This Video “Basel III for dummies” is based on life presentations by Lars Machenil (CFO BNP Paribas) and Walter Rosenhek (Basel 3 Program Manager BNP Paribas Fortis.

The liquidity and capital consequences of these changes cannot be ignored. A new report produced by KPMG’s Global Financial Services Risk and Regulatory Centre of Excellence crystallises many of these issues. The report “Liquidity bigger challenge than capital ” highlights that:

Banks face high adjustment costs to satisfy the new liquidity ratios. Additional costs will emerge from the assembling and reporting of the necessary data, running stress and scenario tests and formulating recovery plans

In many instances, satisfying liquidity requirements will hurt profitability, particularly from the need to hold more high quality but low yielding liquid assets on the balance sheet.

Problems will be compounded because many banks will be making similar adjustments at the same time. Changes to business models and organisational structures will be the inevitable consequence in many cases.

For some banks the requirement to report unrealised fair value gains separately from losses could challenge existing systems. It is also clear that the recognition of these gains/losses within Common Equity Tier 1 capital under the Basel III framework will mean increased regulatory focus on the fair value policies and procedures of banks

Key features of Basel III include:
• A stronger capital base – More stringent capital standards and higher capital requirements

• Additional risk coverage:
o Enhanced quantification of counterparty credit risk
o Credit valuation adjustments
o Wrong way risk
o Asset Value Correlation Multiplier for large financial institutions
• Liquidity management and monitoring
o Introduction of liquidity ratios
o Introduction of leverage ratios

• Introduction of capital buffers

• Even more rigorous data requirements

Banking executives must consider:
• How will Basel III play into their Risk Appetite?
• How will they create project plans for Basel III when they haven’t yet finished implementing Basel II?
• How will new regulations impact capital distributions to shareholders? (Will new lead to diminished profitability and implementation problems.

Implementation challenges include:
Data availability, data quality/integrity, data lineage, dat retention data Models and Compliance in prescribed formats.

Manual approaches to regulatory reporting are already too cumbersome and automation and sue of metadata tools is now the norm. A strong, scalable architecture with work flow tools, logs and audit trails demonstrate data integrity. Manual touch points have to be minimized. o Data relevance/coverage – Data must be relevant to all portfolios and storage devices must allow for sufficient data retention.

Coverage of both on and off balance sheet exposures is critical. Model development – Requires highly trained resources with both quantitative and subject matter expertise. All Basel models need to be validated. This requires additional resources with skills that may not be readily available. All models should be properly documented.

Its important to ensure that the data and processes related to Risk assessment and management and financial reporting are integrated. For Basel compliance the Allowance for Loan and Lease Losses (ALLL) is calculated by Finance, yet the Expected Loss (EL) is calculated by Risk Management – and they need to give the same answer.This is not trivial to achieve.

A Compliance Challenges is that some Basel III requirements leave room for interpretation. Business lines are challenged by the competing priorities which arise from regulatory compliance and business as usual work. To provide internal and external auditors with robust evidence Banking executives complain that regulations will have a detrimental affect on business. The introduction of new regulations will no doubt hinder short-term profitability. The regulator view seems to be that by requiring banks to focus on premium growth, there is more potential for sustainable long-term profitability. The argument is that a stable banking system will increase consumer confidence which in turn will supports banking activity .

The regulations also aim to ensure that adequate funding is available for individuals and companies i.e stability brings profitability to banks. Therefore, it is important that every banking institution takes the steps necessary to properly manage, monitor and disclose its risks and this warrants the assistance and oversight of an independent regulatory authority.

Whether that noble view will endear itself to banks struggling to avoid fins and to get reports out on time remains to be seen. Its too late to debate Instead with regulators over the implementation of new requirements, the key task at hand is to implement systems that embrace these regulations with minimum pain and to fund ways to use the information and analysis to be more competitive.