News, Events and Articles
You are here: / News, Events and Articles

Tips For Using deljobhst

, ,

Often our Lawson print queues get cluttered and out of hand.  Lawson’s deljobhst command is a really great tool for cleaning up your batch jobs.  It can clear the clutter from your user’s print managers, as well as free up some space on your server.  Run this command in LID.

For each of these commands, you must provide a “ToDate” in MMDDYY format.  So, if you give it an end date of 033119, for instance, you would delete all the selected job history up to March 31, 2019.

You also have the option of providing a user’s account so that you just perform the delete for a specific user.  There is also a from date option that allows you to manage job history for a specific date range.

We recommend setting up some of these commands on a schedule to keep your Lawson server happy & healthy.

Here is a summary of the command:

The -w option will delete all waiting jobs, so jobs in recovery and jobs with Invalid Parameters.  After you run this, there will not be any jobs listed in the waiting queue for the specified user (or all users) up to the specified run date.

The -c option deletes all completed jobs.  This is a great way to clean up user’s job schedule print manager lists.  This action removes the data from the QUEUEDJOB table.  It does not remove print files.

The -r option removes all the print files associated with batch jobs, that were created up to the specified to date.  This will help keep your server from getting too cluttered.  Make sure you back up your print directory, especially if you have a retention policy at your organization.  If you run the command so that it deletes ALL print files (so delete everything up to today), it will delete your entire print directory.  Don’t panic!  It’ll be created the next time a user runs a batch job.

From Risk To Return: Making ERP Data Migration A Strategic Win

ERP (enterprise resource planning) transformations promise streamlined operations and smarter decision-making—but only if the data powering them is accurate and reliable. As Shiv Kaushik, Chairman & CEO of ICCG, explains in his Forbes article, data migration is often undervalued, yet it’s one of the biggest risks to ERP success. Many organizations enter ERP projects with fragmented, duplicated, or outdated data. Treating migration as a technical task—rather than a strategic priority—leads to delays, cost overruns, and broken business processes. Successful ERP projects treat data migration as a business-critical initiative. This involves executive sponsorship to prioritize clean, reliable data, cross-functional collaboration between IT and business teams, and strong data governance and use of automation tools.

To reduce risk and drive value, Kaushik advises:

  1. Assess current data sources and systems

  2. Establish governance early in the process

  3. Clean and standardize data before migration

  4. Automate testing and validations

  5. Engage end users in testing, not just IT

  6. Train users on new data structures and tools

ERP success depends on data readiness. When data migration is led strategically—with the right focus and leadership—it becomes a powerful enabler of long-term value, not just a project hurdle.

For Full Article, Click Here

MSPs: Are you ready for the next evolution of ERP?

As more small and midsize businesses (SMBs) outgrow traditional enterprise resource planning (ERP) systems, Managed Services Providers (MSPs) have a powerful opportunity to step in with a smarter solution: SAP Business ByDesign (ByD). In his article for ManagedServicesJournal.com, technical director Atit Shah highlights how this cloud-first ERP solution is ideal for fast-scaling businesses—and for MSPs ready to offer more value. SAP Business ByDesign, for example, brings together finance, HR, CRM, supply chain, and project management in a single, modular platform. With built-in analytics, AI-powered automation, and a scalable foundation via SAP HANA, businesses gain real-time insights and operational efficiency. For MSPs, ByD means recurring revenue and strategic partnerships. From implementation to training and performance monitoring, the cloud-native model simplifies support while enabling ongoing services. Its open APIs and evolving AI features ensure it grows alongside client needs. More than an ERP system, SAP Business ByDesign is a foundation for smart, sustainable growth. And this is just one major player. Expect other ERP powerhouses like Oracle or CloudSuite to follow a similar path. For MSPs looking to stay ahead, it’s the right tool at the right time.

 

For Full Article, Click Here

Building a .cbl for Infor

, ,

There are times that Infor support will ask for a .cbl of a program in your Lawson system.

 

