Need an Access Lawson database to reside on the desktop of select users without having to relink all the tables each time?

If so, see the below query for the DSN-less connection with a function to relink all the tables and pass-through queries. This also just works for databases in general. Good luck!

 



Super Bowl Sunday is notorious for people throwing tailgate parties at home with finger food platters, cheering on your favorite team, singing along to the show stopping halftime performances from iconic artists, and of course watching the entertaining lineup of commercials. From automobiles to movie trailers, to pizza to the latest technology, there is a commercial for everyone to take interest. This year’s technology lineup of commercials featured the popular craze in cryptocurrency with timeslots from Coinbase, FTX and Crytpo.com, the all new MetaQuest 2 Virtual Reality headset, the Google Pixel 6 phone now with “real tone” photos, powerhouse musicians Dolly Parton and Miley Cyrus gushing over T-Mobile’s 5G network,  Uber Eats’ expansion of delivering everyday essentials and groceries, the intuitiveness of Amazon’s Alexa voice AI, and Amazon Prime’s streaming service hype trailer for the following NFL season’s Thursday night games streaming exclusively on their app. These are just a handful of the popular tech trends of today and tomorrow. Which commercial/tech are you looking forward to the most?

 

Click here to view this year’s technology commercials on TechCrunch 

In late December 2021, long time Infor customer Montgomery County of Pennsylvania successfully upgraded to the newest iteration of Infor CloudSuite™ Financials & Supply Management from its current on-premise system to transform its back-office strategy. Montgomery County will now be operating with a modern ERP system that authorized users can access easily with consumer-grade system documentation available at their fingertips, allowing the organization to stay modern and agile for continued growth. Per the press release, as part this digital transformation, Montgomery County is now using Infor CloudSuite applications to streamline processes, in near real time, to help drive adoption, compliance and productivity. With this, teams can utilize a full range of business applications to interconnect critical processes and transactions in more meaningful ways, such as reconciling open invoices that were aged. Further, Infor CloudSuite provides Montgomery County the tools to support productivity, forecast more accurately, and analyze the business more effectively. Infor Financials and Supply Management (FSM) applications are role-based, data driven, consumer-inspired, and mobile enabled. The modern analytics software will help Montgomery County understand key business drivers and visualize changes that will drive growth and profitability.

 

For Full Article, Click Here

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!

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

  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, 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

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, 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

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!

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