Archive for the ‘Office tips’ category

Power Bi Designer preview

January 22nd, 2015

The Power BI Designer is a new companion application for Power BI.

It is a standalone Windows Desktop application that can be downloaded from the Power BI site.

This application combines Power Query, Power Pivot Data Model and Power View into a seamless experience that will allow customers to build their Power BI elements in an offline fashion and then upload to the Power BI Service.

The Add-ins for Excel 2013 and later are still available and customers can continue to use that to model their data and build reports.

The Power BI Designer will be another option and allow customers with an older version of Office to be able to create reports.

Is the cloud right for you? Costs? Data security? What else? Which applications? Ask Synergy Software Systems

May 10th, 2014

Is my data safe in the cloud is a bit like asking whether your money is safer in the bank or under the bed. Banks also get robbed but in general are better protected than most other options.

Why use the cloud?
– is it a strategic decision to focus on the core business and to outsource an administrative function
– is there a limitation of available technical skills and local infrastructure,
– is there a need to deploy quickly and expectation of rapid scalability for which on premise deployment will be too slow
– is there a highly seasonal or variable demand for system use?
– is it economic decision to take advantage of the cloud’s economies of scale, or to smooth out cash flow, or to get more predictable IT costs ?

Such questions will help you to determine which is the best datacenter and cloud provider for your circumstances.

When choosing a data centre consider:
– the likelihood of natural disasters and weather, climate, geology
– the likelihood of man-made problems like terrorism or industrial disputes.
– the available skilled workforce, the quality of life on offer, what is the staff turnover> and certification levels?
– what are the contractual terms
– what are the latency issues for he software you run
– how geographically dispersed are your operations
– is the local bandwidth and latency the same everywhere.
– -will your cloud provider include a thin client in the pricing or might you also need to purchase Citrix or similar technology?
– does your business store large graphic or media files , will those also be in the cloud? What is the likely upload and download time?
– What about printing time and cost for large documents?
– What about BI? How fast will it run across the cloud?
– – Where will you site your Active Directory server? Will you also use ADFS?
– Does the cloud data centre provide the necessary viewers?
– the government, legislative and business culture. If governance is a critical factor for choosing a home for company data then to avoid government snooping, find a friendly country – and first define what friendly means.
– are you reluctant to use sites that are too far away. Do you want desire to visit the site in a reasonable time
– what are the accreditation and audit standards of the data centre
– can you undertake your own audits?
– what managed services are provided?
– are costs transparent? Have you budgeted for test and live systems, or for reporting databases, for back up storage? What if you want to move data between test and live – what is the time the cost, and who can do it, when?
– is your requirement for heavy processing for a few hours a day or do you need an always on transactional system.? I.e. a fixed cost or another monthly utility bill? Who is going to estimate the capacity and cost for usage based? How does that vary during implementation when you are data loading and developing, and during live operation? How does this impact costs when pay on a usage basis?
– what are the payment terms and what happens if you are late or miss a monthly payment?
– if you decide to move to another provider what assistance can you expect, how long will it take to move the data at what usage cost?
– Will you take your own back-ups to an on premise location, how will you test those the back up restores will work outside the cloud environment?
– Do the service levels, SLAs and up time statistics typically reflect 5 x 8 hour operation or 24 x 7 operation?
– and how do those factors compare to your own backyard?

Any company that distributes high volumes of content will be a large bandwidth user and will want to be located near to strong network hubs. This is why established internet exchanges in e.g. London, Amsterdam and other hubs continue to attract local business.

Dubai has long had major data centres and Synergy Software Systems offers cloud hosting as a private cloud in Dubai, as an IAAS service on Azure through Microsoft, or via level 4 international data centres in Europe and Asia, particularly for SPLA licensing of Dynamics Ax and Dynamics CRM.

Another powerful but undocumented reason why few data centres hosts migrate is that the expertise has become localised. Staff that have the experience of building data centres and running them have some of the rarest skills in IT. Recruiting these specialists is incredibly expensive and time consuming, so it’s often easier to take the data centre to the areas where they live. Dubai has a modern infrastucture and a ready supply of skilled IT engineers and we expect to see local cloud providers increase.

