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.
Page 2 of 3 << < 123 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 1064 Views PA71 Job Budget upload  1064  0 Started by  Deleted User Can MS Addins be used to upload job budgets to PA71  I have a spreadsheet of records to be add and to expire existing ones.
0 1064
09/06/2012 7:27 AM
0 Replies and 1613 Views Using Addins to Set-up New Hires PR12  1613  0 Started by  MattH Hi, We receive a file from an onboarding web site as our employees are hired which contains their PR12/direct deposit information.     Each employee may have up to 3 deposit records. Has anyone done much with the PR12 upload for new hires   It seems to be working very well for me with a single upload record, but, when I get multiple, it always wants to make the first record the Default Account and I haven't found away to have it auto-assign ACH Distribution Number. Also, w...
0 1613
09/04/2012 5:45 PM
5 Replies and 2240 Views Update to HR11 works in LID but not Add-Ins  2240  5 Started by  Dennis Setliff We are still using LAUA/LID. I can directly update the Phone Number on HR11 in our Dev and Prod environments/product lines. I can us Add-Ins to update the Phone Number through HR11 in our Dev environment/product line but I get a 'Security violation' return message in our Prod environment/product line. I copied the security class from Dev to Prod thinking there may be a difference in LAUA but still get the same message. Any suggestion on where or how I could track down the 'Securit...
5 2240
by  Dennis SetliffJump to last post
08/21/2012 2:55 PM
2 Replies and 3338 Views DME Query String  3338  2 Started by  AJ I am trying to go through the DME query wizard in MS Addins to produce a DME query for an infoset that I want to create.  I am using the S3 query wizard and selecting database tables as the query source.  I go through and select the tables and fields that I want to return and add the criteria under the criteria tab.  However, when I click the view string icon at the top of the dialog box, the entire query string is not being shown. I do not see the fields that I selected or any of...
2 3338
by  AJJump to last post
08/09/2012 12:23 PM
4 Replies and 2517 Views Query brings back dates, but excel 2010 displays as a number  2517  4 Started by  Terrie We were on Windows XP, Office 2010, and when I did a query, it brought back the data in excel and displayed correctly.  We recently upgraded laptops to Windows 7.  Now when I do same query, it brings back data and displays dates as number. It only does this for me.  It doesn't do that on another person laptop who was give Windows 7. Has anybody seen or experienced this  Any suggestions on what I can do to stop this Thanks
4 2517
by  TerrieJump to last post
07/25/2012 1:37 PM
2 Replies and 2040 Views Special Characters Introduced through AddIns  2040  2 Started by  Allison Terry Hello, I'm new to Lawson. I work with addins while maintain the Item/Vendor Masters... Every once in a while a special character gets loaded into the Lawson database that is not on our excel worksheet or it is hidden.  We make every effort to copy and paste using Puretext and we remove spaces but these characters are still introduced.  I wanted to know if anyone else has had this issue and what they did to resolve the problem. Thanks. Allison
2 2040
by  Allison TerryJump to last post
07/03/2012 3:17 PM
5 Replies and 2622 Views Blanking Out a Field (GL20.7)  2622  5 Started by  Dave Mitchell I've tried everyting I can think of, excepting any 'special characters', from a space, to multiple spaces, to a hyphen, and nothing seems to work. We're on Lawson 9.01 with Lawson S3 Add-In's (version 9.0.3.1) using Excel 2010 on Windows XP. If anyone has an idea, my email is Mitchell.Dghc.org 
5 2622
by  Dave MitchellJump to last post
06/21/2012 9:22 AM
9 Replies and 5557 Views Add Ins Error  5557  9 Started by  Deleted User Can someone tell me what this addins error may mean - Filter cannot begin with '&' or '|' We just moved to apps v901, and queries that have never had problems are now returning this error.  Seems to happen most often if I try to use criteria that is any option other than '='.  I'm on the most recent add-ins version Thanks in advance - I'm almost bald from pulling my hair out over this one!!
9 5557
by  Sherry ShimekJump to last post
06/06/2012 10:41 AM
1 Replies and 1833 Views HOLD CODE Query Assistance  1833  1 Started by  Katfra Hello, Could someone give me a little assistance in writing a query in AP that would give me HOLD CODES  I've tried different combinations with tables to achieve this but failed each time.  I'm trying to produce a query that give me the following: Company, Invoice, Invoice DTE, Invoice Description, Process Level, Vendor, Vendor-Vname, Vendor Group, Tran Inv Amt.  I've used the APINVOICE and APPAYMENT tables and was able to pull in the HOLD CODE fields due to relationshi...
1 1833
by  JonAJump to last post
05/18/2012 6:47 AM
0 Replies and 1432 Views Upload in ZQ20 Contact Tab  1432  0 Started by  upasana Hello, Could anyone please help me in knowing the process if any field is required to be changed in ZQ20 what should be the parameters of excel file to be uploaded and what should be the process to be followed. I need to make changes in ZQ20 Contact 4 MISC details. Please let me know about the upload function and the relevant field name that is to be used. Thanks in Advance Upasana Mehra
0 1432
05/11/2012 11:12 AM
1 Replies and 1900 Views All Position in a Process Level  1900  1 Started by  upasana Hello, Could anyone please help me in writing a query to provide positions with their respective Job Codes in a Process Level using Lawson AddIns. I need this information for various clients. Thanks in Advance Upasana Mehra
1 1900
by  WoozyJump to last post
04/16/2012 4:36 PM
0 Replies and 1923 Views Upload Multi-Line invoice to BL20?  1923  0 Started by  katsmily Hello! My company uses the Lawson Excel Add-In to upload into Lawson.  One of the things we upload are invoices into BL20.  We are able to upload a number of different invoices and even invoices with up to 4 lines.  But we're unsure how to create an excel file to upload invoices with more than 4 lines.  Right now our 4 line invoice upload file has the difference lines listed horizontally across the columns in excel, using fields F100:0,F102:0,F103:0,F107:0, etc through F100:...
0 1923
04/11/2012 1:13 PM
1 Replies and 2353 Views Trying to create DME query that returns blank and/or constants  2353  1 Started by  David Britton I am trying to build a DME query that will return a variety of fields from the EMPLOYEE and PAEMPLOYEE tables, but I need to include a number of either Constant fields (such as 'P') or blank fields. For the blank fields I could try to find a table field that is always blank that that seems kind of tacky and dangerous. Any suggestions. I tried just including constants in both single quotes and double quotes in the DME string but always got an error. The record format is: 'P' ,' ' , 'City...
1 2353
by  Robert SpurrJump to last post
03/19/2012 3:20 PM
0 Replies and 1267 Views BN81 Upload  1267  0 Started by  Jodi Kruesel Has anyone been able to use/create an upload to BN81  I'm able to add records to BN81 but am still trying to get the Release function to work.   Any help would be appreciated.
0 1267
03/12/2012 4:26 PM
2 Replies and 2079 Views Moving employees into new company with add-ins  2079  2 Started by  BL I have created a new company and added the accounting untits with add-ins, but now I am challenged with adding all the old company employees into the new company.  I thought I could extract the data from the Employee table, but there are so many lines that add-ins pul 100 lines at a time and not I'm not so sure that is the right route to go. Does anyone have any ideas either about using add-ins or a Lawson template to expedite the process
2 2079
by  BLJump to last post
03/06/2012 5:11 PM
0 Replies and 1769 Views PO21.3 Distributions  1769  0 Started by  JonA I've got 132 distribution lines I want to upload to a PO line in PO21.3.  When I try it I get 'Purchase Order doesn't exist' These are the fields I'm using. (H),_f3,MMD-COMPANY (H),_f4,MMD-SYSTEM-CD (H),_f6,MMD-DOC-NUMBER _f9,MMD-LINE-NBR _f35:0,LINE-FC1 _f36:0,MMD-ACCT-UNIT1 _f37:0,MMD-ACCOUNT1 _f39:0,MMD-DIST-COMPANY1 _f42:0,MMD-DIST-QTY1
0 1769
02/22/2012 11:23 AM
1 Replies and 2668 Views PR35.2 Change fields on 2nd page  2668  1 Started by  ISO Dan Hello, I am doing a DME to retrieve information from the TIMERECORD table and want to make changes to the second page using the PR35.2 Lawson Add Ins.  Since the PR35.2 only has 10 lines, how would you make a change to a field on line 12 (need to page down to get to the second page) Thank you,
1 2668
by  John HenleyJump to last post
01/05/2012 11:46 AM
2 Replies and 2422 Views Various reports needed related with EE History  2422  2 Started by  upasana Hi, I am currently working on an analysis of our clients and I need below details from Lawson. It will be great if anyone of you can help me in getting the details using Lawson / Lawson Add Ins. 1. For every New Hire entered in Lawson during a period. Employee ID, Process Level, GBU, Processor Id (who entered the Employee in Lawson), Time of entering the Employee in Lawson. 2. For every Personnel Action processed in Lawson during a period including changes in PA52, PR12, ...
2 2422
by  Greg MoellerJump to last post
12/09/2011 2:09 PM
0 Replies and 3139 Views Citrix and MOA  3139  0 Started by  Greg Moeller Sorry for the double-post, but I felt this was applicable to both System Admin, and MOA. When we run a particular query from our MOA install on Citrix, we notice that there are some missing records returned. Just for grins, I tried running the MOA query from a local install.  This returned all records that qualified.  (*There were 5 records returned on the local install that just never were for the Citrix install.) Question:  What have others been doing  There is no...
0 3139
12/06/2011 10:56 AM
2 Replies and 4142 Views addin upload error  4142  2 Started by  Lynda User is getting FATAL ERROR when trying to upload file to BN31.1 'Incident_Id1321623691888-0000 An error occured outside of IOS while accessing Lawson Security Any help would be greatly appreciated, thanks Lynda
2 4142
by  mark.cookJump to last post
11/22/2011 9:06 AM
3 Replies and 3687 Views AM20.5 MS Add-In Template  3687  3 Started by  Whitney Johnson Trying to develop a MS Add-In template for AM20.5 to upload new entries. We haven’t been successful due to hidden keys. Does anyone have any suggestions on how to resolve this
3 3687
by  Dave MitchellJump to last post
10/13/2011 8:46 AM
1 Replies and 1984 Views Add Ins Query of Open Checks  1984  1 Started by  Beth This seems to me it would be a simple query, but I can't pull all of the info that I need.  I want a simple list of any open checks for a particular cash code, along with the vendor Name and address for mailing due diligence letters.  Does anyone have any suggestions
1 1984
by  Sam SimpsonJump to last post
09/21/2011 3:14 PM
1 Replies and 1654 Views Special Actions  1654  1 Started by  Srini Rao Hello - How DO I use Special functions in MOA's upload wizard. For eaxmple, PO31 has special functions like copy, cancel etc.  We are working on inventory clearence and I may need to upload more then 10,000 records to PO31 using special actions.   
1 1654
by  John HenleyJump to last post
09/20/2011 10:47 AM
3 Replies and 2757 Views HR06 upload  2757  3 Started by  Karen Sheridan We need to upload salary range values to HR06 and are using the HR06 upload template from the MyLawson Market Place. We are getting the error: Employees exist for this job code; OK to change currency If the 'Ignore' box is checked on the upload tab - no return message is given There are a number of hidden fields including a hidden key. WHen I use the HK field with company job code, I get the 'You must inquire first' error; no ignore and no message with ignore checked. Anyone have ...
3 2757
by  Shane JonesJump to last post
07/29/2011 8:55 AM
2 Replies and 1963 Views IC24 release  1963  2 Started by  TracyO I have created an add-in upload for IC24, that adds the headers then I go back and do a change only to add all the lines but now need to do a mass release.  I tried to add another upload to do a change with the FC code of R and that does not work.  Any one doe this or something on a similar screen that needs a header, details, then needs to be released
2 1963
by  JonAJump to last post
07/26/2011 7:20 AM
3 Replies and 5248 Views Upload Wizard does not launch - 9.0.3.1  5248  3 Started by  David Hi all, hoping someone can help me! We have the Lawson add-ins, 9.0.3.1.1387 (latest patch) installed on Excel 2003, XP SP3 and we are experiencing an issue with the Lawson Upload Wizard.  When a user tries to log on, they are met the with logon dialog box displaying the server, username and password fields as expected.  When they click ok, the logon screen disappears and then nothing happens.  The Upload Wizard does not display and no error is produced.  The Query Wi...
3 5248
by  DavidJump to last post
07/20/2011 9:52 AM
5 Replies and 3152 Views Data extract field  3152  5 Started by  Jeff in PA I'm currently trying to use MS Add-In to extract data from the Payroll system.  Specifically I am looking to get employee information including those employees whose bi-weekly hours are set to a fixed distribution.  I've looked high & low and cant seem to find a field.    HM-ACCT-UNIT is no problem, I get their home department but I cant find the other field I've mentioned.  Does such a field exist & if so where  Thanks Jeff
5 3152
by  Jeff in PAJump to last post
07/18/2011 1:01 PM
3 Replies and 4079 Views Upload Error - new value must be spaces  4079  3 Started by  Amy Sweek Trying to change salary class (H instead of S) for employees.  My upload is returning an error message stating 'new value must be spaces because line has no item'.  Been doing uploads for a few years and haven't seen this message before.  Anyone have guideance on how to proceed
3 4079
by  AngiePJump to last post
07/12/2011 10:39 AM
0 Replies and 1645 Views Addin for LP80  1645  0 Started by  Paul Berkowitz Is there a why to use LP80 to perform a mass transfer to manual PTO plans. LP80 requires Transfer Actions, the Transfer 'T' is is assigned to F1 however the LP80 addins does no thave F1 as an options. Is there another way Thank you Paul
0 1645
07/05/2011 2:58 PM
2 Replies and 1874 Views Add-Ins Upload 903  1874  2 Started by  This_Guy So I have a spreadsheet ready to upload to a form, however there are no PDLs / Forms to select from when I try to Map the columns We are LSF9017 / Apps 901 MSP5, SQL2008, Windows 2003 Any ideas Is it something is LS
2 1874
by  JonAJump to last post
06/30/2011 12:49 PM
8 Replies and 14280 Views Timeout in ADDINS  14280  8 Started by  Jim Howerton The size of our tables seems to have reached a point where most queries run through ADDINS times out. Does anyone know of a setting that controls the amount of time a query may run before it fails with a timeout This also occurs using the OLEDB drivers and Crystal.
8 14280
by  Greg MoellerJump to last post
05/20/2011 3:53 PM
3 Replies and 2237 Views Addins Query no pulling all data  2237  3 Started by  JonA Trying to query POVAGRMTLN and I'm not getting all the lines for a particular agreement. Even when I specify the VEN-AGRMT-REF in the index the query gives me only 227 lines when I can see 371 in PO25.6.  Any ideas why this is happening
3 2237
by  JonAJump to last post
05/05/2011 7:17 AM
7 Replies and 7976 Views Anyone using Add-ins with Windows 7?  7976  7 Started by  CindyW We are having a problem with users that have just upgraded to Windows 7 and can no longer log in to the Lawson Add-ins.  They are using the same version of Office/Excel as before (2007).  I opened a case with Lawson and they state that Add-ins is 'not certified to run with Windows 7 or VISTA.  Well I have VISTA (and Office 2007), and I can user the add-ins fine.  So I'm curious if there are any other folks out there have been successful in running the add-ins on a W...
7 7976
by  CindyWJump to last post
04/29/2011 4:02 PM
0 Replies and 1820 Views Query and upload to Comments fields  1820  0 Started by  Sherry Shimek Hello.  We are are making multiple distribution adjustments to change the accounting unit and activity/account category for a major project.  To provide a cleaner audit trail, we would like to add a standard comment indicating the change was made for this project and a reference for further documentation. Is it possible to upload to the AP Distribution or Invoice Comments fields  And is it possible to query them Thank you, Sherry Shimek
0 1820
04/29/2011 10:26 AM
3 Replies and 2157 Views Lawson Webinar today at 10: am CST on how to Constructing Efficient Data Queries Using Lawson Add-Ins  2157  3 Started by  Ruma Malhotra Topic: Constructing Efficient Data Queries Using Lawson Add-Ins for Microsoft Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 10:00 am, Central Daylight Time (Chicago, GMT-05:00) Event Number: 665 619 705 Event Password: This event does not require a password Registration ID: This event does not require an enrollment ID
3 2157
by  Ruma MalhotraJump to last post
04/28/2011 11:09 AM
1 Replies and 2072 Views Add Stop Date in PR12 via AddIns  2072  1 Started by  upasana Hi, Can anyone please confirm how to use Upload Wizard (via AddIns)for adding stop Direct Deposit date for all the employees terminated through Mass Uploadation. In our company we are having a big client where 'n' number of employees were terminated by using AddIns, but we find that Direct Deposit is still Active in PR12 screen. A Stop Date needs to be entered for all those employees in PR12, Is there a query that can be uploaded to add end date in PR12 Screen. Thanks in advance. Upasana M...
1 2072
by  upasanaJump to last post
04/26/2011 5:25 AM
0 Replies and 1572 Views GL20 Query with LSF Security  1572  0 Started by  Wade-T Hello, We currently have a program that performs manual tasks for us that is currently logging on as a termed user that has LID security.  I am working on getting these tasks moved over to a non-employee account and set up LSF security locked down to only the data the program needs to complete the task. The first one being GL20.1 inqueries. I have given access to the 7 fields that need to be pulled, as well as the program, token, files, data source, and some elements with Unconditiona...
0 1572
03/31/2011 9:11 AM
4 Replies and 2805 Views MAI & PA52.1/PA56.1 comments  2805  4 Started by  kadkins Is there a way, either using a Lawson Conversion Report or MAI's, to load comments tied to a personnel action at the time the action is updated Thanks in advance!
4 2805
by  Carl.SeayJump to last post
02/23/2011 1:48 PM
3 Replies and 2360 Views PO 25 Upload  2360  3 Started by  Boyd Does anyone have any templates, that they are willing to share, that would assist in uploading standing orders to PO 25  
3 2360
by  Dave MitchellJump to last post
02/10/2011 8:53 AM
2 Replies and 1659 Views AR addins wont return all the rows  1659  2 Started by  Deleted User Hello, I'm using the Excel Addins to query a form (AR90.1) and while I&160;do receive data, I only return 11 rows.&160; I know the data query should return a few hundred rows.&160; I've set the number of rows limit to 9999 and still not difference.&160; Any ideas
2 1659
by  JonAJump to last post
02/02/2011 12:16 PM
3 Replies and 6054 Views Query wizard  6054  3 Started by  prav Hi all, I am trying to write a query to get a list of all the vendors and their addresses that had payments in 2010 with the total payment above $600. My idea is to use APPAYMENT as the main file and then use the relation to APVENMAST to get the vendor related info. Now when I am entering selection criteria, how can I enter something like sum(TRN-CHK-AMT) > 600 Does the query wizard allow to use column functions Greatly appreciate your help in this.
3 6054
by  JonAJump to last post
02/02/2011 11:38 AM
3 Replies and 1842 Views Connect Lawson 8 Environment  1842  3 Started by  Rajantonyv When trying to connect using MS Add in to a Lawson 8 (Office 2007/Office 2010), what are the steps  Does the user need to be given appropriate permission  Does anyone have any docs that can be applicable to Lawson 8 please
3 1842
by  mark.cookJump to last post
12/30/2010 7:36 AM
1 Replies and 1924 Views Change Issue Method on PO20.2  1924  1 Started by  LouP We are trying to change the issue method on PO 20.2. I created a uwf file sometime earlier this year which worked fine. Now I cannot find the file and do not remember the format...Help!!
1 1924
by  Vijay SJump to last post
12/29/2010 12:08 AM
1 Replies and 1179 Views Optional processing of blank field!  1179  1 Started by  Vijay S I have a requirement In MS ADDINS. It says that If Cell is kept blank on the Excel template for that column it should not change that corresponding field value in the Lawson form (such as AP30.1) but if some value is entered in that cell the corresponding field value in Lawson form should be changed. Is it possible via Lawson MS Addins
1 1179
by  JonAJump to last post
12/27/2010 7:23 AM
3 Replies and 1464 Views Help Uploading to HR54  1464  3 Started by  hussey1213 The problem I'm having is identifying the record that needs to be updated. The upload is assuming that the first record is the record being updated but that's not the case. Is there a way around this
3 1464
by  Shane JonesJump to last post
11/24/2010 3:03 PM
3 Replies and 2012 Views Upload to BL34 Inquire then change  2012  3 Started by  TracyO I am trying to create an upload wizard for BL34.&160;When in Portal you must first inquire on this screen with the Company, Frequency, Cycle COde &&160;AOC description, then you can enter the line-fc C and the amount.&160;&160;I had read on an old post here that Add-Ins automataically does an inquire before it trys to do the change function that I am uploading. &160;When I try to procees my upload I get the error message:&160; Customer recurring invoice does not exist.&160; I&160;als...
3 2012
by  Karen PloofJump to last post
11/10/2010 12:31 PM
8 Replies and 2951 Views List of Process Level in a Process Group  2951  8 Started by  upasana Hi, Can anyone please confirm me how to get list of all the process level in a Process group. Currently I am working for a company with many clients having different process level. We have set up such clients with Process Group. Now I want to know all the existing Process Group with their respective Process Level. Please confirm. Thank you for the feedback.
8 2951
by  upasanaJump to last post
09/09/2010 1:15 AM
1 Replies and 2399 Views PO header comments  2399  1 Started by  Deleted User Does anyone know if it is possible to upload information into the PO comments fields on PO20(the PO header comments)
1 2399
by  Ruma MalhotraJump to last post
09/02/2010 10:24 AM
0 Replies and 2679 Views Add Ins not showing in Excel  2679  0 Started by  mark.cook Do you guys know why Excel, when opened by VB code or from email attachments doesn't include the Lawson macro button on the toolbar
0 2679
09/01/2010 1:45 PM
1 Replies and 1635 Views Lawson ADODB - Update a form field defined as VS Problem  1635  1 Started by  RayB I am attempting to set the value of the AMD-ORIG-AMT defined as a VS (17 length, 2 decimals) field type on form AR21.3. What would the format string for updating this field I assumed '0.00;0.00-' but this failed! BTW I am attempting to upload data from an excel worksheet using vba/adodb. Thanks, Ray
1 1635
by  RayBJump to last post
08/27/2010 2:58 PM
9 Replies and 5705 Views Add-Ins issue with Excel 2007? Limited to 65k lines?  5705  9 Started by  MBJH Is it a known issue that add-ins&160;Query&160;Wizard&160;only returns 65521 lines even when used with Excel 2007 Excel 2007 allows many more lines than that, but my query results still max at 65k. Any ideas
9 5705
by  MBJHJump to last post
08/24/2010 4:24 AM
3 Replies and 6786 Views Speadsheet Designer  6786  3 Started by  Lisa Stewart Any one heard of a Lawson Product called spreadsheet designer that is supposed the take the place of excel add-ins If so could you share what you know about it
3 6786
by  John HenleyJump to last post
08/20/2010 12:40 PM
4 Replies and 2394 Views Get Field Translation in DME Query  2394  4 Started by  Woozy I'm building a DME query against the LOGAN WFWORKUNIT table. I want to include the description of the WF-STATUS field values (which are setup in dbdef), but I can't figure out how to do it. Is there some trick to including the descriptions in the query /servlet/Router/Data/ErpPROD=LOGAN&FILE=WFWORKUNIT&FIELD=WORKUNIT;WORK-TITLE;PROCESS-NAME;WF-STATUS;WF-RM-ID;&OUT=XML Thanks! Kelly
4 2394
by  WoozyJump to last post
07/08/2010 9:30 AM
4 Replies and 2518 Views ERROR... can't use Selection Criteria...Related Table Fields and Parenthesis  2518  4 Started by  FireGeek21 Hi Everyone, We are receiving the following error when attempting to create output using MS Addins: ERROR. You cannot use Selection Criteria that contains both Related Table Fields and Parenthesis. Not sure how to resolve this... We are building output to include the following: -Dependent's Name -Benefit Plan Type (HL; DN) -Benefit Start-Date -Benefit Stop-Date -Dependent's Relationship -Dependent's Consent -Employee's Date of Hire -Employee's Name -Employee's Company ...
4 2518
by  FireGeek21Jump to last post
06/14/2010 3:45 PM
6 Replies and 3950 Views ACTRANS, APDISTRIB, CBDISTRIB, & GLTRANS Query with duplicates  3950  6 Started by  Sherry Shimek One of our users has queries set up by a former consultant that uses ACTRANS as the base table and fields from related tables APDISTRIB, CBDISTRIB, and GLTRANS. Prior to running the queries this month, the user was getting correct data.&160; She doesn't remember making any changes to the query and now she is getting multiple duplicate records.&160; The file was only 6k lines last month and now is 60k. Are there indices or other parameter settings that restrict the data to not pull duplicates...
6 3950
by  Sherry ShimekJump to last post
03/19/2010 3:03 PM
0 Replies and 2030 Views LSF 901/Apps 901 Add-Ins Issues  2030  0 Started by  MattD Gurus, We just upgraded to LSF 9015 and Apps 9012.&160; We are now having issues with our MS Add-Ins.&160; Lawson has provided us with several updated versions of Add-Ins to correct different issues, but we are still receiving the below error.&160; The biggest issue is that there is no good way to track what is going wrong.&160; I&160;have reviewed the system logs including ios, the Websphere logs, and the log generated by Add-Ins itself.&160; None have shown any issues.&160; Any ideas o...
0 2030
03/17/2010 1:33 PM
1 Replies and 2160 Views License question  2160  1 Started by  pmeckes Does anyone know if the licenses for ms add ins are by concurrent users The license information for ms addins only states 'Named Users' .&160;How is everyone handling the&160;installs&160;&160;
1 2160
by  mark.cookJump to last post
03/08/2010 7:10 AM
6 Replies and 3381 Views Lawson Addins LSF9 'Time out' problems  3381  6 Started by  Deleted User Since the upgrade to LSF9 (and patches that were since installed) I am experiencing problems running large queries using Lawson addins. I am getting a 'time out' message regularly or a 'Fatal error' message very occasionally. The IS department is telling me that this is causing problems with slowing down the users of Lawson Portal but I cannot understand why this did not happen previously as I have been using the same query regularly for almost 4 years. I have to run large data sets regularly an...
6 3381
by  Dave MitchellJump to last post
02/19/2010 10:44 AM
11 Replies and 4792 Views Server Resources for Addins  4792  11 Started by  itsjustme Has anyone had their Admins or Server folks complain about the resources that queries are taking up Does anyone restrict users to predefined queries and ensure that any new queries are created in a test environment to prevent odd table joins from hitting production Either we have some tuning to do or our users are building their queries wrong. Thank you for any response or organizational direction that can be provided. &160;LSF9, 8.0.3 MSP11 Apps, UNIX server w/websphere etc all on same b...
11 4792
by  itsjustmeJump to last post
02/12/2010 10:20 AM
6 Replies and 6208 Views Attach .uwf file for users in Word document  6208  6 Started by  Sherry Shimek I have created a Word document for our users that I easily attached a Excel template for uploading into Lawson.&160; However, I haven't found a good way to attach the .uwf file so the user can save it to their computer and upload the data. Any suggestions
6 6208
by  Dave MitchellJump to last post
02/09/2010 3:05 PM
4 Replies and 10754 Views Lawson query wizard not showig up in MS Excel  10754  4 Started by  RobertL I use Tools-->&160;Add-Ins menu in Excel to add Lawson query wizard. It works but after I close Excel and re-open it, the query wizard Add-In does not show up in Excel. I have to go to Tools-->&160;Add-Ins menu to add the Lawson query wizard everytime when I open Excel. Please advise. Thanks.
4 10754
by  RobertLJump to last post
02/01/2010 1:55 PM
2 Replies and 1713 Views Where does the APVENBAL(MA95) table get its data?  1713  2 Started by  willz06jw Hi and thanks for your help, I am trying to use the APINVOICE and APPAYMENT tables to calculate similar results as what shows up in the PURCH section of the&160; APVENBAL&160;table (this is where MA95 is grabbed)...but they are always too high.&160; Any ideas Thanks, Will
2 1713
by  willz06jwJump to last post
02/01/2010 1:41 PM
4 Replies and 3613 Views Using Lawson Queries to pull the transmission type from PO20 data (EDI or FAX?)  3613  4 Started by  willz06jw Thanks for your help, &91;I am using Lawson 9.0&93; I am trying to use Lawson Queries in Excel to pull the transmission type from the data for PO20.&160;&160; For example: I need to know if the POs for last year were sent via fax, edi, or paper.&160;&160; Thanks again for your help, Will
4 3613
by  JonAJump to last post
12/17/2009 2:04 PM
1 Replies and 2231 Views po20 only loads first 5 lines  2231  1 Started by  TimD I down loaded the PO20.1 upload from http://solutions.lawson.com/lu/addins/main.htm When I try to use it, it will only load the first five lines of the po and then I get the error message : Cannot enter vendor item different from existing This message appears after every five records beyond the first five that worked. What is causing this issue I'm trying to upload 100 lines to a po. If I&160;change the temp po number after every 5...
1 2231
by  JonAJump to last post
12/17/2009 1:51 PM
12 Replies and 2567 Views Add-ins very slow after LSF 9 upgrade  2567  12 Started by  Linda Wilson We just upgrade to LSF&160;9, and are on 8.1 apps.&160; Add-in queries are painfully slow now and many times won't finish (queries that ran in less than a minute are now running 30 minutes).&160;&160; Any ideas what might be causing this&160; Seems to be particularly with add-in queries that are using more than one table.&160; Thanks
12 2567
by  tamJump to last post
12/01/2009 3:13 PM
2 Replies and 3090 Views Invalid Date using Upload Wizard  3090  2 Started by  Staci B Hello, My goal is to delete the medical plan for a group of ee's and add it back.&160; I used Lawson's KB 521719 to determine the required fields for mapping, but I get the following message: Invalid Date: BEN-STOP-DATE1.&160; I've changed the format of the date from YYYYMMDD to MMDDYY to MMDDYYYY and nothing is working.&160;
2 3090
by  Brad SchauerJump to last post
11/30/2009 2:31 PM
2 Replies and 2334 Views Query Help Needed  2334  2 Started by  Harry I'm looking for assistance with an Lawson excel query. The query pulls employee information (name, work location, pay rate). My problem is trying to get pay rate information 'as of' a defined date. My query currently pulls information on employees that were employed on the defined date (i.e. 12/31/2008) but its downloading the employees current rate of pay, not their rate of pay on the defined date (i.e. 12/31/2008). Any idea on the query criteria that would solve this problem Thanks
2 2334
by  AdamJump to last post
11/24/2009 2:50 PM
1 Replies and 2385 Views AP20 Invoice Hold Code  2385  1 Started by  Deleted User I am looking for the Hold Code field.&160;The field is located at f115_API_HLD-CODE but I can't find it in Addins at the API&160;table or in Process Flow.&160; Is it hiding in another table that I can connect using a relationship
1 2385
by  John CrudeleJump to last post
11/04/2009 3:31 PM
3 Replies and 2504 Views PR36 add-in upload  2504  3 Started by  Phil Simon Hello All I'm trying to create the upload for the PR36.&160; I have mapped the fields below and have read:&160; Finding Splat or Hidden Key (HK) Fields for use with Lawson Add-ins for Microsoft Office &160; Article ID:1054552 &160; For some reason, I&160;can't get to the formdef to find the hidden field(s).&160; Anyone&160; Thanks. field...
3 2504
by  Phil SimonJump to last post
10/20/2009 9:07 AM
0 Replies and 2374 Views MA236 (Invoiced Not Received) Available as Lawson Query DME?  2374  0 Started by  Lorenda Just wondering whether anyone has a DME written to mock the output of the MA236 report in Lawson. We are needing to run it across companies, so I&160;was hoping to get a 'tweakable' query to run this using ADODB.
0 2374
09/23/2009 11:43 AM
4 Replies and 2626 Views PO25 Vendor Release?  2626  4 Started by  willz06jw Let me start by saying thanks for the help, Is there a way to automatically release all unreleased vendor agreements in PO25 Also, what are the effects of not re-releasing a revised vendor agreement Thanks again, Will
4 2626
by  willz06jwJump to last post
09/18/2009 12:51 PM
1 Replies and 1574 Views Any Monarch users out there?  1574  1 Started by  Deleted User I'm new to the forum and&160;not sure this is the appropiate forum for this question&160; Anyone ever used the tool from Datawatch called Monarch&160; I use daily for all kinds of Lawson tasks.&160; It has been one of the best software investments I've ever made. Joanna Bledsoe joanna.bledsoejhsmh.org
1 1574
by  NormJump to last post
09/17/2009 3:10 PM
2 Replies and 2154 Views Table where I can query Full name and Login username (Using Lawson ADDINS)?  2154  2 Started by  willz06jw Thanks for your help, I am trying to find a table where I can query the username (that people log in with) and the full name attached to it. I am trying to pull this in&160;Excel using Lawson Addins. Thanks for your help, Will
2 2154
by  willz06jwJump to last post
09/17/2009 8:44 AM
1 Replies and 2433 Views Using Perl to query Lawson DME revisited with LSF9 environment  2433  1 Started by  jeremy.zerr So we just got the LSF9 environment, and I just found out that one of the things that changed is the method of authentication for DME&160;queries. In the 8.0.3 environment, basic HTTP authentication was used, which is very easy to navigate using perl. However, in the LSF9 environment, the DME authentication switched to the Lawson server side auth, which is basically requiring a login to the same login form that normal users have to log into Portal with. This means to access LSF9 DME&160;wit...
1 2433
by  jeremy.zerrJump to last post
08/23/2009 9:17 PM
3 Replies and 1909 Views Addins is too quick...  1909  3 Started by  BrianP I know it is hard to believe (and i can't believe i am asking) but, I need to slow down the Addins upload to&160;one entry per second.&160; The reason behind it... APAUDIT has a time field (APA-TRANS-TIME) that is updated during a delete load I am working on in AP10.6 and the process aborts with a duplicate record error due to the time (HHMMSS).&160; So far I have been able to insert several lines of old data between&160;the rows that could cause a failure and it appears to be working fine, ...
3 1909
by  NormJump to last post
07/20/2009 1:03 PM
0 Replies and 1585 Views ed810 not pulling tax  1585  0 Started by  linda phillips we are currently 8.03 sitting on 9.0lsf and use Ghx as our provider for EDI. We currently became a tax company and we seem to have a problem at month end with out of balance for AP due to tax. WHen you look the tax is not be added to the invoice and we run the ap126 which matches and were done. Has anyone set up edi for tax &160; I'm begining to think that this is the problem. If not and anyone has a great suggestion on how to fix this I would greatly appreciate your help. The only one we ...
0 1585
07/02/2009 11:40 AM
6 Replies and 4137 Views AP10.6 Company Codes (lsf9, 803apps)  4137  6 Started by  BrianP Has anyone had&160;success using Lawson Add-Ins against AP10.6.&160; My user would like to&160;delete Company Codes.
6 4137
by  Brad SchauerJump to last post
06/29/2009 9:44 AM
4 Replies and 5683 Views Vendor Query  5683  4 Started by  Boyd Does anyone have any thoughts on creating a Query that will Pull in Vendor, Vendor ID, GL coding (A/U, Acct. etc.) and Payment number&160; I&160;have been able to pull in all the information I need except for the Payment number.&160; Boyd
4 5683
by  BoydJump to last post
06/26/2009 1:47 PM
1 Replies and 1912 Views Addins for PA22-creating duplicate records  1912  1 Started by  thanef I am trying to upload a file from CE&160;Broker to PA22 Certifications but I am getting duplicate records for some reason.&160; LIS does not support this function when I asked them for help.
1 1912
by  John HenleyJump to last post
06/03/2009 6:43 PM
7 Replies and 7455 Views Unreleased AP invoice - APDISTRIB & APINVOICE tables Activity field not filled?  7455  7 Started by  Sherry Shimek &160; Help - We need to see Activity field information for unreleased AP invoices to determine which activity is overbudget and not allowing the batches to post. Set-up a query of APDISTRIB and APINVOICE tables including Activity and Account Category field from APDISTRIB.&160; Allowed Multiple OTM&160;Values for multiple invoice lines.&160;On AP20 screen confirmed that on invoices queried there were activities entered, but nothing was included in the Actvitiy field of the query. Thanks!&1...
7 7455
by  Sherry ShimekJump to last post
05/18/2009 1:44 PM
3 Replies and 2011 Views MS Addins install that limits to Query only capability  2011  3 Started by  Michael Barron As part of our LSF 9.0 implementation we are upgrading MS&160;Addins. We would like to allow query only capability without providing the Upload even when some people may have update rights to the screen in Portal. I know by removing the 2 upload wizard files you can prevent uploads from being done but I was curious how you bundled that process to provide users or people to install MS&160;Addins and ensure these wizards are not installed.
3 2011
by  Michael BarronJump to last post
05/01/2009 2:30 PM
7 Replies and 2456 Views MS Add-ins version level with LSF9 env/8.03 aps  2456  7 Started by  Deleted User We are upgrading to LSF9, but remaining on 8.03 applications until next year.&160; We are currently on MS Add ins v2.0.5.0.&160; Lawson has indicated that we can upgrade to v9.0.3.1.&160;&160;My understanding is that this version was released in 2006.&160; Is anyone&160;with this configuration&160;using a different version&160;of MS Add-ins&160; Thanks&160;
7 2456
by  Michael BarronJump to last post
05/01/2009 1:08 PM
3 Replies and 2290 Views Field size limitation in query???  2290  3 Started by  Sherry Shimek &160; Does MS&160;Addins and or Excel&160;have a size limit to the amounts to be extracted in a query&160; We have a number we have queried from a table that appears to have lost the last two digits of a $3trillion gl amount.
3 2290
by  Sherry ShimekJump to last post
04/27/2009 10:56 AM
6 Replies and 5684 Views BN32 - hidden key...  5684  6 Started by  Shane Jones Anyone have the structure for BN32 Add-ins.&160;&160; I thought I had it but it is not working....&160;&160; I think I need help with the Hidden Key.... Any ideas
6 5684
by  BrendaHJump to last post
04/17/2009 2:03 PM
4 Replies and 2722 Views Addins to bring multiple distributions into AP20  2722  4 Started by  Joe O'Toole We import some of our invoice files with IMPORTDB, but would like to develop an interface&160;using Addins. I was looking to hear how others have faired creating an Addin's template for bringing in invoices with multiple details lines (some in excess of 100) into AP20.1. Thanks.
4 2722
by  Ruma MalhotraJump to last post
03/31/2009 3:42 PM
0 Replies and 2387 Views Issue with Add-Ins for AP20.7, does not add first record  2387  0 Started by  desichet Most of our Invoice have one line distribution.We are building AGS call to add records to AP20.7&160; to&160; occur few days&160; after Invoice header was created and Invoice is approved.&160; Running into issue with adding one record to AP20.7 OR AP20.2 (distribution). First record does not get added through AGS call OR Add-In. Return message -Message>No More Records For Given Key. Once we enter first one using portal screen, same AGS call and MS-AddIn can add more records as needed.&16...
0 2387
03/27/2009 5:05 PM
2 Replies and 2526 Views Creating a report from MS Access  2526  2 Started by  Deleted User Hi I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access. That ebing said,&160; I was told by Lawson support that there is not a report that will produce this report.&160; The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab. The report need to reflect by company, by lo...
2 2526
by  Phil SimonJump to last post
03/17/2009 10:52 AM
2 Replies and 2688 Views Product Lines Disappearing  2688  2 Started by  JonA Anyone else experiencing this&160; Occasionally, when I use the Upload Wizard, my product lines are not showing.&160; I have to re-install addins for them to appear again.&160; I'm not having any issues with the query wizard. Lawson S3 Add-Ins version 9.0.3.1380; MS Excel 2003 version 11.6560.6568 (SP2); Windows XP Pro version 2002 SP2
2 2688
by  JonAJump to last post
03/17/2009 4:21 AM
3 Replies and 5058 Views PO20.1 Add-In - Release PO  5058  3 Started by  Ken Ptak I'm attempting to create an Add-In for the PO20.1 that will perform a 'Release' from the 'Action' menu. I&160;have three fields mapped (Company, PO Number, and Save&160;FC) on the attached spreadsheet and .uwf.&160; When I&160;run the Add-In the result is 'Change Complete -&160;Continue'.&160; However, if I&160;inquire on that&160;PO on PO20, the Revision still states 'Unreleased'. We're on Apps 8.1, LSF9, Add-Ins 9.0.3.1. Any ideas/thoughts/suggestions would be greatly appreciated. ...
3 5058
by  John HenleyJump to last post
03/04/2009 11:43 AM
5 Replies and 4250 Views Lawson Advanced Add-ins query document - only available from CUE  4250  5 Started by  jeremy.zerr Just had a Lawson support person help me out with debugging some edits on a PA55 upload, they sent me a document that is only available to Advanced Add-ins class attendees at CUE. Figured I would share it.&160; Its attached to this post. Has a really great section on how to debug edits from uploads. That was the info I have been looking for quite a while, and I'm totally excited to finally have something to be able to help myself. Jeremy Running shoes website
5 4250
by  SrinivasJump to last post
02/16/2009 4:22 AM
3 Replies and 4518 Views AP Invoice Comments  4518  3 Started by  Meghan I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.&160; Since invoices are included as an attachment, is there any way to include them in the query
3 4518
by  John HenleyJump to last post
01/30/2009 5:56 PM
6 Replies and 3608 Views GLTRANS query returns no results  3608  6 Started by  Sherry Shimek We recently created a new data level security class expanding the data accessible to a current security class., but still not allowing full data access.&160; Lawson data level security class testing passed with no exceptions.&160; However, due to the intense MS Addins query usage of the users in the two classes we decided to test MS Addins queries. They primarily run queries on GLTRANS. Queries worked fine in the test environment except for queries of the GLTRANS table.&160; Queries of...
6 3608
by  k-rockJump to last post
01/28/2009 3:10 PM
2 Replies and 2087 Views Product line access  2087  2 Started by  GailC I have a user with a RM setup identical to my test user. The user can only see 1 of our 2 product lines in the addin. Any idea why
2 2087
by  John HenleyJump to last post
01/14/2009 1:08 PM
1 Replies and 2761 Views addins template for hr04.7 value listing?  2761  1 Started by  Deleted User Can anyone share the secret to doing an upload for HR codes, but the actual values list (hr04.7). We have a new hr code with a bunch of values and would hate to manually input. I think that there are hidden fields involved. Any help is appreciated. &160; &160;
1 2761
by  John HenleyJump to last post
01/06/2009 2:20 PM
0 Replies and 2826 Views Deleting a GL Budget via Excel Add-Ins  2826  0 Started by  John Henley I recently was asked if you could use the Add-Ins to delete records, particularly in the GL 'Flex Budgeting' module. The answer, of course, is yes! The ability to delete records on forms was added to the Upload Wizard some time ago, and you can use it with just about any form to which you can map for adding and/or changing. And since you're just changing the way you interact with Lawson (in other words, you're using Excel as a 'front-end' instead of LID or Portal), you're still making use of ...
0 2826
12/27/2008 5:35 AM
2 Replies and 2926 Views AM20 security error  2926  2 Started by  GailC We are new to Lawson using the new LS security. I have security working for all addins except AM20. When my user runs it with here SuperAdmin security, it fails. When she uses Lawson (CheckLS = 'N') it works. The only thing I can find in the logging is that 'It can't execute script ModLocalAdmin.bat'. This is from the xls log. Any ideas were I can look
2 2926
by  GailCJump to last post
12/19/2008 1:55 PM
0 Replies and 1788 Views MS Addins and Environment Form Ids  1788  0 Started by  des123 I am&160;in the planning stages for installing MS Addins and setting up LAUA security accordingly. According to the 'Lawson Administration: LAUA Security', page 25, step 5, the security class for the users who will use the Addins must not include access to environment forms. Why is it necessary to&160;NOT include access to environment forms for Addins users
0 1788
12/10/2008 12:30 PM
10 Replies and 5304 Views Add-Ins Query - Unattended  5304  10 Started by  William Saltmarsh Is there a functionality/mechanism that will allow an Add-Ins query to run completely unattended, that is, with no operator intervention for entering login credentials and deleting duplicate output files
10 5304
by  MARCO3535Jump to last post
12/10/2008 12:08 PM
11 Replies and 20934 Views Automating Excel Add-In JE Import with VB  20934  11 Started by  Deleted User Our company is trying to automate journal entry and AP uploads to Lawson using the add-in wizard. We would like to use macros and visual basic but have not found any documentation on how to call the Lawson add-in object. Can someone point us in the right direction
11 20934
by  joel_fJump to last post
12/05/2008 10:18 AM
1 Replies and 2612 Views New feature to insert a column in Excel Upload Wizard  2612  1 Started by  John Henley For years, one of the Lawson tips I’ve been sharing with users has been how to add a new column to an upload mapping you’d previously saved. This is often needed when you add a new column to a spreadsheet and include it in your upload. Read New feature to insert a column in Excel Upload Wizard.
1 2612
by  Joe Van DenburgJump to last post
12/01/2008 7:44 AM
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 3 << < 123 > >>


RSS Feed Available