Archive for the ‘Infor Financial solutions’ category

Oman launches tax card from July 1

June 29th, 2020

The Oman Tax Authority will launch a new tax card system from July 1, which will be the proof of the registration for any taxpayer from the tax Authority. The card will be issued for RO 10.

All ministries, public authorities and institutions, and companies, which has more than 40 percent holding by the state must request the taxpayer to submit a copy of the tax card when issuing any contracts, or directly undertaking any transaction with the taxpayer. The chairman of the Oman Tax Authority may impose a fine in the event of failure to obtain the tax card.

Every taxpayer must apply to obtain the tax card when initiating the incorporation or licensing procedures for practicing the activity or registration in the commercial or Industrial registry and shall request for renewal upon the end of the validity of the card.

The Tax card will replace the tax certificate currently in use at the Authority that is required by some government authorities, except in cases where the tax certificate Is requested for the purposes of canceling a commercial registry. dissolution, merging. or liquidation of any company.

KSA to add VAT on on-line purchases

June 29th, 2020

Saudi Arabia announced it will levy 15 percent value added tax (VAT) on items bought from online sellers and online stores based abroad. The Saudi customs authority said on Sunday (June 28) the new rule will be applicable to all products shipped to the kingdom on or after July 1. Saudi Arabia is tripling its VAT from 5 percent to 15 percent starting on July 1. It will also suspend the cost of living allowance to its citizens on July 1.

The online order placed before June 30, 2020 is delivered to the buyer after June 30, then 15 per cent VAT will apply on the selling transaction, whereas the seller should issue an additional tax invoice pertaining to the difference of the applicable tax due. E-commerce companies should ensure to collect additional 10 per cent from the buyer if the products will be delivered to the buyer on or after July 1, 2020 because they have to pay 15 per cent VAT at the time of custom clearance of the goods.

With the implementation of VAT on online selling, e-commerce companies are expected to collect additional fees from buyers if products are delivered to Saudi Arabia.

The kingdom will also suspend cost of living allowance from next month in order to shore up state finances, which have been battered by low oil prices and the coronavirus. The revised higher VAT rates will be applicable to all supplies of taxable goods and services in the country.

KSA Higher Customs Duty June 2020

June 29th, 2020

The Kingdom of Saudi Arabia (KSA) has published the new list of goods on which higher customs duty rates which are effective from 20 June 2020.

Earlier the Customs duty increased was supposed to be effective from 10 June 2020.

Further, in view of the VAT rate increase to be effective 1st July 2020, it is recommended for the businesses operating in KSA to do an impact assessment to identify the impact of VAT and Customs duty increase on their business.

KSA VAT changes 1 July 2020

June 29th, 2020

The Government of the Kingdom of Saudi Arabia (KSA)announced that the Value Added Tax (VAT) rate will increase to 15% from the current 5%, effective 1 July 2020.The increase is one theof additional measures taken by the KSA government in response to the economic impact of the COVID-19 crisis, due to the decline in government revenue resulting from lower oil prices, reduced economic activity and increased healthcare expenditure.

How could this impact your business?
In addition to the increased VAT rate, businesses in KSA should expect an increased level of scrutiny from the General Authority of Zakat and Tax (GAZT), as VAT becomes a more important source of revenue.

Businesses whose sales are partially or fully VAT exempt, will experience an increase in costs as a direct effect of the rate increase. Nevertheless, the rate increase will impact all industry sectors in KSA and not primarily the Financial Services, Insurance and Real Estate sectors. All consumers will finally bear the brunt of the increases and it is not clear whether a lower rate of VAT, may still continue to apply to such items as food and utilities, to mitigate the impact.

We advise to review existing contracts that provide for continuous or periodic supplies of goods/services, and consider the required documentation changes that should be effected before 1 July 2020. Be clear on the correct rate of VAT to charge on contracts and supplies that span both June and July 2020. As o the 2018 introduction of VAT shows, transitional rules can be difficult to implement.

The rate increase will also impact cash-flow for businesses due to the timing difference between the payment and recovery of VAT, so cash flow planning will take on renewed significance.

Review the internal systems and processes to reflect the increased VAT rate. What systems and report need update and testing when.

We remind taxpayers that the window for voluntary disclosures without incurring penalties remains open only until tomorrow 30 June 2020, he rate increase heightens the importance for businesses to ensure they are fully compliant from a VAT perspective.