Major vendors solution road map are increasingly heading to the cloud. Microsoft with Azure is now taking all its apps to the cloud. Not only Dynamics CRM on line and Office 365 on line but also erp systems like Dynamics Ax. Solution development features and pricing is increasingly favouring cloud users.

If you plan to use Office 365 , with a hosted erp system in the cloud then consider whether your erp system integration with Office apps will work on line or wether you will still need on premise office licences.

USA
The US is the leader in providing cloud computing services across the globe, dominating every segment of the market.

In the 2013 Informa Cloud World Global Insights survey, 71% of respondents (of whom only 9% were from North America) ranked the US as the leader in cloud computing usage and innovation.

In this same survey, 9 out of 10 respondents linked cloud computing to their country’s economic competitiveness.

Revelations about the extent of USA government agency surveillance of private data has exacerbated concerns about locating data centres there.

The National Security Agency (NSA), and other US law enforcement and security agencies, exploit the Foreign Intelligence Surveillance Act (FISA) and Patriot Act to snoop on foreign electronic data is forcing foreign companies to consider their options.

A report from the US- based Information Technology and Innovation Foundation, suggests that post-PRISM concerns could cost US cloud computing firms up to $35bn in the next three years should foreign companies feel storing data in the US is too risky.

Meanwhile, a stable banking sector, strong consumer spending and a solid economic outlook, a skilled workforce, and modern infrastructure and a climate that makes cooling servers much less costly are factors, making Canada a preferred location for foreign investors seeking safety and growth, according to Cushman & Wakefield’s Data Centre Risk Index 2013.

Despite natural disasters like the US is still generally seen as a low-risk location. The ability to recover from Hurricane Sandy impressed analysts and the US still has the highest internet bandwidth capacity of all the countries measured by the International Telecoms Union (ITU) and the average cost of electricity, while not the cheapest, has stabilised and is relatively low.

Canada

The costs of Canadian labour and energy have reduced since last year, according to the World Bank. Canada’s international bandwidth is ranked 11th in the world. The construction of a new submarine broadband cable in 2014 and will bring better links to global commercial markets. Canada attracts increasing investment from operators and occupiers and its cold climate is perfect for free cooling.

Europe
In 2012 a policy document entitled Unleashing the Potential of Cloud Computing in Europe, the European Commission (EC) called for a number of steps to promote cloud computing adoption in Europe, including creating pan-European technical standards, EU-wide certification for cloud computing providers, and model contract language.

In Europe Germany, France and the UK still leader in bandwidth, latency, workforce skills and political stability, but the energy crisis is making Scandinavian countries a much more attractive proposition

UK is highly ranked thanks to its international internet bandwidth capacity and ease of doing business. The combination of recession and a recent construction boom means there are plenty of empty data centres in the UK.

Document Management – Dubai, U.A.E., Qatar, Kuwait, KSA, Oman, Bahrain – anywhere! Synergy Software Systems

March 4th, 2014

As we move more and more into the digital world the need to access documents electronically, anytime anywhere is of increasing importance. To complement our financial and erp systems we have also provide solutions such as fax software, print management software and document management. Many erp systems have some facility for document linking or attachment e.g Dynamics CRM and Dynamics Ax. However the document repository is usually best kept outside the erp system for many reasons e.g.:
– Users need an erp license to access documents stored in an erp system
– Documents stored in an erp system are usually static in contact because those relate to specific transactions and time and should not be subject to changes and version control.
– Documents take up database space and increase the size of the erp system back ups thereby extending downtime on the operational system
– There may be document workflow processes outside of erp.
– OCR scanning and searching are generally not supported within erp systems

Filehold is a modern feature rich comprehensive document system which integrates with SharePoint and we extend it with Arabic OCR. It is available on premise or on-cloud.

There are several considerations to select and to introduce a document management system. For example:

