We've been having mutiple users' screens freeze up in both AR and PO. They have to log off and back in to continue. I've reproduced the problem myself. For example PO20, PO30, RQ10, AR20, AR30... hangs up in po30.1 while receiving; hangs up whenever changing screens; when trying to release receiver; also happens when paging up & down. hangs up at different stages, not always the same places. Please help - the users have been having a terrible time. John

We are looking into options for our AP process to ECM (Content Management) solution. We have noted that Lawson lists 2 partners on their site; however, we would like to have input as to some of the vendors that are in use as to document imaging, etc. We would like pros/cons; ease of implementation, usage, etc that you may have experienced, etc. Any and all replies are welcome!

I am trying to have some tables dumped out to get a listing of invoice header info, invoice line info and any other fees such as freight or add on costs. what tables should i ask for. no report writing tool. APINVOICE AND APDISTRIB AND MAINVOICE THANK YOU.

Hello, Is there a function in Lawson AP that will allow you to accrue payables At the end of each month, we have payables coming in at the last minute and at some point, we just have to close our payables down. However, everytime this happens, we have some significant invoices come in that need to be posted so the Accountants would make a reversing JE to essentially accrue the payable. I was hoping there was a function in AP that would actually do this Thank you, Frank

We are having an issue with response time on batch releases using both AP25 and AP125. We are Iseries 9.0.0.6 both apps and env. The batches that used to take seconds now take minutes. We had one this morning that had one invoice and it took over two minutes to release. It is driving AP crazy. Does anyone have any advice on how to solve this

Hello, As I continue to do more testing for the asset management module I came across another error which I'm hoping someone can help me with. I'm trying to transfer an asset from one company to the other using AM30.1. However, the following error message appears: 'Company is not defined within range for activity.' We only have two companies set up and I confirmed that an intercompany relationship exists between them in GL25.1. Any help will be appreciated! thanks, Miyuki

I have a client who has been running GM400 with Output Option 'D' for Detail. Unfortunately, they are not able to see the detail. I need to clarify: They are able to see cost and revenue info for Budget, LTD, etc., but I am thinking that by 'Detail', they are hoping to see transaction detail. In any case, what level of detail should GM400 show when run with Output option 'D' Thanks.

We entered an inter-agency AP invoice. In reviewing the paid invoice detail in AP90 the Paid Amount displayed is double the Invoice Amount however, the amount posted and paid is correct. Why would the Paid Amount display as double the Invoice Amount

Does anyone have any good ideas or tricks to identify duplicate vendor records so that they can be merged. I thought I would see if there are best practices already established before I begin the process on my own.

We just upgraded to version 9.0.1.3 from 9.0.0.7. We have several reports that use level group overrides on columns within a Style 1 report. In version 9.0.0.7, these worked fine. In version 9.0.1.3, in some cases, the level groups simply print '0' when there is truly data within that account. I don't see any patches for 9.0.1.3 with regards to this issue. Is anyone else having RW issues in 9.0.1.x

Does anybody know that steps needed to change the default disbursement account in Accounts Payable

We would like to start processing some AP payments through ACH rather than a paper check. Our current bank setup in Cash Management was set up some time ago so they did not use the bank ID number in CB00.1, they gave it an alpha name to identify the bank, so when we run the AP160, the ACHTAPE file shows the bank name rather than the bank ID number. I have added two new banks in CB00.1 (the bank id for one is the electronic transfer bank’s routing number and the other bank id is the bank’s pape...

Hello, Every time I try to change the GL account for an existing GL code in AR15.7 I receive a message that states 'Cannot change GL account; GL code in use'. Any idea what is causing the message

Hello, I am trying to find out the field name and table name for the Purchase Order comments field. Thanks. Mike

We are a non-academic healthcare system with signficiant numbers of grants/sponsored projects. We are investigating how we can use the Activity module to steamline our grant accounting processes. Is there another similar institution that would be willing to share some tips/experiences/pitfalls Thanks

Hi, I am a brend new user of S3 and I run BR120 for 0 (unreleased) status instead of processed (3) in update run. So I generated a physical invoice but the invoice is in the system as 'unreleased', so AR can't see it. In the trx BR20.5 there is an option to release it, but I am not sure if it won't create any bug. I was trying this in the testing environment, but it didn't work, I've got an error message. Could you please help me Thanks many times.

We are trying to clean up our vendor master, In doing so we want to find vendors with no activity. I see there is no canned Lawson report for this - but in trying to create in crystal, we are a multi company facility - and using the APVENBAL table isnt proving to be that easy to use b/c it shows Last Payment date. I am sure there is a way to do this - but I am not a crystal expert by any means - so if anyone has done something similar to this, any information is greatly appreciated!

Hi, I am trying to access the PO20.1 form GL distribution fields (for GL posting) with an SQL query and I haven't been able to find out where these fields are located. I looked at the POLINE table definition and didn't see anything. Does anyone know where these fields are These are the fields at the bottom of the PO20.1 form for the tab that says 'Line Detail'. I am particularly looking for the fields under the 'Account' label which are Accounting Unit, Account, and Sub Account and also th...

Can anyone help me with invoice routing for invoices with multiple distribution lines that have different AUs. The invoices are routing by total invoice amount and the AU. Right now its routing by the first AU in line on AP20, regardless of how many AUs are listed. I tried using AP52 to interface these in an unreleased status so we can use a suffix for each line, so they route separatly. But, it isn't possible to interface an unreleased invoice on AP52 with a suffix and the flow is triggered ...

We just upgraded from 9.0.0 to 9.0.1. Many of our users are receiving duplicate record errors. So far, we have experienced this in GL, AR and AM. The user gets the message when they are trying to add an entry with multiple lines of coding.

I am trying to extract by SQL a count of the total PO lines of PO's that have a 3 way match of PO/Invoice/Receipt. I am using this total as the denominator to calculate the percentage of electronically processed PO's versus non-electronically processed PO's that could potentially be electronically processed. I've been told that to be electronically processed there has to be a three way match. For my numerator of the electronically processed PO's I am matching the POLINE table with the APINVOICE...

Have been trying to access the ERDs on this site for two days now with no response. Are others having a similar issue Jeff

IC11 takes longer time to respond, when delete action is performed. In 8.0.2 Applications, it is faster, But in 9.0.1 Application,it takes more time to process(nearly 15 minutes).

I know you can use 'Ctrl-Shift-O' to view the name of the corresponding field from a screen in Lawson Portal. Is there a way to identify the name of the table as well

A user allocates benefits costs from the Benefits Accounting unit to the department accounting units using Cost Allocation. Is there a way to round the amounts so the Benefits Accounting Unit is reduced to zero automatically for each account instead of leaving a few pennies presumably due to rounding