Archive for the ‘Infor Financial solutions’ category

VAT update Qatar, KSA

September 10th, 2019

On 23 May 2019, Qatar’s General Tax Authority (GTA) disclosed to tax advisors in Qatar a new online tax management system known as “Dhareeba.” The new system should be available to taxpayers near the end of 2019, with all taxpayers expected to be registered before 1 January 2020, at which time Dhareeba will replace the current Tax Administrative System (TAS). PwC Qatar was invited to go through its own registration as a ‘pilot’ exercise during the last week of July 2019.

The Qatar General Tax Authority (‘GTA’) has redesigned the Tax website, allowing it to be operational in both English and Arabic. The website aims to provide vital information regarding any new taxes which may be implemented, particularly emphasizing the Excise Tax which came into effect on January 2019.

VAT is widely expected to be introduced on 1 Jan 2020. Synergy support several companies in Qatar and has a local registered company there. If you need assistance with planning VAT implementation for Dynamics Ax./Dynamics 365 Finance and Operations, or Infor SunSystems then please contact us. we have already undertaken numerous VAT projects In the GCC.

You will find much useful advice in our previous blog posts.

Meanwhile today the International Monetary Fund (IMF) has suggested that the value-added tax (VAT) should be doubled from 5% to 10% in Saudi Arabia in consultation with the other Gulf countries. Analysts expect the hike in VAT rate will come only after 2021 once Kuwait and Oman will also be ready to implement it and as a customs union, the increase makes sense across the GCC countries.

The UAE and Saudi Arabia introduced the 5% value-added tax from January 2018 and both the countries surpassing their tax collection targets. So this proposed increase seems odd because it has already impacted businesses more than expected.

The Kingdom’s non-oil revenues last year increased by 59%, buoyed by the VAT, excises, expatriate levy, and proceeds from the settlement agreements. IMF estimated that the VAT rate increase will add 2.0% to the Kingdom’s GDP in 2024.

Of course, as a customs union, it is logical that GCC countries would seek to keep their VAT rates harmonized in order to prevent tax arbitrage opportunities emerging within the GCC.

SQL Server 2016SP2 Cumulative Update 8

August 3rd, 2019

The urgent security update earlier this month is not the only patch for SQL Server 2016 in July,
Microsoft has released SQL. SP2 CU8 (build number: 13.0.5426.0)
• Restores of compressed encrypted backups fail
• Data masking doesn’t
• DAXquery needs memory 200x larger than the database size
• Peer-to-peer replication fails when your host name isn’t uppercase
• QueryStore cleanup can fill the transaction log and cause an outage
•DistributedAvailability Groups cause memory dumps when automatic seeding
• AGreplication stops working due to internal thread deadlocks
•The deadlock monitor can cause an access violation
• Query a view with a union on a linked server,
• Concurrent inserts into a clustered columnstore index can deadlock
•Infiniteloop when FileTable is used for a long time without a restart
•SSAS2016 randomly crashes ( maybe not completely random if they fixed it)
•TransparentData Encryption doesn’t encrypt if it’s restarted mid-encryption

And much more.https://support.microsoft.com/en-us/help/4505830/cumulative-update-8-for-sql-server-2016-sp2

I guess we will get a similar patch for Sp1 but by now you should be on a later patch

“Disbursements & Reimbursements’: U.A.E. – VAT clarification

July 31st, 2019

The Federal Tax Authority (‘FTA’) has released a Public Clarification on “Disbursements & Reimbursements” which addresses how to distinguish reimbursements and disbursements, and to clarify the applicable VAT treatment.

U.A.E. businesses incur expenses and subsequently recover such expenses from another party. The VAT treatment of the subsequent recovery of expenses depends on whether the recovery is a “disbursement” or a “reimbursement”.

The first step to determine whether a recovery is a disbursement or reimbursement is to establish whether you have acted as a principal or an agent in purchasing the goods or services

General principles to determine the VAT treatment of such recoveries:
Where a taxable person acts in the capacity of an agent, the recovery would generally amount to a disbursement.
A disbursement does not constitute a supply and is,therefore, not subject to VAT

Where a taxable person acts in the capacity of a principal, the recovery would generally amount to a reimbursement.
A reimbursement is part of consideration for the supply and follows the same VAT treatment as the main supply.

Principles

* The other party (from who you are recovering such expenses) should be the recipient of the goods or services;

* The other party should be responsible for making the payment to the supplier;

* The other party should have received an invoice or tax invoice in their own name from the supplier;

* The other party should have authorized you to make the payment on his behalf;

* The goods or services paid for should clearly be additional to the supplies you make to the other party;

* he payment should separately be shown on the invoice and you should recover the exact amount paid to the supplier, without a mark-up.

* You should have contracted for the supply of goods or services in your own name and capacity;

* You should have received the goods or services from the supplier;

* The supplier should have issued the invoice in your name;

* You have the legal obligation to make payment to the supplier;

* In case of goods, you should own the goods prior to making any onward supply.

Examples

Company A procured group medical insurance from a local insurance company and received an invoice directly from the insurance company.

* Company A requested Company B to make the payment on its behalf.

* The subsequent recovery of the amount by Company B from Company A will amount to a disbursement, and would not be subject to VAT.

* Company A should ensure that the Tax Invoice is addressed to it from the insurance company and should recover the input tax through its UAE VAT return, subject to the normal input tax recovery rules.

Company A entered into a contract with Company B to provide marketing services.

* The contract stipulated that Company A would be eligible to reimburse the expenses from Company B.

* Company A incurred the expenses in its own name and subsequently recovered the amounts from Company B as per the terms of the contract.

* The recovery of expenses from Company B would follow the same VAT treatment as that of the main supply.

We recommend;

* Identify the nature of your contract and agent/principal relationships (if any) based on the above principles;
* Ensure that all disbursements have proper authorizations (contracts); and
* Re-view all inter-company disbursements/ reimbursements (cross-charges).

SQL Server 2008 and SQL Server 2008 R2 -OUT OF SUPPORT today

July 13th, 2019