How many documents?
What types of documents?
What is the mix of document types e.g., what % are created soft copy by applications e.. erp systems, email systems and thus don’t need scanning or physical printing and filing , and how many are received as hard copies e.g. faxes, or printed contracts?
Do you receive faxes as hard copy print outs or do you use a fax software to send and to receive?
How many users?
How many locations?
Will hard copy documents need to be scanned?
If so, then will there be a central scanning department or will users have individual access to scanners?
Do you already have scanners in place?
Is OCR scan conversion required?
If so then does this need to be multi lingual e.g. Arabic or English?
Do you need to ocr scan dual language within the same document? e.g. a bi-lingual Arabic-English contract?
How much integration is needed to other systems and how easy is this e.g. from within email systems, or within erp systems?
will the document management system work with you collaboration system e.g. SharePoint?
Does it offer version controls?
Does it offer workflow approval processes?
What will be done about legacy hard copy documents- how many are there?
How long would it take to unbind, scan, ocr convert, index, and then re-file?
Does it provide the right security Access controls to digital documents rather than to physical documents?
Which physical documents will still also be filed?
How should it be phased in e.g. by one function or one department at a time?

Business case?
For a knowledge-worker time is money. If the average annual cost of an engineer is ~$100k then how much of that workers time is consumed searching for amendments in paper contracts?

Modern businesses create complex contracts that often require multiple revisions and many authorizations. Creating and managing those contracts electronically in a document management system saves time and frustration and ensures that everyone is working with the most current version of a document.

Filehold provides important features for contract management that : maintains security, allows users to collaborate, provides alerts and reminders as to contract expiration or renewal dates. It is essential that the solution allows project users at site users to look at and even check out contract documents from anywhere in the world from where they have access to the Internet.

Engineering organizations and engineering departments create large and complex design and report documents. Being able to put these documents into a document management workflow for review and approval saves time and money. Tight version control ensures everyone uses with the most recent version of a document.

There are obvious cost saving benefits stemming from document management such as reduced printing, postage, and physical storage costs. The more significant benefits from the business impacts:
• Rapid find and search of key data and files for timely decision making based on all the related information
• Version control to ensure the correct prices, designs and contractual terms are used.
• Streamlined electronic processes,
• Support for compliance and audit trails and avoidance of legal disputes

If you are drowning in documents and want to streamline our business, reduce errors, improve collaboration, reduce errors and ensure compliance then document management is often one of the fastest solutions to implement with the quickest ROI.

Ask us for a demo: 00971 43365589

Implement erp fast and save money and look good -Formpipe Lasernet

February 6th, 2012

Lasernet form FormPipe

http://www.formpipe.com/Products/Formpipe-products/FormPipe-LaserNet/Demo-and-movie/

Look good, save money and make everyone’s life easier. Really!

Systems cannot ‘go live’ without external facing documents:  Purchase orders, Quotes, invoices,  cheques, delivery notes etc.

‘Out of the box’ reports are seldom adequate without customisation. 

It takes time. Time to explain, to develop, to deploy to a test system, to create test data and transactions, to test layout content and printing, to test distribution and archiving, to rework, to move to live systems, to create variations by site, and by trading partner  and to get approval from marketing and management is a major area of underbudgeted implementation time and cost.

So why not do this outside the systems in tools like Microsoft Word using your own staff, who know how to use that software  and how they want the finished report to look?

Yes it can be done!  Use the same solution instance for all of your companies for almost any software, from anywhere in the world you have connectivity ..

FormPipe Input/Output Management ensures that the document goes in the right format from operational systems to business systems, from web to business systems and from business systems to the web.

Send the document the way you want in the format you want

Improve your branding with modern fonts, colours and consistent look and feeldon’t be constrained by canned report formats.

Rapidly change company logo, address, or registration details or quickly update marketing messages, across all your system documents

Three major areas are addressed:

  • Convert from one data format to another, eg XML to PDF / A
  • Appearance/layout handling, basically the graphical part of a document
  • Distribute in the correct format to the right receiver

FormPipe Input/Output Management manages the organizations many different types of business documents, Print templates, forms, letters, invoices, orders, reports whether an electronic format such as XML, XHTML, EDI, PDF /  or in paper format.

With FormPipe Input/Output Management your organization will be compliant with all requirements of a document’s appearance and data format, regardless of original system format.

Manage information flows in and out of all your business systems, and use with any operating system regardless of what those systems do or what data they produce.