Economic Substance Regulation (ESR) in the U.A.E. ask Synergy Software Systems

June 16th, 2020

Existing companies should have complied with the regulations by now, since the starting date was 30th April 2019.

(If an entity fails to meet the requirements or if inaccurate information is given to the regulatory authority, annual administrative penalties of AED 10,000 to AED 300,000 will apply. If they fail to meet the requirements for consecutive years, the penalties will increase and might force the authorities to suspend, revoke or deny renewal of an entity’s license.)

(In the case of new entities, regulations must be complied with upon receiving its trade license.)

This legislation (collectively, referred to as the “Economic Substance Regulations“) were issued in response to the UAE’s inclusion in the European Union’s list of non-cooperative jurisdictions for tax purposes, and their aim is to facilitate tax transparency and fair tax competition in the UAE’ The Economic Substance Regulations apply to natural or juridical (legal) persons, including all UAE onshore and free zone companies, branches, foundations, non-profit organisations and partnerships (referred to as “Licensees“) that carry out one or more of the following “Relevant Activities” in the UAE -see below for the details. With the introduction of ESR, UAE has been removed from the blacklist of tax havens.

BEPS [Base Erosion Profit Shifting)] Base Erosion Profit Shifting directives are regulations issued by the Organization for Economic Cooperation and Development [OECD] to combat corporate policies for Tax Planning which would shift the profits of companies from low tax rate jurisdictions to high tax jurisdictions. Thus “eroding” the tax base in high tax jurisdictions.

The appropriate regulatory authority varies depending on the type of Relevant Activity and the location in which it is undertaken. Each regulatory authority will set out the form of the reports to be filed and the mechanisms for submitting such forms.

What is the economic substance test?
The economic substance test requires a Licensee to demonstrate that:
• the Licensee and the Relevant Activity are being directed and managed in the UAE;
• the relevant Core Income Generating Activities (“CIGAs“) are being conducted in the UAE; and
• the Licensee has an adequate number of employees and adequate physical assets and expenditure in the UAE.

Licensees carrying out a holding company business or a high risk IP business are subject to different economic substance test requirements.

See: https://www.mof.gov.ae/en/StrategicPartnerships/Pages/ESR.aspx for some useful documents including a flow chart.

The Regulations require UAE onshore and free zone companies and other UAE business forms that carry out any of the “Relevant Activities” listed below to maintain an adequate “economic presence” in the UAE relative to the activities they undertake.

Relevant Activities:
• Banking Business
• Insurance Business
• Investment Fund management Business
• Lease – Finance Business
• Headquarters Business
• Shipping Business
• Holding Company Business
• Intellectual property Business (“IP”)
• Distribution and Service Centre Business

The Regulations provide a definition to each of the above Activities. The provisions of the Regulations shall not apply to Companies in which the Federal Government of the UAE or the Government of any Emirate of the UAE, or any governmental authority or body or any of them has at least 51% direct or indirect ownership in their share capital.

Entities that are governed by the Regulations will need to submit a notification to their Regulatory Authority (defined under Cabinet Decision No (58) of 2019 issued on 4 September 2019) from 1 January 2020 onwards, and prepare and submit to the same Regulatory Authority an economic substance declaration within 12 months from the end of their financial year (e.g. 31 December 2020 for entities with a financial year ending 31 December 2019).

An entity is not required to meet the economic substance test and file an economic substance declaration for any financial period in which it has not earned income from a Relevant Activity. Failure by an entity to comply with the Regulations shall result in administrative penalties, spontaneous exchange of information with the Foreign Competent Authority (as defined in Article 1 of the Regulations), and potential suspension, revocation or non-renewal of its registration.

In the DIFC, the ESR will be administered by the Registrar of Companies (“Registrar”) for all DIFC entities, including entities that are regulated by the DFSA. Key points to note about ESR and how to prepare your business for it :
1. All DIFC entities are required to submit an economic substance notification by 30 June 2020 in the DIFC Client Portal
2. The UAE Ministry of Finance has issued a Relevant Activities Guide which should assist you in determining whether your business conducts a relevant activity and falls within the scope of the ESR.
3. Your business may also be required to file an economic substance return (“ES Return”), within 12 months of your financial year end, to demonstrate that your business meets the ESR requirements. Information relating to the ES Return will be issued in the second half of 2020.