SQL Server 2008 and 2008 R2, both of these versions of SQL server go out of extended support with Microsoft today 9th July 2019

Many companies and businesses are still SQL Server 2008 R2 and below. There can be a number of reasons for this, maybe the applications the databases support require an older version of SQL Server, maybe the applications are also coming to the end of life, but the end dates do not match up with the data platform end of support dates.

Sometimes applications are critical to the business and everything works just fine. The business doesn’t want to disrupt the application or introduce any risk by performing a migration to a new version so why change it?

In this situation your data platform is out of support completely. Out of support system attract hackers. Note the previous articles about fines for loss of privacy data to realise how serious this can be

So you should be making plans to migrate your legacy SQL Servers off the unsupported versions. It is likely if you are still on an old database that you are also on an old server and on an old version of Windows. That gives additional risk of failed hard disks, other system vulnerabilities – Meltdown, Spectre? Phishing…….
Investors and insurers are not likely to be sympathetic in such circumstances.

There are many performance and security benefits of upgrade.

If you decide to run on out support software and take the risk associated with running on out of support software. The main advantage of this approach is there is nothing immediate to do. The longer you run on the platform the greater the chances of you encountering a security vulnerability or failing a compliance test.
If anything does go wrong you’ll have no support from Microsoft.
Other software vendors support contracts may also require that you be on a currently supported database

Modernise and upgrade is one of the options that you have available.

You can upgrade your on premises SQL Server or migrate the databases to Azure either as IaaS solution where you run the VM in Azure or even the PaaS Azure SQL database offering

There are number of advantages to upgrading your data platform. You’ll be running your database workloads on an in support data platform, with a long support window. There will likely by new features in the latest and greatest version of SQL Server that you can use to add business value to your application – Availability Groups for example. Also you will likely find people with skills in the later technology, those skills will be more readily available in the jobs market.

There will likely be a different licensing model – the licensing model changed between SQL Server 2008 R2 and SQL Server 2012 – it possible you will have to pay more for you SQL Server licences.

The third option is instead of doing nothing you pay for a custom support agreement. The main advantage here is you can continue to get security updates and therefore potentially remaining compliant. The main disadvantage of this approach is the cost involved, which is typically 75% of the full license costs of the latest version of SQL Server and Windows Server.

Migrate workload to Azure. Microsoft allow SQL Server 2008 and SQL Server R2 VMs running in Azure to have the security updates for free for a further 3 years. So you can migrate your database server to azure and continue to get security updates for free until 2022.

The main advantage of this is you get to keep running the same version of the OS and Data platform, the security updates are free so the cost is minimal \. The disadvantages is you would need to move off premises, if this is not an option for you then you can’t exercise this option and there will still be work in involved in ‘lifting and shifting’ the VM to the cloud.

Whatever you do when support ends for SQL Server 2008 and SQL Server 2008 R2 have a plan

Integration as a Service – ask Synergy Software Systems, Dubai about Snap Logic

July 2nd, 2019

Why do companies like Adobe, AstraZeneca, Box, GameStop, OSN, Verizon, and Wendy’s choose SnapLogic?

They have a problem that many other companies are facing today. On one side, business managers rely more and more on SaaS applications and big data for daily tasks yet IT is responsible for integrating the applications. These business managers need daily access to accurate information but can’t always wait for IT. On the other side, IT is managing multiple projects, including integration requests and is working with far fewer resources. Requests can take weeks or even months to complete and business leaders can’t wait that long, so end up making decisions based on less than perfect data.

The Snaplogic Enterprise Integration Cloud comes with Iris Artificial Intelligence built in. Take away he complexity of dealing with multiple applications, big data, complex APIs, and IoT and abstract it into drag and drop components, all in one platform. SnapLogic’s Iris AI further democratizes the use of data by empowering users from all departments and teams to make data-driven decisions quickly and easily with higher accuracy. Business manager can now do their own analysis with minimal support from IT and make informed, data-backed decisions quickly.

IT people can spend less time building routine integrations and more time helping the business grow. SnapLogic is already helping many businesses with these challenges. GameStop reduced the amount of time it took to build integrations by 83%. Business processes cut across functions and applications. Transform business processes faster and stay focused on managing your business with data-driven insights rather than spend time on writing and maintaining code.

General Electric’s (now Suez Water) employees are 4 times more productive when it came to onboarding partners through its multiple systems.

AstraZeneca has more than 500 users around the world who are performing self-service integrations.

Box has connected 40 applications and is processing more than 15M transactions daily with only 1.5 full-time developers needed to support this volume.

Corporate performance management or Big data analytics from multiple, disparate corporate erp and finance systems, hybrid cloud and on premise integration, migrating to the cloud or to new software versions, IoT, T@A, EAM systems, WMS systems, Payroll systems, there are many integration challenges.

To support your digital transformation call us on 0097143365589

SQL Server 2008 and SQL Server 2008 R2 – end of life July 9, 2019 -ask Synergy Software Systems

June 23rd, 2019

Microsoft has previously announced that SQL Server 2008 and SQL Server 2008 R2 will reach end of life on July 9, 2019.

This means that in less than a month, Microsoft will no longer release regular security updates for the product.

There are several reasons this is important to you.
• Attacks against software products of all types are common and ongoing. With Microsoft SQL being such a prevalent platform, attacks against it are ubiquitous, and it’s important to keep your database platform up-to-date with the latest Microsoft security patches.
• Many compliance requirements dictate that you must be running currently supported software.
• As Microsoft drops support for a product, many third-party applications may also discontinue support for their products running on those platforms.

So, if you are still running SQL Server 2008/2008 R2, then what are your options?

1.Upgrade to a newer version of SQL.
SQL 2019 is in preview release as of this writing, so the current production version of SQL Server is 2017. Its end of life will be October 12, 2027.
Evaluate your applications and databases to make sure they are compatible e.g. Dynamic Ax 2012 is not supported beyond SQL 2016

