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

We have a need to upload about 700 assets. The upload for AM20.1 only allows 8 at a time and each different asset data is in another column of one row rather than a row for each asset data. Does anyone know of a way to upload this information more efficiently Thanks Dave

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

Query We are using Addins V2.0.3.0 with Apps 8.03  Is there a more efficient way of stoping the query once it is started.  Like for example in Access Ctrl Break will stop the query after the run command anywhere from the start to the x minutes its time to kill this now moment Upload Same question for uploads, sometimes the 1st 100 rows go fine and then there is a repeated error on everyline like 'account does not exist' and options are go for lunch or close the wizard or excel.

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.  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

Anyone have the structure for BN32 Add-ins.   I thought I had it but it is not working....   I think I need help with the Hidden Key.... Any ideas

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.

I am 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 NOT include access to environment forms for Addins users

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

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.  Lawson data level security class testing passed with no exceptions.  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.  Queries of other tables w...

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 ...

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.

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

Anyone else experiencing this  Occasionally, when I use the Upload Wizard, my product lines are not showing.  I have to re-install addins for them to appear again.  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

I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.  Since invoices are included as an attachment, is there any way to include them in the query

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,  I was told by Lawson support that there is not a report that will produce this report.  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 location the...

We are upgrading to LSF9, but remaining on 8.03 applications until next year.  We are currently on MS Add ins v2.0.5.0.  Lawson has indicated that we can upgrade to v9.0.3.1.  My understanding is that this version was released in 2006.  Is anyone with this configuration using a different version of MS Add-ins  Thanks

I'm attempting to create an Add-In for the PO20.1 that will perform a 'Release' from the 'Action' menu. I have three fields mapped (Company, PO Number, and Save FC) on the attached spreadsheet and .uwf.  When I run the Add-In the result is 'Change Complete - Continue'.  However, if I inquire on that 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. Thanks, Ken

Most of our Invoice have one line distribution.We are building AGS call to add records to AP20.7  to  occur few days  after Invoice header was created and Invoice is approved.  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.                Did any...

Does MS Addins and or Excel have a size limit to the amounts to be extracted in a query  We have a number we have queried from a table that appears to have lost the last two digits of a $3trillion gl amount.

As part of our LSF 9.0 implementation we are upgrading MS 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 Addins and ensure these wizards are not installed.

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.  Allowed Multiple OTM Values for multiple invoice lines. On AP20 screen confirmed that on invoices queried there were activities entered, but nothing was included in the Actvitiy field of the query. Thanks!

I am trying to upload a file from CE Broker to PA22 Certifications but I am getting duplicate records for some reason.  LIS does not support this function when I asked them for help.

Has anyone had success using Lawson Add-Ins against AP10.6.  My user would like to delete Company Codes.

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  I have been able to pull in all the information I need except for the Payment number.  Boyd