How to generate an SQL database user report via Infor Cloudsuite

, ,

With Infor Cloudsuite’s SQL Users And Roles Report Service, there is no need to setup any DBA permissions or to use database management software in order to see who has Database access and with what role.

 

  1. Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
  2. Select Deployment and Request Type: SQL Users And Roles Report >> Next
  3. Select the Database Server and Database fields >> Submit
  4. This report can take anywhere from 5-15 minutes. Once complete, select the Request ID created and download the Users or Roles report for review.

And we’re done! Good luck!

How to modernize your legacy ERP system

While the taking your business to the cloud is a popular trend these days, there are still some businesses who choose to stay on premise and keep their legacy systems in place. This may be a good decision for a company, though managers should still consider modernizing their legacy enterprise resource planning (ERP) systems. Healthcare Informatics consultant Reda Chouffani of Biz Technology Solutions shares an interesting read on TechTarget.com on how to modernize your legacy ERP system using the right approach. Gartner defines five legacy ERP modernization approaches, known as the “five R’s”. Chouffani breaks them down below:

  1. Rehost. “A company that has outgrown their existing ERP and is seeing performance start to suffer can consider moving its ERP system into another infrastructure, such as a new server or cloud service provider, to gain more processing power, faster storage and better networking.  Rehosting also includes upgrading only the hardware or software of the back-end database engine that stores the ERP data. This can improve system performance.”
  2. Refactor. “Refactoring an ERP system involves evaluating and optimizing ERP processes and customizations. This approach requires an internal committee of business analysts, IT staff, subject matter experts and other business leaders. The committee evaluates the ERP system and recommends changes that will increase efficiency and improve overall operations.”
  3. Rearchitect. “Rearchitecting is adding third-party apps to gain functionality that the legacy ERP lacks, which could potentially solve business issues. For example, a company may want to eliminate duplicate data entry between the current ERP and their supplier’s system. One potential fix is to adopt an electronic data interchange that can provide a way to automatically exchange data such as orders, invoices and delivery confirmations, which reduces duplication.”
  4. Rebuild. “As with refactoring, the rebuilding approach includes a committee reviewing and attempting to optimize existing processes. However, for this strategy, the committee considers rebuilding some of the existing business processes, including potentially starting from scratch. The committee may add new tools to the mix or change staff responsibilities.”
  5. Replace. “The replace strategy refers to eliminating some of the legacy ERP system components that are ineffective and don’t meet business requirements. Manufacturing resource planning, warehouse management systems and production scheduling are a few ERP components that organizations often find difficult to use or inadequate for business needs.”

When choosing this approach, there are certain factors to consider when selecting a legacy ERP modernization approach. Two very important factors to note are business risk and costs. While every critical business decision comes with risks, make sure your organization knows the high and low level risks you’re taking in modernizing your ERP system. Likewise, your company must also evaluate whether you can afford these business decisions.

 

For Full Article, Click Here

Bright Food Global Selects Infor to Deliver Essential Ingredients for Success

Bright Food Global, an Asia-Pacific based market-leading distribution network specializing in consumer packaged goods, high-end fine foods and Australia’s largest exporter of citrus fruit, has selected Infor Food & Beverage (F&B) to power its move to a multi-tenant cloud setting for ERP and core business systems. Part of their growth plans, the enterprise-wide transformation project will see Infor F&B deployed in financial management, inventory management, procurement, warehouse management, sales order management, cost accounting, manufacturing, quality management, and other areas. Per the press release, Infor F&B will provide Bright Food with greater flexibility, mobility, automation and visibility across the business in warehousing, retail, finance and manufacturing pillars, and positively impact a variety of users, from production line workers to administration staff. The tech giant’s solution will replace Bright Food’s 14-year, on-premises Infor ERP solution. Further, this implementation will be rolled out in three phases across Australia and New Zealand, in partnership with Infor gold channel partner and ERP specialist ComActivity.

 

For Full Article, Click Here

