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 8 of 8 << < 45678
Topics
 Replies
 Views
 Last Post
2 Replies and 2573 Views GL95 & GL90 not matching for period activity  2573  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 2573
by  mdantonaJump to last post
12/11/2008 2:21 PM
3 Replies and 2625 Views GL290 - Error trying to print landscape  2625  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 2625
by  John HenleyJump to last post
12/05/2008 5:03 PM
4 Replies and 2611 Views Running Microsoft AddIns  2611  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 2611
by  MikeMJump to last post
11/21/2008 12:52 PM
2 Replies and 5081 Views Intercompany accounts building - do you settle/reconcile them?  5081  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 5081
by  Deleted UserJump to last post
10/30/2008 11:28 AM
2 Replies and 2487 Views Crystal Reports  2487  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 2487
by  Deleted UserJump to last post
10/29/2008 2:40 PM
4 Replies and 3009 Views tsStoreDBRec Error  3009  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 3009
by  John HenleyJump to last post
10/23/2008 3:07 PM
2 Replies and 2115 Views CA for Journal Entry  2115  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 2115
by  JLSJump to last post
10/23/2008 11:22 AM
0 Replies and 3187 Views Intercompany balances building (zone balancing)  3187  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 3187
10/15/2008 1:55 PM
1 Replies and 3389 Views AR Reconciliation  3389  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 3389
by  John HenleyJump to last post
10/07/2008 8:33 AM
0 Replies and 2580 Views 1099's for Tuition Reimbursement  2580  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 2580
10/03/2008 9:32 AM
2 Replies and 2379 Views AR Customer User Fields  2379  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 2379
by  LindaMJump to last post
10/03/2008 2:58 AM
3 Replies and 4505 Views AP150 Fails With Error Payment Forms Creation AP155 is Running  4505  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 4505
by  JuanSJump to last post
10/02/2008 2:20 PM
0 Replies and 1984 Views workfile error  1984  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 1984
09/04/2008 5:36 PM
3 Replies and 2622 Views LID 9.0 on Unix ??  2622  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 2622
by  des123Jump to last post
09/04/2008 9:50 AM
3 Replies and 2360 Views Vendor User Fields  2360  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 2360
by  des123Jump to last post
09/02/2008 3:15 PM
2 Replies and 2559 Views AP Vendor Class  2559  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 2559
by  Chris MartinJump to last post
08/29/2008 4:40 PM
2 Replies and 2460 Views No drill back information for this column  2460  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 2460
by  Sam SimpsonJump to last post
08/20/2008 11:51 AM
1 Replies and 2383 Views XBRL  2383  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 2383
by  k-rockJump to last post
08/20/2008 9:55 AM
0 Replies and 2083 Views APInvoice with no APDistrib record  2083  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 2083
08/15/2008 2:12 PM
3 Replies and 3178 Views Cognos 8  3178  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 3178
by  Chris MartinJump to last post
08/15/2008 10:38 AM
3 Replies and 5087 Views AP161 EDI 820 file  5087  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 5087
by  Ben CoonfieldJump to last post
08/11/2008 2:36 PM
6 Replies and 4211 Views AR30.3 Invoice unavailable  4211  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 4211
by  djJump to last post
07/25/2008 4:55 PM
6 Replies and 2744 Views batch program using Users locale for workfile definition instead of jobstepwrk  2744  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 2744
by  Barry GhotraJump to last post
07/21/2008 7:20 PM
1 Replies and 2073 Views AM20.3 and Addin  2073  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 2073
by  John HenleyJump to last post
07/21/2008 8:47 AM
2 Replies and 3269 Views Budgeting Software  3269  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 3269
by  John HenleyJump to last post
07/17/2008 5:58 PM
2 Replies and 3240 Views Unapplied cash by day (AR)  3240  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 3240
by  John HenleyJump to last post
06/10/2008 1:33 PM
8 Replies and 3265 Views Lawson apps 9.0 differences/enhancements/features  3265  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 3265
by  Barry GhotraJump to last post
06/09/2008 10:14 AM
3 Replies and 3142 Views AP170 - going into needs recovery  3142  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 3142
by  John HenleyJump to last post
06/06/2008 9:19 AM
14 Replies and 6150 Views help with GL10.1  6150  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 6150
by  Jimmy ChiuJump to last post
05/29/2008 8:59 AM
5 Replies and 5063 Views Overflow: Printing issue...Lawson related?  5063  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 5063
by  Jimmy ChiuJump to last post
05/25/2008 12:45 PM
5 Replies and 4338 Views How does AC190 select the rate to use?  4338  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 4338
by  Deleted UserJump to last post
05/20/2008 8:33 AM
3 Replies and 4638 Views Error message on the portal  4638  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 4638
by  Deleted UserJump to last post
05/06/2008 11:02 AM
1 Replies and 3697 Views AP22.2  3697  1 Started by  jjcyeshua Hi! guys, Question! What table gets updated using AP22.2... Thank you
1 3697
by  John HenleyJump to last post
04/24/2008 4:51 PM
0 Replies and 2890 Views Help --> Urgent--->Lawson Reports to CSV Files  2890  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 2890
04/23/2008 9:08 PM
3 Replies and 3739 Views JE-Memo transaction  3739  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 3739
by  oregonJump to last post
04/22/2008 12:33 PM
3 Replies and 3255 Views Corp Adjustments  3255  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 3255
by  Deleted UserJump to last post
04/07/2008 10:23 AM
1 Replies and 14262 Views Lawson manuals  14262  1 Started by  Deleted User I am new to Lawson and my company does not have any manuals for the GL package. Is there anywhere I can get a good&160;manual on Lawson GL
1 14262
by  John HenleyJump to last post
03/16/2008 11:11 AM
2 Replies and 3601 Views Process Level Accrual Codes  3601  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 3601
by  Deleted UserJump to last post
03/07/2008 9:23 AM
1 Replies and 11154 Views AP - Invoice  11154  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 11154
by  bssridharaJump to last post
03/06/2008 10:51 AM
0 Replies and 3057 Views Biweekly Recurring AP Payments  3057  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 3057
03/06/2008 9:53 AM
3 Replies and 2649 Views period 0  2649  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 2649
by  k-rockJump to last post
03/04/2008 12:18 PM
3 Replies and 3667 Views GL Information (New to Lawson)  3667  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 3667
by  Deleted UserJump to last post
02/25/2008 10:02 AM
1 Replies and 4927 Views Chart of Accounts maintenance  4927  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 4927
by  John HenleyJump to last post
02/20/2008 1:46 PM
0 Replies and 2860 Views Recurring invoice  2860  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 2860
02/12/2008 9:37 AM
0 Replies and 2713 Views Adding Total Names the easy way  2713  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 2713
02/06/2008 8:57 AM
2 Replies and 3960 Views Asset Management - when to tag assets  3960  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 3960
by  Bill IanniJump to last post
02/05/2008 2:40 PM
2 Replies and 2865 Views Add ins  2865  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 2865
by  John HenleyJump to last post
02/05/2008 1:31 PM
7 Replies and 9673 Views Bill Rate Correction question -- BR120  9673  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 9673
by  chasnikJump to last post
01/16/2008 2:54 PM
1 Replies and 10646 Views Financial Calendar dates reverting?  10646  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 10646
by  John HenleyJump to last post
12/20/2007 9:08 PM
3 Replies and 10822 Views GL190 - some can post, one cannot. Why?  10822  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 10822
by  John HenleyJump to last post
12/03/2007 8:23 PM
2 Replies and 10548 Views CB195 has unposted entries. HELP !!!  10548  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 10548
by  LitoJump to last post
11/13/2007 6:37 PM
1 Replies and 10946 Views Purging A/P Vendor Master AP300  10946  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 10946
by  John HenleyJump to last post
10/31/2007 1:57 PM
5 Replies and 11350 Views AP160 and AP161 Check file  11350  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 11350
by  John HenleyJump to last post
10/23/2007 8:36 AM
2 Replies and 11236 Views auto-load one-time vendors  11236  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 11236
by  Sam SimpsonJump to last post
10/15/2007 2:22 PM
1 Replies and 10792 Views AR48 - Add and Release  10792  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 10792
by  John HenleyJump to last post
10/12/2007 2:05 PM
3 Replies and 12646 Views Invoice/Credit note matching  12646  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 12646
by  John HenleyJump to last post
10/09/2007 12:11 PM
0 Replies and 10042 Views Aged Creditors  10042  0 Started by  Deleted User Does anybody use a good report for aged creditors. Thanks
0 10042
10/09/2007 10:11 AM
1 Replies and 10009 Views Screen Caching Issue in 9.0?  10009  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 10009
by  John HenleyJump to last post
10/05/2007 1:05 PM
2 Replies and 10330 Views Lawson  10330  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 10330
by  Bill IanniJump to last post
09/28/2007 10:59 AM
5 Replies and 12096 Views GL Maintenance Tracking / Statistics  12096  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 12096
by  Deleted UserJump to last post
09/24/2007 10:44 AM
1 Replies and 10361 Views Former employees owing Cobra payments  10361  1 Started by  Deleted User Has anyone ran across a table that lists Accounts Receivable of former employees that owe Cobra Premiums, Life Insurance Premiums, etc.
1 10361
by  John HenleyJump to last post
09/20/2007 1:08 PM
3 Replies and 11439 Views Vendor Statement  11439  3 Started by  Deleted User Hi, I am new to Lawson, am barely using it a month and working in a department that are not entirely sure what they are doing either. I was wondering is there any way of running a detailed outstanding vendor statement for any given period In work I have been instructed to run an AP91.1 and drill into each transaction to see if invoices have been paid but this is time consuming and tedious. Is there a quick way of filtering that to see all outstanding items or have I simply been directed...
3 11439
by  Deleted UserJump to last post
09/16/2007 5:04 PM
1 Replies and 10190 Views UG11.1  10190  1 Started by  Kevin Hagan We are in the process of upgrading to 9.0, and have encountered the required UG11.1 fields. I was looking to see what everyone has benn populating in these fields and if they are keeping naming conventions identical to coding in the HR tables for names and descriptions
1 10190
by  John HenleyJump to last post
09/12/2007 10:49 AM
5 Replies and 11873 Views Mass link sub-account to acct  11873  5 Started by  jjcyeshua I just created a new sub-account, and i would like to link it to multiple accounts. What is the best way to do this Is there a form where i could do it I tried using GL02.3 but that doesn't work.... Well thanks in advance
5 11873
by  John HenleyJump to last post
08/21/2007 6:23 AM
2 Replies and 10680 Views Activity Period Budget Upload  10680  2 Started by  Deleted User Is it possible to upload an activity period budget using ms add-ins upload wizard, or can it only be done via FTP AC27.1 and AC27.2 are accessible separately in the upload wizard, but it looks like there is no way to access the AC27.2 amount and unit field names via AC27.1.
2 10680
by  k-rockJump to last post
06/20/2007 9:10 AM
1 Replies and 10380 Views AP20.7 Distribution  10380  1 Started by  jjcyeshua On AP20.7 there's a Description field at the bottom. In what table in lawson can i find this field. Does lawson archive these invoices if it does, in what table does it save it to...Thanks again to all
1 10380
by  jjcyeshuaJump to last post
05/23/2007 4:58 PM
1 Replies and 10743 Views A/P Invoice Print  10743  1 Started by  Karl Kemp Is anyone else doing an Invoice Print routine I don't see one in Lawson and our A/P user's are needing a paper copy of their invoices, mainly for the ones that we receive via EDI. I guess the auditors are pushing for this. I'm guessing that I will need to do a custom app/report but thought I'd see if anyone had any ideas on this subject. Thanks
1 10743
by  k-rockJump to last post
05/21/2007 12:43 PM
5 Replies and 14093 Views FAILED JOBS  14093  5 Started by  Deleted User I am a GL module users and any new jobs I summitted failed and needed recovery. Even after the recovery I can not see the jobs in print manager for screen viewing or printing. This problem started two week ago. Can any one help me out
5 14093
by  Deleted UserJump to last post
05/21/2007 9:37 AM
5 Replies and 10701 Views Problem in creating Activity List  10701  5 Started by  Deleted User I can create activity list on MX10.2 using object type ACGRP in production. We are on MSP5. In our test environment, we are on MSP6 and when I create list and use conditions, it odes not show up anything on AC14. Any idea Is there any CTP Thanks
5 10701
by  John HenleyJump to last post
05/18/2007 8:03 AM
6 Replies and 11794 Views RQ approver  11794  6 Started by  jjcyeshua Hello! all... in what table in lawson can i find the approver of a requisition... Can anyone help me with this.. Thank you.!!!!
6 11794
by  jjcyeshuaJump to last post
05/17/2007 10:20 AM
5 Replies and 11481 Views Duplicate Journal Entries  11481  5 Started by  Deleted User I have noticed with our 7.2.2.4 version of Lawson that when users submit CB175, AR190 and even AP175 jobs, the system is creating duplicate journal entries however only releasing one journal entry report when these programs are run. It is only caught by reviewing the GL190 and by reviewing GL45 to see if we missed any duplicates at month end. This problem seems to be happening more often, has anyone else come across this. We have version 7.2.2.6 but have never installed it. I'm going ...
5 11481
by  John HenleyJump to last post
05/09/2007 5:07 PM
2 Replies and 10859 Views Budget Edit  10859  2 Started by  jjcyeshua Hi! all... I need help regarding Budget Edit. My company is planning to use this to keep track of our buget to actual spending. But it seems that there are two types of Budget Edit (AC and GL). What is the difference between the two and how do i go about implementing this. What is the best way to approach this Any suggestion will be greatly appreciated. Thanks in advance...
2 10859
by  jjcyeshuaJump to last post
05/07/2007 10:28 AM
0 Replies and 10614 Views OE Returns Account Overrides  10614  0 Started by  Deb In an effort to accumulate all sales returns in a separate GL account . . . . Using Account Override on OE30.3 - Disposition Tab overriding sales GL account number to a sales returns GL account number. OE portion of posting (scrap/cogs)working fine in all sceanrios. BL portion of posting (sales/AR)- override works only when disposition is S=Scrap, when disposition is R=Return to Inventory - lawson allows the change on the OE30.3 screen just fine, but the actual postings still go to the o...
0 10614
04/22/2007 2:04 PM
2 Replies and 10885 Views MS Add-in AC45.1  10885  2 Started by  Deleted User We fix a number of errors in AC45.1 but we process this manually and it could get tedious at times. Is there an AC45.1 MS Add-in upload If so, can you please provide the table And what is the primary key to use so that the upload would identify the exact transaction we're trying to change since at times there are numerous entries against 1 activity with 1 account category.
2 10885
by  Deleted UserJump to last post
04/11/2007 8:00 PM
16 Replies and 15929 Views Invoice creation  15929  16 Started by  Deleted User Good afternoon to all. Can you please tell me how to create invoices I am using ver 7.2.24 on AS400. We currently use Lotus Notes for our invoicing, then we have to upload to Lawson. I am trying to use Lawson and work a bit more efficiently. Thank you all for your help. Signed NJ
16 15929
by  John HenleyJump to last post
04/10/2007 5:49 PM
0 Replies and 10452 Views General Comment  10452  0 Started by  Deleted User Would be remiss if I don't comment on the vast experience and knowledge displayed in this forum. Special thanks to John and Jason for their patience and tolerance. Keep up the good work!!
0 10452
04/05/2007 11:34 AM
2 Replies and 11780 Views Out of Balance General Ledger  11780  2 Started by  Deleted User I am trying to find a way to bring the General Ledger back into balance with the transactions. When reviewing the GLTRANS I see that transactions exist however, on one particular day Lawson doubled the value of the transaction when determining the posted amounts and the ending balances. We are using 7.2.2.4 without support as we are a small operation that doesn't want to cash flow $15m/month. Anyhow, this is confirmed when printing a trial balance and when extracting data from the GLTRANS dir...
2 11780
by  Deleted UserJump to last post
03/30/2007 11:25 AM
11 Replies and 14579 Views Bank Recs  14579  11 Started by  Deleted User Can someone tell me how to reconcile bank statements through Lawson. Currently we are doing it the old fashion way--Excel spread sheet. We enter interest and charges thru CB20. Transfers thru CB15.1. We process AR invoices and receipts thru AR30.1 and 21.3 etc.I just want to do a few mouse clicks and have a clean nice completed bank rec all done in Lawson.
11 14579
by  Deleted UserJump to last post
03/30/2007 8:30 AM
7 Replies and 12270 Views Tax Calculation - Invoice Processing  12270  7 Started by  Vijay Ananthu During Invoice Processing in AR System, I require to pass the invoice to third party application which will calcuate tax for that invoice and return back that invoice with taxed amout to Lawson. Could anyone suggest me to do this Thanks in Advance.
7 12270
by  John HenleyJump to last post
03/12/2007 5:47 PM
5 Replies and 12478 Views GLTRANS - (Incremental update to DW) Identifying newly inserted or updated records  12478  5 Started by  debika_sharma I am a data warehouse/BI architect developing a data warehouse that must extract records from GLTRANS once nightly. I don't want to do a full refresh of the GLTRANS table (that would mean pulling over several hundred million rows). Instead I would like to find a way to identify the new records and the records that have been updated since my last extract. So for example, lets say I have in my data warehouse all records from GLTRANS through 2/22/07. When my ETL job runs on the next day,...
5 12478
by  debika_sharmaJump to last post
03/06/2007 11:59 AM
6 Replies and 12233 Views Importing Patient refunds  12233  6 Started by  Deleted User EPIC system will be interfacing A/P (Pt. refund) data to Lawson. I provided the required specs for APCINVOICE, but noticed that the 2 records provided by EPIC do not have 1) Acct and 2) the Vendor They have said that they do not have the ability to provide the Vendor, but how can I get this file to include the acct (it is always 12110, fyi)
6 12233
by  Roger FrenchJump to last post
10/12/2006 1:33 PM
1 Replies and 12320 Views Test Scripts for 8.1  12320  1 Started by  Maestro Hey all At my company we are upgrading from 8.0.3 Apps to 8.1. Does any have or know where I could get some test scripts for 8.1 integrated testing Thanks Michael
1 12320
by  Ken PtakJump to last post
09/22/2006 12:33 PM
0 Replies and 10888 Views 9.0 issues to watch on first close?  10888  0 Started by  Deleted User Hi all, Are there any issues that need to be watched for on closing financial for the month, especially with multi-currency Any info would be greatly appreciated. Thanks -
0 10888
09/06/2006 5:47 PM
3 Replies and 11591 Views Lawson AR set up  11591  3 Started by  Deleted User Ok... I have never completed a Lawson AR implimentation. I have dloaded the AR User Manual - which looks like it pretty much walks you through step-by-step, but I am hoping to get some feedback on any issues/concerns, or REALLY some Advice! Thanks all. Mike
3 11591
by  Deleted UserJump to last post
08/29/2006 10:03 AM
1 Replies and 11195 Views Duplicate Invoices  11195  1 Started by  PV Rajan Hi: Is there a way to prevent duplicate invoices in Lawson. In other words, Is there a way to prevent a second invoice added to the system which has all the same data as the first one, except the Invoice number (Apps 8.0.3, Non-Lawson PO, Manually entered in AP20). Thanks in advance!
1 11195
by  Bill IanniJump to last post
08/26/2006 1:23 PM
1 Replies and 11433 Views GL90  11433  1 Started by  Deleted User Has anyone dealt with an issue were in GL90.1 you see one figure for period. When you drill around to the Annual Balance for that same period there is a different total. If so have did you resolve the issue
1 11433
by  John CrudeleJump to last post
07/11/2006 2:42 PM
1 Replies and 11150 Views OERTL 227 Error  11150  1 Started by  Ariela Levy Hi there, Was wondering if anyone has experienced the OERTL227 error when processing returns in the order entry module (OE30.1 ). I am trying to troubleshoot and cannot find documentation on it. Thanks, Ariela
1 11150
by  John HenleyJump to last post
07/10/2006 12:45 PM
1 Replies and 11366 Views Activations and Inactivations  11366  1 Started by  Horace McCoy The auditors have asked me to run a report in Lawson that shows them all the accounts we activiated and inactivated from year end to present. I have not had this request before. Can anyone help me or point me in the right direction Thanks
1 11366
by  John HenleyJump to last post
06/27/2006 3:50 PM
5 Replies and 12295 Views Parameter Update Programs  12295  5 Started by  Deleted User What is parameter Update Programs (related to Batch processing) in Lawson ERP.Can anyone brief me on this topic..
5 12295
by  Bill IanniJump to last post
04/22/2006 11:12 AM
4 Replies and 12872 Views Report Writer  12872  4 Started by  Scott Krueger Does anybody know the linking between RWDICT and the actual file/fields being used from the G/L when a report writer report executes. I view the RWDICT data and I see a valu of CPBUD and a description, but were does the value come from that prints on the report As always Thanks!
4 12872
by  John HenleyJump to last post
03/16/2006 3:34 PM
1 Replies and 11946 Views Lawson 6.1 Documentation  11946  1 Started by  Scott Krueger Hello All, I am looking or Lawson 6.1 documentation for the iSeries(AS/400) Does anybody out there have a copy of this documentation. I am looking for the technical documentation for this release. Thanks
1 11946
by  John HenleyJump to last post
03/15/2006 8:12 AM
1 Replies and 11735 Views GMCODES  11735  1 Started by  Deleted User We have this table included in our Activities Module but the details are not listed in the Data Dictionary.
1 11735
by  John HenleyJump to last post
07/28/2005 3:15 PM
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 8 of 8 << < 45678


RSS Feed Available