Produce consistent house style and branding across all you application documents . Tailor external documents by trading partner – add their logos, or use a different sort order, or add a page total , or a bar code etc. Format and sort and group outside your erp system using familiar office program template documents. Produce as a pdf a fax or an email or send an sms at the same time while you also save a copy in the associated document management system.

The benefits of the solution are many and our customers use FormPipe Input/Output Management for example:

  • Template Management
  • Form Handling
  • Print Management
  • Process incoming electronic documents
  • PDF rendering
  • Layout management of business documents

In built modules for SAP and Microsoft Dynamics Ax

Save time and cost on erp implementation

Save on time and stationery once operational

When you upgrade your business systems your reports do not need to be redesigned –  remap the print output to the same report templates and save days of reprogramming and testing.

References

· BOC Edwards

“Through good project management, SAP implementation cost overruns and delays are becoming rarer, however, when they do occur they are generally caused by output programming errors. By using LaserNet we were able to avoid all these issues as well as adding some beneficial document management facilities. Overall LaserNet was a key factor in the success of the SAP implementation overall.” (ERP: SAP)

· PC WARE

“We send up to 70,000 invoices a year to our customers, and with FormPipe LaserNet we can convert each and every one of them into an electronic format, so that they can be sent to the recipients by the customers choice of email, fax in addition to XML: all without operator intervention. Just by switching 20% of our invoices to email delivery we saved several thousand euros within a few months and anticipate a significant return on investment within the year.”

· INVITA

“Thanks to our LaserNet system we can now print our business forms on to plain laser stock, eliminating the cost & difficulties associated with pre-printed stationery. Further on, FormPipe LaserNet enables us to distribute documents via email and archive them electronically. We save over 15,000 euro a year on printing, postage & filing costs. With a low starting cost the FormPipe LaserNet solution is an investment that has given us our money back many times over.” (ERP: Dynamics AX)

· UNICEF

“There are three good reasons why we chose to implement LaserNet: Firstly, LaserNet is not dependent on a printer, in contrast to our previous form printing system. Next, we can perform the programming and preparation directly in LaserNet which we’d otherwise have to do in our financial management system. It’s a huge benefit to us, saving both time and money. And last but not least we can easily and efficiently reuse the forms we make in LaserNet when we switch from using Concorde XAL to Dynamics AX as an ERP system”. (ERP: Dynamics AX)

SQL 2012 and SSRS

February 4th, 2012

Reporting Services in SQL Server 2012 will support XLSX, DOCX formatsand this removes the 65536 rows limit in XLS files 😉

the 65.536 rows limit in an Excel sheet was removed with Office 2007/2010 with the introduction of new Excel format XLSX.

 SQL Server Reporting Services lacked XLSX file export support in SQL 2008 and ealier versions.

That means you won’t receive the error messages like below.

However think twice before generating an XLSX file with millions of rows. Who will open this Excel sheet with millions of rows in it ?

Even if the answer  “I will reach this XLSX file programatically not directly opening with Excel” rmemebr that Excel files are not intended to be used as a database!

Dubai in the cloud? Office 365?

December 7th, 2011

When you are starting up or need a new solution fast then a cloud based solution rather than an on-premise one  will get you up and running without the cash flow hit.  . . . at least in the short-term. However, if you implement a major business application then you still need comprehensive business process mapping, data cleansing, organizational change management, end-user training , data migration local support etc.

 The cost structure of cloud ERP avoids paying a lump sum up-front, either for hardware , software, product install, or day to day IT staff  but  organizations must pay for yearly subscriptions to their cloud provider. So it’s an easy way to amortize a large upfront expense witrhout punitive bank loans or mortgages.  You also don’t need to worry about the cost of applying patches and upgrades or resizing hardware, or the cost of back up tapes nor the space costs of a server room (what is the opportutnity cost of the space in a amjor city?)  and the energy costs that go with it, not to mention insurance and support costs for the hardware.

 However if the business cash flow should cash dry up, then you may find it  impossible to pay for the subscription – you dont just lose support, you may lose your entire system.   Vendors need to make a profit so ultimately they have to cover the cost of the up front finance. Cloud applications therefore generate more predictable revenue and higher long term revenue.

