50 Subscribed to this forum
Search this forum:
Search
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.
Topics
 Replies
 Views
 Subscribers
 Last Post
1 Replies and 32929 Views and 0 Subscribers How do you reference the current date in 4GL?  32929  1  0 Started by  Deleted User Hello Everyone, I am writing an interface that will select data the previous week. I would like know how to get the current date so I can determine my date range. Thanks in advance! Bonnie PS. If you could reply to my e-mail address that would be great. bwhite2tufts-nemc.org
1 32929 0
by  John HenleyJump to last post
9/15/2005 9:05 PM
2 Replies and 29880 Views and 0 Subscribers How do you export the whole database?  29880  2  0 Started by  Deleted User Is there a way to export the Lawson database in its entirety without going datamart-by-datamart I'm trying to export all the corporate Lawson data into an ASCII star schema but am only able to extract one mart at a time. Does anyone know a way within Analytic Architect (or otherwise) to extract all the tables and structures at once into an ASCII star schema (So I can load it into Oracle, we do not use Essbase or Microsoft Analyis Service). Thanks in advance.
2 29880 0
by  Deleted UserJump to last post
11/3/2005 6:27 PM
17 Replies and 33734 Views and 1 Subscribers Conversion from AS400 to WIndows  33734  17  1 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 33734 1
by  PKSJump to last post
12/22/2015 2:59 PM
1 Replies and 29689 Views and 1 Subscribers AC data conversion  29689  1  1 Started by  Keri White My company recently converted from one Lawson company to another. In this process we converted open AR invoices. Since we use AC/BR to create AR invoices, I need to find a way to update the AC/BR data related to the open AR invoices I converted so that in the event an invoice needs to be cancelled (via BR21) the reversing entries point to the correct company. Is this possible Does a conversion program for this sort of thing even exist Thanks! Keri
1 29689 1
by  John HenleyJump to last post
1/12/2006 12:57 AM
12 Replies and 36185 Views and 3 Subscribers IC527 Item Interface  36185  12  3 Started by  Steve Williams Do any users here use IC527 to generate an item master report, or any of the other IC52X reports I'm right now in a slightly heated email exchange with GSC, due to the fact that our IC527 reports have the purchase UOM price inserted into the 'Patient Charge' field (CD3, field 25). We don't have or use the PC module at all, and the database element that this information is supposed to come from is empty - actually, the whole table is empty (PCCHRGITEM). None of the KB articles or the IC...
12 36185 3
by  Greg MoellerJump to last post
7/21/2006 2:39 PM
1 Replies and 30056 Views and 1 Subscribers Load Data Onto Portal Screen  30056  1  1 Started by  Deleted User My company has a program that new employees use to learn about the company and they also input their employee information and select benefits from this program. It is saved into a database. Is there a way to load that data onto HR11 portal screen for example so that it can then be validated and saved into the Lawson DB
1 30056 1
by  John HenleyJump to last post
4/19/2006 9:28 PM
3 Replies and 30370 Views and 2 Subscribers Migating from DB2 on zOS to UDB on AIX  30370  3  2 Started by  Deleted User Has anyone tried this migration We are concerned that the Lawson Utilities may not be able to cope with the migration of EBCDIC to ASCII. How does it handle Packed Data fields Are there any issues we need to address ASAP We are getting 'no problem' answers from Lawson Support but I have burnt too many times not to make sure with the rest of the customer base. Thanks.
3 30370 2
by  John HenleyJump to last post
5/2/2006 5:50 PM
5 Replies and 33304 Views and 3 Subscribers EDI and 834 data  33304  5  3 Started by  Greg Moeller We are implementing the transmission of Benefit Enrollment data to the insurers, using the BN106 application. Lawson does not currently support the translation of the HIPAA834 data file into EDI X12-04010 834 format. What translator engines are other clients using for processing the HIPAA834 data files
5 33304 3
by  John HenleyJump to last post
6/4/2008 11:49 PM
0 Replies and 13714 Views and 0 Subscribers Interface to Lawson  13714  0  0 Started by  Deleted User As I mentioned before, we are moving to a program called EPIC to do some of the financial work - Pateient Refunds - that send a csv to us to import to APCINVOICE. I have a couple of questions about the refund file before I ship it off to Epic. CVI-VENDOR - Spec states that this field is alpha. Can I put a numeric value here for the vendor ID YES. CVI-BATCH-NUMB - Is this the date of the file CVI-TAX-PNT-DATE - Is this the date of the file CVI-DUE-DATE - Is this the da...
0 13714 0
8/14/2006 6:38 PM
0 Replies and 13361 Views and 1 Subscribers pt accounting interface  13361  0  1 Started by  linda phillips WE are currently looking to interface creative socio medics with lawson. Has anyone done this interface and if so are you will to share your information. we are 8.03-msp8 and ser pk 4. This will be a once a month interface
0 13361 1
8/15/2006 1:30 PM
5 Replies and 31524 Views and 0 Subscribers gltransrel upload  31524  5  0 Started by  linda phillips Has anyone uploaded files into gltransrel and have the system add a leading number to the file We are 8.03 msp8,ser.pk 4 and we are trying to load a file into the system. It has taken a for an example a credit for 10.00 and made it 210.00. The system added a leading 2 to every number if it was a credit or a debit. If anyone could help shed some light on this, It woulds be appreciated
5 31524 0
by  linda phillipsJump to last post
9/21/2006 9:23 AM
1 Replies and 33311 Views and 1 Subscribers apcinvoice  33311  1  1 Started by  Deleted User I get this error when doing 'importdb' with the csv file. The field it is referencing as 'too large' is blank Error: tsStoreDBRec error is Database error (94). Additional information is 1843. Additional Text is: StoreSqlRec(LAWSON.APCINVOICE) OCIStmtExecute() returned OCI_ERROR code 1843 parse offset 88997888 ( ORA-01843: not a valid month ) Error at line 2, Field 65: is too large for field size of 25 2 Record(s) Proc...
1 33311 1
by  Greg MoellerJump to last post
9/26/2006 7:19 PM
1 Replies and 30221 Views and 1 Subscribers LP570 PTO Balance upload conversion  30221  1  1 Started by  Deleted User I'm trying to run the LP570 to upload our PTO balances for our implementation. I get this vague error: Unable To Open File With Mode 'r' KB articles state this could be a variety of things. I have the file name in uppercase, I have RW access, etc. I've pointed jobdef to where I stored this file (same place I put the other conversion files which worked fine). I'm baffled and in a desperate situation as the LIS/Help Desk is taking their time guessing what this could po...
1 30221 1
by  Deleted UserJump to last post
2/25/2007 5:36 AM
2 Replies and 29667 Views and 1 Subscribers Conversion of Customized Lawson App. to RPGILE  29667  2  1 Started by  Deleted User Hi, We have a customized Lawson application running in Unix Operating System. We are in the process of converting the application to RPGILE in Iseries. I need clarification as below 1. Do I have to convert all the programs manually in RPG ILE or is there an utility or tool which can be useful for converting all the source code from COBOL.UNIX to RPGILE/AS400 2. How to go about converting the database, indexes , business rules .. etc in Iseries 3. How to load existing ...
2 29667 1
by  Deleted UserJump to last post
4/12/2007 4:21 AM
0 Replies and 13388 Views and 2 Subscribers Payroll History removal  13388  0  2 Started by  Deleted User We are in go-live and want to use our current data system as our go-live with the exception of the data created by running a payroll (want to remove any evidence that we ran a payroll). I've reviewed various items in the data file text and technical text in effort to find out what tables would have to be 1) wiped out and 2) what tables would need values reset (i.e. comphist and coda). Apparently the pr300 purge of hist does not take out everything. Does anyone have the info on this, is it...
0 13388 2
4/13/2007 4:11 PM
1 Replies and 30055 Views and 1 Subscribers hr04 conversion program?  30055  1  1 Started by  Deleted User I did not see a conversion program for the hr04 items and was wondering the best way to get this info from our test environment into our live...which has to be either manually put in or converted. The addins I think involve hidden fields and are quite complex. Does anyone have a template for the addins or any ideas. (I'd like to just copy the database table, but I know that this will bypass the edits and is not supposed to be done). thanks
1 30055 1
by  John HenleyJump to last post
4/14/2007 9:18 PM
0 Replies and 12912 Views and 1 Subscribers PR560 payroll history  12912  0  1 Started by  Deleted User We are pressed to get our 2007 payroll history into the system and I had a few questions. The consultants made this sound as if it was going to require extensive testing. If my upload sheet passes in report mode, I'm assuming that it will pass in update mode. I'm also assuming that the system will then take the data and properly add to the current totals in the system (though I plan to query to check)...but is this really supposed to be this complex of a project I know that we've worked ...
0 12912 1
9/21/2007 12:16 PM
2 Replies and 31457 Views and 3 Subscribers bn106 834 file format woes  31457  2  3 Started by  Deleted User I've done some reading and research enough to know that the bn106 is not going to give me what I need to transmit to the various benefit vendors. My question is - how far does this file take you and what remaining things have to be accomplished before you have a file ready to send Will this require a programmer or special software Any suggestions are appreciated.
2 31457 3
by  Sam SimpsonJump to last post
9/25/2007 1:41 PM
0 Replies and 12480 Views and 1 Subscribers 850 Correction Progam ???/  12480  0  1 Started by  Deleted User Has anyone created a Cobol program to correct transations (IE INVALID SHIPTO) I was trying to steamline the correction process.
0 12480 1
11/14/2007 1:35 PM
4 Replies and 29221 Views and 1 Subscribers Multi Product line in COBOL PROGRAM ??  29221  4  1 Started by  Deleted User Can you access tables in LOGAN Product LIne from another PRODUCT LINE in COBOL I am trying to get to WEBUSER in a Batch Application program.
4 29221 1
by  John HenleyJump to last post
12/4/2007 12:28 AM
2 Replies and 29635 Views and 3 Subscribers Interfacing Lawson with GE Centricity DMS  29635  2  3 Started by  Deleted User Just wondering if anyone has interfaced with GE centricity DMS system (It's our cath lab's Hemodynamic/inventory system) If so, what Lawson interface sis you use for issues (ie: IC500, RQ500, etc) and what item master interface (ie: IC524, IC523, etc. and if issue came up during implemetation that would be helpful to know beforeheand. Thanks n advance Scott
2 29635 3
by  Greg MoellerJump to last post
6/5/2008 7:41 PM
2 Replies and 27121 Views and 1 Subscribers RQ500 and Cerner/Surginet  27121  2  1 Started by  Greg Moeller Wondering if anyone is successfully interfacing Surginet pref card data into RQ500. We were told by Cerner that they would not write us an interface, so were thinking if we could come up with the data, we could get it into the format that RQ500 is expecting. Anyone out there using Surginet with Lawson What types of interfaces do you have implemented We'll share ours with you!
2 27121 1
by  Greg MoellerJump to last post
2/5/2008 7:54 PM
3 Replies and 21817 Views and 1 Subscribers What do you do when a divestiture occurs??  21817  3  1 Started by  Tim Salaver I have an issue that I'm trying to resolve which I don't believe is easy. My client is going through a divestiture of one of its companies so it needs to group 15 companies into 2 separate environments to their respective acquiring organizations. The expected result is to have a set of companies that appear completely separate as if they were always like that. &160; I know I can't use any of the Lawson utilities because none of them separate the data by field. For instance, I want all of rela...
3 21817 1
by  John HenleyJump to last post
3/6/2008 1:16 PM
21 Replies and 49811 Views and 1 Subscribers 803 to LSF9  49811  21  1 Started by  Sam Simpson Just recently the new LSF9 env/apps has been completed (). I have been tasked to test some of the application programs. I have not have the success of running them so far. My question are: 1. Are there any differences between 803 and lsf9 applications like HR, AP, PO etc programwise 2. Will LSF9 provides a new copy of the application (cobol programs)&160; &160;&160;&160; Appreciate any help on this. &160; Sam
21 49811 1
by  John HenleyJump to last post
6/9/2008 9:53 PM
9 Replies and 25735 Views and 3 Subscribers loaduser.xml  25735  9  3 Started by  Deleted User Has anyone automated the loaduser.xml for adding Wen Users to Portal in LSF9.0 If so, how did you do it We have anywhere from 20-50 New Hires per week, and ALL New Hires use Employee Self-Service, but do not have an LID acct. In the past we used Add-Ins (Query & Upload) to RD30, but this&160;is no longer available on LSF9 (RD30) so, I am curious if anyone has automated and used the loaduser.xml in LSF9 Any info is greatly appreciated. &160; &160;
9 25735 3
by  Roger FrenchJump to last post
11/24/2008 5:18 PM
2 Replies and 24332 Views and 1 Subscribers LSF9 Implementation  24332  2  1 Started by  Deleted User Our company is in the process of getting ready to implement LSF9. We are running into some questions concerning the implementation of the environment and the applications at the same time. Has anyone done this at the same time If so what are the pros and cons associated with doing it this way compared to upgrading the environment and then applications
2 24332 1
by  Kwane McNealJump to last post
7/11/2008 6:34 PM
1 Replies and 22673 Views and 2 Subscribers Cardinal FTP  22673  1  2 Started by  Deleted User Anyone out there transferring files to/from Cardinal via FTP We are converting our connection from EDI to FTP for this particular&160;Vendor. We would like to speak with anyone utilizing this method. &160; Thanks!
1 22673 2
by  Deleted UserJump to last post
11/13/2008 3:10 PM
7 Replies and 24720 Views and 2 Subscribers Scripting  24720  7  2 Started by  dap We are planning our Lawson upgrade from 8.0.3 to LSF9.&160; As part of the upgrade we are moving from UNIX/Oracle to Windows/SQL.....yes I know this sounds like a step backward but beyond my recommendations.&160; We have a lot of custom programs that call UNIX scripts for various reasons but mostly to move files to a windows server.&160; When we go to Windows we need a new scripting tool as we cannot use UNIX.&160; We have researched MKS&160;Toolkit and it does not accomplish everything we ...
7 24720 2
by  ichibenJump to last post
9/23/2008 5:31 PM
1 Replies and 21484 Views and 1 Subscribers Impact of Lawson upgrade on other custom application  21484  1  1 Started by  Pravin We currently have an environment 8.0.3 with 8.1 application. We are planning to install LSF 9.0 on new server and then migrate the 8.1 applications to the new environment. Wanted to check what will be impact of environment upgrade to other custom application built around it. For e.g We have Lotus Notes application which connect Lawson using DECS. Internally DECS either invokes AGS call or DME call to update & reterive data from Lawson. So will this interface needs to be redesign or will th...
1 21484 1
by  John HenleyJump to last post
5/21/2008 2:18 PM
0 Replies and 5164 Views and 1 Subscribers FTP in 9.0LSF  5164  0  1 Started by  linda phillips I'm not sure if I have the right area but here goes. We are 8.03 apps on 9.0LSF env. Like all of you FTP is a mjor hitter in the lawson world. We are RCO and have had a number of issues with FTP. WHen you pull the files from Lawson such as a csv file you get a broken pipe message or the file does come across but not complete.&160; If I try and move a file csv to the system so we can interface with lawson I get broken pipe or again not all the file comes across but it reads comp. Has anyone had ...
0 5164 1
6/5/2008 12:41 PM
0 Replies and 4137 Views and 0 Subscribers Form wont recognize script  4137  0  0 Started by  Deleted User Can anyone help&160; I insert this script, in design studio on PO31; even if the text37 is empty the process still goes through and dont trigger the script to run. function BUTTON_OnClick(id, row) { &160;if (id == 'button8')&160; //When the shipped button is pressed &160;{ &160;&160;var compValue=lawForm.getFormValue('text37'); &160;&160;if (compValue == '') &160;&160;{ &160;&160;&160;alert('Message'); &160;&160;&160;lawForm.positionInFieldById('text37'); &160;&160;...
0 4137 0
8/6/2008 6:24 PM
3 Replies and 24517 Views and 1 Subscribers Cbord Interface  24517  3  1 Started by  weizened We are attempting to Interface Lawson with our Cbord Food & Beverage software.&160; We have some files from Cbord but are having trouble testing them with Lawson, does anyone know how we can test these against Lawson to see if they are in the correct format.
3 24517 1
by  Greg MoellerJump to last post
8/11/2008 2:26 PM
2 Replies and 25042 Views and 1 Subscribers Interface Tables apcinvoice & apcdistrib  25042  2  1 Started by  Wanda Schaaf I am new to the Lawson environment and need to write an interface from an outside system into the Lawson invoice tables. (i.e. apcinvoice and apcdistrib). Before I get to deep into the procedure I am writing, I want to know this question:&160; Does Lawson allow us (IT Developers) to directly insert into the interface tables using a procedure (sql server) instead of using the importdb tool&160; I have asked lawson support this question, but am still waiting for an answer.&160; I am automatin...
2 25042 1
by  Sam SimpsonJump to last post
9/11/2008 1:38 PM
0 Replies and 4682 Views and 1 Subscribers 9.0LSF Transaction/Erp?_f0=?  4682  0  1 Started by  Russ For any value I enter for field _f0, the below xml returns (what is valid for _f0): IFAC.1&160; &160;&160; &160; 000&160;&160;&160;&160; 001 &160; _f0
0 4682 1
9/19/2008 6:12 PM
0 Replies and 4503 Views and 1 Subscribers Error: 5 - .dtl File and RptMap Version Mismatch  4503  0  1 Started by  Mick After the migration from 8.0.3 to LSF9 enviornment (Hp-UX) this error appeares when trying to view any report prior to the migration date. Now, Lawson suggest reruning the report (which does work) but there are some people out there that has, well, how do we say 'years' of reports.&160; It was suggested to run a srgen productline which did happen and did not resolve the error/issue.&160; Any thoughts on how to correct this other than reruning years of reports There is one work a...
0 4503 1
10/21/2008 10:53 AM
2 Replies and 22167 Views and 3 Subscribers cath lab hemodynamic systems  22167  2  3 Started by  Dave5 We are in&160;initial startup&160;of process and design to implement Lawson to our healthcare system, has any other institutions done this yet Have any interfaced their hemodynamics to Lawson for Patient charge capture and inventory replenishment Presently our hospital system will eventually standardize hemodynamic systems but at present with 3 cath labs we have GE Mac-lab, Whitt, and Philips Whitt Thanks for any input
2 22167 3
by  Dave5Jump to last post
4/7/2009 5:39 PM
2 Replies and 21676 Views and 2 Subscribers Inteface development methodology and standards  21676  2  2 Started by  Kristie Bowman Hello, We are preparing to implement Lawson with our initial go-live scheduled for March of 2010. We will be utilizing a combination of PFI and our Cloverleaf engine for our interfaces. We are looking for advice and lessons learned pertaining to process flow development methodology, file naming conventions, and coding standards.&160; Does anyone have information or recommendations to share Thanks, Kristie
2 21676 2
by  Kristie BowmanJump to last post
5/7/2009 6:23 PM
0 Replies and 4187 Views and 1 Subscribers Writting to MACINVOICE  4187  0  1 Started by  Deleted User Has anyone experience writing directly to MACINVOICE&160;&160; I asked Lawson and it looks like they have customers that do do this.&160; Any tips for doing this Thanks
0 4187 1
5/7/2009 4:10 PM
3 Replies and 21425 Views and 1 Subscribers mass delete of AP520 interface  21425  3  1 Started by  Deleted User I&160;uploaded an AP520 with Update=Y in error (in a dev environment). Is there a way to mass delete all these records Thanks for any assistance--not finding anything documented in Lawson KB.
3 21425 1
by  Deleted UserJump to last post
6/8/2009 5:54 PM
2 Replies and 21095 Views and 2 Subscribers User Analysis Values copying-moved from other thread  21095  2  2 Started by  brihyn Wanted to bump the topic in the other forum to see&160;if there's any answers&160;and noticed this forum listing...figured while bumping it, i'd move to a more appropriate area. So...anyone have any hints or tricks for this original request Thanks! Brian Hynes We're still in the implementation phase of Lawson. The users have been working in a training pdl, and as of next week, will be moving to a conversion pdl. I'm being asked if we can somehow get the User Analysis values copied over ...
2 21095 2
by  brihynJump to last post
8/10/2009 12:37 PM
0 Replies and 4079 Views and 0 Subscribers Job is crashing when a Lawson program is invoked by another Lawson program  4079  0  0 Started by  Jinu Hi All, I am invoking a Lawson Online program from another Lawson user exit program. But my batch job is crashing by saying an error message 'Pointer not set for location referenced'. This happened when my online program is is trying to do an RPG I/O operation on a Lawson DB file. Did anybody come across such an error before, if so, could you please guide me to resolve this issue
0 4079 0
9/4/2009 3:18 AM
1 Replies and 20832 Views and 1 Subscribers Recurring Interfaces  20832  1  1 Started by  MattK I have daily interface files coming through&160;importdb and I'd like to create a recurring job to convert these files to GL daily, via gl165.&160;&160;These interface files carry&160;the same run group name (there are multiple per day with different run group names), the only difference for each of these files from day&160;to day is the day of the month is concatenated to the end of the run group name so that the files do not try to overwrite each other as they come through.&160; Do I nee...
1 20832 1
by  mark.cookJump to last post
10/20/2009 11:13 AM
10 Replies and 30278 Views and 4 Subscribers Interfacing new Employees into Lawson  30278  10  4 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 30278 4
by  Srini RaoJump to last post
4/27/2017 1:38 PM
2 Replies and 58868 Views and 1 Subscribers UTF output files and conversion  58868  2  1 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 58868 1
by  Sampath SJump to last post
3/19/2020 9:49 AM
2 Replies and 25241 Views and 0 Subscribers Difference between PO Issued Received and Closed?  25241  2  0 Started by  willz06jw Thanks for reading this email, What is the difference between POs Issued, POs Released, and POs Closed Thanks for the help, W
2 25241 0
by  willz06jwJump to last post
3/30/2010 6:44 PM
12 Replies and 28628 Views and 0 Subscribers AP520 Interface Data update from External Systems  28628  12  0 Started by  Sri Hello Friends, I am new to the Lawson system and forums. I am trying to Integrate Lawson system using BizTalk tool. I do not have access to Lawson system. I am trying to create NonPo Invoice(AP520). Does Lawson expects two .CSV files one for header data and other for Detail data. Thanks for the help. With Regards Sri
12 28628 0
by  Srini RaoJump to last post
10/3/2011 6:28 PM
3 Replies and 21438 Views and 1 Subscribers expose lawson db  21438  3  1 Started by  Raj HI I'm new to Lawson systems.All i want to do is to bring in Accounts payable tables into my Datawarehouse. wondering how easy or hard lawson exposes its db Any thoughts thanks in advance Raj
3 21438 1
by  RajJump to last post
9/15/2010 10:09 PM
2 Replies and 22948 Views and 0 Subscribers Java Program to make a AGS call in Lawson 9  22948  2  0 Started by  nafri Hello All, I am trying to write a java program to make a AGS call in Lawson9. I wrote this app in Lawson8 without issues. Since Lawson9 uses SSO, I am finding it difficult. I am not a Lawson expert and would appreciate all your responses. Thanks.
2 22948 0
by  lankharJump to last post
3/31/2011 2:24 PM
3 Replies and 25752 Views and 1 Subscribers Best Practice for Integrating Maximo Work Order system to Lawson Inventory  25752  3  1 Started by  Ollerton We are working on a 2 way interface between lawson and maximo work order system.  Part of the workflow is staff will reserve materials on a work order in maximo. Maximo item master and inventory balances are syncronized with Lawson.  When someone reserves materials in Maximo, I want the interface to reserve the materials in Lawson. What is the best method to reserve the materials in Lawson I need a pick ticket as a result. I was thing RQ10 as that is the method that people g...
3 25752 1
by  Greg MoellerJump to last post
4/5/2011 8:16 PM
1 Replies and 20059 Views and 0 Subscribers Magnifying glass ON/OFF ???  20059  1  0 Started by  superswan Easy question How do I switch the zoom glass on & off
1 20059 0
by  superswanJump to last post
3/9/2011 10:55 AM
4 Replies and 20859 Views and 0 Subscribers Lawson TX Triggering External Events?  20859  4  0 Started by  Garth Gerwing We will be required to integrate between an in-house developed application and the Lawson Financials. For near/real-time integration requirements - we plan to leverage the IOS services layer that currently supports the Portal. So....pushing/pulling data to/from Lawson based on external events - no problem. But does anyone have any experience with monitoring Lawson activity (either transactional or data) in order to trigger activity externally Like 'listening' to TX's or servlets - something ...
4 20859 0
by  Jason BeardJump to last post
4/15/2011 2:31 PM
2 Replies and 22845 Views and 0 Subscribers tsStoreDBRec error is Key change not allowed (32)  22845  2  0 Started by  Denise When attempting to add or change a vendor via an interface from another application, we get the above referenced error. Has anyone else had experience with addressing this error
2 22845 0
by  Sampath SJump to last post
4/26/2011 8:04 AM
1 Replies and 21565 Views and 2 Subscribers Transaction Integration -> Lawson A/R  21565  1  2 Started by  Garth Gerwing We are required to integration transactions (Invoices, Debit/credit memos) from a non-Lawson billing application -> A/R. The billing application will be an in-house J2EE application - so ideally, we would like to enact this integration on a real/near-time service basis. Existing transactional integration to A/R is kind defined as a 2-step, batch-oriented approach: 1) Populate ARITRANS/ARIDISTRIB and optionally ARIITEM - via AR97.1,AR97.2, AR97.5 2) Execute batch job of AR560 to move da...
1 21565 2
by  Claudia W.Jump to last post
6/3/2011 1:13 PM
2 Replies and 20749 Views and 1 Subscribers Customer Comment Conversion (ARICOMMENT)?  20749  2  1 Started by  Garth Gerwing I see that Lawson has provided a staging table to support comment conversion (ARICOMMENT - consumed by AR506) - and that by leaving the 'transaction/invoice-related' elements blank, the process will interpret these comments as 'Customer' comments.  However: - there are appears to be no on-line dialogue to support conversion corrections (as per other conversion constructs) - the ARICOMMENT table has a single 'Comment' element of 40 CHARS (which is less apace than desired) Does anyo...
2 20749 1
by  Ragu RaghavanJump to last post
7/5/2011 4:18 PM
6 Replies and 22835 Views and 1 Subscribers Batch Processing API's  22835  6  1 Started by  wwaters Has anyone used the Lawson Batch Processing API's I am trying to use ULOADJOB and UCRTJOB to update my PO120 job definition. The program retrieves the current job definition via ULOADJOB, changes the PO field to the PO that I am working with, and then issues UCRTJOB to update the PO120 definition. The program runs, but the job definition is not being updated. I am not seeing an error message anywhere indicating what went wrong. Please help!!
6 22835 1
by  wwatersJump to last post
8/2/2011 6:12 PM
1 Replies and 23457 Views and 1 Subscribers SAML Programming language?  23457  1  1 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 23457 1
by  MattHJump to last post
6/16/2014 8:49 PM
0 Replies and 4131 Views and 2 Subscribers Convert-> AR Cust & AP Vendor: One Shot?  4131  0  2 Started by  Garth Gerwing We need to convert all of our customers into Lawson AR. Our plans are to eventually use the AR->AP integration (as per AR48) -whereby AR credit values can be transported to AP for refund purposes. Lawson facilaites this AR->AP integration via 'linking' an AR Customner occurrence to a corresponding AP Vendor occurrence. Is anyone aware of an Lawson conversion/'integration construct whereby we can convert our customer base to both AR Customer & AR Vendor in one shot - which would include th...
0 4131 2
10/20/2011 2:02 PM
5 Replies and 22164 Views and 1 Subscribers RQ511  22164  5  1 Started by  Lynne Has anyone used RQ511 for order interfacing from Omnicell  If so, do you have the detail line of the input file  Lawson can't seem to provide it to me or tell me how RQ511 works.  Thanks!
5 22164 1
by  JimYJump to last post
11/7/2011 6:01 PM
5 Replies and 26582 Views and 4 Subscribers Enterprise Job Scheduling & Lawson (TIDAL)  26582  5  4 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 26582 4
by  KimmJump to last post
5/29/2014 5:09 PM
5 Replies and 21253 Views and 0 Subscribers RQ10 Invoke  21253  5  0 Started by  Srini Rao Hello - I'm trying to bring the requisitions into Lawson from external system. We used the RQ500 but we are consistently facing an issue with interface. I'm thinking to re write the interface to create RQ10 records directly into RQ10 by Invoking the RQ10 in custom program. When I invoke the RQ10 for ADD function, some reason it does not initialize lot fields and it returns error messages. Do I need to any special functions before RQ10 ADD functions
5 21253 0
by  Greg MoellerJump to last post
2/7/2012 3:05 PM
0 Replies and 3299 Views and 0 Subscribers AR503 - Converting Historical Payments  3299  0  0 Started by  Garth Gerwing Does anyone have any experience using the Lawson AR Payment conversion process: ARCPAYMENT->AR503 We are required to convert/import historical payment occurrences from an external system. Our plan for payments is to track the source/type of payment via the 'Pay Code' value(s) - which are at the payment batch level. However - the AR Payment Conversion process/data apparently does not allow for me to qualify my payment data by 'Pay Code' - even though the on-line and interface of payments v...
0 3299 0
3/16/2012 2:47 PM
2 Replies and 21510 Views and 0 Subscribers Add Run Group Param to AP520  21510  2  0 Started by  desichet Since AP520 does not offer Run Group Parameter as found on MA540 OR GL165. I there a way to add new Parameter on AP520 screen and execute AP520 using new Param We need AP520 to process only selected records where Batch Number, Auth Code will not work. We are usign Lawson 9.0.1 on system-i. 
2 21510 0
by  Steven GrayJump to last post
3/25/2012 1:34 PM
2 Replies and 20807 Views and 0 Subscribers Add extra comma to the end of the CSV  20807  2  0 Started by  Nancy We have a 4GL program that we have written to output a CSV file for one of our vendors. The vendor has stated that they need a ',' at the end of each CSV record after the last field in that record. Does anyone know how to get the extra comma at the end of the last field  We thought about adding another field to the record and just moving a comma into the field but because the file has each field enclosed in double quotes  the comma ends up being in double quotes also. &...
2 20807 0
by  NancyJump to last post
3/28/2012 7:18 PM
4 Replies and 20984 Views and 1 Subscribers Need info about going from PFP 9.0.0.4 to PFI current  20984  4  1 Started by  cindy MHSIL Can anyone give me info on a conversion from PFP to PFI recently.  Needed knowledge, how long how hard what kind of testing.  We dont have many existing flows to convert.  Any usful info about current PFI
4 20984 1
by  cindy MHSILJump to last post
5/10/2012 12:51 PM
11 Replies and 24613 Views and 2 Subscribers Interface Lawson with 3rd party Report System  24613  11  2 Started by  ArthurThum We need to interface 3rd party report spolling system to Lawson. Need to be able to take Lawson reports and attach parms to them to pass to command line lpr command. Looking for way to get reports from prtmgr and pass them and what they are named to a script to setup this command.
11 24613 2
by  SuhasJump to last post
10/1/2013 9:21 AM
1 Replies and 20602 Views and 1 Subscribers laua Security Issue - Please help!  20602  1  1 Started by  LauraP Apps - 8.0.3  Environment - 8.0.3 Unix Oracle Yesterday we hit max users in laua (2,000 is max - we had 2,062).  All users after the 2,000th user lost all access in Lawson. And I couldn't see any users in laua past the 2,000th entry. We changed the parameter (to 3,000), bounced Lawson, rebuilt the security dictionary (just to be thorough).  I can now see ALL users in laua again - but the problem still exists with all users after the 2,000th user having no access to Lawso...
1 20602 1
by  LauraPJump to last post
5/17/2012 12:02 PM
2 Replies and 21397 Views and 0 Subscribers IC500 - lost drill around functionality  21397  2  0 Started by  LauraP Using IC500 to load inventory transactions to Lawson: We currently use IC500 with the 'F' Flat File option in the job parameters and it works fine.  After the transactions process, the user can look them up in IC50 and all drill around functionality/data is there and works fine. We are changing the IC500 job to use the 'T' (Table) flag instead of the 'F' (Flat File) flag for input. I have populated the ICCTRNHDR and ICCTRNLIN tables as identified in the Lawson documentation.  ...
2 21397 0
by  Greg MoellerJump to last post
6/26/2012 4:00 PM
2 Replies and 24200 Views and 2 Subscribers Inspect and replace with double quotes  24200  2  2 Started by  jcarrott I am trying to inspect for a character '' and the replace it with a ' (double quote) on a windows system. The system does no seem to support single quotes or hex. I used '' as a simple place holder that I wanted to replace with a double quote. Does anybody know how to do this
2 24200 2
by  Phil RomovJump to last post
7/2/2012 3:49 PM
0 Replies and 3192 Views and 1 Subscribers Any issues using PAEMPPOS table to evaluate FTE?  3192  0  1 Started by  Sarah I am testing a new eligibility file that will be going to a vendor. We are required to send current employees who are eligible, employees who were eligible but are now ineligible because of a status change (old FTE>=.40 and newFTE Below is the criteria in a crystal report I put together (EMPLOYEE table has an outer join with PAEMPPOS so you can get the previous FTE on PAEMPPOS) to test the file. Our programmer is using PERSACTHST and is looking at reason codes to determine when an employee has ...
0 3192 1
9/13/2012 7:47 PM
0 Replies and 3964 Views and 1 Subscribers HR511 Problem?  3964  0  1 Started by  Mickey TMP1.1845 file HR511PRW The workfile is trying to update a record and get this error Operation sequence for member TMP1.1845 not valid Any ideas  Basically created the CSV and want to update a record in Lawson.  Thanks in advance    
0 3964 1
10/25/2012 10:29 AM
0 Replies and 3714 Views and 0 Subscribers Oracle WAM interface into Lawson S3  3714  0  0 Started by  jb2012 I'm looking for vendors that have demonstrated the capability to interface Oracle WAM into Lawson S3. We have two divisions that will not be abandoning Oracle WAM and do not want to rekey requisitions into Lawson S3. Are there best practices and what companies are leaders in accomplishing this Thank you!
0 3714 0
11/7/2012 3:22 PM
1 Replies and 21931 Views and 0 Subscribers HIPAA 834 file  21931  1  0 Started by  RickyY Hi, we recently switch our health insurance to Delta and they are requiring a HIPAA 5010 834 file. Has anyone generate the 834 from Lawson to a vendor We are new at the 834 and not sure where to start. Any advices, sites, or suggestion is greatly appreciated. Again something in detail would be nice because we're very new at it. Thanks. Ricky
1 21931 0
by  jaherbJump to last post
1/25/2013 5:13 PM
1 Replies and 20674 Views and 1 Subscribers Immunization tracking in Lawson  20674  1  1 Started by  Alex Just curious as to the prefered place in Lawson to store immunization information. We store it in our EMR but also like to store in Lawson. Thanks
1 20674 1
by  John HenleyJump to last post
12/28/2012 3:27 PM
3 Replies and 37809 Views and 0 Subscribers Translate USERNAME To A Login ID  37809  3  0 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 37809 0
by  Marsha DeMariaJump to last post
12/2/2013 9:03 PM
3 Replies and 20624 Views and 0 Subscribers AGS return from AP20  20624  3  0 Started by  Lee Blattner I added an AP Invoice to Lawson from an external application and checked the XML response for API-OBJ-IDr0 and got 0 (zero). I checked the AGS return in Lawson AP20.2 itself and it was also 0 (zero). Maybe 5 or 10 minutres later, there was a 7 digit number but it does me absolutely no good if I can't get the OBJ_ID from the XML response. Is there a way to get the APINVOICE.OBJ_ID when the invoice is created Or am I missing something
3 20624 0
by  Lee BlattnerJump to last post
2/27/2013 5:42 PM
2 Replies and 21239 Views and 1 Subscribers Lawson Integration  21239  2  1 Started by  Elam I would like to integrate Lawson System Foundation 9.0.1.8 and Lawson Application 9.0.1.6 to push the Contract file, Item Master file, Vendor Catalog file into Lawson system and retrieve Item Master, Invoice History, PO History, Vendor Master from Lawson System. Gurus please let me what is best way to develop a solution
2 21239 1
by  Greg MoellerJump to last post
4/2/2013 2:46 PM
2 Replies and 20375 Views and 1 Subscribers Handling Bad Data  20375  2  1 Started by  Chad Dirst Greetings, We have some bad data in our database which is causing issues in one of our interface programs.  We are working on ensuring this data does not get entered on the front end, however, we are also looking to have checks in the interface program to ensure we can handle the data appropriately.   Here is a sample of the data as seen via SQL     Staplesßéó  Medium-Weight Here is a sample of the data as seen in the Debugger:   ...
2 20375 1
by  Chad DirstJump to last post
3/14/2013 3:13 PM
0 Replies and 3931 Views and 0 Subscribers S3 web services pack  3931  0  0 Started by  Gary M. Hi, I'm very new to the Lawson products.  We have S3. Can anyone tell me what I can find detailed information on the S3 web services pack  I'd like to know what wsdls are available.  Also, does it require an extra license Thanks, Gary
0 3931 0
3/23/2013 6:50 PM
4 Replies and 20665 Views and 0 Subscribers Writing Rule With Date Function  20665  4  0 Started by  Dennis Amory I am writing a security rule that uses the date util functions dateFormat( ) and dateDiff( ). The rule is successful if I enter a hardcoded date in the function (such as '20051130' or '04/24/2013'), but not if I enter the field from a form (such as form.TRD_TR_DATE). Any idea how to fix this
4 20665 0
by  Dennis AmoryJump to last post
4/30/2013 8:46 PM
0 Replies and 5066 Views and 0 Subscribers Lawson and EPIC Optesia  5066  0  0 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 5066 0
11/21/2013 5:38 PM
0 Replies and 3317 Views and 0 Subscribers Add/remove user from Lawson  3317  0  0 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 3317 0
5/9/2014 2:53 PM
2 Replies and 22644 Views and 0 Subscribers Address Verification Integration  22644  2  0 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 22644 0
by  Troy ThompsonJump to last post
5/15/2014 7:05 PM
8 Replies and 22241 Views and 1 Subscribers double quote in empty field  22241  8  1 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 22241 1
by  jaherbJump to last post
11/19/2015 2:35 PM
2 Replies and 20731 Views and 1 Subscribers Convert employee id from ssn  20731  2  1 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 20731 1
by  Vijay SJump to last post
11/19/2015 12:32 PM
1 Replies and 20008 Views and 0 Subscribers S3 Query Wizard - UK  20008  1  0 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 20008 0
by  Chris SnapeJump to last post
7/2/2015 8:11 AM
4 Replies and 21247 Views and 4 Subscribers sudo work-a-like for Cygwin    21247  4  4 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 21247 4
by  Stuart PerkinsJump to last post
9/10/2015 6:24 PM
3 Replies and 20212 Views and 0 Subscribers API to right justify an alphanumeric field  20212  3  0 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 20212 0
by  jaherbJump to last post
11/18/2015 2:27 PM
2 Replies and 19474 Views and 0 Subscribers Customer Comments-OE  19474  2  0 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 19474 0
by  Vijay SJump to last post
5/12/2016 2:35 AM
0 Replies and 2783 Views and 2 Subscribers GL Interface to Lawson  2783  0  2 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 2783 2
6/27/2016 5:19 PM
3 Replies and 19582 Views and 2 Subscribers Custom Calendar  19582  3  2 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 19582 2
by  jaherbJump to last post
7/8/2016 3:43 PM
2 Replies and 19962 Views and 1 Subscribers More places to the right of decimal  19962  2  1 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 19962 1
by  Ben CoonfieldJump to last post
8/18/2016 6:31 PM
1 Replies and 22561 Views and 0 Subscribers Need SOAP/ REST API document to connect to Lawson HR V10  22561  1  0 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 22561 0
by  Mark PetereitJump to last post
10/3/2016 1:57 PM
1 Replies and 23331 Views and 1 Subscribers .imp files for the M3 data import tool  23331  1  1 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 23331 1
by  Thibaud Lopez SchneiderJump to last post
11/10/2016 8:39 PM
0 Replies and 2850 Views and 1 Subscribers Comments Upload  2850  0  1 Started by  Srini Rao Is it possible to upload the comments using MS-Addins  
0 2850 1
4/26/2017 7:23 PM
0 Replies and 3092 Views and 1 Subscribers Configuring Information Investigator to interface with Support Assistant  3092  0  1 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 3092 1
7/31/2017 2:34 PM
0 Replies and 3274 Views and 1 Subscribers .idx files not being created  3274  0  1 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 3274 1
9/12/2017 3:45 PM
2 Replies and 20882 Views and 1 Subscribers Recurring Job Question for patching  20882  2  1 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 20882 1
by  LauraPatJump to last post
2/5/2019 3:36 PM
2 Replies and 25594 Views and 0 Subscribers IF10.1 or NX10.1 Lookup Table Update  25594  2  0 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 25594 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.


RSS Feed Available