Search this forum:
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 9 << < 56789 > >>
 Last Post
1 Replies and 2177 Views Inventoried Items details in GL  2177  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 2177
by  John HenleyJump to last post
03/01/2009 2:37 PM
1 Replies and 2095 Views AP20 Addin Load  2095  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 2095
by  Ruma MalhotraJump to last post
02/26/2009 9:49 AM
1 Replies and 2180 Views AC500, AC510, AC540 Interface Errors Question...  2180  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 2180
by  John HenleyJump to last post
02/19/2009 8:39 AM
0 Replies and 3136 Views Year-End Closing Journal Entry in consolidation company  3136  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 3136
02/09/2009 2:29 PM
6 Replies and 3708 Views 8 Formats in RW100  3708  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 3708
by  Ruma MalhotraJump to last post
01/22/2009 10:09 AM
9 Replies and 6648 Views Reconciling AP170 Summarized Transactions  6648  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 6648
by  DeronJump to last post
01/09/2009 9:02 AM
0 Replies and 1723 Views Partial Payment Reconciliation  1723  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 1723
01/07/2009 2:28 PM
0 Replies and 1607 Views Upgrade wedges LDAP data--how to recover?  1607  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 1607
01/03/2009 1:22 PM
0 Replies and 1934 Views Year End Process - Should we closed all the POs?  1934  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 1934
12/24/2008 10:47 AM
0 Replies and 1912 Views RW100 Reports - Identify path  1912  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 1912
12/19/2008 2:23 PM
2 Replies and 2632 Views GL95 & GL90 not matching for period activity  2632  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 2632
by  mdantonaJump to last post
12/11/2008 2:21 PM
3 Replies and 2665 Views GL290 - Error trying to print landscape  2665  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 2665
by  John HenleyJump to last post
12/05/2008 5:03 PM
4 Replies and 2668 Views Running Microsoft AddIns  2668  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 2668
by  MikeMJump to last post
11/21/2008 12:52 PM
2 Replies and 5159 Views Intercompany accounts building - do you settle/reconcile them?  5159  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 5159
by  Deleted UserJump to last post
10/30/2008 11:28 AM
2 Replies and 2536 Views Crystal Reports  2536  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 2536
by  Deleted UserJump to last post
10/29/2008 2:40 PM
4 Replies and 3056 Views tsStoreDBRec Error  3056  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 3056
by  John HenleyJump to last post
10/23/2008 3:07 PM
2 Replies and 2161 Views CA for Journal Entry  2161  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 2161
by  JLSJump to last post
10/23/2008 11:22 AM
0 Replies and 3288 Views Intercompany balances building (zone balancing)  3288  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 3288
10/15/2008 1:55 PM
1 Replies and 3445 Views AR Reconciliation  3445  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 3445
by  John HenleyJump to last post
10/07/2008 8:33 AM
0 Replies and 2618 Views 1099's for Tuition Reimbursement  2618  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 2618
10/03/2008 9:32 AM
2 Replies and 2430 Views AR Customer User Fields  2430  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 2430
by  LindaMJump to last post
10/03/2008 2:58 AM
3 Replies and 4636 Views AP150 Fails With Error Payment Forms Creation AP155 is Running  4636  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 4636
by  JuanSJump to last post
10/02/2008 2:20 PM
0 Replies and 2025 Views workfile error  2025  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 2025
09/04/2008 5:36 PM
3 Replies and 2673 Views LID 9.0 on Unix ??  2673  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 2673
by  des123Jump to last post
09/04/2008 9:50 AM
3 Replies and 2390 Views Vendor User Fields  2390  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 2390
by  des123Jump to last post
09/02/2008 3:15 PM
2 Replies and 2599 Views AP Vendor Class  2599  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 2599
by  Chris MartinJump to last post
08/29/2008 4:40 PM
2 Replies and 2500 Views No drill back information for this column  2500  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 2500
by  Sam SimpsonJump to last post
08/20/2008 11:51 AM
1 Replies and 2427 Views XBRL  2427  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 2427
by  k-rockJump to last post
08/20/2008 9:55 AM
0 Replies and 2132 Views APInvoice with no APDistrib record  2132  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 2132
08/15/2008 2:12 PM
3 Replies and 3240 Views Cognos 8  3240  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 3240
by  Chris MartinJump to last post
08/15/2008 10:38 AM
3 Replies and 5176 Views AP161 EDI 820 file  5176  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 5176
by  Ben CoonfieldJump to last post
08/11/2008 2:36 PM
6 Replies and 4282 Views AR30.3 Invoice unavailable  4282  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 4282
by  djJump to last post
07/25/2008 4:55 PM
6 Replies and 2794 Views batch program using Users locale for workfile definition instead of jobstepwrk  2794  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 2794
by  Barry GhotraJump to last post
07/21/2008 7:20 PM
1 Replies and 2109 Views AM20.3 and Addin  2109  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 2109
by  John HenleyJump to last post
07/21/2008 8:47 AM
2 Replies and 3326 Views Budgeting Software  3326  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 3326
by  John HenleyJump to last post
07/17/2008 5:58 PM
2 Replies and 3291 Views Unapplied cash by day (AR)  3291  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 3291
by  John HenleyJump to last post
06/10/2008 1:33 PM
8 Replies and 3323 Views Lawson apps 9.0 differences/enhancements/features  3323  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 3323
by  Barry GhotraJump to last post
06/09/2008 10:14 AM
3 Replies and 3190 Views AP170 - going into needs recovery  3190  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 3190
by  John HenleyJump to last post
06/06/2008 9:19 AM
14 Replies and 6214 Views help with GL10.1  6214  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 6214
by  Jimmy ChiuJump to last post
05/29/2008 8:59 AM
5 Replies and 5176 Views Overflow: Printing issue...Lawson related?  5176  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 5176
by  Jimmy ChiuJump to last post
05/25/2008 12:45 PM
5 Replies and 4371 Views How does AC190 select the rate to use?  4371  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 4371
by  Deleted UserJump to last post
05/20/2008 8:33 AM
3 Replies and 4698 Views Error message on the portal  4698  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 4698
by  Deleted UserJump to last post
05/06/2008 11:02 AM
1 Replies and 3753 Views AP22.2  3753  1 Started by  jjcyeshua Hi! guys, Question! What table gets updated using AP22.2... Thank you
1 3753
by  John HenleyJump to last post
04/24/2008 4:51 PM
0 Replies and 2943 Views Help --> Urgent--->Lawson Reports to CSV Files  2943  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 2943
04/23/2008 9:08 PM
3 Replies and 3808 Views JE-Memo transaction  3808  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 3808
by  oregonJump to last post
04/22/2008 12:33 PM
3 Replies and 3308 Views Corp Adjustments  3308  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 3308
by  Deleted UserJump to last post
04/07/2008 10:23 AM
1 Replies and 14761 Views Lawson manuals  14761  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 14761
by  John HenleyJump to last post
03/16/2008 11:11 AM
2 Replies and 3661 Views Process Level Accrual Codes  3661  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 3661
by  Deleted UserJump to last post
03/07/2008 9:23 AM
1 Replies and 11192 Views AP - Invoice  11192  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 11192
by  bssridharaJump to last post
03/06/2008 10:51 AM
0 Replies and 3114 Views Biweekly Recurring AP Payments  3114  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 3114
03/06/2008 9:53 AM
3 Replies and 2691 Views period 0  2691  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 2691
by  k-rockJump to last post
03/04/2008 12:18 PM
3 Replies and 3704 Views GL Information (New to Lawson)  3704  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 3704
by  Deleted UserJump to last post
02/25/2008 10:02 AM
1 Replies and 4992 Views Chart of Accounts maintenance  4992  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 4992
by  John HenleyJump to last post
02/20/2008 1:46 PM
0 Replies and 2931 Views Recurring invoice  2931  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 2931
02/12/2008 9:37 AM
0 Replies and 2756 Views Adding Total Names the easy way  2756  0 Started by  k-rock I posted a tip over on about automatically generating Total Names for a new year. Check it out.
0 2756
02/06/2008 8:57 AM
2 Replies and 4006 Views Asset Management - when to tag assets  4006  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 4006
by  Bill IanniJump to last post
02/05/2008 2:40 PM
2 Replies and 2908 Views Add ins  2908  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 2908
by  John HenleyJump to last post
02/05/2008 1:31 PM
7 Replies and 9722 Views Bill Rate Correction question -- BR120  9722  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 9722
by  chasnikJump to last post
01/16/2008 2:54 PM
1 Replies and 10682 Views Financial Calendar dates reverting?  10682  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 10682
by  John HenleyJump to last post
12/20/2007 9:08 PM
3 Replies and 10877 Views GL190 - some can post, one cannot. Why?  10877  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 10877
by  John HenleyJump to last post
12/03/2007 8:23 PM
2 Replies and 10588 Views CB195 has unposted entries. HELP !!!  10588  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 10588
by  LitoJump to last post
11/13/2007 6:37 PM
1 Replies and 10999 Views Purging A/P Vendor Master AP300  10999  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 10999
by  John HenleyJump to last post
10/31/2007 1:57 PM
5 Replies and 11419 Views AP160 and AP161 Check file  11419  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 11419
by  John HenleyJump to last post
10/23/2007 8:36 AM
2 Replies and 11335 Views auto-load one-time vendors  11335  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 11335
by  Sam SimpsonJump to last post
10/15/2007 2:22 PM
1 Replies and 10837 Views AR48 - Add and Release  10837  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 10837
by  John HenleyJump to last post
10/12/2007 2:05 PM
3 Replies and 12718 Views Invoice/Credit note matching  12718  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 12718
by  John HenleyJump to last post
10/09/2007 12:11 PM
0 Replies and 10103 Views Aged Creditors  10103  0 Started by  Deleted User Does anybody use a good report for aged creditors. Thanks
0 10103
10/09/2007 10:11 AM
1 Replies and 10052 Views Screen Caching Issue in 9.0?  10052  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 luck yet in trying to figure it out. Thanks
1 10052
by  John HenleyJump to last post
10/05/2007 1:05 PM
2 Replies and 10367 Views Lawson  10367  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 10367
by  Bill IanniJump to last post
09/28/2007 10:59 AM
5 Replies and 12150 Views GL Maintenance Tracking / Statistics  12150  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 12150
by  Deleted UserJump to last post
09/24/2007 10:44 AM
1 Replies and 10401 Views Former employees owing Cobra payments  10401  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 10401
by  John HenleyJump to last post
09/20/2007 1:08 PM
3 Replies and 11476 Views Vendor Statement  11476  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 11476
by  Deleted UserJump to last post
09/16/2007 5:04 PM
1 Replies and 10228 Views UG11.1  10228  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 10228
by  John HenleyJump to last post
09/12/2007 10:49 AM
5 Replies and 11974 Views Mass link sub-account to acct  11974  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 11974
by  John HenleyJump to last post
08/21/2007 6:23 AM
2 Replies and 10716 Views Activity Period Budget Upload  10716  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 10716
by  k-rockJump to last post
06/20/2007 9:10 AM
1 Replies and 10407 Views AP20.7 Distribution  10407  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 10407
by  jjcyeshuaJump to last post
05/23/2007 4:58 PM
1 Replies and 10775 Views A/P Invoice Print  10775  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 10775
by  k-rockJump to last post
05/21/2007 12:43 PM
5 Replies and 14259 Views FAILED JOBS  14259  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 14259
by  Deleted UserJump to last post
05/21/2007 9:37 AM
5 Replies and 10739 Views Problem in creating Activity List  10739  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 10739
by  John HenleyJump to last post
05/18/2007 8:03 AM
6 Replies and 11900 Views RQ approver  11900  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 11900
by  jjcyeshuaJump to last post
05/17/2007 10:20 AM
5 Replies and 11526 Views Duplicate Journal Entries  11526  5 Started by  Deleted User I have noticed with our 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 but have never installed it. I'm going ...
5 11526
by  John HenleyJump to last post
05/09/2007 5:07 PM
2 Replies and 10906 Views Budget Edit  10906  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 10906
by  jjcyeshuaJump to last post
05/07/2007 10:28 AM
0 Replies and 10658 Views OE Returns Account Overrides  10658  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 10658
04/22/2007 2:04 PM
2 Replies and 10918 Views MS Add-in AC45.1  10918  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 10918
by  Deleted UserJump to last post
04/11/2007 8:00 PM
16 Replies and 16139 Views Invoice creation  16139  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 16139
by  John HenleyJump to last post
04/10/2007 5:49 PM
0 Replies and 10490 Views General Comment  10490  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 10490
04/05/2007 11:34 AM
2 Replies and 11846 Views Out of Balance General Ledger  11846  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 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 11846
by  Deleted UserJump to last post
03/30/2007 11:25 AM
11 Replies and 14627 Views Bank Recs  14627  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 14627
by  Deleted UserJump to last post
03/30/2007 8:30 AM
7 Replies and 12325 Views Tax Calculation - Invoice Processing  12325  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 12325
by  John HenleyJump to last post
03/12/2007 5:47 PM
5 Replies and 12549 Views GLTRANS - (Incremental update to DW) Identifying newly inserted or updated records  12549  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 12549
by  debika_sharmaJump to last post
03/06/2007 11:59 AM
6 Replies and 12310 Views Importing Patient refunds  12310  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 12310
by  Roger FrenchJump to last post
10/12/2006 1:33 PM
1 Replies and 12367 Views Test Scripts for 8.1  12367  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 12367
by  Ken PtakJump to last post
09/22/2006 12:33 PM
0 Replies and 10949 Views 9.0 issues to watch on first close?  10949  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 10949
09/06/2006 5:47 PM
3 Replies and 11658 Views Lawson AR set up  11658  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 11658
by  Deleted UserJump to last post
08/29/2006 10:03 AM
1 Replies and 11248 Views Duplicate Invoices  11248  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 11248
by  Bill IanniJump to last post
08/26/2006 1:23 PM
1 Replies and 11490 Views GL90  11490  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 11490
by  John CrudeleJump to last post
07/11/2006 2:42 PM
1 Replies and 11192 Views OERTL 227 Error  11192  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 11192
by  John HenleyJump to last post
07/10/2006 12:45 PM
1 Replies and 11412 Views Activations and Inactivations  11412  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 11412
by  John HenleyJump to last post
06/27/2006 3:50 PM
5 Replies and 12356 Views Parameter Update Programs  12356  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 12356
by  Bill IanniJump to last post
04/22/2006 11:12 AM
4 Replies and 12922 Views Report Writer  12922  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 12922
by  John HenleyJump to last post
03/16/2006 3:34 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 9 << < 56789 > >>

RSS Feed Available