We've found some limitations using the Excel Add-In's Upload Wizard in Asset Management because Additions, Adjustment, Transfers and Disposals often prompt new forms after the first record is entered onto the first form. Our way around this is to not use the standard entry forms, but some alternate forms.Read Uploading to Asset Management using Lawson's Excel Add-In.

Good afternoon! I would like to email with someone from a local government that uses Lawson Asset Management.  We are refining our processes and thought I would get some feedback from others.  Please email me at Kelly.Houstonbuncombecounty.org.  Thank you very much!

What does it mean when in Upload Wizard a dialog box pops up with the title 'Lawson_Upload Wizard' and a message of 'Type mismatch' Jeff

Does anyone know if there is a way to 'turn on' a system control that will not allow GL 199 to close a period for a company if there is a balance in error suspense

My Company is considering using sub accounts for a select group of accounts.  I swear that about four years ago, my boss told me he had talked to someone at Lawson who recommended against using the accounts in this fashion (to better break-out accounts).  Anyone have some stories (good and/or bad) about using sub-accounts  An example of intended use is to have a 'maintenance' account that has sub accounts for vehicles, store, a/c, etc. Thank you in advance Greg Wiklund Rent-A-Center, Inc...

We are just starting the learning and data migration for M3/S3 etc. The Accounts people tell me they will soon have a chart of accounts loaded, but I am looking for how we load Opening balances, and journal postings from our legacy system, not having much luck.....We have licked the item master, customers etc pretty well, but this area is a bit more elusive. Anybody have any wisdom they could share in this area please thanks jp

Have anyone installated or upgraded Smart reconciliation to 9.0.1.03 before I recently upgrade mine to this version. After installation, I got the following error messages when trying to sign on as 'lawson' from the /smart-recon/admin.htm page: Smart Reconciliation encountered an error processing your request. If this problem persists, please contact your system administrator. Error details: status_code: 500 message: Error on line -1: Premature end of file. request_uri: /smart-recon/doLo...

I have not run AC191 for almost 1 year. Can any1 tell me the impact of not running this program

I have been requested to setup a new AR company in Lawson, which will be used to track accounts that are written off from Company 1000 AR. We do not want it to interact with current GL company 1000. Is this possible What is needed Thanks

I'm looking for a technical reason as to why an Activity level length cannot be modified after it has been created.  We are using four activity levels to identify an Activity in Lawson.  We are wanting to change the length of level four from 8 characters in length to 9 characters.  I've done some playing around in one of my Lawson sand boxes, updating the ACACTGRP file in our product line database.  I set the LEVEL_SIZE_04 value for our primary Activity Group to 9. So far, what we've foun...

We would like options for posting some of our AP data in summary.  We created a vendor class to be used for these items and designated it to post in summary.  Then we assigned the vendor class to the particular vendor but when we load the detail into AP, it is still posting in detail from the AP175 through the GL.  Is there something we have to do to the line items in the AP20 and AP20.7 to make sure we post in summary.  We add to the description line at the distribution level.  Since the distri...

Will AC40.1 update transactions to AC without affecting the GL. AC is not one of the core accounting module used by us. It is used on the side to tract detail patient activity for billing purpose. I would like to purge AC however the purge will not work because their are outstnding commitments on the Activities. I am considering using AC40.1 to clear these redundant commitments to facilitate the purge. Will this work without affecting the GL

Hi, We used importdb to load data into ARITRAN and ARIDISTRIB tables and then run AR560 without problem. After that the records show up in AR90.1.   But the data can not be seen in BL123. Are there other steps missing How to make the data available in BL123   Thanks!

How do you unapply a payment from an AR invoice

Hello,   I was wondering if anyone could provide me with a simple way to do this when the control accounts go out.  Currently our AP 175 posts in summary to the GL so when AP control does not = AP 136 Subledger, I have no idea where to start looking.   Thanks!

When converting our vendor master to lawson AP vendor (version 9.0.1)  a couple of cities were longer than the 18 length limit. Ex. San Juan Capistrano and  Rancho Santa Margarita Anyone run into this type of problem  - how would you shorten a city name and still get a check to the correct destination

Our finance department has decided to setup a new company (5020) for a group of accounting units that currently exist in another company (2500).  Both companies will co-exist.  Looking for ideas on how best to move accounting units and history to the new company.  AR is handled in a different system.  AM and AC are utilized though.

does anyone know an easy way, or if it is possible, to change vendor numbers and maintain the vendor history.  employees are in our vendor master file.  we have just implemented a new adp portal and I was wondering if there would be any easy way we could change the employees vendor numbers to match the adp employee number and keep the vendor history under the new .  The range of numbers used by the adp employee is not being used in the lawson apvenmast.

We are running AC120 for the first time in 5 years and it is taking anywhere from 18 to 25 hours to run. We have tried different servers and it makes no difference. We are on a HPUX server with 16 cpu's and 16 Gb of memory. Apps 8.0.3.9 Env 8.0.3.7. Is this normal Is there a way to shorten the run time TIA

I am working on cleaning up AP by querying Open Invoices using MS Addins where the records have very old dates.  We use the data and make a determination whether to write off the credit or cancel the invoice.  I am finding invoices in the query that have a Released status but have been paid.  Why does this happen and is there something we can do to change the status of history so the process completes.

I should know this but:  Can you update existing vendor records in the APVENMAST table (i.e. name changes) by using the AP510 (or I would insert records into the APCVENMAST table).  I know you can add vendor records with this, but am confused about the Update part. Thanks for any answers. (If employee in EMPLOYEE has a name change, then we want to update their matching Vendor record by using the AP510. I would automate this by using process flow) Wanda

We upgraded to Apps 9.0.1.2 and now certain actions in Lawson processing is causing the system to create a Commitment Budget. This is causing a major problem with our Crystal reports. AP175 is one program that creates a new budget. Can I just turn it off in GL01.4

We are getting positive pay exceptions because the vendor name is too long for the 30 character limitation in the vendor master. How can we use a larger vendor and insure that it will print on the AP check

I am looking for the information on the AP270 and also if it was tagged with a  Reportable Income code.  Would Addins be the best route to take, and if so, which table should i pull from Currently we are running the AP270 for the year and the AP245 then reviewing both to see what should have been reported, and what wasn't but should have been.   Any help would be great.

We are trying to create a trigger in Oracle that will capture the user ID of the individual making a change within the Lawson Application.  Looking at the code within Lawson itself, it looks as if the application graps the CRT-USER-NAME. Is it possible to grab the application user signed on using an Oracle trigger