Plan a migration for either on-premises or cloud. A move to an Azure SQL Database Managed Instance, will not require you to upgrade in the future. By choosing this option, you will also gain access to new features which have appeared in the latest SQL Server versions. However, it only offers subset of SQL features so you need to be sure it will support your application and use.

2.Migrate to Azure to receive three more years of Extended Security Updates for SQL Server 2008/2008 R2. If you need to stay on the same SQL code base for a bit longer, Microsoft will allow you to rehost your SQL 2008 environment in Azure and still provide you with security updates for an extended period. There is no extra cost for the extended updates beyond the standard Azure VM rates.

3.Purchase extended support. Microsoft allows customers with an active Enterprise Agreement and Software Assurance subscription to purchase and receive three years of Extended Security Updates for SQL Server 2008/2008 R2. The annual outlay for the updates is 75% of the full license cost.

4.The least desirable option is to stay where you are and pray. If circumstances prevent you from moving forward now, then at minimum you should:
• Recognize and account for the risk;
•Plan and budget for a transition as soon as possible;
•Re-evaluate your security and tighten it as much as possible.

Microsoft provides guidance for handling the end of support of SQL Server 2008/2008 R2 at https://www.microsoft.com/2008-eos.

Of course, Synergy is ready to help you to evaluate and to progress to the next level. 0097143365589

If you are running newer versions of SQL Server, then here are their End-of-Life dates.
•SQL Server 2012 – July 12, 2022
•SQL Server 2014 – July 9, 2024
•SQL Server 2016 – July 14, 2026
•SQL Server 2017 – October 12, 2027

Windows Server 2008 and 2008 R2, support is coming to an end.

June 23rd, 2019

Sometimes lifecycles end because of age or workload and other times they expire due to vendor support.
In the case of Windows Server 2008 and 2008 R2, Microsoft announced that Extended Support will end on January 14, 2020.

Microsoft provides: Mainstream Support, Extended Support, and Beyond End of Support.

Mainstream Support

Mainstream Support is Microsoft’s first phase of support and lasts five years. It includes the following benefits:
• Incident support (no-charge incident support, paid incident support, support charged on an hourly basis, support for warranty claims)
• Security update support
• Ability to request non-security updates

Extended Support

The Extended Support phase follows Mainstream Support, and also lasts five years. The key features of Extended Support are:
• Paid support
• Security updates at no additional cost
• Ability to request non-security updates (available only via Unified Support, a new model of support that offers comprehensive support that covers your entire organization)
• Microsoft will not accept requests for warranty support, design changes, or new features during the Extended Support phase.

Beyond End of Support

The Beyond End of Support phase is the final phase of the product lifecycle and lasts for three years. Here are the key things to remember.
• Request to change product design and features are not available
• Security updates are available only with the purchase of the Extended Security Update Program for up to three years. This typically costs 75% of the on-premises license cost annually.
• Technical support is provided when you purchase Extended Security Updates and have an active support plan in place on the product that has moved beyond the Extended Support date.

Server 2008 and 2008R2 are moving out of the Extended Support phase on January 14, 2020. From that date on,
non-security updates will no longer be available,
security updates will be available only if you pay for the Extended Security Update Program,
and other vendors will diminish their support of this operating system version.
If you are not prepared, then this will leave your environment open to security holes, application instability, and support restrictions.
If you have not already planned for this then now is the time to get it into your budget for first thing next year.

Major SQL updates don’t skip – SQL Server 2016 SP2 CU7 and SQL Server 2017 CU 15

May 26th, 2019

This week, Microsoft released two major updates.

SQL Server 2016 SP2 CU7 has multiple fixes including:

• Filtered index corruption
• Access violations in sys.dm_exec_query_statistics_xml, sys.dm_hadr_availability_replica_states, sys.availability_replicas, sys.dm_db_xtp_hash_index_stats, sys.fn_dump_dblog, sys.dm_db_xtp_checkpoint_files
(I.e. if you monitor your servers, which you should, then you should apply this CU to avoid problems caused by the monitoring tool’s queries)
• AG failover fails
• Incorrect query results on columnstore indexes, and also this

SQL Server 2017 CU 15 has even MORE fixes, read the full list. https://support.microsoft.com/en-us/help/4498951/cumulative-update-15-for-sql-server-2017

Note also, that from SQL Server 2017, the Analysis Services build version number and SQL Server Database Engine build version number do not match

There are some CUs you might be tempted to skip because they don’t affect you. These releases will affect a wide range of features and you should plan to apply these sooner than later.

Recent G.C.C VAT updates

February 16th, 2019

Passive interest and dividends
The Federal Tax Authority (FTA) asserted that passively earned interest income from bank deposits and dividend income are outside the scope of Value Added Tax (VAT), and there is no requirement to report these in the VAT return.
VAT is a tax imposed on the import and supply of goods and services at each stage of production and distribution, therefore, VAT implications arise only when there is a supply – when there is no supply, there is no VAT implication.
The FTA explained that the Federal Decree-Law No. (8) of 2017 on VAT and its Executive Regulations have included specific provisions on what would constitute a supply of goods and a supply of services and also included a definition for taxable supplies. As such, where any transaction falls outside the scope of these provisions, it would, as a consequence, fall outside the scope of VAT.
The FTA also noted that although Article (42) of the Executive Regulations outlines the tax treatment of financial services, stating that the payment or collection of any amount of interest and dividend is considered to be a financial service and is therefore exempt from VAT, this would only apply where there is, in fact, a supply.
The Authority had issued the “VAT Public Clarification on Bank Interest and Dividends” as part of its Public Clarifications service, which are available on the FTA website and seek to educate taxpayers on all technical issues surrounding taxes, allowing them to implement the tax system efficiently.
In a press statement the Federal Tax Authority noted that if, for instance, a retail business deposits its income into a bank account and earns interest on the deposited amount, and the said retail business does not do anything to earn this income aside from merely depositing the money in the account, it can then be said that the interest was earned passively. In this case, the retail business is not considered to have made a supply to the bank, and the interest income received is not a consideration for a supply, which, in turn, means that the retail business is not required to declare this income on its VAT return, as it is outside the scope of VAT.
The Authority noted, however, that the above position only applies to interest derived from bank deposits and does not have any bearing on the interest generated from extending loans or credit, which are exempt supplies for VAT purposes.
Dividend income:
• The FTA explained that the payment of a dividend by a company is a distribution of its profits to its shareholders, where the holder of a share is not entitled to a dividend until the company has declared a dividend.
• Dividend income becomes due for shareholders in a company by the mere ownership of shares in that company and if the company makes any profits and declares dividends.
• The shareholder then receives the dividends and does not make any supply in order to be eligible for a payment of dividends, making the dividend a generally passive income.
• Accordingly, dividend income is outside the scope of VAT, and is therefore, not required to be reported on the VAT return. T
• he Authority noted, nonetheless, that while dividend income is generally outside the scope of VAT, any amount charged as a “management fee” would be subject to VAT. For example, management fees charged by a holding company to its subsidiaries would be subject to VAT.