When working with Infor Lawson systems, you may encounter situations where Infor support requests a .cbl file for a specific program. This is because .cbl files contain the source code for programs written in COBOL, a language commonly used in business software like Lawson.

Why Infor Support Might Ask for a .cbl file:

  • Troubleshooting Program Errors: If a Lawson program is not functioning correctly, providing the .cbl file allows Infor support to examine the source code to identify and diagnose the issue.
  • Investigating Program Behavior: The .cbl file helps Infor support understand the program’s logic and how it processes data, which can be crucial for resolving unexpected behavior or performance problems.
  • Analyzing Customizations

 

Resolution :

At the command prompt, type bldsh productline system code program

Example: bldsh test IC IC130

This will create a .cbl in your LAWDIR/productline/xxsrc directory.

What parts of ERP will be left after AI takes over?

ERP (enterprise resource planning) systems aren’t disappearing—but AI is dramatically reshaping how we use them. In a recent piece for CIO.com, senior writer and IT journalist Grant Gross explores how generative AI and embedded copilots are transforming ERP from a static system of record into a dynamic, intelligent assistant. Tasks like invoice processing, reconciliations, and financial reporting—traditionally labor-intensive—are now being automated with the help of AI. Vendors like SAP (via Joule) and Microsoft (via Copilot) are already deploying tools that summarize procurement, create reports, and interpret data using natural language. This shift doesn’t eliminate ERP. Instead, it enhances it. AI acts as a productivity layer, freeing teams from repetitive tasks so they can focus on strategic analysis and decision-making. At IBM, Gross uses for example, AI agents now flag billing errors, draft board reports, and summarize account variances—boosting both efficiency and margins. What’s emerging is a more modular, AI-driven ERP ecosystem. Task-specific agents will interact with ERP data behind the scenes, leaving the core system in place but changing how users experience it. The ERP becomes the reliable data source; AI becomes the interface. In short, Gross states that ERP is staying, but your interaction with it is about to look and feel very different—so be prepared.

 

For Full Article, Click Here

Lawson Comments & Attachments

, ,

Many Lawson screens have comment buttons that open a drill-around screen with different comment types.  If you have ever wished to query these comments for reporting or other user interfaces, you may have noticed that they are difficult to find.  Infor has “hidden” them in tables with the “L_H” prefix.  This is the “header” for the comment.  If there are any details that spill over the available characters in the commend, there will also be a record in the corresponding L_D table.  The naming convention is “L_HXXX” or “L_DXXX” where “XXX” is the prefix of the table that feeds screen where you add the comments.  For instance, Requisition Header comments can be found in “L_HRQH” and “L_DRQH”.  Join the comments to your main record using the “L_INDEX” column in the parent table.

Upcoming Events September 2025

Mark your calendars for these upcoming virtual and in-person lawson events to kick off the Fall!

 

Monthly Office Hours

Hosted by: Infor

When: Tuesday, September 9th, 2025 from 12:00 to 1:00 (US/Eastern)

The HCM product team will be holding monthly open office hours for customers, partners and fellow Inforians to ask their questions on rolling out this important set of features.  We will be pairing these office hour sessions with quarterly update webinars on the regular Innovation Insights series to overview product improvements as we continue to innovate on this functionality.

View/Register Now

 

FSM Monthly Office Hours – September

Hosted by: Infor

When: Thursday, September 11th, 2025 from 12:00 to 1:00 (US/Eastern)

We invite all our FSM customers to join us for a monthly office hours session to help with your organization’s Web App Consolidation rollout.  Bring your questions, concerns, and feedback to our product team experts so that we can help ensure you have a successful adoption of this key feature!
Open to customers, partners and Inforians!

View/Register Now

 

New Infor Spreadsheet Designer 2025

Hosted by: Infor

When: Wednesday, September 24th, 2025 from 12:00 to 1:00 (US/Eastern)

In this session you will learn about the new version of Infor Spreadsheet Designer to be released in October 2025.

