DME Queries in Lawson

, ,

Lawson provides the ability to query Lawson tables via URL.  These transactions are called “DME” queries, and can be quite useful in IPA processes, or in scripting bulk data calls.

To query data using a DME call, the URL is https://<server name>/servlet/Router/Data/Erp?.  To select specific fields, use the “FIELD” key word.  To filter the results, use the “SELECT” key word.  You will need to have knowledge of the data tables and columns to build these queries.  The dbdef command in LID can be quite useful for this.

GEN

To query GEN data, the syntax would be https://<servername>/servlet/Router/Data/Erp?PROD=GEN

For example, this URL would return the PRODUCTLINE and FILENAME fields for the FILEDEF record with prefix “API”:

https://lawson.company.com/servlet/Router/Data/ERP?PROD=GEN&FILE=FILEDEF&SELECT=PREFIX=API&FIELD=PRODUCTLINE,FILENAME

LOGAN

To query LOGAN data, the syntax would be https://<servername>/servlet/Router/Data/Erp?PROD=LOGAN

For example, this URL would return the VERSION data in the LOGAN data area

https://lawson.company.com/servlet/Router/Data/ERP?PROD=LOGAN&FILE=VERSION

Data Area

To query your desired data area, the syntax would be https://<servername>/servlet/Router/Data/Erp?PROD=<data area>

For example, this URL would return the CUCODE “USD” from the CUCODES table in the TEST data area.

https://lawson.company.com/servlet/Router/Data/ERP?PROD=TEST&FILE=SELECT=CURRENCY-CODE=USD&FIELD=CURRENCY-CODE,DESCRIPTION

Output

The default output type is XML, but you can also output in CSV format.  To do that, in the URL, append the command “&out=csv”.

Infor and C3 AI Form Strategic Partnership to Deliver Scalable Enterprise AI Industry Applications

Leading enterprise AI software provider C3 AI and Infor announced in March a strategic alliance to jointly expand enterprise-class artificial intelligence (AI) solutions across applicable industries. This wil extend Infor’s native machine learning capabilities and allow the tech giant to explore expansion of its industry offerings into edge scenarios and analyze ways to provide deeper capabilities beyond standard Infor offerings. Per the press release, Infor plans to market, license, and deploy C3 AI prebuilt solutions to Infor customers under the Infor brand and to explore new solutions using the C3 AI® Suite. One of the first focuses will be on predictive maintenance surrounding Internet of Things (IoT) systems with the goal of providing a more proactive and accurate maintenance strategy within Infor’s EAM (Enterprise Asset Management) solution. Further, the partnership allows C3 AI exploration into other verticals and is designed to supplement Infor’s existing platform technologies in advanced analytics and embedded intelligence.

 

For Full Article, Click Here

Zahid Tractor Turns to Infor for Digital Transformation

Infor announced in March that Zahid Tractor, a Saudi Arabia-based Zahid Group company that supplies construction machinery and commercial vehicles, is now using the tech company’s enterprise resource planning (ERP) to streamline and gain visibility across all departments. Integrating to Infor M3 for Equipment will allow Zahid Tractor to continue its commitment to excellence in customer service and offerings across the Kingdom of Saudi Arabia’s construction, transportation and rental sectors. Per the press release, Infor M3 met all the requirements stemming from interface-driven initiatives Zahid Tractor has with its original equipment manufacturer (OEM) partners, which help increase supply chain visibility and improve service levels for their customers. This was a key prerequisite of the ERP solution for Zahid Tractor. The Infor M3 solution will be instrumental in helping Zahid Tractor tap high levels of growth in Saudi Arabia’s construction equipment market. Zahid Group is currently working with Infor to roll out Infor Birst Analytics and Infor M3 CloudSuite to other companies within the group.

 

For Full Article, Click Here

Outdated TLS 1.0 and TLS 1.1

, ,