Infor Cloudsuite Add Users Process Failed

, ,

You’ve created a template file to load a user into Lawson via Infor Cloudsuite but it failed.

  1. First let’s review the Request ID that failed by clicking on it.
  2. At the bottom you will see 2-3 links, one to download the Template file, and the others to download the AD or LSF log file (depending on the error). Let’s click the AD and LSF Logs to review.
  3. In this example, the AD log file was fine, but the LSF log file shows errors.
  4. In the log shown above, we have an invalid LBI Group. Review your template file (you can download it above AD log file) and make the correction to the template file. Load it again and see if the errors are resolved.

Good luck!

Supertech Group Digitally Transforms with Infor to Boost UAE’s Industrial Growth

Supertech Group, a diversified Dubai-based conglomerate, has digitally transformed with the help of Infor LN, enhancing its ability to meet growing demand for industrial products and discrete manufacturing across sectors. Per the press release, Supertech Group’s digital transformation aims to support national initiatives such as the UAE’s ‘Operation 300bn’ strategy to increase the industrial sector’s contribution to gross domestic product (GDP) to AED 300 billion (US $81.7 billion) by 2031. With Infor LN being a powerful, industry-focused, enterprise resource planning (ERP) application, it has enabled the Supertech Group to increase visibility, reduce complexity and boost efficiency across its business. Additionally, Supertech Group has transformed its human capital management (HCM), with bespoke HR solutions built into Infor LN. These solutions reportedly enhance the way Supertech Group manages its large and rapidly growing workforce, enabling it to increase the efficiency of its HR practices, raise productivity and improve customer service. Further, with Infor LN, Supertech Group is now able to capture and manage product warranty information, which is essential when its customers visit for quality audits.

 

For Full Article, Click Here

Infor Automated Process Error – No Incoming Connection

, ,

If you just started working in IPA, some of the documentation is not straight forward and can often even be confusing at times.

The “No Incoming Connection” error is a simple fix for most nodes that do a query or write/read on a file.

 

Example of a No Incoming Connection error:

 

To resolve, select the connect tool and connect the Starting node with the end node to resolve the issue.

Done! These types of nodes should already come connected and if the developer needs to change them up that would be up to them. Good luck with the rest of the little quirks of IPA!

Four Ways Data Drives Digital Transformation Success

Since the COVID era began, a popular term in the technology and business space emerged – digital transformation. Leaders struggled with the abrupt change in consumer behavior and many new practices required business to be done remotely. Yet, even as many organizations have returned to on-site or hybrid operations, the need for leaders to define, execute, and balance how a business adapts to the faster pace of today’s digital reality has never been more critical. Benjamin Laker, a global affairs and leadership  strategy expert, shares an article on Forbes highlighting the ways that data drives successful digital transformations.

Return on Investment
“CFOs will be the first to share that any business project must deliver a compelling ROI that is benchmarked against a clear and purpose-built business case. Leading companies are demonstrating excellence in their digital transformation projects. Winning enterprises consistently demonstrate how technology enables the organization to eliminate legacy systems, improve data accuracy, reduce risk, and ultimately deliver shareholder value.”

Automation
“Automation should never be the goal of any project but rather an enabler that frees staff time to pursue higher value-added activities. It’s the entry-level requirement to unlock time to improve strategy and achieve new business outcomes. Consider Maslow’s hierarchy of needs. In that case, automation and productivity are fundamental building blocks in the journey to achieving digital transformation — the ultimate capacity to maximize outcomes and deliver value across the enterprise.”

Process Maturity and Intelligence
“To deliver higher value business outcomes, digital transformation initiatives must offer new insights that lead to better decision making. The most effective and mature systems offer more dynamic and integrated levels of business processes to enable CFOs with greater capacity for decision support.”

