I have an older database from release 6.1 (I beleive) from the AS400, and I am backing all of the files off into CSV files. The next step will be to import the data into A newer Windows based version of Lawson. My client has not yet bought the new Lawson so I am not able to get any technical support from Lawson. My question is, is there a conversion tool that Lawson has that will take my CSV files from the old Lawson system and convert them to the newer Windows based Lawson files If not, what i...

We're going to be implementing an Applicant Tracking system and will need to interface data for applicants that are selected for hire into Lawson. Our existing hire process is manual and it invokes a custom DS form built off of HR11. Since we will be automating I was considering using HR511 (CSV) for this new interface. I've not used HR511 since we went live on Lawson - does anyone know if HR511 provisions the employee in Lawson to the same extent that HR11 does or is there extra work to be done...

Hello all: I'm looking for the best/easiest way to strip out those first 3 characters that exist on UTF output files from Crystal scheduler.  Does anyone have any recommendations We are Sun Solaris Unix running 9.0.1 apps and env. It just appears on the first record, and we need to get rid of it. Thanks for the help, all.

Is anyone using SAML to develop security trusted interfaces to ADP from Lawson If you do, please contact me ASAP. Thanks in advance, Roger

We are currently using TIDAL as an enterprise job schedular. We would like to also use it to trigger and manage Lawson jobs - whereby we can manage timing and dependencies between Lawson jobs and non-Lawson jobs. NOTE: am aware that TIDAL has an extension product of: Lawson Enterprise Adaptor Does anyone have experience with either:  - usage of the TIDAL Lawson Enterprise Adaptor - costs, effectiveness, complexity  - interfacing between TIDAL and Lawson without the use of the above adap...

