Forum: S3 Interfaces/Conversion

 50 Subscribed to this forum
Page 1 of 41234 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Conversion from AS400 to WIndows    

Started by  Deleted User
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...
17 34125 1
by  PKSJump to last post
12/22/2015 2:59 PM

Interfacing new Employees into Lawson    

Started by  Joe O'Toole
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...
10 30725 4
by  Srini RaoJump to last post
4/27/2017 1:38 PM

UTF output files and conversion    

Started by  Greg Moeller
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.&160; Does anyone have any recommendations We are Sun&160;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.
2 59337 1
by  Sampath SJump to last post
3/19/2020 9:49 AM

SAML Programming language?    

Started by  Roger French
Is anyone using SAML to develop security trusted interfaces to ADP from Lawson If you do, please contact me ASAP. Thanks in advance, Roger
1 23814 1
by  MattHJump to last post
6/16/2014 8:49 PM

Enterprise Job Scheduling & Lawson (TIDAL)    

Started by  Garth Gerwing
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 ...
5 27000 4
by  KimmJump to last post
5/29/2014 5:09 PM

Translate USERNAME To A Login ID    

Started by  Garth Gerwing
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.U...
3 38261 0
by  Marsha DeMariaJump to last post
12/2/2013 9:03 PM

Lawson and EPIC Optesia    

Started by  brooke
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.
0 5478 0
11/21/2013 5:38 PM

Add/remove user from Lawson    

Started by  Brajesh Goyal
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.
0 3621 0
5/9/2014 2:53 PM

Address Verification Integration    

Started by  Troy Thompson
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 any...
2 22991 0
by  Troy ThompsonJump to last post
5/15/2014 7:05 PM

double quote in empty field    

Started by  Srini Rao
Hello, In COBOL program, I need to replace the empty fields with double quote. how to do this My out is in CSV format.
8 22587 1
by  jaherbJump to last post
11/19/2015 2:35 PM

Convert employee id from ssn    

Started by  Cindy
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
2 21079 1
by  Vijay SJump to last post
11/19/2015 12:32 PM

S3 Query Wizard - UK    

Started by  Chris Snape
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 mi...
1 20344 0
by  Chris SnapeJump to last post
7/2/2015 8:11 AM

sudo work-a-like for Cygwin    

Started by  Stuart Perkins
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.    
4 21619 4
by  Stuart PerkinsJump to last post
9/10/2015 6:24 PM

API to right justify an alphanumeric field    

Started by  Vijay S
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
3 20571 0
by  jaherbJump to last post
11/18/2015 2:27 PM

Customer Comments-OE    

Started by  Vijay S
Any Guess in which form are customer comments stored in Lawson. They are stored in the Header of table OEORDCMNT (L_HOOC).   Thanks,   Vj
2 19821 0
by  Vijay SJump to last post
5/12/2016 2:35 AM

GL Interface to Lawson    

Started by  LauraPat
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
0 3162 2
6/27/2016 5:19 PM

Custom Calendar    

Started by  LauraPat
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...
3 19935 2
by  jaherbJump to last post
7/8/2016 3:43 PM

More places to the right of decimal    

Started by  John Chappell
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 ...
2 20325 1
by  Ben CoonfieldJump to last post
8/18/2016 6:31 PM

Need SOAP/ REST API document to connect to Lawson HR V10    

Started by  SAgrahari
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.
1 23000 0
by  Mark PetereitJump to last post
10/3/2016 1:57 PM

.imp files for the M3 data import tool    

Started by  rhenricks
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, w...
1 23753 1
by  Thibaud Lopez SchneiderJump to last post
11/10/2016 8:39 PM

Comments Upload    

Started by  Srini Rao
Is it possible to upload the comments using MS-Addins  
0 3247 1
4/26/2017 7:23 PM

Configuring Information Investigator to interface with Support Assistant    

Started by  GCAMM84
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 a...
0 3623 1
7/31/2017 2:34 PM

.idx files not being created    

Started by  LauraPat
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 ...
0 3676 1
9/12/2017 3:45 PM

Recurring Job Question for patching    

Started by  LauraPat
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 ...
2 21317 1
by  LauraPatJump to last post
2/5/2019 3:36 PM

IF10.1 or NX10.1 Lookup Table Update    

Started by  Raphael Bernard
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&39;t have the files. I placed a ticket with Infor and the techs I talked to have never heard of these forms.  I&39;m ...
2 26252 0
by  John HenleyJump to last post
1/24/2023 2:52 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 41234 > >>


RSS Feed Available