I am trying to write a query that will return APINVOICE, APDISTRIB, APVENMAST, and APPAYMENT information. Basically the user wants the Paid invoice detail information including vendor name and check number & date. I created the following query but it doesn't seem to completely work the way I would like it to do. It pulls the same invoice & distrib twice for each combination. In other words, if there is a single invoice with 2 distribution records, instead of the query returning 2 r...

How would one call a web service on another machine FROM lawson  The call would need to be made in the background without opening a new window.   The web service can accept either a POST or GET request.  For this request, the response is not processed but future request probably would need to process the response. I think the xmlhttp request is the answer but have no documentation on it's use. I've seen a lot of posts on calling into Lawson web services from external applications but nothing g...

I am seeking a third-party shop who is certified by Lawson/Infor to develop 'Connectors' with S3 and/or M3. Avalara is an Infor Partner, supporting eight (8) different Infor ERP platforms. I hope to find the A1 certified development partner for S3 and/or M3. Thank you for your help!

Hi all,  I am looking for some help on scripting in Lawson,  I am new to the software, looking to run a script to dump a table to csv file. I can run the  rngdbdump –c gen queuedjob >  jqstat.csv   from the server and it will run clean and dump the data to the csv file.  When I apply the same code in a script, nothing gets dumped to the csv file,  the file is created but no records in the file.  I also tried the jqstatus same issue.     wscript.echo 'VBS Script running parameters '  Dim objS...

Curious if anyone has done a database read (find) where the read places the data into a separate or unique working storage section.  Example READ VENMAST INTO VENMAST-PAY-VENDOR.

Is there a way to schedule a job automatically in 'recdef' and passing job parameters automaticcaly like To & From date range. They have to be from the past 7 days . Like for today's run , From-date=today, to-date=today-7 days.......      Thanks,   Vijay

Can I create a paintscreen program to access recdef

Hi Gurus - I'm stumped, and I need some ideas. We have a custom batch program that includes an error report.  I recently modified the program and the error report to add additional columns.  With the new columns, the report is too wide for the printed report but works fine in the CSV export in DEV. However, after promoting the changes to PROD, the report compiles and runs without errors in PROD, but some of the new columns are blank in the CSV including the error message column (from msgmnt). ...

Hi, is there a way to add 'themes' I found the  xhrnet/xml/config - emss_config_xml where it says themes but I am not sure where this is getting the theme files I can manually change the css link in the header.htm file to refer to a custom style sheet but wanted to know if there is a better way using themes I am running lawson 10 on webshere not via sharepoint.

Working on my first update form in PGMDEF and have run into a number of issues.  Currently, I can’t seem to get rid of the previous version of my form. Ideally it will have multiple PRDISTRIB records and allow just the account field to be updated.  At this point, it’s just and “online inquiry” that shows a few fields from the file. The problem is that I created a new version but Lawson won’t display it. Here’s the sequence: Create form in PGMDEF.  Run type is Prototyped and 4GL Quick painte...

We have a custom batch program that validates input date from a csv file. The date is never formatted properly and sometimes could be mddyy, mmddyy, or mmdyy. We want the date to be reformatted as mmddyyyy.  If the input date is 8 digits and mmddyyyy. then continue processing. Otherwise, check if the date length and fix it. Is there a Lawson API I can use to reformat the input date to be mmddyyyy

I am writing an SQL statement to select dates from a table and creates a file.  I want to convert date to string mm/dd/yyyy.  Any help would be greatly appreciated. select startdate from table;  this date is displayed as 31-MAY-15 so I want it displayed as 05-31-2015

I am not sure why I am not seeing the issue with a simple extract program... but I am at a loss at this point.    We have an extract file being produced as a 250 byte fixed length file.   There are 3 record types... a typical Header, Detail and Trailer record.  Each record must be delimited by  CR/LF characters. The logic writes the records to an intermediate sequential file and then at the end of the job it is reformatted by a cnvexp -f  filename  250  command to append the CR/LF characters a...