There is a requirement for a business to use the “Substance over Form” approach when evaluating whether they undertake a relevant activity or not. This means that companies will not only be evaluated on what activities are stated on their commercial license but their activities will be evaluated and ESR applied accordingly.

It is not a requirement that a UAE entity is directly engaged in the performance of a relevant activity directly. When an entity is earning income passively from a relevant activity, it will be sufficient for the application of Economic Substance Regulations [ESR].All Entities which assess that they are involved in the performance of a Relevant Activity will carry out the Economic Substance Test for Economic Substance Regulations [ESR].

The Economic Substance is composed of two parts:
1. The Direct and Managed Test:
The Entity needs to be directed and managed in the UAE with regards to the relevant activity carried out in the Emirates.

2. The Core Income Generated Activities Test [CIGA]:
1. The Entity that performs the relevant activities for the purpose of application of Economic Substance Regulations [ESR], need to demonstrate that the CIGA’s are undertaken in the UAE.The activity which constitutes as a CIGA varies with the activity being performed.

The Entities which exist in the United Arab Emirates and carry out relevant activities within its jurisdiction need to follow certainly and comply with certain reporting requirements. The entities will be required to submit an annual notice to their Regulatory Authority indicating that they are carrying out a Relevant Activity in the preceding Financial Year and whether there has been any Income from the Relevant activity that has been subject to Taxation outside the United Arab Emirates.

UAE entities that qualify for an exemption from the Economic Substance Regulations, or those that did not earn any income from their Relevant Activities will still be required to file a notification with the Relevant Authority.

UAE Entities which qualify for submission of notification, and those that earned any income from the same, will also be required to file an Annual Economic Substance Return. The purpose of the Return is to make an assessment of the requirements of economic substance regulations are met, the income earned, qualifications of the staff involved, and information about the premises and other assets used in carrying out the relevant activity.

What are the Penalties for Non-Compliance of [ESR]?
In addition to an exchange of information by the UAE with countries which are a member of Organization for Economic Cooperation and Development [OECD] to remove the possibility of Base Erosion and Profit Shifting, failure to comply will cause the levy of administrative penalties not less than 10,000 AED and not more than 50,000 AED for failure to comply for the first year. In case of failure to comply with ESR, the minimum amount of penalty will be increased to 50,000 AED and the maximum amount to 300,000 AED. In addition to this, additional penalties, such as suspending, revocation of UAE Trade License may also be levied.

Synergy Support during covid-19 lockdown

April 6th, 2020

As a precautionary measure instructed by our Government for COVID-19 to be Safe at Home to protect our staff and to protect the community Synergy, consultants are instructed to work from home for at east the next two weeks.

To help us to provide continuous support please follow these guidelines to ensure our queries are recorded and assigned to be addressed in addressed as soon as possible.:

1. Send an email with a clear description in the email Subject line”, which will be helpful to track the email chain.
2. Please mention any internal issue/ticket number assigned, the user, and as much detail as possible e.g. transaction detail such as: order number, vendor code, item code – take a screenshot – copy any error message and attach those details to the email. Better still record the steps e.g. with e.g. webex, or task recorder.
3. If you are not on your work telephone number, or email, e,g when working from home yourself, then ensure you provide contact information for us to reach you.
4. To understand the issue, we may need to connect to the user PC through a screen sharing app such as Microsoft TEAMS, or Go To Meeting. Please ask your admin take appropriate action to ensure we can dial in remotely to your systems if needed, Even when located elsewhere they will also able to join such sessions.
5. Every request is given a ticket number and is then assigned to a consultant. For follow up communication please mention the ticket number. That will make it easier for us to find and review the details and actions to date. It’s possible that more than one consultant may be involved and they will be working remote from each other. This will save time for everyone .
6. Once the support request/ issue is resolved, upon receipt of confirmation email, the request will be closed.
7. When needed to discuss pending issues we will also be available to have a conference call via Microsoft Teams. issues @ mutual agreed time.
6. All support request to be sent to Axapta.support@synergy-software.com and we suggest copy in the lead consultant and account manager with whom you normally deal’
7. Please circulate this information to respective users and department heads, so that everyone working from home is aware that we are still available to support you as best we can and that they know how to help us, to help them.

Be prepared for Potential Iranian Cyberattacks

January 10th, 2020

The drone attack as Suleimani was visiting Baghdad last week is widely expected to prompt counterattacks of some sort from Iran, with Iranian leaders vowing as much in recent days. One of the most rapid ways that Iran can respond is through attacks on computer systems of U.S. businesses and government agencies

