Custom Lawson Portal Message

How to add a welcome message or notification to the portal login page

Custom Lawson Portal MessageLet’s say you want to display a message on the login page for your users. It’s possible you just want to let the know about an upcoming outage, possibly about benefits enrollment dates, or just to tell them about a new event. There’s really no easy way to do that in Portal now. But with a little hacking you can get a really nice message displayed.

You’ll first want to go to the sso.war folder of your IBM profile where you login.htm resides. This can take a few minutes to locate as the Websphere directory structure is notoriously complex. Here’s an example from a client:

D:\IBM\WebSphere\AppServer\profiles\AppSrv01\installedApps\prodCell01\LawsonSecurity.ear\sso.war

Once there:

    1. Open the login.html file in your favorite text editor (I like editplus)
    2. Find the bottom portion of the login box. It’s just below the div that contains the “All rights reserved” message.
    3. Insert your own div there that contains your message and save. Here’s an example of mine:

 

<div style="position:absolute;left:5px;top:416px;width:452px;color=#FF0000;background:#FFFFFF;padding:5px" dir="ltr"><b>NOTICE: </b>Lawson will be unavailable on Tuesday, Sept. 29th.</div>

 

Keep in mind, each time you upgrade portal this message will likely disappear.

 

Lawson SQL Code Snippets

Two SQL queries that we found helpful in the Lawson Absence Management Suite

,
Lawson SQL Code Snippets

Lawson SQL Code Snippets

We don’t typically post technical information here on the blog, that’s mostly reserved for the education section of the site. The past couple of week however we were able to write a couple of queries that helped out a customer quite a bit so we figured maybe you all can benefit from them. Without any further delay, here they are:

 

 

-- Get available balances for employees in a specific group and/or plan
select E.COMPANY,E.EMPLOYEE,E.FIRST_NAME,E.LAST_NAME ,E.EMP_STATUS, T.R_PLAN, T.EMPLOYEE_GROUP,T.ACCR_LAST_DT,T.AVAIL_HRS_BAL
From [PROD].[dbo].TAEEMASTER T, [PROD].[dbo].EMPLOYEE E
Where 
-- T.EMPLOYEE_GROUP = 'EXAMPLE' and
T.R_PLAN='XXX' and
T.COMPANY = E.COMPANY and
T.EMPLOYEE = E.EMPLOYEE and
E.EMP_STATUS not like 'T%';
-- Obviously you'll have to change the Employee Group, the Plan code, and the Emp-Status condition to match yours.

This next statement does something rather unique. It reaches into GEN to get the status code definitions for the table field. Nifty!

-- Get all transactions for specific employee group and plan since a specific date including field transactions from GEN
select E.COMPANY,E.EMPLOYEE,E.FIRST_NAME,E.LAST_NAME ,E.EMP_STATUS, T.R_PLAN, T.EMPLOYEE_GROUP,T.TA_HOURS,T.DESCRIPTION,A.VALXLT as 'TYPE',B.VALXLT AS 'TRAN TYPE',C.VALXLT AS 'STATUS',D.VALXLT AS 'BALANCE TYPE'
From [PROD].[dbo].TAEMPTRANS T, [prod].[dbo].EMPLOYEE E , [GEN].[dbo].[VALLST] A, [GEN].[dbo].[VALLST] B, [GEN].[dbo].[VALLST] C, [GEN].[dbo].[VALLST] D
Where 
T.EMPLOYEE_GROUP = 'EXAMPLE' and
T.R_PLAN in('XXX','YYY') and
T.COMPANY = E.COMPANY and
T.EMPLOYEE = E.EMPLOYEE and
T.R_DATE >= '2015-01-01' and
A.DOMVAL =  T.TA_TYPE and
B.DOMVAL =  T.TRAN_TYPE and
C.DOMVAL =  T.STATUS and 
D.DOMVAL = T.BALANCE_TYPE and
A.PRODUCTLINE = 'PROD' and A.FILENAME='TAEMPTRANS' and A.FLDNAME='TA-TYPE' and
B.PRODUCTLINE = 'PROD' and B.FILENAME='TAEMPTRANS' and B.FLDNAME='TRAN-TYPE' and
C.PRODUCTLINE = 'PROD' and C.FILENAME='TAEMPTRANS' and C.FLDNAME='STATUS' and
D.PRODUCTLINE = 'PROD' and D.FILENAME='TAEMPTRANS' and D.FLDNAME='BALANCE-TYPE';

-- You'll have to change the Employee Group, the Plan codes, and the date condition to match yours.

3 Steps For Unlocking Hidden Value In Your CRM Data

Although Customer Relationship Management (CRM) systems can do a great deal of reporting customer data, brands need to better identify their high-potential customers to make more informed decisions about how to allocate marketing efforts. It takes three steps for marketers to make the most of their CRM systems, enhance their marketing models, and identify which consumers are optimal prospects for marketing and sales efforts:

  1. Analyze existing high-value customers – Marketers can go even deeper to build pictures of high-potential customers for specific products or sub-brands.
  2. Activate CRM data to narrow and prioritize the prospect audience – This helps identify the customers hidden within the CRM system that are more likely to be good matches for the product or service being promoted.
  3. Leverage high-potential customer personas in marketing efforts – Brands can focus marketing efforts on high-value consumers in the appropriate marketing medium.

These steps can help improve the cost efficiency of marketing efforts across the board. Marketing teams can feel more confident that their efforts are being directed at shoppers that are more likely to have the ability and interest to respond to each marketing promotion.

For Full Article, Click Here

7 Significant ERP Trends

