Forum: S3 Interfaces/Conversion

 50 Subscribed to this forum
Page 2 of 4 << < 1234 > >>


Last Post

Interface Lawson with 3rd party Report System    

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 25246 2
by  SuhasJump to last post
10/1/2013 9:21 AM

Writing Rule With Date Function    

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 21209 0
by  Dennis AmoryJump to last post
4/30/2013 8:46 PM

Lawson Integration    

Started by  Elam
I would like to integrate Lawson System Foundation and Lawson Application 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 21788 1
by  Greg MoellerJump to last post
4/2/2013 2:46 PM

S3 web services pack    

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 4465 0
3/23/2013 6:50 PM

Handling Bad Data    

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 20886 1
by  Chad DirstJump to last post
3/14/2013 3:13 PM

AGS return from AP20    

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 21183 0
by  Lee BlattnerJump to last post
2/27/2013 5:42 PM

HIPAA 834 file    

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 22492 0
by  jaherbJump to last post
1/25/2013 5:13 PM

Immunization tracking in Lawson    

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 21220 1
by  John HenleyJump to last post
12/28/2012 3:27 PM

Oracle WAM interface into Lawson S3    

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 4281 0
11/7/2012 3:22 PM

HR511 Problem?    

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 4573 1
10/25/2012 10:29 AM

Any issues using PAEMPPOS table to evaluate FTE?    

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 3701 1
9/13/2012 7:47 PM

Inspect and replace with double quotes    

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 24789 2
by  Phil RomovJump to last post
7/2/2012 3:49 PM

IC500 - lost drill around functionality    

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 21996 0
by  Greg MoellerJump to last post
6/26/2012 4:00 PM

laua Security Issue - Please help!    

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...
21145 1
by  LauraPJump to last post
5/17/2012 12:02 PM

Need info about going from PFP to PFI current    

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 21540 1
by  cindy MHSILJump to last post
5/10/2012 12:51 PM

Add extra comma to the end of the CSV    

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 21376 0
by  NancyJump to last post
3/28/2012 7:18 PM

Add Run Group Param to AP520    

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 22055 0
by  Steven GrayJump to last post
3/25/2012 1:34 PM

AR503 - Converting Historical Payments    

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 3798 0
3/16/2012 2:47 PM

RQ10 Invoke    

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 21788 0
by  Greg MoellerJump to last post
2/7/2012 3:05 PM


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 22754 1
by  JimYJump to last post
11/7/2011 6:01 PM

Convert-> AR Cust & AP Vendor: One Shot?    

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 4741 2
10/20/2011 2:02 PM

AP520 Interface Data update from External Systems    

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 29252 0
by  Srini RaoJump to last post
10/3/2011 6:28 PM

Batch Processing API's    

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 23662 1
by  wwatersJump to last post
8/2/2011 6:12 PM

Customer Comment Conversion (ARICOMMENT)?    

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 21335 1
by  Ragu RaghavanJump to last post
7/5/2011 4:18 PM

Transaction Integration -> Lawson A/R    

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...
22191 2
by  Claudia W.Jump to last post
6/3/2011 1:13 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 2 of 4 << < 1234 > >>

RSS Feed Available