There are many successful solutions particularly in the CRM space.  Why am I writing about this now? Well Microsoft recently invited me to particpate in one of the partner surveys about our awarenes of, and our business plans, re the cloud and use/planned sales of specifically Azure and other providers like Amazon web  services. So I ahd to think – we sell some cloud solutions but we not likely to be a host  of the cloud – we implement and support. So how might it change our future and offerings?

In this region there has been cautious adoption . Of course most of us use the cloud  without thinking about it when we buy books on line or upload photos, or use web email, or Facebook etc.

So what about erp solutions like Dynamics Ax . We have been able to offer this for a long time on the cloud but clients in this region are still concerend about proven reliability – there have been some prominent site outages this year, and about  risks to their data. I am less conerend about secuirty – if you choose a major provider then they will have  a Fort Knox equivalent data centre physical security with appropriate back up,  disaster recovery, firewalls, virus protection, and skilled staff  etc that will be far safer than most on premise networks. For me the problem is more about the contractual and support side which seems much less clear..

 2. Will we still own our data? a crucial question to ask your ERP cloud provider before the purchase-  how and in what format will  the cloud provider deliver your data to you when you cancel your contract – how long will that take  .

3. How to choose the ERP cloud provider? Few will have a cloud track record, but  lots of satisfied customers is always a good sign .  Check the uptime guarantees, service level agreement (SLA) and other terms and conditions and whether these cna be substantiated and what happens if those are not met . Check the vendor is operating on a large enough scale with redundant infrastructure facilities in the case of a natural disaster at their primary facility. What is their financial stability. WIll your data be in the sama server as others on a shared database, or will it be dedicated for you? How does the application licensing work if the cloud provider is not the application vendor?

4. What if  we want to bring ERP back in-house? . Some vendors only support cloud deployment,

5. Will a cloud-based ERP system be able to integrate with the other line of business applications that we use?  ERP solutions with integration tools will allow you to integrate to other on premises and cloud based solutions. Can you customise for your business, or is it a common build offered to all clients – i.e if the system is enhanced for you then all other users similarly benefit. A common build will tend to be continually improved and be easier to upgrade maintain – Birch St is a typical product that works on this module for Hospitality procurdment.

6. Will there be connectivity and response time issues   Check the latency and   bandwidth requirement per client – consider report printing and BI.  Response time is a key factor for the user with a cloud based system. Flex system is a powerful user friendly cloud BI system – its in memory processing ensures exceptional processing response time. Ask us! Its a well kept secret here but is widely used in financial services in Asia.

7. What if the internet connection goes down? Consider a  redundant internet service to ensure continued operations even when your primary ISP goes down this may also help you to load balance and peak times . Many organizations find that a redundant system also helps with load balancing during high usage time.

8. What if the cloud provider is offline? The SLA (Service Level Agreement), should define   uptime guarantees and explanation of the redundant systems in place to protect against major system failure – 99.9% uptime  means in the worst case scenario that your system isdown less than 8.76 hours per annum – probably better than an in house system .

9. What  about add on customised developments?   Will these  work with a cloud based application ? This will become more common as the cloud usage expands, but there will be an additional cost to adding ISV applications to your hosted or cloud system.

What about office tools- these are less crtical than erp solutions Most of us use a hotmail gmail ,yahoo or equivalent mail account. Google apps has a large footprint of users – and Zoho also has its fans,

Microsoft has now entered this space with 2 million clients for Office 365 in a very short time. For small businesses this is a quick way to get up and running at a known cost with Office Professional, SharePoint, Exchange server and Lync with the only requirement being an internet connection,- instant productivity with the possibility of Skype or other VOIP phone systems. Ask us for details. However, it can also be a big boon for large companies as a way of outsourcing these IT functions – useful when skilled resources are scarce /costly, and when office rents are high, and the company wants to stay compliant with ITIL, and the latest technology, or has   variabe staffing e.g a project based company  or is experiencing rapid growth which is outstripping systems.

This seems to me where the cloud will get established and  will  lead to wider acceptance of erp on the cloud. Meanwhile apps stores are increasingly adding business apps and Microsoft now also runs an apps store to complement its products.  expect to see SaaS models evolve around web services e.g pay for a credit card gateway on an ad hoc  per use basis.

