Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 5 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
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.cookJump to last post
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 SmithJump to last post
06/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  ARajaJump to last post
06/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 HenleyJump to last post
06/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 MalhotraJump to last post
06/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  DennisMJump to last post
06/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  BoydJump to last post
05/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 Replies and 1665 Views Table and Field Location of Purchase Order Comments  1665  2 Started by  mikekask Hello, I am trying to find out the field name and table name for the Purchase Order comments field. Thanks. Mike
2 1665
by  mikekaskJump to last post
05/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 SchauerJump to last post
05/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  JohnbabyJump to last post
05/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.cookJump to last post
05/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 SchauerJump to last post
05/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  LauraSantosJump to last post
05/10/2010 9:14 AM
2 Replies and 1690 Views Changing Default A/P Disbursement Account  1690  2 Started by  AD Does anybody know that steps needed to change the default disbursement account in Accounts Payable
2 1690
by  Gail GudgelJump to last post
05/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 GudgelJump to last post
05/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 SJump to last post
05/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  aphillipsJump to last post
05/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  mikekaskJump to last post
04/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 MalhotraJump to last post
04/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 AmenJump to last post
04/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 HaganJump to last post
04/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  EdBJump to last post
04/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 TsukroffJump to last post
04/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  sgoinsJump to last post
04/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 UserJump to last post
03/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 SchauerJump to last post
03/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 SchauerJump to last post
03/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  BobG2166Jump to last post
03/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  SaurabhJump to last post
03/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 HenleyJump to last post
03/03/2010 9:06 AM
2 Replies and 2657 Views AP175 Error Cannot run for cpy 0003 - company run in progress  2657  2 Started by  magskn User is trying to run AP175 and gets this error - Cannot run for cpy 0003 - company run in progress. We see no jobs that are running/waiting. Any help would be appreciated. Thanks
2 2657
by  magsknJump to last post
02/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 HenleyJump to last post
02/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 HenleyJump to last post
02/19/2010 3:44 PM
1 Replies and 4590 Views Reconciling the Received Not invoiced account with the GL  4590  1 Started by  cori We are fairly new to Lawson and are trying to reconcile the RNI to the GL. Where is the best place to start:crazy:
1 4590
by  mark.cookJump to last post
02/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 UserJump to last post
02/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 SchauerJump to last post
02/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 SchauerJump to last post
02/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 HaganJump to last post
02/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 HenleyJump to last post
02/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  LeeJump to last post
01/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 SchauerJump to last post
01/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 SchauerJump to last post
01/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.cookJump to last post
01/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 Replies and 1357 Views does any one run ap246 with a control code  1357  1 Started by  linda phillips we need to add the control code and in lawson I see Payer name- are they the same.
1 1357
by  linda phillipsJump to last post
12/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 ChiuJump to last post
12/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 HaganJump to last post
12/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 UserJump to last post
12/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 MJump to last post
12/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 PayneJump to last post
12/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  franJump to last post
12/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 LandisJump to last post
12/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 HenleyJump to last post
12/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 SchaafJump to last post
12/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 MalhotraJump to last post
12/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 MalhotraJump to last post
12/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  FrankHJump to last post
12/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 LiameroJump to last post
11/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  blongJump to last post
11/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  chadCJump to last post
11/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  chenJump to last post
11/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 MitchellJump to last post
11/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 MitchellJump to last post
11/04/2009 12:56 PM
3 Replies and 2483 Views Unapplying Payment to an AR Invoice  2483  3 Started by  Deleted User How do you unapply a payment from an AR invoice
3 2483
by  John HenleyJump to last post
11/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 SchauerJump to last post
10/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 UserJump to last post
10/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 CostaJump to last post
10/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  EricSJump to last post
10/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  kumarJump to last post
10/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  jpJump to last post
10/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 HenleyJump to last post
10/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  mpoveyJump to last post
10/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 ShimekJump to last post
10/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 SmithJump to last post
10/01/2009 8:47 AM
4 Replies and 1492 Views Use Excel Addins to create New Calendar in AC00.2  1492  4 Started by  HBrown I have tried to use Excel Addins to create new Calendar in AC00.2 without luck. Is there anyone with knowledge on how to do this
4 1492
by  HBrownJump to last post
10/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  JeffJump to last post
09/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  DaintyJump to last post
09/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_15Jump to last post
09/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 PuckettJump to last post
08/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.cookJump to last post
08/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  JeffJump to last post
07/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  KishanJump to last post
07/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 SchauerJump to last post
07/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 HenleyJump to last post
07/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 ChiuJump to last post
07/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 HaugenJump to last post
07/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 HenleyJump to last post
06/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 SchauerJump to last post
06/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  djJump to last post
06/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 HenleyJump to last post
06/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  TracyOJump to last post
06/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 HenleyJump to last post
06/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 MalhotraJump to last post
06/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 JacksonJump to last post
06/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  mclJump to last post
05/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  DeltaFoxtrotJump to last post
05/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 SchauerJump to last post
05/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 HenleyJump to last post
05/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 HenleyJump to last post
05/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 CostaJump to last post
05/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.cookJump to last post
04/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  JeffJump to last post
04/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 RamanJump to last post
04/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 HenleyJump to last post
03/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 HenleyJump to last post
03/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  djJump to last post
03/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 HenleyJump to last post
03/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 HenleyJump to last post
03/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 HenleyJump to last post
03/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  dcaianiJump to last post
03/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  dcaianiJump to last post
03/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 AmatulliJump to last post
03/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  djJump to last post
03/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 RaoJump to last post
03/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 HenleyJump to last post
03/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 MalhotraJump to last post
02/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 HenleyJump to last post
02/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 MalhotraJump to last post
01/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  DeronJump to last post
01/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 Replies and 2836 Views GL95 & GL90 not matching for period activity  2836  2 Started by  mdantona Has anyone had this problem GL 95 and GL 90 are not matching for the same acct unit for the same period.
2 2836
by  mdantonaJump to last post
12/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 HenleyJump to last post
12/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  MikeMJump to last post
11/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 UserJump to last post
10/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 UserJump to last post
10/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 HenleyJump to last post
10/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  JLSJump to last post
10/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 HenleyJump to last post
10/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  LindaMJump to last post
10/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  JuanSJump to last post
10/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  des123Jump to last post
09/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  des123Jump to last post
09/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 MartinJump to last post
08/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 SimpsonJump to last post
08/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-rockJump to last post
08/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 MartinJump to last post
08/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 CoonfieldJump to last post
08/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  djJump to last post
07/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 GhotraJump to last post
07/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 HenleyJump to last post
07/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 HenleyJump to last post
07/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 HenleyJump to last post
06/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 GhotraJump to last post
06/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 HenleyJump to last post
06/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 ChiuJump to last post
05/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 ChiuJump to last post
05/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 UserJump to last post
05/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 UserJump to last post
05/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 HenleyJump to last post
04/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  oregonJump to last post
04/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 UserJump to last post
04/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 UserJump to last post
03/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  bssridharaJump to last post
03/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-rockJump to last post
03/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 UserJump to last post
02/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 HenleyJump to last post
02/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 IanniJump to last post
02/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 HenleyJump to last post
02/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  chasnikJump to last post
01/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 HenleyJump to last post
12/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 HenleyJump to last post
12/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  LitoJump to last post
11/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 HenleyJump to last post
10/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 HenleyJump to last post
10/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 SimpsonJump to last post
10/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 HenleyJump to last post
10/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 HenleyJump to last post
10/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 HenleyJump to last post
10/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 IanniJump to last post
09/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 UserJump to last post
09/24/2007 10:44 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 5 << < 12345 > >>


RSS Feed Available