The Public Clarifications service can be accessed through the Federal Tax Authority’s official website by clicking the “Help” button, then choosing the “Public Clarifications” tab, and selecting the required document. (https://www.tax.gov.ae/en/public-clarification.aspx)

Deregistration
The Federal Tax Authority (the “Authority”) explained that the Federal Decree-Law No. 8 of 2017 on Value Added Tax has defined the cases for tax de-registration. As such, when a registrant stops making taxable supplies or if the value of the taxable supplies made by the registrant over a period of 12 consecutive months is less than the voluntary registration threshold of AED 187,500 and it is not expected that the total value of the registrant’s anticipated taxable supplies or expenses subject to tax in the coming 30-day period will exceed the voluntary registration threshold, then the registrant must submit a de-registration application to the Authority within 20 business days of the occurrence of any of these cases using the Authority’s e-Services portal, knowing that failing to submit the de-registration application within the period specified in the tax legislation will lead to the imposition of administrative penalties as stipulated in the Cabinet Resolution No. 40 of 2017 on Administrative Penalties for Violations of Tax Laws in the UAE. This was the subject of a press release issued by the Authority to clarify the conditions and procedures for de-registration for Value Added Tax, after more than a year of its implementation. The Authority confirmed that registrants will not be de-registered unless they have paid all due taxes and administrative penalties and filed all required tax returns for the period in which they were registered as stipulated under the tax legislation.

The Authority went on to assert that the UAE Tax System is based entirely on voluntary compliance by Taxable Persons, whether it being with regards to registration, filing Tax Returns and payment of due tax or de-registration, noting that these services are available free of charge.
The Authority also mentioned that these procedures can be completed within few minutes through simple steps via the e-Services portal, available 24/7 on the Authority’s website (www.tax.gov.ae).

KSA
Reduction of the value-added tax (VAT) registration threshold to SR 375,000 from January 1, 2019, will increase the taxpayer base by about 150,000
The 2018 base was over 140,000 VAT-registered taxpayers.

Non-resident taxpayers are required to appoint a tax representative to act on their behalf and to assume joint liability for VAT debts. This requirement is posing some challenge to some non-resident taxpayers. Hopefully, progress in this area can be made soon.

VAT audits have commenced and assessments issued for contraventions of the regulations such as late registration and filing of VAT returns as well as incorrect declarations.
The global trend is towards tax authorities accessing taxpayer data directly and, in some territories, preparing the return for the taxpayer. Saudi taxpayers need to be prepared. Expect an increase in the level of scrutiny as GAZT continues to build its resources to challenge the VAT treatment of specific transactions.

Foreign Business VAT recovery
In a new guide on “VAT Refunds for Business Visitors”, published on its official website, the Federal Tax Authority (FTA) outlined four conditions that allow foreign businesses to recover Value Added Tax (VAT) incurred in the UAE To be eligible for the VAT refund.
1.The first condition is that foreign businesses must not have a place of establishment or fixed establishment in the UAE or in any of the VAT-Implementing GCC States that fully comply with the provisions of the Common VAT Agreement of the Cooperation Council for the Arab States of the Gulf.
2.Second, such foreign businesses must not be a Taxable Person in the UAE.
3.Third, they must also be registered as an establishment with a competent authority in the jurisdiction in which they are establishe
4. The fourth condition is that they must be from a country that implements VAT and that equally provides VAT refunds to UAE businesses in similar circumstances.

FTA Director General His Excellency Khalid Ali Al Bustani described the refund procedure as clear and transparent, noting that it supports economic activities in the areas in which the visiting business of the country participates, which is reflected positively on many sectors including tourism, trade, exhibitions, conferences, etc. He stated that the mechanism is in accordance with the Federal Decree-Law No. 8 of 2017 on Value Added Tax and the terms and conditions set in its Executive Regulations, which call for refunding taxes paid on supplies or imports made by a foreign entity not residing in the UAE or any of the Implementing States, subject to meeting certain conditions. He further explained that reciprocity is a key condition for the procedure, whereby the Authority will refund the VAT to businesses resident in countries that refund VAT for UAE businesses visiting their territories.

The Federal Tax Authority clarified that the period of each refund claim shall be a calendar year, noting that for claims in respect of the 2018 calendar year, refund applications can be made as of April 1, 2019. However, for subsequent calendar years, the opening date for accepting refund applications will be March 1st of the following year; this means that for the period from January 1 to December 31, 2019, applications will be accepted as of March 1, 2020.

The FTA went on to stress that the minimum claim amount of each VAT refund application submitted by business visitors is AED2,000, which may consist of a single purchase or multiple purchases. The Authority urged potential applicants to hold on to the original tax invoices on the purchases for which they would like to reclaim VAT, as they will be required to be submitted along with the refund applications.
Businesses residing in any GCC State that is not considered to be an Implementing

State may still submit a VAT refund application to reclaim VAT incurred in the UAE under this scheme, the FTA assured, outlining only 3 situations where VAT cannot be reclaimed,
1,The first situation is if the Foreign Business in question makes supplies in the UAE, unless the recipient is obliged to account for VAT under the Reverse Charge Mechanism.
2. Second, a VAT refund cannot be processed if the Input Tax in respect of any goods or services is “blocked” from recovery and, therefore, not recoverable by a Taxable Person in the UAE.
3. The third situation where a refund is not possible is if the Foreign Business is a non-resident tour operator.

The guide on “VAT Refunds for Business Visitors” can be accessed on the FTA’s official website via the link:
https://www.tax.gov.ae/pdf/VAT%20Refund%20User%20Guide-Business%20Visitors_EN.pdf (See Public Ax 2012 Finance Vat folder)
Independent Directors Services

Independent Directors’ services
The Federal Tax Authority (FTA) has confirmed that the date of supply for Value Added Tax (VAT) with regard to Independent Directors’ services is determined either in accordance with the general rules or the special rules, depending mainly on whether the fees for the said directors were known from the outset or not.
Where such fees are known from the outset, the date of supply shall be determined in accordance with the provisions of Articles (25) and (26) of Federal Decree-Law No. (8) of 2017 on VAT, depending on whether or not there will be periodic payments. If such fees are not known from the outset, they shall be determined upon conclusion of the Annual General Meeting and the date of supply shall be established only when such fees become known.
The date of supply prescribes the point in time when a VAT Registrant needs to account for VAT, the Authority explained in the Public Clarification on the Date of Supply for Independent Directors. This is part of the “Public Clarifications” service available on the FTA’s website to introduce taxpayers to all aspects of the tax system and facilitate compliance. The service can be accessed via the link: https://www.tax.gov.ae/public-clarification.aspx
The FTA explained that in instances where the Board Fees are known at the outset and involve periodic or multiple payments, the date of supply would be determined as per Article (26) of Federal Decree-Law No. (8) of 2017 on VAT, where the date of supply would be the earliest of the following three: The date of issuance of the tax invoice; the date the payment is due as shown on the tax invoice; and the date of receipt of payment. If 12 months have passed from the date of provision of services and none of the aforesaid events has occurred, the date of supply will be triggered at the end of the 12th month.
As for the instances where Board Fees are known at the outset but there are no periodic or multiple payments, the date of supply would be determined as per Article (25) of the Federal Decree-Law No. (8) of 2017 on VAT. Accordingly, the date of supply would be the earliest of the following three: The date of issuance of a tax invoice; the date on which the provision of services was completed; and the date of receipt of payment.

Profit Margin Scheme
The UAE Federal Tax Authority (FTA) asserted that only those goods which have previously been subject to VAT before the supply in question may be subject to the profit margin scheme. As a result, stock on hand of used goods which were acquired prior to the effective date of Federal Decree-Law No. (8) on Value Added Tax (“VAT law”), or which have not previously been subject to VAT for other reasons, are not eligible to be sold under the profit margin scheme. VAT is therefore due on the full selling price of such goods.

The taxable person will not be allowed to apply the profit margin scheme in such cases where he has issued a tax invoice or any other document mentioning an amount of VAT chargeable in respect of the supply.
• The profit margin is the difference between the purchase price of the Goods and the selling price of the Goods,
• The profit margin shall be deemed to be inclusive of Tax
• A VAT registered business may apply the profit margin scheme to eligible goods when:
o the goods must have been purchased from either a person who is not registered for VAT;
o or a taxable person who calculated VAT on the supply by reference to the profit margin i.e. a VAT registered business, which already applied the profit margin scheme on the same goods.
o In addition, the profit margin scheme may also apply when the taxable person made a supply of the goods where input tax was not recovered in accordance with Article 53 of Cabinet Decision No. 52 of 2017.
Suppliers should be confident that a good has previously been subject to tax in order to apply the profit margin scheme. Such evidence or information of this position could include but is not limited to.:
o information relating to the date the good was first manufactured, sold or brought in to use
o e.g. in the case of a car, the date the car was first registered would indicate its sale would have been subject to VAT if it was registered on a date after 1 January 2018;
o Evidence that the supplier paid VAT on their original purchase e.g. by asking the supplier for a copy of the tax invoice relating to their purchase of the good.
Where a Taxable Person has charged Tax in respect of a supply with reference to the profit margin, the Taxable Person shall issue a Tax Invoice that clearly states that the Tax was charged with reference to the profit margin, in addition to all other information required to be stated in a Tax Invoice except the amount of Tax.

Transportation

As per the Clause (4), Article (45) of the Federal Decree-Law No. 8 of 2017 on Value Added Tax and as per Article (34) of Cabinet Decision No. 52 of 2017 on the Executive Regulations (“VAT Executive Regulations”): The supply of the means of transport shall be subject to the zero rate in the case of, a supply of bus or train that is designed or adapted to be used for public transportation of (10) or more passengers.

One such qualifying means of transport includes the supply of a bus or train that is designed or adapted to be used for public transportation of 10 or more passengers. This Public Clarification discusses the definition of ‘public transportation’ and its interpretation for the purposes of identifying those buses or trains which qualify to be supplied at the zero rate under this provision.As a result, those means of transport which are designed to transport a specific category of individuals, such as school students or employees of a business, do not meet the conditions to be treated as a qualifying means of transport for the purposes of the zero-rating provisions. Such means of transport shall therefore be subject to the standard rate of VAT.
This denotes that, any supplies of means of transport (e.g. supply of buses) made for the use of schools or business are subject to 5% tax at the time of its purchase.
It has also been clarified by the FTA that, whether or not the original supply of the means of transport qualified for zero rating has no impact on the VAT liability of any charges made for the supply of transportation services. The VAT treatment of the means of transport when purchased does not determine the VAT treatment of any supply of transport services made using that vehicle. Providing services to business for transporting its employees from one place to another still remains exempt under law. Therefore, where local transport is made for a charge to a defined group of people, any VAT incurred on the costs of purchasing the means of transport, fuel etc. in order to provide that service is not recoverable.

Difference between private transportation & public transportation in the VAT Law:
What is Private Transportation?

FTA defines ‘Private Transportation’ as ‘all means of transportation used to transport a specific group of people under contracts.’
What is Public Transportation?
The transport used for ‘public transportation’ shall be interpreted by the FTA as, ‘all means of mass transportation used to transport all individuals without specifying any category.’
The difference between the two forms of transportation therefore means that public transportation should be available for all individuals without exception. Public transportation would not include transportation which is only available to a specific category of user.
To summarize, if a bus or train is designed or adapted for a specific class or group of people, or is only available for use by a specific class or group of people, then it shall be considered to be designed or adapted for use for private transportation. And thus, the supply of such means of transport will be taxable.
Factors relevant to identify Public Transportation:
In order to determine whether a bus or train is designed or adapted for use for public transportation, the following factors would be relevant:
1. Features exist which allow passengers to pay for the transportation or to indicate they possess a ticket e.g. a payment booth, ticket scanner or device to take payment;
2. There is branding either within or outside the vehicle advertising the transport service, indicating the transportation is available to all;
3. There is branding or other features indicating regulation of the means of transport by the entity regulating public transportation in the Emirate of operation;
4. The intended use of the means of transport is to transport members of the public without exception or limitation to a specific group.
By considering above points, the following means of transports are not be considered to be used for public transportation:
1. School buses;
2. Buses used to transport groups of employees or workers to or from a place of work;
3. Shuttle buses used to transport hotel guests to other locations e.g. a mall, airport, park, or other tourist attraction.
Hence the and the supply of such means of transports shall be subject to VAT at the standard rate.
VAT Liability of Transportation Services:
To add on, services related to transportation shall be governed by Clause 4 of Article 46 of the VAT Law and Article 45 of the Executive Regulations which state that any supply of local passenger transport shall be exempt from VAT where the supply is of local passenger transport services in a qualifying means of transport by land, water or air from a place in the UAE to another place in the UAE.
For the purposes of the exemption from tax, one of the qualifying means of transport listed includes a motor vehicle, including a taxi, bus, railway train, tram, mono-rail or similar means of transport, designed or adapted for transport of passengers.

Emirati Nationals – Home owners
The Federal Tax Authority issued a guide Apr2018 with details for home owners on how to claim the refund.
Emirati house owners have the right to a five per cent value added tax (VAT) refund when constructing their homes, the Federal Tax Authority (FTA) has stated. The Authority has issued a guide with details for home owners on how to claim the refund. It clarifies that only UAE citizens have the right to ask for the refund. They need no new account on the Authority’s website, and only need to download and fill a form and submit it back so the Authority
t UAE nationals can claim the VAT refund against the construction expenses for a residential building, when they construct it either for themselves or for their family members.
UAE nationals can claim the refund against a newly constructed building to be used solely as residence, under Article (66) of Cabinet Decision No. (52) of 2017 on the Executive Regulations, of the Federal Decree-Law No (8) of 2017 on Value Added Tax,”.
The VAT refund is not allowed in relation to a building that will not be used solely as a residence by the person or the person’s family. For example, it is not to be used as a hotel, guest house, hospital, or if the property is to be used for rental purposes or for any other purpose not consistent with it being used as a residence,
According to the guide issued by the FTA, an Emirati owner has the right to ask for the VAT refund if he bought a piece of land and allowed an authorised person or company to establish a housing unit on it. The guide says that the VAT refund only includes the money spent on establishing the unit, adding that it includes the amounts paid as building materials, except for electricity products of furniture or green areas.
On the other hand, the refund also includes VAT paid for doors, fire alarms systems, floors, kitchens, health units, bathrooms, windows, and electricity cables. A third entity is going to review the housing units to approve the refund and its amount after the Emirati owner submits the form. Moreover, the owner needs documents that prove his ownership for the unit, show the date of issuing the certification of establishment, prove the ownership of the land and show the value of VAT paid during the process.
It should be noted that the VAT refund will be claimed after completion of the new building which is ready to use. The owner must file a VAT refund application after getting registration with the FTA within six months from the date of completion of the newly built residence. Processing can take up to 20 days.
A newly built residence is considered complete at the date the residence becomes occupied, or the date when it is certified as completed by a competent authority in the state, or as may otherwise be stipulated by the Authority.
Also where the Authority has repaid tax and following the receipt of such repayment, if the person used the building for rental or any other commercial purpose, then he will be required to repay the amount of the tax that was claimed by him. The UAE national can claim VAT against construction related expenses excluding furniture or electrical appliances.

Grants and Sponsorships
The VAT treatment of donations, grants and sponsorships depends on whether the donor, grantor or sponsor, as the case may be, received any benefit in return for such payments.
o Where any benefit is received in return for the payments, VAT implications will arise.
o However, where no benefit is received, the payments will be treated as outside the scope of VAT as they will not be seen as consideration for a supply.
The VATP011 clarification states where donation and grants do not have any supply, they are considered as out of scope.
Generally, sponsorship will be subject to VAT as there is usually associated supply to such sponsorship.

Pre Vat Orders and post Vat supply
As per the FTA’s statement, the only case where consumers are directly responsible for paying VAT on services are those that were delivered fully or partially after VAT went into effect from January 1 and it was contractually/ stated that the amount due is exclusive of tax.
According to the FTA’s statement, suppliers will be liable for VAT in two cases:
o if the contract states that the amount received against the good or service is inclusive of VAT;
o or if the contract issued to the consumer did not refer to VAT.
In the latter case, when the goods or services recipient is registered for tax, the amount due is treated as exclusive of tax. So the supplier has to ascertain whether the recipient is registered, and the recipient ability to recover tax as per Article 70 of the VAT Executive Regulations.
The authority stressed that in all cases, the supplier remains liable for accounting for the tax and paying it to the FTA.

Bahrain and Utility Bills
A Bahraini lawyer has insisted that the recent decision by the Electricity and Water Authority (EWA) to apply Value Added Tax (VAT) on subscribers’ bills are unconstitutional, demanding immediate cancellation of the decision. This came as lawyer Mohammed Al Thawadi appeared before the High Administrative Court, which is examining a complaint lodged by him against the authority. The court said that it would issue its final verdict in the case on February 24.
In his statements, the lawyer asserted that the decision is unconstitutional, claiming that Articles 15 and 17 of the Constitution of the Kingdom stipulate that taxes should only be imposed through legislation. Mr. Al Thawadi also accused EWA of not adhering to the Unified GCCVAT Agreement.
“Article 29 did not stipulate the imposition of taxes on electricity supply services, but on the contrary, it gave each state the right to exempt some sectors in accordance with local law. “Additionally, Article 30 stipulates the exemption of government bodies from paying taxes, and therefore it is not permissible for the authority to collect taxes.” The lawyer’s last statement came after the authority denied the accusations during the previous hearing.
“The authority does not exercise its functions as sovereign and there is no monopoly of providing electricity and water supply services in the Kingdom,” the authority’s counsel had told the court. Further supporting his accusations against the authority, Mr. Al Thawadi said: “The authority’s claim that it does not operate in a sovereign manner and that there is nothing preventing competition with it from any other party in providing its services is incorrect.

Sunsystems v 6.3 – time to upgrade.

January 14th, 2019

Infor SunSystems® delivers integrated financial, purchasing, inventory, and sales management paired with social business, analytics, and in-context business intelligence. For those on legacy versions such as v5 or even 6.1 or 6.2 there many reasons to upgrade this year to version 6.3. here are just a few:

1.ENHANCED SUNSYSTEMS CORE FEATURES
Give users a familiar, easy-to-use environment. Infor SunSystems helps you to increase productivity and to reduce training time. Employees can easily find information relevant to their jobs, and even delivers that data to them automatically.
2.MODERN USER INTERFACE
Create real-time queries and drill back to the source transaction to take immediate action. The addition of the Infor Ming.le™ social feed helps you get clear, supporting insight and links to additional information at the point of decision.
3.ROBUST BUSINESS INTELLIGENCE
SunSystems has web dashboards and a self-service front-end that allow any business user to conduct sophisticated analytics.
Centralization of data is improved, and integration to your business applications is more seamless so that you can get business insights through a variety of channels.
4.INFOR ION INTEGRATION
This version of SunSystems has expanded Infor ION® integration capabilities, which provides easy integration with a range of Infor solutions for risk management, human capital management, travel expense control, asset management, and more. You get cross-application workflows and event management, and deeper insight across application process flows, as well as proactive, preemptive control.

SunSystems in 2018 became part of the Infor OS. This brings several advantages to the product. It will become integrated with other Infor solutions. There are plans to integrate Infor Birst, HCM, HMS (Hospitality Management) and CRM from 2019. The integration of Birst may see some customers adopt the powerful BI tool and rethink their reliance on spreadsheets.

Sql 2014 Sp2 Update 15

December 15th, 2018

The 15th cumulative update release for SQL Server 2014 SP2 is available for download at the Microsoft Downloads site.
Registration is no longer required to download Cumulative updates.

CU15 KB Article: https://support.microsoft.com/en-us/help/4469137

Microsoft® SQL Server® 2014 SP2 Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=53592

Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx

RPA certifications for Synergy Software Systems, Dubai

November 25th, 2018

I am pleased to announce that following extensive training over recent weeks two of our consultants have already achieved certifications.

If you have an ROA project in mind and need support for your project from a proven, local. UAE partner then please call Synergy Software Systems on 0097143365589

Making Tax Digital (MTD)

November 19th, 2018

If you have U.K operations then be aware of Making Tax Digital (MTD), a transformational approach to taxation in the UK from HMRC. The first change is coming in 2019 and will affect every organisation from processes to how systems are set up to record and report tax.

This will affect all companies with U.K, financial operations and all financial software. From April 2019, businesses that are registered for VAT and have turnover above the VAT registration threshold of £85,000 will be required to keep digital records for VAT purposes and submit their quarterly VAT return updates to HMRC through functional compatible software

The new VAT record keeping rules requires that all applicable VAT return data is digitally linked so that transactions can be traced from source data (i.e. purchase/sales ledger) to VAT return completion and upload.

Key benefits for businesses include improved visibility over their tax situation and easier access to tax information online; enabling businesses to plan and budget more effectively, driving performance and growth

With Making Tax Digital, the new regulation from HMRC going live from 1 April 2019, it’s time to start preparing. This is similar to the legislation already implemented in the U.A.E. which we have done for both infor SunSystems, and Dynamics 365/Dynamics Ax.

Which versions of Dynamics AX will Microsoft be ‘Making Tax Digital’ compliant?

Any Dynamics product that is still under mainstream support will get an update from Microsoft to ensure full compliance. This means for Dynamics AX only Dynamics AX 2012 R3 will be automatically updated. Microsoft have not confirmed when this update will take place – there are still some further details to come from HMRC.

Receiving the Microsoft update may not be enough to guarantee full compliance – there will likely need to be a number of small updates such as capturing the right fields and updating commercial forms, and reporting format that will need to be confirmed.

In addition, by April 2020 you will need to ensure all of your processes are fully digital.

IFRS 9

November 7th, 2018

The Standard includes requirements for recognition and measurement, impairment, de-recognition and general hedge accounting. This standard has replaced IAS 39 and responds to the criticisms that IAS 39 was too complex,
inconsistent with the way entities manage their businesses and risks, and defer the recognition of credit losses on loans and receivables until too late in the credit cycle.

The new standard is based on the concept that financial assets should
be classified and measured at fair value, with changes in fair value recognized
in profit and loss as they arise (“FVPL”). That is unless restrictive criteria are met for classifying and measuring the asset at either Amortized Cost or Fair Value Through Other Comprehensive Income (“FVOCI”) subject to a special
FVOCI designation option for investments in equity instruments, only
loans, receivables, investments in debt instruments and other similar
assets ( “loans and receivables”), can qualify for measurement at Amortized Cost or FVOCI. The key questions are whether:
• The objective of the entity’s business model is to hold assets only to collect
cash flows, or to collect cash flows and to sell (“the Business Model test”),
and
• The contractual cash flows of an asset give rise to payments on specified
dates that are solely payments of principal and interest (“SPPI”) on the
principal amount outstanding (“the SPPI test”).

Both of these tests determine whether to account for an instrument at
Amortized Cost or FVOCI

IFRS 9 specifies how an entity should classify and measure financial assets, financial liabilities, and some contracts to buy or sell non-financial items. IFRS 9 , deals separately with the classification and measurement of financial assets, impairment and hedging.

IFRS 9 requires an entity to recognise a financial asset or a financial liability in its statement of financial position when it becomes party to the contractual provisions of the instrument. At initial recognition, an entity measures a financial asset or a financial liability at its fair value plus or minus, in the case of a financial asset or a financial liability not at fair value through profit or loss, transaction costs that are directly attributable to the acquisition or issue of the financial asset or the financial liability.

So why does it matter if you are not in the Financial services sector?
Any entity with long-term loans, equity investments, or any non-standard financial assets, or only holding short-term receivables may find that it requires
significant changes to its financial reporting as the result of this standard.

Possible consequences of IFRS 9:
Income statement volatility. More assets will
have to be measured at fair value with changes in fair value recognized in
profit and loss as they arise.

Earlier recognition of impairment losses on receivables and loans,e.g. trade receivables. Entities will have to provide for possible
future credit losses in the first reporting period that a loan goes on the books
– even when it is highly likely that the asset will be fully collectible.

New disclosure requirements—the more significantly impacted may even need new systems and processes to collect the necessary data.

IFRS 9 is an opportunity for balance sheet optimization, enhanced efficiency of
the reporting process and cost savings.

Before your year end audit consider the possible impact on financial statements, systems, processes, controls.

Financial assets

When an entity first recognises a financial asset, it classifies it based on the entity’s business model for managing the asset and the asset’s contractual cash flow characteristics, as follows:

Amortised cost—a financial asset is measured at amortised cost when both of the following conditions are met:
◦ the asset is held within a business model whose objective is to hold assets in order to collect contractual cash flows; and
◦ the contractual terms of the financial asset give rise on specified dates to cash flows that are solely payments of principal and interest on the principal amount outstanding.

Fair value through other comprehensive income—financial assets are classified and measured at fair value through other comprehensive income when these are held in a business model whose objective is achieved by both collecting contractual cash flows and selling financial assets.

Fair value through profit or loss—any financial assets that are not held in one of the two business models mentioned are measured at fair value through profit or loss.

When, and only when, an entity changes its business model for managing financial assets it must reclassify all affected financial assets.
Financial liabilities

All financial liabilities are measured at amortised cost, except for financial liabilities at fair value through profit or loss. Such liabilities include derivatives (other than derivatives that are financial guarantee contracts or are designated and effective hedging instruments), other liabilities held for trading, and liabilities that an entity designates to be measured at fair value through profit or loss (see ‘fair value option’ below).

After initial recognition, an entity cannot reclassify any financial liability.

Fair value option

An entity may, at initial recognition, irrevocably designate a financial asset or liability that would otherwise have to be measured at amortised cost or fair value through other comprehensive income to be measured at fair value through profit or loss when doing so will either eliminate, or significantly reduce a measurement or recognition inconsistency (sometimes referred to as an ‘accounting mismatch’) or will otherwise result in more relevant information.

Impairment

Impairment of financial assets is recognised in stages:

Stage 1—as soon as a financial instrument is originated or purchased, 12-month expected credit losses are recognised in profit or loss and a loss allowance is established. This serves as a proxy for the initial expectations of credit losses. For financial assets, interest revenue is calculated on the gross carrying amount (ie without deduction for expected credit losses).

Stage 2—when the credit risk increases significantly and is not considered low, full lifetime expected credit losses are recognised in profit or loss. The calculation of interest revenue is the same as for Stage 1.

Stage 3—when the credit risk of a financial asset increases to the point that it is considered credit-impaired, interest revenue is calculated based on the amortised cost (ie the gross carrying amount less the loss allowance). Financial assets in this stage will generally be assessed individually. Lifetime expected credit losses are recognised on these financial assets.

Hedge accounting

The objective of hedge accounting is to represent, in the financial statements, the effect of an entity’s risk management activities that use financial instruments to manage exposures arising from particular risks that could affect profit or loss or other comprehensive income.

Hedge accounting is optional. An entity applying hedge accounting designates a hedging relationship between a hedging instrument and a hedged item. For hedging relationships that meet the qualifying criteria in IFRS 9, an entity accounts for the gain or loss on the hedging instrument and the hedged item in accordance with the special hedge accounting provisions of IFRS 9.

IFRS 9 identifies three types of hedging relationships and prescribes special accounting provisions for each:

fair value hedge: a hedge of the exposure to changes in fair value of a recognised asset or liability or an unrecognised firm commitment, or a component of any such item, that is attributable to a particular risk and could affect profit or loss.

cash flow hedge: a hedge of the exposure to variability in cash flows that is attributable to a particular risk associated with all, or a component of, a recognised asset or liability (such as all or some future interest payments on variable-rate debt) or a highly probable forecast transaction, and could affect profit or loss.

hedge of a net investment in a foreign operation as defined in IAS 21.

When an entity first applies IFRS 9, it may choose to continue to apply the hedge accounting requirements of IAS 39, instead of the requirements in IFRS 9, to all of its hedging relationships.

IFRS 9 is effective for annual periods beginning on or after 1 January 2018.

SQL 2014 SP3 now released

November 1st, 2018

Fixes include:

• Less TempDB contention
• Improved memory grant diagnostics using Extended Events
• Trace flags show up in query plans
• Wait stats, CPU time, elapsed time show up in query plans
• Query_hash and query_plan_hash data types now match between XE and DMVs
• Scalar UDF stats show up in query plans
• Row goals show up in…oh, you get the point
• Unified showplan schema for all supported versions
• MAXDOP hint for creating and updating statistics
• Faster restores on disks with 4K sectors