Enterprise Apps Today interviewed IT experts to determine what’s going on with Enterprise Resource planning (ERP), where it’s all heading and what companies should be doing about it.

  • ERP’s Cloudy Future – Migrating to the cloud enables companies of all sizes to evolve their IT infrastructure.
  • Hybrid Cloud – Have the best of both worlds with on-premise applications AND cloud appications integrated to your system.
  • Better ERP Reporting – Improved reporting, facilitated by analytics and tighter integration is a current trend in ERP.
  • Fighting ERP Tradition – Companies hesitant of change want something that can help them solve their problems with simple solutions.
  • SMB ERP Adoption – The move to the cloud has led to greater SMB adoption of ERP.
  • ERP Platform Approach – There is a move toward businesses making a strategic platform choice first, and then working with individual departments to choose applications that fit the overall platform strategy.
  • ERP Vendor Consolidation – There will most likely be more mergers in the near future.

We are likely to see a growing cloud ERP presence, heavier SMB buy-in, more analytics and a smaller group of ERP vendors to choose from as the field continues to thin down due to mergers.

 

For Full Article, Click Here

Modern ERP: Greater Expectations

When considering Enterprise resource planning (ERP), several factors come to mind.  ERP provides basic human resource management capabilities, though as the customer starts to customize their system to their company’s liking, there are more things to consider when choosing the right system:

  • Define initial requirements
  • Use vendor demonstrations for research
  • Align teams early on
  • Get specialized treatment
  • Be open to change
  • User experience
  • Utilize on-demand training methods
  • Set realistic expectations
  • Communicate, collaborate and document
  • Consider TCO and growth
  • Move beyond functionality
  • Define flexible

A flexible ERP solution allows organizations to focus on the details that matter most to customers. Select an ERP that will support your current needs while providing a platform for growth.

For Full Article, Click Here

Infor buys GT Nexus to strengthen manufacturing ERP cloud

Earlier this month, Infor acquired supply chain management cloud software GT Nexus for $675 million, a move to broaden the capabilities of its Enterprise Resource planning (ERP) software. With customers including the likes of Adidas Group, Caterpillar, Columbia Sportswear, Levi Strauss & Co., Maersk, Pfizer, and UPS. Infor’s aims to strengthen its portfolio as the retail industry continues to shift towards contract-based manufacturing. Charles Phillips, chief executive of Infor, states “Together, Infor and GT Nexus will provide customers with unprecedented visibility into their supply chains to manage production and monitor goods in transit and at rest.”

For Full Article, Click Here

How predictive analytics will revolutionize healthcare

An academic medical center in New Hampshire is working to revolutionize healthcare with predictive analytics, wearable devices and the cloud. “It’s important to think about healthcare being on the precipice of what I think of as an industrial revolution,” says Dr. Jim Weinstein, president and CEO of Dartmouth-Hitchcock Health System. Weinstein’s goal is to improve patient outcomes, reduce costs and deliver more personalized care. To get there, healthcare providers must implement technology in a more automated, systematic way.

Connected devices such as blood pressure cuffs, pulse oximeter devices and activity tracker would collect data to be transmitted to the Azure Cloud via smartphone, where it’s pulled into a Cortana Analytics Suite dashboard at a contact center, helping to prevent people from getting sick in the first place by providing physicians with actionable data that can help them provide personal, optimal care.

 

For Full Article, Click Here

Lawson Security

Implementing Lawson Security is a relatively simple and straightforward procedure. If you are planning on taking on this challenge in-house we encourage you to follow the following steps:

  1. Spend time on gathering your requirements. This is by far the most important step of the process and you should have a good working document to begin with. If you need templates to start with, feel free to use our templates.
  2. Come up with a really great naming convention up front. This will save you all kinds of headaches in the long run. I like to add the word “Role” to all my roles, and “CLS” to all my classes, because later it makes them easier to read and understand as I’m trying to debug. You can come up with your own ideas but keep them consistent.
  3. Make sure you have a good backup process for your LDAP data and you have tested it. There is nothing worse than losing your entire implementation because of corrupt LDAP instances. It happens more than you know.
  4. Rome wasn’t built in a day. Don’t try to implement all the wishlist of every department in the first phase. Give them the necessities. After they have tested and accepted them, then move on to the fancier stuff.
  5. Ask us for a 30-day trial of LSF_IQ when you’re ready to implement because I can assure you that it will save you hundreds of hours of work.
  6. Clear all your cache when testing. I’m talking all your cache including:
    1. IOSCacheRefresh
    2. Browser Cache
    3. Security Cache
  7. Have a small group of testers. This will ensure that testing is completed in a reasonable time. Otherwise you will be chasing after users for their issues.
  8. Create a Google Spreadsheet for issue tracking unless you have a better tool.
  9. Roll out to one small group of users at a time. Remember, until check_ls is set to YES, users can still use LAUA

Last but not least, go to the education page on this site and look for webinars related to Lawson Security. There are several there that go over concepts.

Lawson Security Reporting

Read more

How to Find an ERP System That’s Easy to Use

If you’re trying to find a new Enterprise Resource Planning (ERP) system to use for  your business, consider the following when choosing the system for you:

  1. Simplify your business processes first – you should always look to simplify your business processes before implementing ERP software.
  2. Know what you need – Have a check list of needs, that way choosing the right ERP system will be easy.
  3. Get your whole team involved – Your company is as strong as your weakest link, so make sure you get input from every person in every department any needs they would have that an ERP system can solve.
  4. Train staff to understand your business processes – If your staff understands the way your business works and the processes which underpin it, they will have a good grounding in the logic which works behind the scenes of an ERP software solution.
  5. Enable the use of multiple applications – choose a system that is available on your mobile phone/tablet, too so you can access the data you need wherever and whenever.

For Full Article, Click Here