The U.S. agency in charge of cybersecurity urges organizations in the United States to prepare for potential attacks from Iran in response to the American drone killing of General Qassim Suleimani.

The Cybersecurity and Infrastructure Security Agency (CISA) issued its warning, “Potential for Iranian Cyber Response to U.S. Military Strike in Baghdad,” on Monday afternoon. CISA is a federal agency created in 2018 to coordinate with other government entities and the private sector on cybersecurity and critical infrastructure protection.

The drone attack as Suleimani was visiting Baghdad last week is widely expected to prompt counterattacks of some sort from Iran, with Iranian leaders vowing as much in recent days. One of the most rapid ways that Iran can respond is through attacks on computer systems of U.S. businesses and government agencies. However, proxy attack on perceived USA allies, or major USA technology firms also have to be considered.

A key feature in your defence is the way your anti malware software handles unknown files. All Ransomware/Malware starts as an unknown file. Older protection software uses a detect and remediate approach to stop it. Basically, a default ‘allow’ policy, because they let unknown files come into their system and then try to stop the effect. This is a problem because hackers make new malicious codes every single day, and rely on signature based detection methods.

We offer a solution with a default ‘Deny’ approach. Our auto-containment features is a patented and the one-and-only technology that renders malware useless and to date the Platform and Auto Containment.
has 0 breaches.

With growing and ever more sophisticated and expensive attacks, and increasingly stringent legislation such as GDPR with swinging data breach penalties, the risks of international war by cybercrime have gone up another notch.

If you need to boost your defences then contact us on 0097143365589

Windows Server 2008 and 2008 R2 support will end January 14, 2020- ask Synergy Software Systems about options.

November 16th, 2019

On January 14, 2020, support for Windows Server 2008 and 2008 R2 will end. Only 2 months away
That means the end of regular security updates.

Don’t let your infrastructure and applications go unprotected.

We’re here to help you migrate to current versions for greater security, performance and innovation.
009714 3365589

Azure Arc in preview manage hybrid data across cloud platforms……

November 16th, 2019

Now in preview, Azure Arc helps simplify enterprise distributed environments by managing everything via Azure services (like Azure Resource Manager). Connecting hybrid infrastructure via Azure Arc improves security for users via automated patching, and provides improved governance, with everything ‘under one roof’. Azure Arc, a tool that lets organizations manage their data on: the Microsoft Azure cloud, Amazon Web Services (AWS), Google Cloud Platform or any combination.

Microsoft says that deployments can be set up “in seconds” via Azure data services anywhere, a feature of Azure Arc.

Azure Arc also supports Kubernetes clusters and edge infrastructures, as well as on-premises Windows and Linux servers.
No final release date yet but there is a free preview of Azure Arc .


Enhanced HA and DR benefits for SQL Server Sofware Assurance from 1 November.

November 5th, 2019

The enhanced benefits to SQL licensing for high availability and disaster recovery that are listed below are now applicable to all releases of SQL Server for a customer with SQL Server licenses with Software Assurance. The updated benefits will be available in the next refresh of the Microsoft Licensing Terms.

Business continuity is a key requirement for planning, designing, and implementing any business-critical system. When you bring data into the mix, business continuity becomes mandatory. It’s an insurance policy that one hopes they never have to make a claim against in the foreseeable future. SQL Server brings intelligent performance, availability, and security to Windows, Linux, and containers and can tackle any data workload from BI to AI from online transaction processing (OLTP) to data warehousing. You get mission-critical high availability and disaster recovery features that allow you to implement various topologies to meet your business SLAs.

A customer with SQL Server licenses with Software Assurance has historically benefited from a free passive instance of SQL Server for their high availability configurations. That helps to lower the total cost of ownership (TCO) of an application using SQL Server. Today, this is enhanced for the existing Software Assurance benefits for SQL Server which further helps customers implement a holistic business continuity plan with SQL Server.

Starting Nov 1st, every Software Assurance customer of SQL Server will be able to use three enhanced benefits for any SQL Server release that is still supported by Microsoft:
• Failover servers for high availability – Allows customers to install and run passive SQL Server instances in a separate operating system environment (OSE) or server for high availability on-premises in anticipation of a failover event. Today, Software Assurance customers have one free passive instance for either high availability or DR
• Failover servers for disaster recovery NEW – Allows customers to install and run passive SQL Server instances in a separate OSE or server on-premises for disaster recovery in anticipation of a failover event
• Failover servers for disaster recovery in Azure NEW – Allows customers to install and run passive SQL Server instances in a separate OSE or server for disaster recovery in Azure in anticipation of a failover event