After performing WebSphere or Infor application maintenance, your browser may present you with the error code “NET:ERR_SSL_OBSOLETE_VERSION”, indicating that the Quality of Protection (QoP) protocol in WebSphere is using an outdated version.

To resolve this issue, open the WebSphere administration console for the application causing the error.  Navigate to SSL certificate and key management.  Select SSL configurations on the right-hand side.  Then select the Node for your web application, and click “Quality of protection” on the right-hand side.  Select a supported protocol.  Save the changes and restart the WebSphere services.  NOTE: also make this change to the Cell if applicable.

 

The Future Of Cloud Is Vertical

The history of cloud services tracks had very neutral, horizontal offerings.  The cloud was for everyone and for every aspect in our personal and professional lives. However, that is no longer the case and the future of cloud is shifting to a vertical approach. Emil Sayegh, President and CEO of Ntirety, one of the largest managed cloud service platforms in the world, shares an article on Forbes about the narrative of vertical cloud progress. In recent years we’ve seen vertical progress with companies such as Azure and AWS, specialized in government clouds. Look for technical, security, and compliance tool sets for each cloud vertical that will look more like the .Gov cloud, but also look for other emerging verticals in healthcare, banking, IOT, manufacturing and self-driving vehicles to name a few. Verticals in these areas will most likely align with specialized tools, along with resiliency, security, and performance. The verticalized cloud will aid in businesses specializing industry-specific needs such as security, technologies, and application services. Technologies that would shine in vertical cloud growth include web applications, customer relationship management, application, data and systems monitoring, and email, voice, and messaging integration. Exploring vertical cloud offerings is a venture into specific sectors, says Sayegh. Vertical clouds focus on the needs and advantages required for businesses within that solution to improve user data experiences, provide critical business insights, operate under compliance and enhance security and reliability. Sayegh concludes that you will not be able to avoid this vertical cloud future.

 

For Full Article, Click Here

MSCM Handheld Test Fails with Secured URL

, ,

If you are testing your MSCM handheld connection against the secured MSCM URL, and getting a “Test Failed” error, you may need to modify the Quality of Protection protocol in WebSphere.

The symptoms of the issue are: “Test Failed” message on the handheld, and the MSCM COMM log will show an error stating “Failed during SSL handshake”.

To update the QoP protocol in WebSphere, open the WebSphere Admin Console for MSCM, and navigate to Security > SSL certificate and key management.  Click “SSL configurations” on the right side of the page.  Then select the NodeDefaultSSLSettings.  Click “Quality of protection (QoP) settings” on the right.  Update the Protocol to “SSL_TLSv2”.  Click “Apply” and save the configuration.  Repeat these steps for the cell (if applicable), then restart WebSphere services for MSCM.

 

**NOTE: To avoid future issues with the MSCM/Lawson connection, it is best to set the QoP protocol in the LSF WebSphere Console to the same values as MSCM.  Do this both for the Node and the Cell.

 

 

 

 

 

Can ERP implementation happen remotely?

It’s no secret that the COVID-19 pandemic has flipped the script for almost every industry. Common across many fields, remote work has become the ‘new normal’ for many (and still is). In the ERP (enterprise resource planning) business, remote implemantation and its effectiveness is proving its worth in this climate. Gone are onsite implementations when the new normal is remote setup. However, yet how effective is remote ERP implementation? Sean Fowles of Seidor Africa, a leading SAP Business One Reseller in Africa and a top technology integrator, shares an interesting read on ITWEB Africa of certain prerequisites one must consider before relying on remote ERP implementation.

  1. Analysis. “Successful ERP implementations begin with education. It requires organizations to develop an understanding of their business processes and to map those. This allows the team to define the business entity, who is responsible, to what standard a business process should be completed, and how the success of a business process can be determined.”
  2. Design. “Large ERP projects often have a dedicated meeting room with timelines and status updates displayed. With a remote team, this practice is still extremely useful, but it needs to be done virtually. Interactive whiteboard applications offer real-time collaboration for remote workers, enabling visualisation and promoting engagement between those involved. Similarly, HD video-conferencing units allow for face-to-face connections and create an environment where people are more likely to share innovative ideas.”
  3. Build. “Building in phases requires workflow templates, security templates, mapping templates and comprehensive reports. Collaboration and connection with the team will ensure that all members are properly enabled to complete their tasks. It’s also important to address all the ‘how-to’s’ separately with individual team members.”
  4. Test and deploy. “Consistent testing will help to keep project stakeholders engaged and interested. Plan the testing phases and create test scripts to facilitate the process.”