If anyone has some experience with this - would really appreciate some feedback. We are on Lawson 9 - Windows Platform - Financials(AR) In incidences where a given entry screen does not support inputting an overt Lawson 'Operator' (AROPTR) - Lawson will write a windows-based ID to the USERNAME field(s).  EXAMPLE: Payment Batch/Header - ARPYMNTHDR.OPR_CODE  (NT00000023) This appears to be a Lawson/Windows identifier - as in looking at tables in GEN (R_USER.USERNAME, QUEUEDJOB.USERNAME, U...

Does anyone have experience with interfacing Supply Chain item data with EPIC's Optime or Optesia  The costs on the IC525 and IC527 don;t seem to work and we need to create something else.

Hello there: I'm new to Lawson. I'm looking for APIs/powershell script to add/remove a user from Lawson. Any tips will be greatly appreciated. Thanks much.

Hi Forum!  This is my first post so please be gentle!  Seriously though, my company is interested in improving the quality of employee data entered within MSS.  To that end, we are having some issues with valid address entry.  Given some of the new ADP payroll functionality rejects bad address information, we are researching the possibility of integrating with a 3rd party address verification service (at this point, we really like the USPS web service offering).  Has anyone else done this before...

Hello, In COBOL program, I need to replace the empty fields with double quote. how to do this My out is in CSV format.

Currently out employee ids are the employee's ssn.  We are planning a project to convert these to a random number and start using Lawson to create a new employee id for new employees.  Has anyone gone through this process  Was it done in-house or did you use an outside consulting company or Lawson professional services  Any advice, wisdom or gotchas is greatly appreciated!   Thanks, Cindy

Hi all,   New to the forum and Lawson.   I am based in the UK with a lot of UK Locale PCs, which don't seem to like Date formats from our current version of the Lawson Query Wizard Add in. It keeps fetching the wrong date value into Excel for any US Date that can be read as a UK date. The rest it flips correctly. Causing me headaches to get it to stay consistent.   I can convert the incoming column to Text, Number or Date and makes no difference. I figured that the Add in might be preset t...

Has anybody migrated scripts and job steps which utilize the 'sudo -u userid' command to submit jobs as other users or execute commands as other users from a Unix (AIX, HPUX etc..) platform to windows Looking for alternatives to rewriting a bunch of scripts and breaking jobstreams (multi-step jobs executing other user's - system accounts - jobs), which will run under native Windows or Cygwin layer.

Is there an API to right Justify an alpha-numeric field. 'JUSTIFIED/JUST  RIGHT clause is not working in WS storage section with alpha numeric variables.     Thnx,   Vijay

Any Guess in which form are customer comments stored in Lawson. They are stored in the Header of table OEORDCMNT (L_HOOC).   Thanks,   Vj

Just wondering if anyone has experience with specifically interfacing data from ScriptPro TPMS to Lawson for the G/L   Looks like they will only provide 2 canned reports that can be dumped to CSV files and then we have to do our own merging/mapping prior to import to GLTRANSREL.  Wondering if anyone has already been down this road....  TIA   LauraP

Because we don't have a true job scheduler (like Tidal - which works awesome with Lawson!) - I'm looking for a way to create a custom calendar and have programs key off of that to determine whether a program should run or not based on whether it is a holiday, etc.  We have jobs that we do not want to run on holidays and as far as I can tell there is nothing in the Lawson job scheduler for that.  I was thinking of create a custom database calendar - that could be updated once a year via a Lawson ...

Hello, I'm an accountant for a health insurance/care provider. We are migrating from an antiquated in-house software to a newer Epic product called Willow to manage pharmacy inventory. We have been testing for some time now. One problem that we have not been able to solve yet is a rounding variance that occurs as Willow rounds financial transaction data down to hundredths. No one here seems to think we can import any more than two places to the right of the decimal. I'm having a hard time belie...

Hi, I need to connect to LAWSON HR from an external application. I need to perform some operations via external application and need information regarding any SOAP/ REST APIs available to cater to my need. Could some body help me with API documentation.

Hi all.   Does anyone have .imp files for the M3 data import tool that I can reuse  We are having a debate with merit in Norway regarding our upgrade prosject of Movex and they say that we 'must' use the M3 data import tool to upload data, but we all agree that it`s and and they don`t seem to be able to help us good enough.  I see that we have to make .imp files to use in the import tool and when I ask them if they might provide us with those files used on other projects, we get a good, l...

Is it possible to upload the comments using MS-Addins

I have successfully installed the Lawson Information Investigator (LII) and was at the point of interfacing it with Infor Support Assistant (ISA) when I discovered that I would need to install something called 'perl module IO::Socket::SSL'.  I was directed by Infor to visit a website called cpan.org and from there was able to locate the install file.  The only instructions in their 'Install Instructions' is the following: perl -MCPAN -e shell install IO::Socket::SSL I went into QSH and ran the...

I could really use some help - this is really stumping us.  We have a cloned program of IC522 that we named BI523.  It's been working fine on our AIX operating system..  This weekend we moved our Lawson applications from AIX to Linux.  Now when we run the job - the custom program is no longer creating the .idx file and we can't figure out why.  I also ran the Lawson-delivered IC522 program and it does create the .idx file either.  All we did was bring the code over from AIX to Linux and recompil...

Hi all -   Asking for your input please!  Question on how you would do this.  I've done it both ways. We are going to be putting in ADFS this weekend and in a couple weeks, we are going to be installing another round of CTPs (we do these quarterly).  At my previous 2 employers, who both had Lawson - we never shut down every recurring job individually - the first thing we did is made sure no jobs were actively running in the job scheduler and then did stopjobqueue and that point no jobs could ...

I just left an installation where we made extensive use of a form called 'Lookup Table Update' it uses tables LUPTBLHDR and LUPTBLDTL. The version I used was NX10.1, but I think the more common version is IF10.1. It is even cataloged here on LawsonGuru: IF10 (lawsonguru.com).  I would like to install this form at my current installation, but I don't have the files. I placed a ticket with Infor and the techs I talked to have never heard of these forms.  I'm open to ideas on this! Thanks eve...