Archive for category: News

You are here: / News
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

3 ways cloud is changing ERP forever

According to Unit4 CTO Erik Tiden, Cloud is changing Enterprise Resource Planning (ERP) and altering the way we think about applications, organization and business models. The ongoing growth of cloud is the key to improving our experience of workplace enterprise applications. There are 3 ways cloud is reshaping ERP:

  1.  New innovations and service-led business models
  2.  Systems that know what you want before you do
  3.  People will rediscover the value of business computing

With ERP becoming self-driving and enhancing workers’ ability to provide better service, the advantages enabled by the cloud will become even more important for companies and will not only increase worker efficiency, but stand out from the crowd.

For Full Article, Click Here