Should these four requirements be met, Fowler’s believes remote ERP implementation should be successful.

 

For Full Article, Click Here

Lawson MSCM Handheld Unable to Download PlatformDLL File

, ,

Infor recently updated handhelds and MSCM for a cloud environment. The test user was able to download the Infor CAB files to the handheld but was unable to download the PlatformDLL file. The error message kept coming back with “Internet Explorer cannot download file”

 

After ensuring all permissions were set for the user and running several tests, rechecking the configuration setup. We finally located the issue from the update and it turns out a port was reset to a default value and we had to change the Service Type to LHC. Below are the steps you can take to resolve this if you’re experiencing a similar issue.

 

  1. Login into MSCM with Server Administration group rights.
  2. Select MSCM Configuration >> Additional Settings
  3. Select Service Type LHC and under Handheld Service Properties, ensure you’re using the correct port. For us we had to update it to 1447

  1. We updated both LSF and handheld ports to 1447 and the user was now able to download the file.

Hope this was helpful!

STAY Builds for Growth with Infor

Luxury apartment service brand STAY recently deployed Infor HMS property management system for its 169 apartment properties in Camden, London. Infor WMS will help deliver even better customer service and provide a platform for new processes including flexible, contactless check-in. Per the press release, Infor was chosen based on specific invoicing capabilities for the extended stay sector, deep domain expertise within the hospitality industry as well as the ease of integration with other systems. Calum McIndoe at Infor Hospitality says of the deployment, “The serviced apartment and extended stay market has bucked the downward trend of the hospitality industry under COVID. Our proven ability to deliver large projects remotely has allowed STAY to capitalize on this ongoing demand and deliver a premium accommodation experience in the heart of London.”

 

For Full Article, Click Here

Lawson System Foundation Older Addins Attributes

, ,

If you have suddenly noticed in Lawson Security Administrator that certain users have different attributes in their addins field other than ALLOW or DENY, don’t worry as this was setup by design back before LSF version 9.

These values were removed in version 9+ because Lawson User Security (LAUA) and Lawson System (LS) security can now secure these actions on specific tables and records.

If you want to convert the old Addins Attributes like to Allow or Deny, simply edit the users RM info and change the Addins field to Allow or Deny.

 

If you prefer to stay on the older attributes, see the table below for in-depth access descriptions:

Attribute ID Description
Dxxxx The user does not have access to the Query Wizard, but has full access to the Upload Wizard.
DDxxx The user does not have access to any Addins functionality.  Same as the current Addins attribute = DENY.
ADxxx The user has access to full QueryWizard functionality, but is blocked from using any part of the UploadWizard.
AADDD The user has access to both the QueryWizard and the UploadWizard, but is blocked from adding, changing, and deleting records.
AAADD The user can use the QueryWizard and UploadWizard to add records only.
AADAD The user can use the QueryWizard and the UploadWizard to change records only.
AAAAD The user can use the QueryWizard and the UploadWizard to both add and change records, but is blocked from deleting records.
AADDA The user can use the QueryWizard and the UploadWizard todelete records only, but is blocked from adding or changing any records.
AAADA The user can use the QueryWizard and the UploadWizard to add and delete records, but is blocked from changing any records.