Hello, Is there a way to automatically send to Lawson a bunch of requests to a specified form via a Java http client  Actually I am able to do this, but it is very slow as I have to programmatically logon and logoff for each request.  I need to be able to log in once, and then send all the requests I need to.   Any time I send a request after the session has timed out, then I want to be able to detect this and re login, then send my requests.  Is there an API for this in either JAva or any ot...

I'm trying to do something that should be very simple - determine the existence of Comments on Invoice Messages, just like MA66 does when it needs to determine what text to put in the Message Button on the screen.  Simple, no I looked through the API manual to see if there was any voodoo involved - looked pretty easy. copied the code right out of MA66PD and dropped it into my program.              INITIALIZE                 WS-CMTMAG.              MOVE SPACES             TO CMTMAG-TYPE.  ...

When a 4GL program creates a CSV file, and numeric fields defined in that CSV contain ZERO values, BLANKS are substituted. Is there a way to force a ZERO instead Is there a setting in a configuration file that can do that Example: CSV file contains 2 fields, NAME and COUNT. The value in NAME = 'J.Jones' The value in COUNT = 0 Currently the CSV record for the above looks like... 'J.Jones', I need it to look like... 'J.Jones',0

Dear All, I have to copy a standard program having around 10 workfiles. We all know that Lawson doesn't change the name of workfile and WS-Field ID in work file definition while copying , It changes the same in PD (like wherever I am using WH130, it will change it to ZZ130 in PD/WS, The workfile name starting from WH130 doesn't change). It seems like I have to manually go into PD and change the name of all the Workfiles and other field. I had done it earlier also where there were like couple of...

I have developed a custom program that just calls a shell script.... When I try to add the job with the custom form in it, I get an error that says 'The value {1} is invalid for the parameter _TKN' Any clues what is happening here

I'm developing a custom program (update job) to invoke a copy of AP30.3, and keep getting the following error: File SYSTEST/TXTAXTABLE. tsBeginDBTransaction error is Operation illegal while in transaction (20). Does anyone know what this means and how to fix it Thank you

I have a design studio portal page that displays all the AP workunits.  I would like to filter the results to only include the accounting units that the users requester code has access to.  I get the requester code and I get the account units from the RQAcctU table.  How can I filter the results from the WFWORKUNIT table to only select the rows that have an accounting unit allowed.

I created AR15M from AR150, reentered all of the workfiles in workdef and get following error   PrcWRKFILE(): AR15M Not Found In WsGrp

Is there an API I could use to calculate the last day of any month

I am hoping someone can help me with a COBOL statement.  I haven't touched cobol in quite a while and my co-worker that usually works with our custom cobol is out of the office for a bit. I have a custom program that was excluding any employee with a term date in a file.  They now want to change it to include anyone termed that day.  The current statement is: IF (EMP-TERM-DATE > '00000000')             GO TO 1040-NEXT-EMPLOYEE. How do I change this to 'GO TO 1040-NEXT-EMPLOYEE' when 'EMP-T...

We are going from 1 company code to multiple company codes. Some of our custom Screen Rules (.sr files) Hard Code the company, so we need to know which programs use these hard-coded screen rules. Via grep (we're a UNIX shop), I've identified all 14 Form Rules that hard-code ('1111') Company.  However, when I tried to grep which programs used the Form IDs ('H1-EMP-S-0001' is one of the Form Rules, for example), I got no results.  Of the 14 Form Rules, 3 are Rules, 8 are Selects & 3 are SCRDTL.  I...

Not sure anybody has ever used Oracle ProCobol or not but....  Been working with Lawson for about 21 years now and at both of my previous employers we purchased our MF licenses via Lawson.  I also used Oracle ProCobol which requires a MF license as well.  never had a problem compiling/executing Oracle ProCobol programs - never had a license issue and Lawson worked fine as well. At my new employer, we are on Version 10 (previous employer was Version 8) and I can't get the Oracle program to compi...