Value Realization
“Quantifying the realized value of digital transformation projects can help both the planning of projects as well as the evaluation of their success. Value engineering teams, specialized task forces that evaluate how projects can deliver ROI, will quantify the benefits of a transformation project against comparative industry benchmarks. Highly skilled value engineers capture business requirements, measure the impact of those changes in dollar terms, and validate data through a performance maturity framework that measures progression and the financial impact of realizing project goals. The result is a value realization assessment that can be leveraged to monitor progress as a set of project milestones before, during and after the digital transformation is complete.”

 

For Full Article, Click Here

4 Ways to Optimize Your CRM for the COVID Age

Since the COVID-19 pandemic in 2020, there have been many changes in business operations across industries. Social distancing, remote work and learning and online shopping became the norm. Consumer behavior dramatically changed, prompting a company’s customer relationship management (CRM) system to work extra hard to adapt to the changes. Businesses had to accommodate to remote work and changing consumer behavior. With “online” being the main platform, CRMs have had to work hard to help companies best serve their customers. Michael Vickers, executive director of Rainmaker Digital Solutions and Summit Learning Systems, shares an article on Destination CRM describing several ways to optimize your CRM in this COVID age.

Use Cloud-Based Project Management Tools. “These are internal tools that centralize information and communication, allowing employees to work in the comfort of their homes. Employees have access to all of the company databases, including for client engagement and customer service, and all they have to do is log in and use the tools. Cloud-based project management tools make working more orderly, unlike the back-and-forth communication through emails, which can be overwhelming.”

Constantly Update Your Company’s Knowledge Base. “Working remotely means that you might not be at liberty to respond to every employee question. Therefore, you should always ensure that your company’s knowledge base is up to date so that the employees can refer to it whenever clients have any questions. A knowledge base cuts down on time you spend researching information, as employees can access anything they need to know from one place.”

Use Video Chats. “One of the revelatory tools to have emerged from the pandemic is videoconferencing, and apps such as Zoom, Microsoft Teams, and Google Meet became widely adopted practically overnight. Since COVID can make it very difficult (or even impossible) to hold physical meetings, you could communicate with your team (and potential clients) through video chats. Video chats optimize CRM as the team informs you of any challenges they encounter while keeping the team members posted on the welfare of the business. You can use video apps to make individual calls to each team member or conduct webinars involving everyone.”

Use Customer Service Solutions. “The most crucial aspect of your business is your clientele. Customer service software helps you monitor customer relations. Information stored in the service software provides a reference point for identifying any clients’ complaints, thereby improving these areas.”

 

For Full Article, Click Here

How to add a read-only SQL database user via Infor Cloudsuite

, ,

With Infor Cloudsuite’s SQL Manage User Service, there is no need to setup any DBA permissions or to use database management software. You can simply add a read-only database user via Cloudsuite in the below steps.

 

  1. Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
  2. Select Deployment and Request Type: SQL Manage User >> Next
  3. Select the Database Server, fill in the User, Password, Database name and for our example we are using the default database roles, for read-only, use db_datareader. See all default SQL database roles here and then click Submit!

 

Done!

NOTE: Some organizations have minimum password requirements. We recommend using a password generator online and keeping it to letters and numbers so users can type in relatively easy.

OFFICE Stays One Step Ahead with Infor

OFFICE, a leading-edge fashion footwear specialist and part of Truworths International, has chosen Infor CloudSuite Fashion to align multiple business processes within a unified ERP system. The solution, delivered via multi-tenant cloud on Amazon Web Services (AWS), will be deployed by Infor partner Fortude. It will help OFFICE simplify complex processes across merchandising, warehousing, allocations, planning and inventory management for greater business efficiency. Per the press release, OFFICE’s omnichannel model was placing considerable strain on existing IT resources and the business wanted to eradicate inefficiencies while securing real-time business insight to boost decision-making capabilities. “We’re a dynamic business and need systems to match,” says Jon Richens, OFFICE’s managing director. “The solutions from Infor provide simplicity of architecture but with the depth and breadth of industry-specific functionality we need, all at an attractive price point and with the added resilience and agility of the cloud.”

 

For Full Article, Click Here