With these new benefits, Software Assurance customers can implement hybrid disaster recovery plans with SQL Server using features like Always On Availability Groups without incurring additional licensing costs for the passive replicas.

A setup can use SQL Server running on an Azure Virtual Machine that utilizes 12 cores as a disaster recovery replica for an on-premises SQL Server deployment using 12 cores. In the past, you would need to license 12 cores of SQL Server for the on-premises and the Azure Virtual Machine deployment. The new benefit offers passive replica benefits running on an Azure Virtual Machine. Now a customer need to only license 12 cores of SQL Server running on-premises as long as the disaster recovery criteria for the passive replica on Azure Virtual Machine is met.

If, the primary. or the active replica. uses 12 cores hosting two virtual machines and the topology has two secondary replicas: one sync replica for high availability supporting automatic failovers and one asynchronous replica for disaster recovery without automatic failover then . the number of SQL Server core licenses required to operate this topology will be only 12 cores as opposed to 24 cores in the past.

These high availability and disaster recovery benefits will be applicable to all releases of SQL Server. In addition to the high availability and disaster recovery benefits, the following operations are allowed on the passive replicas:
• Database consistency checks
• Log backups
• Full backups
• Monitoring resource usage data

SQL Server 2019 also provides a number of improvements for availability, performance, and security along with new capabilities like the integration of HDFS and Apache Spark™ with the SQL Server database engine.

SnapLogic iPasS integration as a service – from Synergy Software Systems.

October 20th, 2019

Business Intelligence Managers/Analysts, Data/ETL Engineers, and Information/Data Architects are tasked with empowering business users to make use of
data to drive smart decisions and innovations. Data-driven initiatives can be challenging considering the explosion of data volumes due to the proliferation of sensors, IoT, and mobile computing.

Moreover, a growing number of groups within the business want access to fresh data.

To fully harness their data, organizations must also have a cloud strategy for their digital transformation efforts, namely to migrate data from
on-premises environments to the cloud. Considering the tremendous business value of unlocking that data, it’s imperative to prioritize and streamline these
data integration and migration projects.

Gone are the days when IT needed hundreds of coders to build extract, transform, load (ETL) solutions and then maintain those by writing more code. Modern integration platforms eliminate the need for custom coding. Now, data integration projects deploy and scale, often as much as ten times faster.

iPaaS platforms ease the pain because they’re designed for flexibility and ease of deployment for any integration project. A drag-and-drop UX coupled with a powerful platform and hundreds of pre-built connectors out of the box.

The connectors are always up-to-date, so the IT organization doesn’t spend an inordinate amount of time maintaining every integration by hand. This saves an incredible amount of time, money, and frustration across the team and projects and greatly reduces risk.

Not all integration platforms are created equal. Some do simple point-to-point cloud app integrations while others transform large and complex data into a data lake for advanced analytics. Some stgill require extensive developer resources to hand-code APIs while others provide self-service, drag-and-drop offerings that can be used by IT and business leaders alike. Some are best for specific tactical projects while others provide a strategic, enterprise-wide platform for multi-year digital transformation projects.

Organizations must address four key steps during the data migration and integration process:
1. Capture data that supports both the known use cases as well as future undefined use cases (think IoT data to support a future machine learning
enabled use case).
2. Conform inbound data to corporate standards to ensure governance, quality, consistency, regulatory compliance, and accuracy for downstream
consumers.
3. Refine data for its eventual downstream application and/or use cases (once its been captured and conformed to corporate standards).
4. Delivery of data needs to be broad and prepared to support future unknown destinations.

For decades, IT has been tasked to manage integration projects by writing tons of custom code. This onerous task is even more complex with the proliferation of SaaS applications, the surge in big data, the emergence of IoT, and the rise of mobile devices. IT’s integration backlog has exploded. Not only is the deployment too much work, but there is a growing cost to maintain all of the integrations.

Deploying a tactical or departmental data warehouse solution should take days, not months. Moreover, enterprise-wide data transformation projects should take months, not years.

