|
|
|
|
|
|
4 Replies and 8036 Views
Lawson Portal Screens 8036 4
Started by PZ
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
|
|
|
|
4 |
8036 |
by mark.cook 06/23/2010 6:43 AM |
|
4 Replies and 2521 Views
Vendors with no activity 2521 4
Started by jacobske
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!
|
|
|
|
4 |
2521 |
by Eddie Smith06/16/2010 2:18 PM |
|
2 Replies and 1839 Views
IC11 1839 2
Started by ARaja
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).
|
|
|
|
2 |
1839 |
by ARaja06/16/2010 12:00 AM |
|
2 Replies and 1659 Views
ERDs 1659 2
Started by Jeff
Have been trying to access the ERDs on this site for two days now with no response. Are others having a similar issue Jeff
|
|
|
|
2 |
1659 |
by John Henley06/15/2010 9:59 AM |
|
1 Replies and 7974 Views
Identifying a 3 way match PO/Invoice/Receipt with SQL 7974 1
Started by mikekask
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...
|
|
|
|
1 |
7974 |
by Ruma Malhotra06/11/2010 11:21 AM |
|
4 Replies and 3246 Views
Location of GL Distribution fields for PO20.1 form 3246 4
Started by mikekask
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...
|
|
|
|
4 |
3246 |
by DennisM06/01/2010 11:45 AM |
|
2 Replies and 1343 Views
Duplicate Record Error 1343 2
Started by Boyd
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.
|
|
|
|
2 |
1343 |
by Boyd05/26/2010 4:06 PM |
|
0 Replies and 1879 Views
Invoice Approval Routing 1879 0
Started by Tricia
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 ...
|
|
|
|
0 |
1879 |
05/24/2010 9:26 AM |
|
|
2 |
1665 |
by mikekask05/24/2010 8:49 AM |
|
4 Replies and 1759 Views
BR120 1759 4
Started by Deleted User
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.
|
|
|
|
4 |
1759 |
by Brad Schauer05/20/2010 6:41 AM |
|
10 Replies and 2900 Views
Lawson PO and AR screens freezing up 2900 10
Started by Johnbaby
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
|
|
|
|
10 |
2900 |
by Johnbaby05/18/2010 5:47 PM |
|
1 Replies and 1862 Views
Grants in Non-Academic Healthcare 1862 1
Started by Randy
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
|
|
|
|
1 |
1862 |
by mark.cook05/11/2010 11:32 AM |
|
1 Replies and 1594 Views
GL Code maintenance error message 1594 1
Started by AD
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
|
|
|
|
1 |
1594 |
by Brad Schauer05/10/2010 11:19 AM |
|
3 Replies and 6528 Views
CB Setup for ACH Payments 6528 3
Started by LauraSantos
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...
|
|
|
|
3 |
6528 |
by LauraSantos05/10/2010 9:14 AM |
|
|
2 |
1690 |
by Gail Gudgel05/05/2010 12:11 PM |
|
4 Replies and 1701 Views
Accruing Payables 1701 4
Started by Katfra
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
|
|
|
|
4 |
1701 |
by Gail Gudgel05/05/2010 12:04 PM |
|
2 Replies and 2695 Views
invoice tables 2695 2
Started by hkatt
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.
|
|
|
|
2 |
2695 |
by Vijay S05/05/2010 12:24 AM |
|
2 Replies and 1569 Views
AP25 and AP125 1569 2
Started by aphillips
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
|
|
|
|
2 |
1569 |
by aphillips05/03/2010 2:17 PM |
|
2 Replies and 4505 Views
Extracting Received Not Invoiced (PO135) with SQL 4505 2
Started by mikekask
I am trying to automate the data gathering for an AP Scorecard report in Excel. Part of the info I need is the Received Date and the Current Amount for PO's that are received but not invoiced. This info prints on the PO135 report, but I would like to get the data directly with an SQL query through an Oracle Client. This can all be done with a VBA macro in Excel. I need to know what fields and tables to get the data from. I'm not sure if this type of thing is discussed in this forum or on this si...
|
|
|
|
2 |
4505 |
by mikekask04/28/2010 3:47 PM |
|
2 Replies and 1402 Views
RW100 issue using Level Groups in 9.0.1 1402 2
Started by Arden
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
|
|
|
|
2 |
1402 |
by Ruma Malhotra04/19/2010 11:06 AM |
|
2 Replies and 2807 Views
Duplicate Vendors 2807 2
Started by Deleted User
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.
|
|
|
|
2 |
2807 |
by Dave Amen04/12/2010 9:37 AM |
|
0 Replies and 2002 Views
Paid Amount Displayed In AP90 Is Double The Invoice Amount 2002 0
Started by Deleted User
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
|
|
|
|
0 |
2002 |
04/09/2010 9:20 AM |
|
4 Replies and 3874 Views
Asset Transfer Error 3874 4
Started by Miyuki
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
|
|
|
|
4 |
3874 |
by Kevin Hagan04/08/2010 12:17 PM |
|
0 Replies and 1726 Views
GM400 1726 0
Started by LawsonandSapGuy
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.
|
|
|
|
0 |
1726 |
04/07/2010 12:47 PM |
|
5 Replies and 2681 Views
Research - ECM for AP 2681 5
Started by Lee
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!
|
|
|
|
5 |
2681 |
by EdB04/01/2010 11:32 AM |
|
1 Replies and 1273 Views
In Chartsum table how parent_obj_id relates to seq_number 1273 1
Started by cmmrfrds
I am looking at the chartsum table and it looks to me like there is a recursive relationship between seq_number and parent_obj_id. Also, there is a depth field and sumry_acct_id. Can anybody tell me if there is a recursive relationship between seq_number and parent_obj_id If so, should a seq_number have a parent_obj_id that has a lower depth number In other words, a depth 2 seq_number should have a parent_obj_id with a depth 1. Thank you.
|
|
|
|
1 |
1273 |
by Milo Tsukroff04/01/2010 11:31 AM |
|
7 Replies and 1917 Views
Assets posting twice in the GL 1917 7
Started by Miyuki
Hello, I'm currently doing the asset management module testing. I am adding assets through AP and I'm noticing that the assets are being posted on the GL twice, once through AP and another through the AM module. Can anyone give me any guidance on why it's doing this thanks, Miyuki
|
|
|
|
7 |
1917 |
by sgoins04/01/2010 10:51 AM |
|
0 Replies and 1740 Views
Intellias & AC\BR Process Improvement 1740 0
Started by Rory Flood
Hey folks. Just wanted to toss out a question in regards to using Intellias to automate AC\BR processes. Has anyone worked with Intellias for anything and specifically AC\BR process automation This has come up as an area we are looking into and really need some feedback as to who has done this and what it was like for them. Thanks.
|
|
|
|
0 |
1740 |
03/24/2010 7:57 AM |
|
2 Replies and 2251 Views
A/P Check printing changes 2251 2
Started by Deleted User
We are on Lawson 7.2.23. The company is changing banks. Their checks require changes to the print format. We run a pretty 'vanilla' shop in terms of out Lawson apps. Do we need to change a print program or is there defined templates that needs changing The area of change will on the right side of the check-- adjusting where the numeric value of the check prints and shortening the length of textual amount of the check. Any pointers would be helpful and appreciated. Rebecca
|
|
|
|
2 |
2251 |
by Deleted User03/18/2010 3:17 PM |
|
1 Replies and 2246 Views
AP52.3 Must inquire before using this function code 2246 1
Started by Sam Payne
I keep getting this message (Must inquire before using this function code) when I try to upload to APCDISTRIB (AP52.3. I mapped the HK field but I do not see a hidden filed for the inquire.
|
|
|
|
1 |
2246 |
by Brad Schauer03/10/2010 8:39 AM |
|
1 Replies and 3915 Views
Report Writer tables 3915 1
Started by Diane G
Does anyone know what tables Lawson report writer accesses to provide average daily balances I have a report that was working just fine, then when we got to Febr 2010, the previous year adb's started coming up with a -0- in the YTD ADB for February 2009. Not sure if something got messed up in the tables or if there is something wrong with my report, even though I get correct amounts for all other columns on the report.
|
|
|
|
1 |
3915 |
by Brad Schauer03/10/2010 8:37 AM |
|
3 Replies and 8432 Views
where to go to download microsoft add ins for lawson? 8432 3
Started by BobG2166
I've been using Lawson for a grand total of 3 weeks and would like to know what I need to do in order to download the Microsoft AddIns for Lawson Out group has been typing journal entries directly into Lawson and I would like to convert this to an upload process. Thanks. Bob
|
|
|
|
3 |
8432 |
by BobG216603/08/2010 8:16 PM |
|
6 Replies and 1950 Views
Making Old Project Activity Codes Inactive 1950 6
Started by Saurabh
Hi Has anyone found a way to make the old Project Activity codes as Inactive. I have setup a new status called IN and not assigned any of the tasks to it (in AC02 i think). Even put an end date However when in RSS we are still allowed to select that Activity We are on 8.1 0 MSP5, LSF 9.0.0.4 on Win 2003 with SQL2005 backend Regards Saurabh
|
|
|
|
6 |
1950 |
by Saurabh03/03/2010 9:31 AM |
|
1 Replies and 1774 Views
Grants Users? 1774 1
Started by mark.cook
I was wondering how many others&160;use the GM&160;module
|
|
|
|
1 |
1774 |
by John Henley03/03/2010 9:06 AM |
|
|
2 |
2657 |
by magskn02/26/2010 9:43 AM |
|
3 Replies and 4302 Views
Documentation Access 4302 3
Started by manishka22
Last week when i registered on Lawsonguru, I was able to access a link that gave me all documentation for all lawson products and I used it to do some analysis. But this week, I donot see that link and when I try to enter url directly it gives error message that I do not have access Does anyone know how do I get access to all those user manuals under documentation link Is there a specific setup required on my profile to access the documentation. Please reply ASAP, need some docs urgentl...
|
|
|
|
3 |
4302 |
by John Henley02/26/2010 7:31 AM |
|
3 Replies and 12022 Views
GL tables and relationships 12022 3
Started by cmmrfrds
I am new to Lawson GL and would like to combine information from the GL tables to look at the linkages between the various tables. Does anybody have a general query that shows the joins between the glmaster, clchartdtl, glchartsum, glchart, glnames, and glamounts. Thank you, Jerry
|
|
|
|
3 |
12022 |
by John Henley02/19/2010 3:44 PM |
|
|
1 |
4590 |
by mark.cook02/19/2010 7:16 AM |
|
3 Replies and 1806 Views
Vendors: Can you lock down a vendor class 1806 3
Started by Deleted User
Just curious if its possible, can you lock down changes to a vendor depending on what vendor class it is For example, if the vendor falls within an Employee Class, our Vendor Setup employee cannot make a change to the record.
|
|
|
|
3 |
1806 |
by Deleted User02/18/2010 8:05 AM |
|
1 Replies and 1710 Views
GL38 - Split Distributions 1710 1
Started by psal
Does anyone has a process on creating split distributions for prepaid expenses in the GL38 screen If so, do you have a process on how this works without closing Recurring Journal We do not want to setup a closing control for RJ and Lawson's documentation is not clear on what the process is after we add the entery in GL38. When do the transactions get posed to GL etc Thanks, Priya Saluja
|
|
|
|
1 |
1710 |
by Brad Schauer02/17/2010 10:51 AM |
|
39 Replies and 9867 Views
Year End closing process (Pre-Close) 9867 39
Started by Venkatarajamani Raman
Hi,
I seek help on pre-closing the fiscal year. Appreciate your help / guidance.
Background: My client is having just one GL company and having sub-systems like AP, AR, AM , BR, CB and GL.&160; Currently they are following the period from 01-Apr to 31-Mar.
They want to move on to 1-Jan to 31-Dec from Year 2009 onwards. Now that I need to close the current fiscal year (2008).&160; My client will close the GL Books only on 15-Jan and other subsystems will be closed by&160;&160;end of De...
|
|
|
|
39 |
9867 |
by Brad Schauer02/11/2010 6:22 PM |
|
7 Replies and 3567 Views
Project Cost Allocations 3567 7
Started by Boyd
I currently have a project that is setup to record transactions to an expense account.&160; I need to allocate these costs, including the amounts from the RNI accrual, to other accounting units and accounts.&160; I have found a way for CA 10 to allocate actual costs to other GL account, but am having trouble allocating the RNI (PO 135) costs to the other GL accounts.&160; Any asisstance is appreciated.
|
|
|
|
7 |
3567 |
by Kevin Hagan02/04/2010 3:01 PM |
|
1 Replies and 1910 Views
GLS995 1910 1
Started by Deleted User
I am new to Lawson Guru and I am not sure of the protocol for asking questions.
I am in the finance area and was wondering if you can run GLS995 GL Calculate Profit/Loss multiple times - or just once when all of the year end entries are completed.&160; My GLS215 did not close out the year end P&L to retained earnings so my opening balance in 2010 is off.&160; I beleive that GLS995 will correct this; however, I may have new entries once my year end audit is completed (adjust journal entrie...
|
|
|
|
1 |
1910 |
by John Henley02/01/2010 11:10 AM |
|
5 Replies and 2096 Views
Asset Management 2096 5
Started by TerryL
Has anyone implemented Asset Management in S3
We are in that process now and could use any advice you can offer.
thanks.
|
|
|
|
5 |
2096 |
by Lee01/29/2010 1:36 PM |
|
0 Replies and 1753 Views
Test Instance for Lawson 1753 0
Started by manishka22
All Lawson Gurus,
Thanks for having this forum, I was trying to find an environment/instance where I can actually see Lawson and do some testing to find how the product works. Could you please help me with any such instance where I can get access and test the product Financials (or activity and project accounting)
Thanks
|
|
|
|
0 |
1753 |
01/27/2010 9:21 AM |
|
2 Replies and 2220 Views
Tax rounding account not set up for company 2220 2
Started by Lee
We are testing our transition from 8.0.3 apps/9.0.0.x environment to 9.0.1 apps and environment.&160; The error 'Tax rounding account not set up for company' is stopping the release of the batch on AP25.&160; There are 2 new tabs (9.0.1 apps) that were not on 8.0.3 (workflow and tax tolerance). Has anyone encountered this error - how is it repaired
Thanks!
|
|
|
|
2 |
2220 |
by Brad Schauer01/25/2010 5:13 PM |
|
2 Replies and 1401 Views
Find a Skipped Check Run: Possible? 1401 2
Started by Deleted User
If a check run was skipped, without looking at how old invoices are in the APInvoice table is there anyway to find out I'm familar with AP150, AP155, and AP170, I'm thinking since they are jobs its harder to find that info out.
Bascially find out that it has been X number of days since a check run has been performed for a cash code and pay group. Any ideas. I really don't want to see all of the outstanding AP.
Any thoughts will be greatly appreciated.
&160;
|
|
|
|
2 |
1401 |
by Brad Schauer01/25/2010 5:08 PM |
|
1 Replies and 2808 Views
RNI - PO135 HELP 2808 1
Started by lawsonnewbie
I accidently ran the RNI as an update in the middle of the month. Now the final RNI report doesn't tie to what has posted. Is there a fix for this
&160;
|
|
|
|
1 |
2808 |
by mark.cook01/08/2010 11:23 AM |
|
0 Replies and 1358 Views
third party freight bills and tie back to original POs 1358 0
Started by Deleted User
Is there a recommended way to process third party freight bills but keep the freight costs connected to the original POs and ordering centers&160; For example, a FedEx\UPS bill might contain 50 shipments for different vendors and PO numbers, where we asked the suppliers to ship on our account number rather than charge freight through their processes and carriers. What would be the best way to pay the invoice to the freight carrier but tie the individual package charges back to the associated v...
|
|
|
|
0 |
1358 |
01/06/2010 3:22 PM |
|
|
1 |
1357 |
by linda phillips12/31/2009 11:21 AM |
|
2 Replies and 2029 Views
closed am190 by mistake 2029 2
Started by Frank
We closed AM190 by mistake and can we restore only the am from a backup
|
|
|
|
2 |
2029 |
by Jimmy Chiu12/24/2009 9:11 AM |
|
2 Replies and 1805 Views
SQL Tables for AC90.1 form 1805 2
Started by mxg119
I want to create a sql dataset based on the results from the AC90.1 Activity Anyalysis form. Can someone tell me what database tables are used for this
|
|
|
|
2 |
1805 |
by Kevin Hagan12/21/2009 7:27 AM |
|
2 Replies and 1570 Views
Year End CTPs 1570 2
Started by Deleted User
&160;
Does anyone have a list of Year End CTPs for AP and PR&160; We are on Lawson 9.0.0.4. and having trouble tracking down which CTPs we need to apply.
Thanks
|
|
|
|
2 |
1570 |
by Deleted User12/18/2009 1:00 PM |
|
6 Replies and 5998 Views
Reconciling AP Control with AP Subledger 5998 6
Started by Aaron M
Hello,
&160;
I was wondering if anyone could provide me with a simple way to do this when the control accounts go out.&160; Currently our AP 175 posts in summary to the GL so when AP&160;control does not = AP 136 Subledger, I have no idea where to start looking.
&160;
Thanks!
|
|
|
|
6 |
5998 |
by Aaron M12/16/2009 5:34 PM |
|
4 Replies and 2025 Views
Need more than 30 characters for Vendor Name 2025 4
Started by Sam Payne
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
|
|
|
|
4 |
2025 |
by Sam Payne12/15/2009 2:23 PM |
|
4 Replies and 1612 Views
AR Write-Off to seperate company 1612 4
Started by Deleted User
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
|
|
|
|
4 |
1612 |
by fran12/14/2009 11:28 AM |
|
1 Replies and 1976 Views
AP270 need a little more information 1976 1
Started by Wade-T
I am looking for the information on the AP270 and also if it was tagged&160;with a &160;Reportable Income code.&160; 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.
&160;
Any help would be great.
|
|
|
|
1 |
1976 |
by Michael Landis12/12/2009 2:00 PM |
|
2 Replies and 1851 Views
Caputuring Lawson Application user for oracle trigger 1851 2
Started by Todd Mitchell
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.&160; 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
|
|
|
|
2 |
1851 |
by John Henley12/11/2009 2:44 PM |
|
4 Replies and 2493 Views
AP510 Vendor Conversion 2493 4
Started by Wanda Schaaf
I should know this but:&160; 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).&160; 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
|
|
|
|
4 |
2493 |
by Wanda Schaaf12/03/2009 1:51 PM |
|
1 Replies and 1721 Views
Cmmitment Budget Created by System 1721 1
Started by Sam Payne
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
|
|
|
|
1 |
1721 |
by Ruma Malhotra12/03/2009 9:33 AM |
|
2 Replies and 2058 Views
Paid AP Invoices in a Released Status 2058 2
Started by Deleted User
I am working on cleaning up AP by&160;querying Open Invoices using MS Addins where the records have very old dates.&160; We use the data and make a determination whether to write off the credit or cancel the invoice.&160; I am finding invoices in the query that have a Released status but have been paid.&160; Why does this happen and is there something we can do to change the status of history so the process completes.
|
|
|
|
2 |
2058 |
by Ruma Malhotra12/02/2009 3:03 PM |
|
5 Replies and 1464 Views
AC120 running forever 1464 5
Started by FrankH
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
|
|
|
|
5 |
1464 |
by FrankH12/02/2009 11:16 AM |
|
3 Replies and 1931 Views
change vendor numbers and copy history 1931 3
Started by Kate Liamero
does anyone know an easy way, or if it is possible,&160;to change vendor numbers and maintain the vendor history.&160; employees are in our vendor master file.&160; 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 .&160; The range of numbers used by the adp employee is not being used in the lawson apvenmast.
|
|
|
|
3 |
1931 |
by Kate Liamero11/24/2009 1:33 PM |
|
6 Replies and 1712 Views
Moving accounting units between companies 1712 6
Started by blong
Our finance department has decided to setup a new company (5020) for a group of accounting units that currently exist in another company (2500).&160; Both companies will co-exist.&160; Looking for ideas on how best to move accounting units and history to the new company.&160; AR is handled in a different system.&160; AM and AC are utilized though.
|
|
|
|
6 |
1712 |
by blong11/19/2009 2:09 PM |
|
1 Replies and 1847 Views
AP Vendor Master City Length 1847 1
Started by Michele B
When converting our vendor master to lawson AP&160;vendor (version 9.0.1)&160; a couple of cities were longer than the 18 length limit.
Ex. San Juan Capistrano and&160; Rancho Santa Margarita
Anyone run into this type of problem&160; - how would you shorten a city name and still get a check to the correct destination&160;
&160;
|
|
|
|
1 |
1847 |
by chadC11/17/2009 4:28 PM |
|
5 Replies and 1977 Views
Data not show in BL123 after Importdb, AR560 and AR90.1 1977 5
Started by chen
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.
&160;
But the data can not be seen in BL123.&160;Are there other steps missing How to make the data available in BL123
&160;
Thanks!
|
|
|
|
5 |
1977 |
by chen11/07/2009 8:07 AM |
|
1 Replies and 2185 Views
Lawson Asset Management Module - Local Governments 2185 1
Started by KellyH
Good afternoon!
I would like to email with someone from a local government that uses Lawson Asset Management.&160; We are refining our processes and thought I would get some feedback from others.&160; Please email me at Kelly.Houstonbuncombecounty.org.&160; Thank you very much!&160;
|
|
|
|
1 |
2185 |
by Dave Mitchell11/04/2009 12:58 PM |
|
2 Replies and 4628 Views
Uploading to Asset Management using Lawson's Excel Add-In 4628 2
Started by John Henley
<p>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.</p><p>Read <a href='https://www.lawsonguru.com/Articles/View/tabid/346/ArticleId/435/default.aspx'>Uploading to Asset Management using Lawson's Excel Add-In</a>...
|
|
|
|
2 |
4628 |
by Dave Mitchell11/04/2009 12:56 PM |
|
|
3 |
2483 |
by John Henley11/04/2009 11:18 AM |
|
1 Replies and 1658 Views
AC40.1 what does it affect? 1658 1
Started by HBrown
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
|
|
|
|
1 |
1658 |
by Brad Schauer10/28/2009 2:32 PM |
|
3 Replies and 2359 Views
AP Posting In Summary 2359 3
Started by Deleted User
We would like options for posting some of our AP data in summary.&160; We created a vendor class to be used for these items and designated it to post in summary.&160;&160;Then we&160;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.&160; Is there something we have to do to the line items in the AP20 and AP20.7 to make sure we post in summary.&160; We add to the description line at the distrib...
|
|
|
|
3 |
2359 |
by Deleted User10/26/2009 10:43 AM |
|
1 Replies and 1515 Views
Activity Level Length 1515 1
Started by John Costa
I'm looking for a technical reason as to why an Activity level length cannot be modified after it has been created.&160; We are using four activity levels to identify an Activity in Lawson.&160; We are wanting to change the length of level four from 8 characters in length to 9 characters.&160;
I've done some playing around in one of my Lawson sand boxes, updating the ACACTGRP file in our product line database.&160; I set the LEVEL_SIZE_04 value for our primary Activity Group to 9.
So ...
|
|
|
|
1 |
1515 |
by John Costa10/21/2009 11:41 AM |
|
11 Replies and 9322 Views
Lawson Upload Wizard 9322 11
Started by Jeff
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
|
|
|
|
11 |
9322 |
by EricS10/07/2009 3:27 PM |
|
2 Replies and 1800 Views
AC 1800 2
Started by kumar
&160;I have not run AC191 for almost 1 year.
Can any1 tell me the impact of not running this program
&160;
&160;
|
|
|
|
2 |
1800 |
by kumar10/07/2009 7:40 AM |
|
5 Replies and 4189 Views
Initial Ledger data load 4189 5
Started by jp
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
|
|
|
|
5 |
4189 |
by jp10/03/2009 6:09 PM |
|
2 Replies and 2435 Views
Using sub-accounts: Good, Bad, or Ugly stories? 2435 2
Started by Greg Wiklund
My Company is considering using sub accounts for a select group of accounts.&160; 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).&160; Anyone have some stories (good and/or bad) about using sub-accounts&160; An example of intended use is to have a 'maintenance'&160;account that has sub accounts for vehicles, store, a/c, etc.
Thank you in advance
Greg Wiklund...
|
|
|
|
2 |
2435 |
by John Henley10/03/2009 6:09 PM |
|
2 Replies and 2661 Views
Error Suspense 2661 2
Started by Boyd
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
|
|
|
|
2 |
2661 |
by mpovey10/01/2009 2:20 PM |
|
0 Replies and 2779 Views
Smart Reconciliation 9.0.1.03 Installation Issue 2779 0
Started by Deleted User
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...
|
|
|
|
0 |
2779 |
10/01/2009 1:42 PM |
|
3 Replies and 5233 Views
Capitalizing Assets from AC to AM 5233 3
Started by johnmessina
Greetings All!
I have a question I'm hoping someone can help me with, regarding the capitalization of assets from the Activities module to the Asset Management module.
I'm interested in learning the 'official' process in transferring costs from AC to AM, that is, the way the developers designed for the System to work.&160; I would imagine this method would encompass an entry that reduces the balance in the specific activity itself, while increasing a corresponding fixed asset account, or ...
|
|
|
|
3 |
5233 |
by Sherry Shimek10/01/2009 9:25 AM |
|
7 Replies and 2635 Views
Submitting Jobs in Portal 2635 7
Started by mpovey
We just moved onto 9 Portal and I&160;would like to find a way to sumbit jobs without having users' hands leave the keyboard.&160; Lawson says the only way to submit is to click with one's mouse&160;on the submit button, but I'd love to find a way so hands can stay at keyboard. Thank you.
|
|
|
|
7 |
2635 |
by Eddie Smith10/01/2009 8:47 AM |
|
|
4 |
1492 |
by HBrown10/01/2009 8:28 AM |
|
2 Replies and 1682 Views
Urgent: Recall Release AR42.1 1682 2
Started by Jeff
Need a quick reply if there is a means of calling back a Released batch from AR42.1
Thanks in advance.
Jeff Wells - State of NH
|
|
|
|
2 |
1682 |
by Jeff09/30/2009 9:15 AM |
|
0 Replies and 1239 Views
Community Development Loan Administration 1239 0
Started by Quantitalyst
Is there any governmental user who is administering community development loans through Lawson&160;How about loans in general Grants in general
Mark C Johnson
Systems Analyst (City of Providence, RI)
|
|
|
|
0 |
1239 |
09/28/2009 9:53 AM |
|
0 Replies and 1448 Views
AR Rolling or movement reporting 1448 0
Started by SK
Has anyone ever written or created a detailed AR rolling / movement report by customer account to represent the entire AR sub ledger that ties back to the GL movement we have a request from our auditors to provide this information.
Currently we are using open item and do not print statments for all customers. We find the AR294 report lacking in this area.
Any recommendations on which canned Lawson reports may be move useful than creating out own report
|
|
|
|
0 |
1448 |
09/23/2009 8:57 AM |
|
12 Replies and 7515 Views
General ledger 7515 12
Started by Dainty
We are on a fiscal period ending Oct 31st. The years that are opened are 2006, 2007 & 2008. When I posted my transactions(GL190) beg Nov 1, 2008, they were posted in 2006. Please help how I can change the current year to 2009 (GL10.1).
|
|
|
|
12 |
7515 |
by Dainty09/21/2009 2:14 PM |
|
1 Replies and 1722 Views
Multiple Attributes in One List 1722 1
Started by rsq2_15
We have several attributes set up to group cost centers by director, vp, etc for easier report running capabilities.&160; When setting up an attribute, you also have to set up a list (MX10.1) which includes that attribute, in order to call that grouping (by list) in report writer.
My question is...it looks as though multiple attributes are able to be added to each list.&160; It even lets me add them and it says 'Change Complete - Continue'.&160; However, after adding two attributes to a li...
|
|
|
|
1 |
1722 |
by rsq2_1509/07/2009 3:01 PM |
|
0 Replies and 1422 Views
Original Cost Transaction date when Burden Applied 1422 0
Started by Kamal
&160;Hi
&160;I&160;have a question on Burdens. Would appreciate if someone can help me with the answer.
we add a burden to each item that we purchase using donor funding.&160; This burden is a in effect a mark-up or Overhead cost.&160; AC61 applies a specific burden to the cost when the cost is posted.&160; Since the new custom program is changing the structure of &160;burdens the costs, we need to make sure that the burden is applied at the same exchange rate as the original cost...
|
|
|
|
0 |
1422 |
08/20/2009 1:23 PM |
|
3 Replies and 2697 Views
Change GL10 Period Close from Final back to Limited 2697 3
Started by Chris Puckett
We had a GL manager do a 'final' close on GL199 for December 2008 and now we need to post an entry to that month.&160; Has anyone ever done this&160; I figured it's not something recommended by Lawson given the fix probably entails changing a variety of flags.
|
|
|
|
3 |
2697 |
by Chris Puckett08/14/2009 10:59 AM |
|
5 Replies and 2548 Views
Fiscal Calendar Change 2548 5
Started by mpfrimel
We're looking at changing our fiscal calendar from&160;Jan.1-Dec. 31 to a Feb. 1-Jan. 31 period.&160; Has anyone done this and how did you handle the one month gap&160; Lawson documentaion talks about GL500 but that just seems to adjust history.&160; We're iSeries, 9.0.0.4 apps and 9.0.0.5 env.
|
|
|
|
5 |
2548 |
by mark.cook08/03/2009 7:28 AM |
|
0 Replies and 1471 Views
Summarized distributions in APDISTRIB & MA01.1 1471 0
Started by TimD
We went live on 9.0.0.4 apps in December 2009 and didn't change the flag in MA01.1 under the options tab to summarize distributions to 'N'. We discovered this after users were running crystal reports and getting stange results. We then changed the flag to 'N' and all reports were correct (from the date of change forward). This did cause another issue with crystal reports. The data that is now getting written to the GLTRANS table&160; in the 'DESCRIPTION' field actually contains the 'ITEM NUMBER...
|
|
|
|
0 |
1471 |
07/30/2009 10:39 AM |
|
9 Replies and 2725 Views
Requistion History 2725 9
Started by Jeff
How does one view the status and history of a requistion as it flows through the approval process within Lawson&160; Are there standardized reports or screens that provide this level of information&160; Any guidance is appreciated.
|
|
|
|
9 |
2725 |
by Jeff07/28/2009 3:32 PM |
|
0 Replies and 1387 Views
Lawson Financial and POSIX Subsystem 1387 0
Started by dmorton
Does anyone know if the POSIX&160;subsystem is required for Lawson Financial Is it needed for the lid utility
Thanks
Dave
|
|
|
|
0 |
1387 |
07/16/2009 10:29 AM |
|
3 Replies and 2480 Views
Read a flat file. 2480 3
Started by Kishan
IS IT POSSIBLE TO READ A UNIX FILE (CREATED BY THE USER WTH HIS/HER OWN DATA) FROM A LAWSON PROGRAM
|
|
|
|
3 |
2480 |
by Kishan07/16/2009 1:41 AM |
|
6 Replies and 4293 Views
AP136 tie to GL90 AP Acct Balance 4293 6
Started by Freddy Garcia
Looking to see if anyone has had to reconcile their AP accrual account between AP and GL.&160; I have ran both AP136 and looked at GL90.&160; When comparing both I am always off by 425k.&160; I did find one transaction with a source code of AD that was in the accrual account (there should only be trans with a source code of AC).&160; I also ran a query on APDISTRIB and found some trans that for some reason have not posted to GL (would not be in GL90).&160; Well&160;I&160;am still off and ...
|
|
|
|
6 |
4293 |
by Brad Schauer07/14/2009 8:50 AM |
|
0 Replies and 1672 Views
Applying Discounts to Distribution 1672 0
Started by Deleted User
Is there a way to apply a discount to individual line items on an invoice.&160; We have a vendor that allows an early payment discount on the product only not the freight.&160; Is there a better way to do this other than to hard code the discount amount and discount date through the AP30.3 after it's been released.
|
|
|
|
0 |
1672 |
07/13/2009 3:07 PM |
|
1 Replies and 1913 Views
Understand Diff between APInvoice and Invoice Hdr / Detail 1913 1
Started by muffntuf
Hi,
I want to understand the difference between the APInvoice table and the Invoice Header/Detail tables. &160;Is APInvoice for receivables (makes sense to me) and Invoice Header/&160;Detail is for billing, correct
Thanks!
|
|
|
|
1 |
1913 |
by John Henley07/09/2009 9:31 AM |
|
2 Replies and 3799 Views
Two Questions: 3799 2
Started by Eric Haugen
Thanks to anyone thhat can anser two questions I&160;have, Someone posted:
07/01/2009 05:04 PM
EditQuoteReplyAlert&160;
I would appreciate any help anyone may provide on these two problems. I'm working on a brand new apps 9.0 upgrade (we are already on Env 9). Things are going well except:
A Lawson client on this board has previously&160;reported a problem with workfile(s) g...
|
|
|
|
2 |
3799 |
by Jimmy Chiu07/03/2009 9:07 AM |
|
8 Replies and 3920 Views
Work file paths 3920 8
Started by NickM
I went from apps 8.0.3 to 9.0.0.4. We have work files from jobs that are not going to the correct product line for example, we are getting old product line instead of the new one as a relative path to the work files. Do to this, jobs have been going down.&160;Does anyone have a suggestion
|
|
|
|
8 |
3920 |
by Eric Haugen07/01/2009 4:04 PM |
|
1 Replies and 2267 Views
Who released a credit/payment batch 2267 1
Started by Petter
Is it possible to find out what username released a specific payment batch Not the user who created it, but who released it
|
|
|
|
1 |
2267 |
by John Henley06/30/2009 10:15 AM |
|
1 Replies and 1964 Views
Payment Posting 1964 1
Started by Deleted User
If I create a payment in June for July 1st but run the AP170 in June will the payment post and relieve cash in June or July.&160; Here's the scenario.&160; Our rent payments are due the 1st but the ACH file has to be at the bank one day prior so I always run them in the current month.&160; No big deal.&160; We are managing cash tighter this quarter so I want to know if I run the ACH&160;file batch in June but date the payments for July which month will my balance sheet be affected
|
|
|
|
1 |
1964 |
by Brad Schauer06/29/2009 8:45 AM |
|
0 Replies and 1671 Views
Intercompany reporting for auditors 1671 0
Started by Kim92
My company has many intercompany realtionships defined within Lawson.&160; I am curious to find out if any Lawson client has a solution to providing visibility to the originating transaction description.&160; The auditors do not like seeing 'auto offset from...'&160;&160;&160;Thank you!
|
|
|
|
0 |
1671 |
06/25/2009 2:54 PM |
|
1 Replies and 1871 Views
Balance Sheet Account Closing to RE at Year End 1871 1
Started by MattK
Does anyone know how to make a balance sheet account close into retained earnings at the end of the year&160; We are a financial services/insurance organization that needs to track multiple pieces of the retained earnings component in different accounts for statutory reporting.
|
|
|
|
1 |
1871 |
by dj06/17/2009 4:30 PM |
|
1 Replies and 2001 Views
Adding Transactions to Run Billing & Revenue 2001 1
Started by challan
I am adding records into AC54 so that I&160;have some expense&160;to run Billing & Revenue.&160; The problem is that these expenses are already embedded with other expenses in interfaces into&160;Lawson.&160; I&160;cannot change my interfaces to exclude the portion of the expense that I want to run Billing and Revenue for.&160; Therefore, I am double booking the expense and want to reverse out the entries that I am making in AC54 after I run Billing & Revenue.&160; I do not know ...
|
|
|
|
1 |
2001 |
by John Henley06/17/2009 10:11 AM |
|
2 Replies and 1683 Views
Dynamically change As of Date on AR251 1683 2
Started by JoeS
Is there a way to 'dynamically' change the As of Date on a AR251 job&160;&160; I am looking to schedule an AR251 to run weekly via recdef and want to avoid any manual intervention.
JS
|
|
|
|
2 |
1683 |
by TracyO06/15/2009 1:14 PM |
|
6 Replies and 13854 Views
Interface AP employee expense check to payroll 13854 6
Started by Jim Van Zummeren
We have recently installed the Lawson HR/payroll module. Our AP department is wanting to have direct deposit of expense checks available.
So instead of maintaining direct deposit information in both the AP and payroll system we are wondering if anyone passes the expense checks from their AP system to their payroll system so that they can be included on their regular paycheck.
|
|
|
|
6 |
13854 |
by John Henley06/09/2009 12:51 PM |
|
3 Replies and 1924 Views
Interpreting GLNAMES Level Detail information 1924 3
Started by Matthew Nye
Im trying to create a geneology of AUs by using the LEVEL_DETAIL_&160;fields from GLNAMES but I dont really understand the values the fields are being populated with. &160;They dont seem to coorespond to the AU&160;values or the OBJ_IDs. &160;
Any ideas
&160;
Thanks,
Matt
|
|
|
|
3 |
1924 |
by Ruma Malhotra06/09/2009 9:43 AM |
|
0 Replies and 1958 Views
Use of Smart Recon-9.0.0.5 apps 1958 0
Started by itsjustme
We continue to experience issues related to Smart Recon after our recent upgrade from 8.0.3 apps to 9.0.0.5 apps. We are on LSF9.0.0.5, Unix, Oracle.
In particular the Authority Code/Buyer is dropping from the messages created in Smart REcon. When matched in MA60, we cannot duplicate the issue. Lawson is unable to duplicate the issue either using Smart Recon. We have tried finding other companies using Smart Recon without much luck.
Just looking here to see if anyone uses or has additional inf...
|
|
|
|
0 |
1958 |
06/08/2009 8:06 AM |
|
2 Replies and 2348 Views
Printing AP Checks 2348 2
Started by Thomas Jackson
We are currently in the process of installing Lawson at our facility and on our old system we printed checks via Adobe Output Designer and in HR&160;we used Crystal to do this.&160; Is it possible to use one of these programs to print manual AP or Payroll check.&160; If so, could&160;someone shed some light on this for me.
Thanks,Thomas
|
|
|
|
2 |
2348 |
by Thomas Jackson06/04/2009 12:52 PM |
|
2 Replies and 2516 Views
Project & Activity Performance 2516 2
Started by mcl
Our consultants are suggesting the use of the Activity module for several tracking and reporting issues that we have for a city government.&160; We have grants, projects, contracts, enterprise funds, etc. that will be treated as projects or activities in this module.&160; I remember reading one forum issue on an update or closeout program for this module.&160;&160; What is the history of this module in performance, and is there a limit to the number of Activity 'groups' that it can handle.
...
|
|
|
|
2 |
2516 |
by mcl05/18/2009 11:37 AM |
|
2 Replies and 2825 Views
AP136 Performance patch 2825 2
Started by DeltaFoxtrot
In our organization we are having unusually long run times when running an AP136 (takes anywhere from 5 to 20 hours, depending on what parameters are used).&160; AP database is quite large about 92 million records.&160;We are&160;running LSF 9 and SQL server 2005.&160;
Lawson Support&160;suggested we run the CTP 58954 patch to resolve&160;this issue.&160; This patch took 5 days to run in our test environment, we are now evaluating if it is worth it to run it in our production environment...
|
|
|
|
2 |
2825 |
by DeltaFoxtrot05/11/2009 2:10 PM |
|
3 Replies and 2518 Views
Duplicate record in Asset Management 2518 3
Started by Diane G
I'm new to Lawson (just in CRP&160;testing right now). I tried testing an adjustment to change the purchase date and get adjusting entries.
I get to the AM20.5 form and see my journal entries. I know I need to do an ADD to get the entires over to GL, then an AM170 to release. However, on the AM20.5 when I click add, I get a message that says duplicate record, so I get no entries over to GL.
Does anyone have any clues
&160;
|
|
|
|
3 |
2518 |
by Brad Schauer05/08/2009 10:09 PM |
|
5 Replies and 2295 Views
SQL Server 2005 Performance 2295 5
Started by JY
Lawson ENV&160;803 SP7, Financials 803 SP11.&160; Recently migrated to SQL&160;Server 2005 as a step toward LSF9.&160; Since then, performance for the most part has been abysmal.&160; A function like BR42 now times out.&160; Once any load has been put on the system, response time degrades significantly.&160; Pursued Lawson GSC about BR42 but we discovered ourselves that the wrong index (at least from our perspective) is being used.&160; Checked all the usual suspects -- the MICROSOFT&16...
|
|
|
|
5 |
2295 |
by John Henley05/05/2009 12:20 PM |
|
1 Replies and 1918 Views
ee20.2 1918 1
Started by Kate Liamero
Because there are no user fields for ee20.2 we would like to&160;add 2 date fields to the bottom of the eeexpense table and then add the fields to the form in design studio.&160; Our travel audit department needs to track the dates when the expense approval was received and the date the receipts associated to the expense were received.&160; Does anyone forsee any problem with doing this
Thanks
Kate
|
|
|
|
1 |
1918 |
by John Henley05/01/2009 5:20 PM |
|
14 Replies and 2977 Views
AC190 Performance problem 2977 14
Started by John Costa
We are preparing to 'flip the switch' on our LSF9 migration and go live this weekend.&160; However, we've identified a serious performance problem with AC190 (Activity Posting).
On our 5-year old hardware running SQL-2000, environment 8.0.3 (ESP7) and applications 8.1.0 (MSP6), our nightly AC190 job takes app. 4.5 hours to complete.
On our new state of the art 64-bit database server running SQL-2005, LSF9, and the same application set, the AC190 job is taking any where between 10.5 and 12 hou...
|
|
|
|
14 |
2977 |
by John Costa05/01/2009 7:22 AM |
|
2 Replies and 2959 Views
GL165 - IFJR.1 and IFTR.1 error reports 2959 2
Started by Dave
Wondering if anyone has experienced this issue and might offer some tips&160; We are LSF9 - I&160;have a script that launches the GL165 as Lawson - it's launched via a portal button by a handful of users.&160; The user gets a copy of the GL165.prt - but does not get a copy of the associated error and je report created by IFJR and IFTR.&160; Their LS class has complete access to both GL and IF system codes and all programs.&160; The only way a user is able to view all reports is if I set ch...
|
|
|
|
2 |
2959 |
by mark.cook04/23/2009 2:17 PM |
|
5 Replies and 3898 Views
AR Invoice Distribution 3898 5
Started by Jeff
Hello all.&160; Rather new to Lawson so hopefully I can explain my issue.
Using MS Add-ins to upload Invoice data.&160; A typical invoice has 3-5 lines to it.&160; Each line has the total invoice amount in, ARH-ORIG-AMT.&160; The AMD-ORIG-AMT contains the amount that applies to each detail line.
When I upload the data to AR42.2, I receive the following results:
Transaction added - distributions out of balance
Transaction header record already exists | Transaction changed - distributions ...
|
|
|
|
5 |
3898 |
by Jeff04/16/2009 11:46 AM |
|
2 Replies and 5992 Views
Summarized transactions in GL for AP / AC,VP,AP source codes 5992 2
Started by Venkatarajamani Raman
Hi,
Our customer has configured the setup in such a way that summary of transactions should only go to GL from AR, BR, AP, AP, CB, AC and AM sub systems. I&160;am in the process of building a program that would print all the detail transactions for the given GL&160;account.&160; While doing so, I am able to identify the detail records for AR, AC, AM and CB records from ARDISTRIB, ACTRANS, AMTRANS and CBDISTRIB&160;respectively using GLT-OBJ-ID. For invoice distribution records in AP (system...
|
|
|
|
2 |
5992 |
by Venkatarajamani Raman04/13/2009 1:27 AM |
|
3 Replies and 2737 Views
Variance report 2737 3
Started by Chandra
I am creating a budget variance report in reporting services. I am looking for (1) Revenue&160; --&160; Acutal / Budget&160;&160;&160; and&160;&160;&160;&160;(2) Expenditure - Acutal /&160;Budget.&160;&160;I was able to go after some tables like GLTRANS, FBDETAILand etc.
Can some one help me please identifying what table should I go after for my requirements (1) and (2) above for Acutals and Budget
Thanks
|
|
|
|
3 |
2737 |
by John Henley03/31/2009 5:09 PM |
|
10 Replies and 4542 Views
Link AP Record To Another Application 4542 10
Started by Deleted User
Hello, this is my first posting to the forum so my appologies if I've made any forum etiquette transgressions. I am architecting a Sharepoint application which will manage the workflow for each line of business (LOB) for the approval and routing of invoices to Lawson AP. The Sharepoint application will be the repository for the LOB approvals and supporting documentation&160;including, scanned impages.
What I need is a way of linking the invoice in Lawson AP&160;to the Sharepoint application t...
|
|
|
|
10 |
4542 |
by John Henley03/25/2009 1:14 PM |
|
0 Replies and 1678 Views
Factor or Pay To Vendors 1678 0
Started by Verna
My CFO would like to start paying contractors but including the sub-contractors name on the payment to ensure the sub-contractors are being paid.&160; We have never used AP11 before and I cannot determine the difference in 'factor' vs 'pay-to'.&160; Also, how would the check print&160; She would like to see 'GENERAL CONTRACTOR A and SUB-CONTRACTOR B' printed as the payee.&160; Is this possible&160; Any help or suggestions would be greatly appreciated!
|
|
|
|
0 |
1678 |
03/20/2009 6:10 PM |
|
2 Replies and 2688 Views
13 PERIOD ACCOUNTING 2688 2
Started by KathyT
Is anyone using a true 13 period calendar - 28 days per period&160; If so, would it be possible to&160;share how you have set up your dates and rolling the extra week in year 6 into the calendar
Thank you
|
|
|
|
2 |
2688 |
by dj03/16/2009 11:01 PM |
|
0 Replies and 2579 Views
AR Open Item/Invoices Table Extract 2579 0
Started by dj
I am more of a functional user, however, I have experience with Addins.&160; I want to query the following&160;out Lawson but I need to query the tables and not the forms (application)
1)&160;Open AR deposits
2) Open AR items--invoices, credit memo's debit memos
I queried the followoing tables: AROIHDR & AROITEMS&160; Should I be going after different tables
|
|
|
|
0 |
2579 |
03/16/2009 4:23 PM |
|
4 Replies and 2089 Views
drill-around on company field take up 15 second 2089 4
Started by Xin Li
On program Ap20, po20, gl90, etc if drill-around on company field, it takes up 15 second to display. Anyone has similar issue Any suggestion to improve it
We are on AIX 5.3 LSF 9.0.04 and Apps 8.1.0. Oracle 10g
|
|
|
|
4 |
2089 |
by John Henley03/13/2009 12:45 PM |
|
3 Replies and 3286 Views
AP520 3286 3
Started by Deleted User
&160;Can someone help me locate or determine the steps required to upload&160; invoices from&160;our Food and Beverage&160;system into Lawson. We are currently using LSF9.Some of the information I have gathered is that we export the invoice data from our F&B system into a CSV file, then upload the CSV file into Lawson (via AP520). My IT guy said he was able to 'upload'&160;3 invoices out of F&B sys and&160;into Lawson(). However, when he attempted to run AP520, he got no infor...
|
|
|
|
3 |
3286 |
by John Henley03/12/2009 2:18 PM |
|
1 Replies and 2137 Views
AP160 ACH Remot File 2137 1
Started by Vito Amatulli
Our company currently uses a custom VB application to send emails to vendors notfifying them of their payments. We are looking to eliminate this VB&160;application and place the process on our AIX server.&160; Does anyone know if Lawson provides any software to send email acknowledgements to vendors or do we need to code a custom application using PFI or Java
Any feedback would be appreciated.
Thanks, Vito.
|
|
|
|
1 |
2137 |
by John Henley03/06/2009 3:47 PM |
|
1 Replies and 2083 Views
Periodic Accurals 2083 1
Started by NickM
We currently have Lawson 9.0.
On a periodic basis the Financial Planning and Analysis (FP&A) Team will need the Final actual data export (i.e. the financial data for each period that composes the financial statement) out of Lawson so I can upload it into our budget/forecasting tool.&160; We use Adaptive Planning. Export should only contain GL and Actual.
Can I do this through Microsoft Add-ins Or do I need to go after it using the oracle database. I would think Addins should work.
|
|
|
|
1 |
2083 |
by dcaiani03/06/2009 10:41 AM |
|
2 Replies and 3017 Views
System Code GL01.1 and GL01.2 3017 2
Started by Deleted User
Does anyone know the benefit and hindrance of using system control in the GL system&160;
I know you can't close GL if the sub systems are not closed, how does GL know if PR is closed or not.&160; Right now we don't use System Control for PR or other sub systems except for AP.
Does Lawson recommend it&160; Do you clients recommend it
Does it work the same way in LSF9 as it would in 8.1
Appreciate your help.
Barb
|
|
|
|
2 |
3017 |
by dcaiani03/06/2009 10:32 AM |
|
3 Replies and 3120 Views
AP160-Extra Header 3120 3
Started by Deleted User
When our AP160 files&160;have about 200 transactions, AP160 is creating an extra header at the bottom of the file. This confuses the bank because they think more is to follow, but there isn't any extra data.
Any ideas on what is causing the extra header at the bottom
|
|
|
|
3 |
3120 |
by Vito Amatulli03/06/2009 8:48 AM |
|
1 Replies and 1798 Views
Franchise Calendar Change - FR00.1 1798 1
Started by dj
We currently operate on a 4-4-5 calendar.&160; This coming year we will have 53 weeks in our fiscal year.&160; Our FR00.1 calendar is currently setup with 53 weeks, however, the question has been asked if we can change the calendar to 52 weeks&160;
We have the following questions/concerns:
1) How will this affect our interest calcuation on notes
2) How will this affect the scheduled billings for the 53 week.&160; Will the system generate the billings which are interfaced from the FR (fr...
|
|
|
|
1 |
1798 |
by dj03/05/2009 7:31 AM |
|
0 Replies and 1611 Views
Lawson Integration and Testing 1611 0
Started by amit g
Hi Everyone,
Can someone share the testing procedures and workflow diagrams for Lawson Integration with other applications.
It would be great if someone can share the integration model too
|
|
|
|
0 |
1611 |
03/04/2009 6:03 AM |
|
1 Replies and 1667 Views
ISeries 9.05/9.06 GL45 missing 1667 1
Started by TRACY
We are testing our upgrade and don't seem to have a GL45, we have other GL's.&160; Anyone else run into this issue
|
|
|
|
1 |
1667 |
by Srini Rao03/01/2009 5:36 PM |
|
1 Replies and 2396 Views
Inventoried Items details in GL 2396 1
Started by Eddie Smith
We have users wanting to know item information, such as vendor, quantity, unit costs, etc.. for inventoried items that have been received against POs and updated to the general ledger. Has anyone found a way to link back from GL trans to the IC system Thanks in advance for any help.
|
|
|
|
1 |
2396 |
by John Henley03/01/2009 2:37 PM |
|
1 Replies and 2242 Views
AP20 Addin Load 2242 1
Started by jlswildcat
I&160;have a question I'm hoping I&160;can get a quick answer to . . .&160; Can the AP20 Addin be used to update invoices already created in the AP20.1 screen
|
|
|
|
1 |
2242 |
by Ruma Malhotra02/26/2009 9:49 AM |
|
1 Replies and 2311 Views
AC500, AC510, AC540 Interface Errors Question... 2311 1
Started by klippe
For those of you who have used the Activities module interface programs, AC500, AC510 and AC540, can you provide some insight into the following:
Do these programs process all records in the underlying interface tables regardless if an error is encountered, or do they stop processing once the first error is encountered
For example, if I am interfacing 2 Activity records into Lawson via the AC500 and both records have bad data on them.&160; When I run the AC500 program will the error report s...
|
|
|
|
1 |
2311 |
by John Henley02/19/2009 8:39 AM |
|
0 Replies and 3308 Views
Year-End Closing Journal Entry in consolidation company 3308 0
Started by Deleted User
Hi all:
In Lawson companies, only&160;revenue accounts are set up to allow units. When the year end closing entry is generated by the system in period 1 of the consolidation company, it requires that we set up balance sheet accounts to allow units. Otherwise, those accounts will hit suspense. I am not sure why this is. As a work around, our&160;users can either a) allow units in those accounts or b)delete the system generated entry and just create one of their own to reverse the whole Balance...
|
|
|
|
0 |
3308 |
02/09/2009 2:29 PM |
|
6 Replies and 3990 Views
8 Formats in RW100 3990 6
Started by Ruma Malhotra
I am taksed at creating a report writer report that has more than 8 formats. How can I acheive this using report writer
&160;
Is there anyway
&160;
Thanks,
ruma
|
|
|
|
6 |
3990 |
by Ruma Malhotra01/22/2009 10:09 AM |
|
9 Replies and 7147 Views
Reconciling AP170 Summarized Transactions 7147 9
Started by Deron
I'm being asked to write a report reconciling journal entries with an R_SYSTEM of AP, ORIG_PROGRAM of AP170 and DESCRIPTION of Summarized transactions.
From what I can tell, there are no matching records in APDISTRIB.
Does anyone know how I could back into this
|
|
|
|
9 |
7147 |
by Deron01/09/2009 9:02 AM |
|
0 Replies and 1895 Views
Partial Payment Reconciliation 1895 0
Started by Deleted User
We have a balance in our AP for a partial payment on a recurring invoice.&160; When we try to clear the balance by adding an additional payment line in the AP30.3 we receive an error message that partial payments aren't allowed on recurring payments.&160; First,&160;I&160;don't know how we short paid the orginal payment if it's not allowed but how can we clean this out of our aging.&160; It's really triggering my OCD.
|
|
|
|
0 |
1895 |
01/07/2009 2:28 PM |
|
0 Replies and 1723 Views
Upgrade wedges LDAP data--how to recover? 1723 0
Started by bobmetcalf
I was doing the YE upgrade--the one that creates an LDIF
file and has you load it into the LDAP server.&160;&160; After an attempt
to load it, both UAT and PROD instances fail, with LDAP-like
errors.
&160;
Any ideas
|
|
|
|
0 |
1723 |
01/03/2009 1:22 PM |
|
0 Replies and 2062 Views
Year End Process - Should we closed all the POs? 2062 0
Started by AnnaC
Year End Process - Should we closed all the POs so the remain $ amount on the POs will affect next year's budget
Every year, our company has to go through a prolong Year End process because Lawson does not allow two active budgets. Below are the stpes:
1.close all the POs prior to year end and accure the remaining $ amount on the POs to an Accural account.
2. Open requisitions for those POs against the Accrual account so we can pay Decemeber's invoices.
3. Load new budget.
4.Open requis...
|
|
|
|
0 |
2062 |
12/24/2008 10:47 AM |
|
0 Replies and 2115 Views
RW100 Reports - Identify path 2115 0
Started by stcyrk
I amtrying to schedule a job to run an RW00 report and send to a share drive.&160; The share drive receives the .prt (mapped via Reports Options in RW100), but the actual report still shows up in the Print Mgr.&160; Where can I map the actual report
|
|
|
|
0 |
2115 |
12/19/2008 2:23 PM |
|
|
2 |
2836 |
by mdantona12/11/2008 2:21 PM |
|
3 Replies and 2838 Views
GL290 - Error trying to print landscape 2838 3
Started by StephenV
Hi,
One of my finance users has been running the GL290 this morning.&160; When she tries to print these in print manager, every third one or so hangs her system when she attempts to print in landscape.&160; Some times it works, other times not.&160; Has anyone seen anything like this before&160;
Thanks!
Stephen
|
|
|
|
3 |
2838 |
by John Henley12/05/2008 5:03 PM |
|
4 Replies and 2830 Views
Running Microsoft AddIns 2830 4
Started by NickM
We recently added Microsoft AddIns. Does anyone know where a query goes once it's submitted A job queue&160;
If a query is&160;not working and needs to be deleted where does this&160;occur nside Lawson 9.0.04 or in our&160;oracle 10g database&160;
Thanks..
|
|
|
|
4 |
2830 |
by MikeM11/21/2008 12:52 PM |
|
2 Replies and 5473 Views
Intercompany accounts building - do you settle/reconcile them? 5473 2
Started by Deleted User
Do you all do anything about your intercompany accounts continuing to build&160; I know at the top level they net to zero, but if we run finanacials on just on company or a few the intercompany amounts on the balance sheet are very large.
Do any of you try to 'settle' or 'reconcile' them&160; If you make&160; a je to reverse them then the system also reverses in the background when zone balancing and the amounts become the opposite sign.&160; We could turn zone balancing off and then cl...
|
|
|
|
2 |
5473 |
by Deleted User10/30/2008 11:28 AM |
|
2 Replies and 2685 Views
Crystal Reports 2685 2
Started by Deleted User
I have several crystal reports that&160;are &160;parameter driven which&160;are &160;loaded on a dashboard for our users.&160;&160; The problem is when the users put in the parameters
to execute the report and click OK, the parameter screen just sit there until
the report execute with data.&160;&160;&160;Our &160;users would like for something to say that
the 'report is processing'&160; or ' please&160;wait'.&160;&160;&160;&160;&160;On other reports that is not parameter driv...
|
|
|
|
2 |
2685 |
by Deleted User10/29/2008 2:40 PM |
|
4 Replies and 3256 Views
tsStoreDBRec Error 3256 4
Started by SRH
We just upgraded from Laswon 8.x to 9.x on both our Apps and env.&160; We are receiving this error meesage when we try to update our AM information:&160; tsStoreDBRec error is Key Change not allowed (32).&160; I know that this deals with the indexes because this was found&160;in the ladb.log log files:&160;
Wed Oct 22 13:15:21 2008: &91c:\lsftest\law\test\obj\AM604&93
The program attempted to change the value of a field
which is used by a 'no key change' index.
&160;&160; file: AMA...
|
|
|
|
4 |
3256 |
by John Henley10/23/2008 3:07 PM |
|
2 Replies and 2332 Views
CA for Journal Entry 2332 2
Started by JLS
We'd like to create CA that doesn't touch the balance in the original AU and Account, but accumulates all of the costs in certain Cost Centers and creates a journal entry as follows:
Original Balance:
100706-520003 100.00
The CA would create the entry to do the following:
DR 610010-520003 (Same AU for all lines, each expense account would change)
CR 100913-520003 (Same AU for all lines, expense account would change).&160;
Can I do this without creating contra accounts&160; Thanks
|
|
|
|
2 |
2332 |
by JLS10/23/2008 11:22 AM |
|
0 Replies and 3666 Views
Intercompany balances building (zone balancing) 3666 0
Started by Deleted User
Do you all notice that your intercompany accounts keep growing and growing (zone balancing)&160;
They zero out if you include all companies but sometimes we report on only a couple companies and on the balance sheet, our intercompany accts are huge.&160; Do you ever try to zero them out or 'settle' your intercompanies
You can't just make a je to clear them or the zone balancing system will make offset entries and the balances will just appear opposite and not zero.&160; We know we cou...
|
|
|
|
0 |
3666 |
10/15/2008 1:55 PM |
|
1 Replies and 3652 Views
AR Reconciliation 3652 1
Started by dj
In theory, shouldn't the AR250 (Aging)&160;or AR251 (Aging)&160;tie out to the AR256 (Receivables Tie Back).&160; Also, wouldn't the AR250 or AR151 tie to the GL balance outside of any JE's to the AR control account
What would cause the AR251 and AR256 to be out of balance
|
|
|
|
1 |
3652 |
by John Henley10/07/2008 8:33 AM |
|
0 Replies and 2779 Views
1099's for Tuition Reimbursement 2779 0
Started by DeeC
We want to set up a new Income Code to be used for 1099's for Tuition Reimbursement for employees, but we're wondering how other places handle reimbursements that come in after year-end close for the prior year.
&160;
Do you back-date the AP check (and open the prior period/year)&160; &160;If so,&160;what is the best way to post to the prior date/year on the GL side Any info would be greatly appreciated!
|
|
|
|
0 |
2779 |
10/03/2008 9:32 AM |
|
2 Replies and 2634 Views
AR Customer User Fields 2634 2
Started by LindaM
We are looking to use two of the user fields to populate out legacy manufacturing system.&160; We are inquiring to see if anyone has written a user exit application for validation of the AR Customer User fields.
We are currently using the LSF9 security to 'block' invalid entries to fields but the only message that will display is 'Security Violation'.&160; If anyone has an idea on 'customizing' the user fields we would love to know.
|
|
|
|
2 |
2634 |
by LindaM10/03/2008 2:58 AM |
|
3 Replies and 5158 Views
AP150 Fails With Error Payment Forms Creation AP155 is Running 5158 3
Started by JuanS
We are having problems running AP150, it fails with the error log below.&160; We ran AP170 but it did not solve the problem.&160;
Any input will be greatly appreciated.
Juan Sanchez
BEGIN:&160; Job Submitted:&160; Wed Oct 01 18:05:40 2008
&160; Step&160; 1:&160; AP150 Started. . . . . .:&160; Wed Oct 01 18:05:40 2008
&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160; Token Command. . . . . .:&160; C:\LINTE\APPS\aacn803\obj\AP150.gnt
&160;&160;&160;&160;&...
|
|
|
|
3 |
5158 |
by JuanS10/02/2008 2:20 PM |
|
0 Replies and 2199 Views
workfile error 2199 0
Started by MLAN
We entered a PO match invoice on AP20, and click on Match.&160; The error 'workfile error' is received.&160; Should we rebuild the workfile Any diea Thanks
|
|
|
|
0 |
2199 |
09/04/2008 5:36 PM |
|
3 Replies and 2876 Views
LID 9.0 on Unix ?? 2876 3
Started by des123
Does LID 9.0.1 run only on Windows and not Unix&160;
I do not see any documentation for it on Unix, only Windows.
|
|
|
|
3 |
2876 |
by des12309/04/2008 9:50 AM |
|
3 Replies and 2527 Views
Vendor User Fields 2527 3
Started by des123
We recently migrated from LSF8 to LSF9.&160; We have discovered in LSF9 that the customized field namess on the 'User Fields' tab on the AP10.1 form&160;are not carried over from LSF8.
I looked at KB article 130516 but we do not have locales set up in LSF8 that would facilitate the customized fields.
Does anyone know how to either move the customized field names over from LSF8 to LSF9 or can anyone explain how I can re-set them up
Thanks in advance.
|
|
|
|
3 |
2527 |
by des12309/02/2008 3:15 PM |
|
2 Replies and 2818 Views
AP Vendor Class 2818 2
Started by Deleted User
When Adding a new AP Vendor Class and assigning that class at the vendor level invoice history does not seem to be affected in selection reports such as the AP150 or AP250.&160;&160;I thought that since the change was done on the vendor level that the parameter selection for those reports would be pulling information&160;from the vendor&160;tables but the reports come up empty.&160; Does the vendor class populate in an invoice table that can me modified or do I just need to wait for the his...
|
|
|
|
2 |
2818 |
by Chris Martin08/29/2008 4:40 PM |
|
2 Replies and 2654 Views
No drill back information for this column 2654 2
Started by des123
We have just upgraded from LSF8 to LSF9.&160; When I run a customized report&160;in the new LSF9 and&160;invoke the drill around on a field the Drill Around screen has no data in the Detail box and a message 'No drill back information for this column' is displayed at the bottom of the screen.&160; This drill around works OK in the LSF8 environment.
Does anyone know what would cause this to happen in a new environment
Thanks,
|
|
|
|
2 |
2654 |
by Sam Simpson08/20/2008 11:51 AM |
|
1 Replies and 2687 Views
XBRL 2687 1
Started by John Henley
XBRL
I haven't seen much from Lawson on new products/functionality that will help companies comply with new SEC filing requirements by 2010 (some 'lucky' ones get to do it earlier). If this affects you, what are you doing Using another app Outsourcing
John Henley
|
|
|
|
1 |
2687 |
by k-rock08/20/2008 9:55 AM |
|
0 Replies and 2317 Views
APInvoice with no APDistrib record 2317 0
Started by TimF
I am new to AP support, but I have a division that processes prepayment invoices without an APDistribution record.&160; I did not think this was possible.&160; It seems to be only on Wire Transfers or Drafts. I can see&160;APPayment records,&160;I can see the payment on CB80&160;but they are still showing as an open item.&160; &160;This has been goin on for years so I don't think it is bug/patch related - note we are on 9.0 apps. Thoughts anyone
&160;
&160;
|
|
|
|
0 |
2317 |
08/15/2008 2:12 PM |
|
3 Replies and 3430 Views
Cognos 8 3430 3
Started by Deleted User
Are there anyone out there who are using Cognos 8 with the Lawson applications
for reporting and disbusting&160; We are using Crystal 11 and not that please with it.&160;
Would like some feedback on what you think about the product.
|
|
|
|
3 |
3430 |
by Chris Martin08/15/2008 10:38 AM |
|
3 Replies and 5451 Views
AP161 EDI 820 file 5451 3
Started by StephenV
Hello!
Does anyone know how to run the AP161payment file so that it results in an EDI 820 format file&160; The AP manual seems to indicate that it can be done, however following all instructions we have only been able to produce text files in the $LAWDIR/lawapp9db/Work/AP161ELECTPMT and AP161ELECTRMT directories.&160; I notice that Lawson has an 'EDI' application that we aren't licensed to.&160; Do you know if this application is required to transform AP161 result files
Thanks!
Stephen
|
|
|
|
3 |
5451 |
by Ben Coonfield08/11/2008 2:36 PM |
|
6 Replies and 4489 Views
AR30.3 Invoice unavailable 4489 6
Started by Deleted User
7.2.24
An invoice visible in AR90 with an unapplied amount is not visible in AR30.3.
In DBARARO Base applied amount = Base amount while Tran applied amount
We are USD only and the latter was correct by DBARARA so I set base applied = tran applied.
Still no show in AR30.3
Last&160; DBARARA Result-fl = F so&160; I set to P
DBARARO record still unavailable in&160; AR30.3
Any sugggestions Programs to run Fields to examine
Files attached
Thanks,
KB
&160;
|
|
|
|
6 |
4489 |
by dj07/25/2008 4:55 PM |
|
6 Replies and 3026 Views
batch program using Users locale for workfile definition instead of jobstepwrk 3026 6
Started by Barry Ghotra
Not sure If I'm explaining it correctly, but I have a issue, where one out of all the users, is not able to run a batch program and doesn't like the CSV file&160; layout. The key difference I found with the user and the rest of the users is that this users examine log says:
'FILE OPTIONS WERE TAKEN FROM USERS LOCALE' for the ZR504-INV file, VS
'File options were taken from JOBSTEPWRK record'.
I believe it has something to do with the settings
Can anyone help me with how I can force the use...
|
|
|
|
6 |
3026 |
by Barry Ghotra07/21/2008 7:20 PM |
|
1 Replies and 2317 Views
AM20.3 and Addin 2317 1
Started by Kevin Hagan
I was looking to see if anybody has found a way to add more than five item lines on AM20.3 using Addins. While we can manually create numerous lines it appears addins limits you to just five lines because of the requirment to use the more button to add line six or greater
|
|
|
|
1 |
2317 |
by John Henley07/21/2008 8:47 AM |
|
2 Replies and 3534 Views
Budgeting Software 3534 2
Started by MikeScribano
We are beginning the process of looking at Budgeting applications to use with our Lawson ERP system.
I am looking for Lawson user's experience&160;with either Lawson Budgeting software or integrating non-Lawson Budgeting software with Lawson.&160; For non-Lawson Budgeting software, looking for names of vendors that you have had good experience with.
Thanks in advance for your assistance.
Mike
|
|
|
|
2 |
3534 |
by John Henley07/17/2008 5:58 PM |
|
2 Replies and 3499 Views
Unapplied cash by day (AR) 3499 2
Started by Barry Ghotra
we are looking for a way to get the data out of AR for unpaplied cash by day (by customer, is possible) . Accounting folks want to find the variance and I have looked at the tables involved but can't seem to make any sense out of it. Has anyone ever had a need for this. Any pointers/help with SQL if it's possible to do. Don't know if lawson keeps the history or is there any way to figure this out based on the check/cash applied and distribution
Thanks.
|
|
|
|
2 |
3499 |
by John Henley06/10/2008 1:33 PM |
|
8 Replies and 3537 Views
Lawson apps 9.0 differences/enhancements/features 3537 8
Started by Barry Ghotra
Anyone seen any doc/forum or ppt that talks or explain about features/enhancements in applications 9.0 from 8.0. We are only using the financials modules. Just need to know how much training (if any) the users need to go through before we cut over to 9.0 apps.
Thanks.
|
|
|
|
8 |
3537 |
by Barry Ghotra06/09/2008 10:14 AM |
|
3 Replies and 3358 Views
AP170 - going into needs recovery 3358 3
Started by Deleted User
Hello,
When I run AP170 the program is going into needs recovery with error message&160; ' ERROR :&160;&160; Stopped on Exit 1.'&160; Any thoughts why the program gets this error
Thanks in advance for any Suggetions/solution for this error.
&160;
Regards
Suresh
|
|
|
|
3 |
3358 |
by John Henley06/06/2008 9:19 AM |
|
14 Replies and 6442 Views
help with GL10.1 6442 14
Started by Jimmy Chiu
I am trying to change company address in GL10.1 and it hangs with an hourglass. it's happening both in LID and portal. Any suggestions it happening to everyone.
|
|
|
|
14 |
6442 |
by Jimmy Chiu05/29/2008 8:59 AM |
|
5 Replies and 5477 Views
Overflow: Printing issue...Lawson related? 5477 5
Started by Deleted User
Our company is currently having an issue printing overflow checks.&160; We have changed printers, taken the printer off the network, checked the software we are using to print the checks,&160;the driver for the printer, and the memory (512MB). &160;
The issue is if vendor 'A' is in the middle of the print queue the check will print, but the moment the overflow checks start to print , random code appears on the overflow pages and we lose the remaining overflow pages and checks.
If vendor 'A'...
|
|
|
|
5 |
5477 |
by Jimmy Chiu05/25/2008 12:45 PM |
|
5 Replies and 4486 Views
How does AC190 select the rate to use? 4486 5
Started by Deleted User
This is my first post I think this is the appropriate place for it.
We are using units of production to bill our customers. I have no problems when my rates remain the same. Unfortunately I can not figure out how to use more than one rate.
We are using days and we have the rates loaded in the rate table. If I am billing June, the rate changes on the 6th of the month. How do I get AC 190 to bill 6 days at the established rate and the remaining 24 days at the new rate
I am loading my...
|
|
|
|
5 |
4486 |
by Deleted User05/20/2008 8:33 AM |
|
3 Replies and 4905 Views
Error message on the portal 4905 3
Started by Deleted User
I am a newby&160; on the Lawson portal world, and I am having a problem where the program is not displaying the error message in the bottom of the screen as it does on lid. Is it any configuration on the browser that I need to do in order to make this happening Please help
|
|
|
|
3 |
4905 |
by Deleted User05/06/2008 11:02 AM |
|
1 Replies and 3989 Views
AP22.2 3989 1
Started by jjcyeshua
Hi! guys,
Question! What table gets updated using AP22.2...
Thank you
|
|
|
|
1 |
3989 |
by John Henley04/24/2008 4:51 PM |
|
0 Replies and 3106 Views
Help --> Urgent--->Lawson Reports to CSV Files 3106 0
Started by Deleted User
After running a job, 40 reports created in Lason and they need to be downloaded to CSV files in local drive C:
Wonder if there is a script I can run to download these 40 reports to 40 different CSV files directly.
The&160;other ERP will locate a 'marco' bar at the top of screen to allow end users to record the steps in a VB form. End users just record 2 download actions, then edit for the others. Not sure if Lawson can modernize its users to keep everything simple.
&160;
&160;
&160;
|
|
|
|
0 |
3106 |
04/23/2008 9:08 PM |
|
3 Replies and 4002 Views
JE-Memo transaction 4002 3
Started by oregon
Hello Lawson heads! (smile)
&160;
I’m pretty new to the Lawson GL module. If someone can tell me where I can find the status of a specific GL transaction “memo”, I would really appericate it. How the accountants have told me to find the status is as follows:
&160;
1) Log into Lawson desk top application.
2) &160;Go to the specific screen: &160;GL41
3) Enter in specific GL-JE &160;(Company, year..ect..ect)
4) ‘Drill around’ to the “Transaction Detail” screen.
5) Once on the main scre...
|
|
|
|
3 |
4002 |
by oregon04/22/2008 12:33 PM |
|
3 Replies and 3470 Views
Corp Adjustments 3470 3
Started by Deleted User
I am researching a process whereby our company would build a process to perform all of our corporate level&160;allocations.&160; The objective would be to&160;maintain the actuals as is BEFORE&160;the process&160;is executed (A), perform the allocations (B) which are based on&160;complex business logic and then store the results (C)&160;so that reports&160;could be&160;run on any combination of A, B, C.&160;
Mutli-ledger did not appear to handle this.&160; Any suggestions
|
|
|
|
3 |
3470 |
by Deleted User04/07/2008 10:23 AM |
|
2 Replies and 3917 Views
Process Level Accrual Codes 3917 2
Started by Deleted User
We use different process levels to denote different GL companies.&160; The process level defaults the accrual account so that the off setting credit goes to an intercompany accrual account.&160; The process level is entered at the invoice header and the accrual code defaults to the what ever is set up at the AP00.5.&160; Invoices with multiple distribution lines might need to hit more than one accrual codes depending on the GL Distribution Company Code.&160; How do we use different accrual c...
|
|
|
|
2 |
3917 |
by Deleted User03/07/2008 9:23 AM |
|
1 Replies and 11364 Views
AP - Invoice 11364 1
Started by bssridhara
We would like to pay our invoice thru credit card. I would like to hear
any suggestion if you would have done in your company.
|
|
|
|
1 |
11364 |
by bssridhara03/06/2008 10:51 AM |
|
0 Replies and 3339 Views
Biweekly Recurring AP Payments 3339 0
Started by Deleted User
Does anyone know if it's possible to create recurring payment in AP that recurs every other week&160; I&160;can see options for monthly, weekly, etc..but not an option that would meet this need.&160; Is it possible to create others&160; If so how do you do that
|
|
|
|
0 |
3339 |
03/06/2008 9:53 AM |
|
3 Replies and 2860 Views
period 0 2860 3
Started by Deleted User
Question about the General Ledger period 0:
&160;
Does Lawson have a period zero in any form in the GL database tables I started using the GLAMOUNTS table, which has 1-13 periods, but not period 0. &160;
Or.. Will I have to go back to the previous period and find out what the ending balance was and use that as period 0
&160;
Thanks..
|
|
|
|
3 |
2860 |
by k-rock03/04/2008 12:18 PM |
|
3 Replies and 3859 Views
GL Information (New to Lawson) 3859 3
Started by Deleted User
Hi…
&160;I am new to the Lawson and have a couple of question if someone in the group could answer them.
The questions deal with finance&160;GL entries&160;and how to obtain financial information from the Lawson tables.
&160;The information is specifically about the following:
1) All GL information in the GLMASTER table, but I also need the assets and the liabilities also. Please correct me if I am wrong, but I am not able to produce liabilities and assets from the GLMASTER. If not… ...
|
|
|
|
3 |
3859 |
by Deleted User02/25/2008 10:02 AM |
|
1 Replies and 5312 Views
Chart of Accounts maintenance 5312 1
Started by k-rock
How do people clean up the COA We currently purge transactions after 13 months and balances after 7 years. Is there a way to identitfy the accounts that haven't been used in over 7 years and delete them from GL00
What steps are required to delete an account from GL00 Do you have to deactivate the account for all accounting units
|
|
|
|
1 |
5312 |
by John Henley02/20/2008 1:46 PM |
|
0 Replies and 3147 Views
Recurring invoice 3147 0
Started by Deleted User
Hello all,
I have created a recurring invoice which is attached to batch... I released the batch and ran AP193 in UPDATE = Y option.
When I come back and inquire on the invoice... It throws an error that 'Invoice does not exist'.
My Question
Is there an place (form) where I can browse through my recurring invoices which I created
Many thanks in advance.
*********************
Regards
Suresh
|
|
|
|
0 |
3147 |
02/12/2008 9:37 AM |
|
0 Replies and 2909 Views
Adding Total Names the easy way 2909 0
Started by k-rock
I posted a tip over on LGUG.net about automatically generating Total Names for a new year. Check it out.
http://www.digitalconcourse.com/getdigi/dc4main.aspp=210&sp=7&ff=84&forum=1&thread=785&nt=1&ConfCode=lgugwebsite&dSeq=&tag=0
|
|
|
|
0 |
2909 |
02/06/2008 8:57 AM |
|
2 Replies and 4174 Views
Asset Management - when to tag assets 4174 2
Started by Deleted User
We are in the process of planning for an Asset Management implementation and I was wondering what the best practices are for determining at what point an asset is created and where
Options seem to be at the Requisition, Receipt, PO or AP Invoice level. I suppose going directly to the AM module is also an option. Any insight would be appreciated. Thanks!
|
|
|
|
2 |
4174 |
by Bill Ianni02/05/2008 2:40 PM |
|
2 Replies and 3050 Views
Add ins 3050 2
Started by Kevin Hagan
We just got the below response from Lawson regarding a number of our queries which stopped working. Has this issue effected anyone else if so how are you getting around the change.
Using related tables in your criteria is no longer allowed. The only exception to this that you can use a single related field, and then it must be the only criterion. So you can use multiple criteria if they are not to related tables.
|
|
|
|
2 |
3050 |
by John Henley02/05/2008 1:31 PM |
|
7 Replies and 9881 Views
Bill Rate Correction question -- BR120 9881 7
Started by chasnik
Hello, this is my first time posting and I hope I am in the right forum. I am responsible for revising/correcting all invoices at my company and I am having a small issue for which I can't seem to find any documentation in my manuals. Is it possible to correct a bill rate on an invoice once it has been processed through the BR120 run in update I have only been able to correct bill rates if I add new transactions, but I cannot find where I can correct bill rates once revenue has been recogniz...
|
|
|
|
7 |
9881 |
by chasnik01/16/2008 2:54 PM |
|
1 Replies and 10825 Views
Financial Calendar dates reverting? 10825 1
Started by Joe O'Toole
Can someone explain if there is a point where the financial calendar dates would get automatically updated (ie: closing last period in previous year, etc.) We've had an issue 2 years in a row where our finance department swears the calender is set up correctly for the new fiscal year and then the month and day for the new fical year periods magically revert back to the previous years month and day settings. As you can imagine, this causes grief since some periods had entries that could not be m...
|
|
|
|
1 |
10825 |
by John Henley12/20/2007 9:08 PM |
|
3 Replies and 11092 Views
GL190 - some can post, one cannot. Why? 11092 3
Started by Deleted User
Our Financial Acctg. mgr cannot seem to get GL190 to post entries. She gets the message “No journal entries detected for criteria given”. She relates that she has had this problem for several months, and has had to turn to her backup staff to run the jobs for her when all attempts fail. The other two have no problems running GL190, using the same criteria (dates and subsystems to access) that the manager has used.
The mgr. usually runs the GL190 for some of the subsystems, such as AP and ...
|
|
|
|
3 |
11092 |
by John Henley12/03/2007 8:23 PM |
|
2 Replies and 10789 Views
CB195 has unposted entries. HELP !!! 10789 2
Started by Lito
I tried running GL199 with limited close as the closing option. It gave me a report stating that the subsystem CB has not been closed for the period. So I ran CB190 and then CB195. The CB195 then gives me a report of 37 lines of unposted entries for the particular period. All transactions were of trans code DPT and has posted dates included in the report. I am at a total loss here so if anybody can help me, I would appreciate it.
|
|
|
|
2 |
10789 |
by Lito11/13/2007 6:37 PM |
|
1 Replies and 11226 Views
Purging A/P Vendor Master AP300 11226 1
Started by Deleted User
We plan to purge our vendor file of one-time vendors using AP300. We are on the Unix platform running Lawson version 8.0.3. We would like to know if anyone has experience with the AP300 and what your experience with this routine was. What problems, if any, did you encounter What were the benefits you gained from the purge
|
|
|
|
1 |
11226 |
by John Henley10/31/2007 1:57 PM |
|
5 Replies and 11674 Views
AP160 and AP161 Check file 11674 5
Started by jjcyeshua
Hi!.. I would like to ask if there's a way to modify the output check file, so that i could add/delete data that is being pulled. Thanks is advance..
|
|
|
|
5 |
11674 |
by John Henley10/23/2007 8:36 AM |
|
2 Replies and 11585 Views
auto-load one-time vendors 11585 2
Started by Deleted User
Hello - I'm hoping someone out there has experience with using AP520 to create one-time vendors during invoice import process. My organization is working to consolidate refund requests from our patient accounting system with a file upload. While we do import invoices on a regular basis, we have not used the vendor auto-create function in the past. Both AP and accounting staff have concerns in the following areas...
Duplication of existing vendors. It does happen even now, and is it th...
|
|
|
|
2 |
11585 |
by Sam Simpson10/15/2007 2:22 PM |
|
1 Replies and 11003 Views
AR48 - Add and Release 11003 1
Started by Deleted User
Does anyone know / have a process what allows Adding, then Releasing AR to AP payments
We have a few hundred transactions that needs to be interfaced, and manually doing the process takes too long.
We are on LSF9, with 8.0.3 apps
|
|
|
|
1 |
11003 |
by John Henley10/12/2007 2:05 PM |
|
3 Replies and 13173 Views
Invoice/Credit note matching 13173 3
Started by Deleted User
Hi,
Other than when making a payment using AP55 or on a system generated cheque is there any way of matching invoices and credit notes to clear them off an account
|
|
|
|
3 |
13173 |
by John Henley10/09/2007 12:11 PM |
|
0 Replies and 10252 Views
Aged Creditors 10252 0
Started by Deleted User
Does anybody use a good report for aged creditors. Thanks
|
|
|
|
0 |
10252 |
10/09/2007 10:11 AM |
|
1 Replies and 10217 Views
Screen Caching Issue in 9.0? 10217 1
Started by Deleted User
Hello,
I am currently having an issue that when on any form if I hit CtrlShiftK on a form and then try to enter for example a new invoice on AP20 I am receiving an error that the invoice already exists. This is basically happening on every screen where you are trying to add something new after clearing the form. Has anyone seen this issue I currently have a ticket with Lawson open and continue to work on it with them...no luck yet in trying to figure it out.
Thanks
|
|
|
|
1 |
10217 |
by John Henley10/05/2007 1:05 PM |
|
2 Replies and 10480 Views
Lawson 10480 2
Started by Deleted User
It is terrific to find a forum such as this. I am working for the executive leadership of a well known company that is going through some growing pains. They currently are using the unsupported version of Lawson for HR and Finance (modules were not installed properly according to client). Many of the major objectives of the finance department are dependent on the successful implementation of the supported version of Lawson (reporting, reducing monthly close, Sox compliance, etc).
As a fin...
|
|
|
|
2 |
10480 |
by Bill Ianni09/28/2007 10:59 AM |
|
5 Replies and 12314 Views
GL Maintenance Tracking / Statistics 12314 5
Started by Deleted User
I'm new to Lawson, so please forgive me if this doesn’t make sense, or I'm leaving out information.
I'm looking for a table that contains audit information on what account changes were made via GL20, GL00, GL30.
One of the Accounting managers would like a count of every GL record update that is made to Lawson, preferably by the form updated, and which user updated it. He's just looking for a way to track how much work his people are doing.
He specifically mentioned:
Accou...
|
|
|
|
5 |
12314 |
by Deleted User09/24/2007 10:44 AM |