Exclaimer – Exchange server utilities- now with anti-spam stand-alone option

June 30th, 2011
Synergy is perhaps best known for erp, payrol and finacial soltuions, however we also provide  uesful utilties. Everyone uses emails and for those using Exchnage Server and Outlook, Exclaimer is a must have, low cost set of tools. Oneof htose is anti spam which is a daily growing problem.As you would expect Exclaimer  doesn’t use inconsistent word-filtering to catch (or miss) spam. It analyzes data on global email traffic, so whatever its content, in any language, even with images, it spots it and stopa it. Maximum power, minimum false positives and zero effort – as expected.
http://www.exclaimer.com/

Better and Easier

Anti-spam combines Commtouch’s Recurrent Pattern Detection engine with Microsoft’s built-in protection in one simple interface.  So you get all the effectiveness of both, and none of the stress.

Watch RPD  http://www.exclaimer.com/products/anti-spam/videos.aspx?utm_medium=email&utm_campaign=Anti-spam+Reseller+ROW+June+2011&utm_content=Anti-spam+Reseller+ROW+June+2011+CID_883ec5f1e3619379a89a1020418d046a&utm_source=Email+marketing+software&utm_term=work

 
 

Call Us

We always want to hear from you and we always want to offer help and advice, or hear the same from you.

Or call +971 4 3365589

 

What Is Universal Search?

May 29th, 2010

 

Search your  company information quickly with the familar  Google, context-sensitive ,Search  Appliance. Universal search is the ability to search all content in an enterprise through a single search box. Although content sources might reside in different locations, such as on a corporate network, on a desktop, or on the World Wide Web, these appear in a single, integrated set of search results.

The Google Search Appliance provides many capabilities and features that–when used–enable you to enhance universal search and the search experience for your users 

The Google Search Appliance is a one-stop search and index solution for businesses of all sizes. When users search for information, the Google Search Appliance returns a single set of search results that are integrated from different types of sources.The Google Search Appliance crawls and indexes content from many sources:

  • File shares-Files in 220 different formats, such as HTML, PDF, Microsoft Office, and many more
  • Intranets- All files on your intranets or other web servers
  • Content Management Systems-Information in content management systems, with built-in connectivity to EMC Documentum, IBM FileNet, Open Text Livelink, and Microsoft SharePoint
  • Enterprise applications-Information in your business applications, using Google’s OneBox for Enterprise, which enables a search appliance to connect with enterprise applications, such as Customer Relations Management (CRM) systems, Enterprise Resource Planning (ERP) systems, and financial databases
  • Databases-Records in relational database management systems, including IBM DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase
  • World Wide Web-Information on the web

PowerPoint Images

April 21st, 2010

Its generally not  good practice to copy and paste pictures and other content from the internet into PowerPoint.

First make sure the image is not copyrighted – they often are!

Consider using a screen capture utility or otherwise

Right-click the picture, choose Save Picture As and save it to your hard drive.

 To add the image:

Insert | Illustrations | Picture in PowerPoint 2007

 Insert | Picture | From File in PowerPoint 2003 .

When you copy paste from the net, you may create a hard-to-remove link to the internet from your presentation. (Try a right mouse click and select rwmove hyerlink)

If nto removed then this may cause Windows to try to connect to the internet every time anyone opens the presentation. 

Don’t link images

When you insert pictures  you may notice an option to Link to the file. Unless you have a good reason for doing it, don’t. PowerPoint’s image links break very easily. It’s generally safer and more effective to embed the files (in other words, insert them normally, not linked).

Outlook Calendar printing

April 21st, 2010

Tip from the Microsoft Outlook product team

A printed copy of your Outlook calendar can be quite convenient. If the available printing options aren’t sufficient then  try the Microsoft Calendar Printing Assistant for Outlook 2007. The Calendar Printing Assistant supports a wide variety of layout templates and allows you to print multiple shared calendars at once.

The Calendar Printing Assistant is a separate program from Outlook. After you install it from the link above, you can find it in the Start menu under Programs | Microsoft Office | Microsoft Office Tools | Calendar Printing Assistant.