The best data integration platforms:
- Support multiple app and data integration use cases across cloud, on-premises, and hybrid deployments
- Offer the flexibility to be used in cloud, hybrid, or on-premises environments, regardless of the execution location
- Provide a self-service user experience aided by AI, machine learning, hundreds of pre-built connectors, and integration pipeline
templates (patterns) resulting in greater user productivity, and faster time-to-integration
- Have an underlying, scalable architecture to grow with evolving data and integration requirements
- Support different data modes such as streaming, event-driven, real-time or batch

The SnapLogic iPaaS offering is functionally rich and well-proven for a variety of use cases. It supports hybrid deployments and provides rich and differentiating features for analytics and big data integration (Hadooplex). Clients score SnapLogic as above average for cloud characteristics, functional completeness, ease of use and ability to meet SLAs.” Gartner

SnapLogic is a U.S.-based integration platform company. In mid-2013, it transitioned from a traditional software business to an iPaaS model with the release of the SnapLogic Elastic Integration Platform which provides a large set of native iPaaS capabilities that target the cloud service integration, analytics and big data integration use cases.

The flagship Enterprise Edition features a set of base adapters (Snaps), an unlimited number of connections and unlimited data volume.

Synergy Software Systems has been an Enterprise Solutions Integrator in the GCC since 1991. We are pleased to announce our formal partnership to represent Snap Logic in the MEA region.

Do you need to integrate with Azure? with SAP Data Warehouse Cloud? with Workday? With Odette compliant auto mamufacturers………..?.

To learn more call us on 009714 3365589

SQL Server 2016 Service Pack 2 SP2 CU9 release

October 1st, 2019

Cumulative Update package 9 (CU9) (build number: 13.0.5470.0) for Microsoft SQL Server 2016 Service Pack 2 SP2 is now aavilablefor download. (It contains fixes that were released after the initial release of SQL Server 2016 SP2.)
SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence. Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.

The CU provides the following fixes and improvements (Referenced from https://support.microsoft.com/en-us/help/4100997/cumulative-update-9-for-sql-server-2016-sp1)

KB4099472 – PFS page round robin algorithm improvement in SQL Server 2016 SQL service
KB4133164 – FIX: Error when a SQL Server Agent job executes a PowerShell command to enumerate permissions of the database Management Tools
KB4086173 – FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Analysis Services
KB4131193 – Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016 SQL service
KB3028216 – FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Analysis Services
KB4135113 – FIX: Change tracking record is inconsistent during an update on a table which has a cluster/unique index in SQL Server SQL service
KB4293839 – FIX: TDE database goes offline during log flush operations when connectivity issues cause the EKM provider to become inaccessible in SQL Server SQL security
KB4230730 – FIX: A dead latch condition occurs when you perform an online index rebuild or execute a merge command in SQL Server SQL service
KB4163478 – FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server SQL performance
KB4230306 – FIX: Restore of a TDE compressed backup is unsuccessful when using the VDI client SQL service
KB4163087 – FIX: Performance is slow for an Always On AG when you process a read query in SQL Server SQL service
KB4164562 – FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Data Quality Services (DQS)
KB4094893 – FIX: Database cannot be dropped after its storage is disconnected and reconnected in SQL Server SQL service
KB4162814 – FIX: An internal exception access violation occurs and the SSAS server stops responding Analysis Services
KB4134541 – FIX: Error in the MDS Add-in for Excel when you use the German version of Excel in SQL Server Data Quality Services (DQS)
KB4132267 – FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode Analysis Services
KB4101554 – FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error High Availability
KB4098762 – FIX: Hidden parameters are included in reports when the Browser role is used in SSRS 2016 Reporting Services
KB4134175 – FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS Analysis Services
KB4091245 – FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 SQL performance
KB4094706 – FIX: One worker thread seems to hang after another worker thread is aborted when you run a parallel query in SQL Server SQL service
KB4058175 – FIX: TDE enabled database backup and restore operations are slow when the encryption key is stored in an EKM provider in SQL Server SQL service
KB4131960 – FIX: An access violation occurs when you execute a nested select query against a columnstore index in SQL Server SQL Engine
KB4094858 – FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Analysis Services
KB4101502 – FIX: TDE enabled database backup with compression causes database corruption in SQL Server 2016 SQL service

CUs also often include supportability, manageability, and reliability updates.

Before udpate:

- Check compaitbiltiy with your application.
- Test CUs before you deploy to production environments.

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