Speakers – Elizabeth Paran, Francis Bullet Sandico

Please use this Master KB for customers to get more information.

Downloadable invite here –  Invite.

View/Register Now

 

Western Infor User Group Fall Conference

Hosted by: Western Infor User Group (WIUG)

When: Tuesday, September 30th, 2025 to Wednesday, October 1st, 2025

Mark Your Calendar, Tell Your Friends, and Watch for Upcoming Announcements for More Details!

Western Infor User Group Fall Conference: Sept 30 – Oct 1 2025
Location: Valley Medical Center
Renton Washington

We are excited to invite you to the upcoming in-person Western Infor User Group event September 30 – October 1 where you can unlock the full potential of Infor’s industry-specific solutions.

Innovation at work is key to your business success. Come hear from Infor about the latest innovation tools and solutions they are developing and discover how you can utilize these tools to help your employees save time and focus on high-value tasks.

This is a great opportunity to share, learn, and collaborate with other like customers, Infor, and our partner network.

*Shuttle service will be provided between hotel and conference location in the morning and the evening on 1st day and morning and end of conference on 2nd day

Agenda details to come:

  • General Track
  • V10 Track
  • Cloverleaf Track
  • Finance Track
  • Supply Chain Track
  • Technology Track
  • HCM Track

Click the link below to view the event Agenda, fees, and hotel event code.

View/Register Now

Avoiding costly ERP and cloud systems implementation failures: A perspective from the deal room

ERP (enterprise resource planning) and cloud implementations often fail—not due to tech flaws, but because of rushed decisions and poorly defined contracts. In his article on CIO.com, Sean Christy highlights how critical missteps often happen before the project begins. A key issue is the “timing imperative”—the pressure to move fast. This often leads companies to skip due diligence and sign multi-year contracts with vague commitments and limited exit options. One major trap: loosely written Statements of Work (SOWs). Phrases like “assist with data migration” sound supportive but typically place full responsibility on the client. Add in misleading “fixed-fee” models, and costs can quickly spiral. Christy stresses the importance of stakeholder alignment. When legal, IT, and business units aren’t on the same page, contracts fail to reflect real operational needs.

To avoid these failures:

  • Fully vet solutions before signing.
  • Keep vendor options open until terms are locked in.
  • Push for clear, specific SOWs.
  • Involve executive sponsors early.
  • Resist pressure to rush the deal.

ERP and cloud projects rarely fail at go-live—they fail in the negotiation phase. Preparation and clarity are your best safeguards.

 

For Full Article, Click Here

Native vs. Third-Party Apps: Why Where Your Data Lives Matters

Choosing native SuiteApps over third-party solutions for AP automation ensures greater security, scalability, and data accuracy—especially when leveraging AI-powered OCR—while streamlining processes like month-end close through seamless NetSuite integration. In her latest article on ERP Today, technology writer Radhika Ojha highlights a key decision for NetSuite users automating Accounts Payable (AP): use a native SuiteApp like SquareWorks or a third-party add-on? Rahul Jairaj of CloudPaths makes a compelling case for staying native. While third-party tools may seem cost-effective, they introduce risks with data sync and integration. Native apps, on the other hand, live entirely within NetSuite, offering a single source of truth. That means better security, data integrity, and a more seamless automation experience that scales with your business. Jairaj also unpacks the “magic” behind AI-driven OCR (invoice scanning), a must-have for modern AP teams. However, expecting 100% accuracy from day one is unrealistic. A native app allows teams to train AI in a NetSuite sandbox, working up from a 70% success rate to near-full accuracy over time. The impact on AP teams is transformative. Native automation shifts their focus from data entry to exception handling and analysis—adding strategic value. And when data lives natively in NetSuite, it drastically simplifies month-end close, eliminating manual reconciliations and improving reporting accuracy. Ojha concludes, if you want reliable, scalable AP automation that grows with your business and strengthens your ERP, then go native.

 

For Full Article, Click Here