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
10 Replies and 4456 Views Link AP Record To Another Application  4456  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 4456
by  John HenleyJump to last post
03/25/2009 1:14 PM
0 Replies and 1639 Views Factor or Pay To Vendors  1639  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 1639
03/20/2009 6:10 PM
2 Replies and 2511 Views 13 PERIOD ACCOUNTING  2511  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 2511
by  djJump to last post
03/16/2009 11:01 PM
0 Replies and 2454 Views AR Open Item/Invoices Table Extract  2454  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 2454
03/16/2009 4:23 PM
4 Replies and 2014 Views drill-around on company field take up 15 second  2014  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 2014
by  John HenleyJump to last post
03/13/2009 12:45 PM
3 Replies and 3165 Views AP520  3165  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 3165
by  John HenleyJump to last post
03/12/2009 2:18 PM
1 Replies and 2047 Views AP160 ACH Remot File  2047  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 2047
by  John HenleyJump to last post
03/06/2009 3:47 PM
1 Replies and 1983 Views Periodic Accurals  1983  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 1983
by  dcaianiJump to last post
03/06/2009 10:41 AM
2 Replies and 2902 Views System Code GL01.1 and GL01.2  2902  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 2902
by  dcaianiJump to last post
03/06/2009 10:32 AM
3 Replies and 3021 Views AP160-Extra Header  3021  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 3021
by  Vito AmatulliJump to last post
03/06/2009 8:48 AM
1 Replies and 1727 Views Franchise Calendar Change - FR00.1  1727  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 1727
by  djJump to last post
03/05/2009 7:31 AM
0 Replies and 1532 Views Lawson Integration and Testing  1532  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 1532
03/04/2009 6:03 AM
1 Replies and 1589 Views ISeries 9.05/9.06 GL45 missing  1589  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 1589
by  Srini RaoJump to last post
03/01/2009 5:36 PM
1 Replies and 2283 Views Inventoried Items details in GL  2283  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 2283
by  John HenleyJump to last post
03/01/2009 2:37 PM
1 Replies and 2159 Views AP20 Addin Load  2159  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 2159
by  Ruma MalhotraJump to last post
02/26/2009 9:49 AM
1 Replies and 2242 Views AC500, AC510, AC540 Interface Errors Question...  2242  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 2242
by  John HenleyJump to last post
02/19/2009 8:39 AM
0 Replies and 3209 Views Year-End Closing Journal Entry in consolidation company  3209  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 3209
02/09/2009 2:29 PM
6 Replies and 3812 Views 8 Formats in RW100  3812  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 3812
by  Ruma MalhotraJump to last post
01/22/2009 10:09 AM
9 Replies and 6811 Views Reconciling AP170 Summarized Transactions  6811  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 6811
by  DeronJump to last post
01/09/2009 9:02 AM
0 Replies and 1789 Views Partial Payment Reconciliation  1789  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 1789
01/07/2009 2:28 PM
0 Replies and 1659 Views Upgrade wedges LDAP data--how to recover?  1659  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 1659
01/03/2009 1:22 PM
0 Replies and 1975 Views Year End Process - Should we closed all the POs?  1975  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 1975
12/24/2008 10:47 AM
0 Replies and 1996 Views RW100 Reports - Identify path  1996  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 1996
12/19/2008 2:23 PM
2 Replies and 2705 Views GL95 & GL90 not matching for period activity  2705  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 2705
by  mdantonaJump to last post
12/11/2008 2:21 PM
3 Replies and 2741 Views GL290 - Error trying to print landscape  2741  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 2741
by  John HenleyJump to last post
12/05/2008 5:03 PM
4 Replies and 2735 Views Running Microsoft AddIns  2735  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 2735
by  MikeMJump to last post
11/21/2008 12:52 PM
2 Replies and 5264 Views Intercompany accounts building - do you settle/reconcile them?  5264  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 5264
by  Deleted UserJump to last post
10/30/2008 11:28 AM
2 Replies and 2594 Views Crystal Reports  2594  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 2594
by  Deleted UserJump to last post
10/29/2008 2:40 PM
4 Replies and 3133 Views tsStoreDBRec Error  3133  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 3133
by  John HenleyJump to last post
10/23/2008 3:07 PM
2 Replies and 2229 Views CA for Journal Entry  2229  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 2229
by  JLSJump to last post
10/23/2008 11:22 AM
0 Replies and 3433 Views Intercompany balances building (zone balancing)  3433  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 3433
10/15/2008 1:55 PM
1 Replies and 3524 Views AR Reconciliation  3524  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 3524
by  John HenleyJump to last post
10/07/2008 8:33 AM
0 Replies and 2680 Views 1099's for Tuition Reimbursement  2680  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 2680
10/03/2008 9:32 AM
2 Replies and 2503 Views AR Customer User Fields  2503  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 2503
by  LindaMJump to last post
10/03/2008 2:58 AM
3 Replies and 4772 Views AP150 Fails With Error Payment Forms Creation AP155 is Running  4772  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 4772
by  JuanSJump to last post
10/02/2008 2:20 PM
0 Replies and 2092 Views workfile error  2092  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 2092
09/04/2008 5:36 PM
3 Replies and 2757 Views LID 9.0 on Unix ??  2757  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 2757
by  des123Jump to last post
09/04/2008 9:50 AM
3 Replies and 2445 Views Vendor User Fields  2445  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 2445
by  des123Jump to last post
09/02/2008 3:15 PM
2 Replies and 2696 Views AP Vendor Class  2696  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 2696
by  Chris MartinJump to last post
08/29/2008 4:40 PM
2 Replies and 2564 Views No drill back information for this column  2564  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 2564
by  Sam SimpsonJump to last post
08/20/2008 11:51 AM
1 Replies and 2511 Views XBRL  2511  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 2511
by  k-rockJump to last post
08/20/2008 9:55 AM
0 Replies and 2210 Views APInvoice with no APDistrib record  2210  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 2210
08/15/2008 2:12 PM
3 Replies and 3312 Views Cognos 8  3312  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 3312
by  Chris MartinJump to last post
08/15/2008 10:38 AM
3 Replies and 5278 Views AP161 EDI 820 file  5278  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 5278
by  Ben CoonfieldJump to last post
08/11/2008 2:36 PM
6 Replies and 4362 Views AR30.3 Invoice unavailable  4362  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 4362
by  djJump to last post
07/25/2008 4:55 PM
6 Replies and 2874 Views batch program using Users locale for workfile definition instead of jobstepwrk  2874  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 2874
by  Barry GhotraJump to last post
07/21/2008 7:20 PM
1 Replies and 2188 Views AM20.3 and Addin  2188  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 2188
by  John HenleyJump to last post
07/21/2008 8:47 AM
2 Replies and 3397 Views Budgeting Software  3397  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 3397
by  John HenleyJump to last post
07/17/2008 5:58 PM
2 Replies and 3368 Views Unapplied cash by day (AR)  3368  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 3368
by  John HenleyJump to last post
06/10/2008 1:33 PM
8 Replies and 3386 Views Lawson apps 9.0 differences/enhancements/features  3386  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 3386
by  Barry GhotraJump to last post
06/09/2008 10:14 AM
3 Replies and 3258 Views AP170 - going into needs recovery  3258  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 3258
by  John HenleyJump to last post
06/06/2008 9:19 AM
14 Replies and 6284 Views help with GL10.1  6284  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 6284
by  Jimmy ChiuJump to last post
05/29/2008 8:59 AM
5 Replies and 5297 Views Overflow: Printing issue...Lawson related?  5297  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 5297
by  Jimmy ChiuJump to last post
05/25/2008 12:45 PM
5 Replies and 4419 Views How does AC190 select the rate to use?  4419  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 4419
by  Deleted UserJump to last post
05/20/2008 8:33 AM
3 Replies and 4768 Views Error message on the portal  4768  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 4768
by  Deleted UserJump to last post
05/06/2008 11:02 AM
1 Replies and 3841 Views AP22.2  3841  1 Started by  jjcyeshua Hi! guys, Question! What table gets updated using AP22.2... Thank you
1 3841
by  John HenleyJump to last post
04/24/2008 4:51 PM
0 Replies and 3013 Views Help --> Urgent--->Lawson Reports to CSV Files  3013  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 3013
04/23/2008 9:08 PM
3 Replies and 3888 Views JE-Memo transaction  3888  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 3888
by  oregonJump to last post
04/22/2008 12:33 PM
3 Replies and 3367 Views Corp Adjustments  3367  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 3367
by  Deleted UserJump to last post
04/07/2008 10:23 AM
1 Replies and 15520 Views Lawson manuals  15520  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 15520
by  John HenleyJump to last post
03/16/2008 11:11 AM
2 Replies and 3750 Views Process Level Accrual Codes  3750  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 3750
by  Deleted UserJump to last post
03/07/2008 9:23 AM
1 Replies and 11258 Views AP - Invoice  11258  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 11258
by  bssridharaJump to last post
03/06/2008 10:51 AM
0 Replies and 3200 Views Biweekly Recurring AP Payments  3200  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 3200
03/06/2008 9:53 AM
3 Replies and 2753 Views period 0  2753  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 2753
by  k-rockJump to last post
03/04/2008 12:18 PM
3 Replies and 3768 Views GL Information (New to Lawson)  3768  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 3768
by  Deleted UserJump to last post
02/25/2008 10:02 AM
1 Replies and 5091 Views Chart of Accounts maintenance  5091  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 5091
by  John HenleyJump to last post
02/20/2008 1:46 PM
0 Replies and 3027 Views Recurring invoice  3027  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 3027
02/12/2008 9:37 AM
0 Replies and 2822 Views Adding Total Names the easy way  2822  0 Started by  k-rock I posted a tip over on about automatically generating Total Names for a new year. Check it out.
0 2822
02/06/2008 8:57 AM
2 Replies and 4067 Views Asset Management - when to tag assets  4067  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 4067
by  Bill IanniJump to last post
02/05/2008 2:40 PM
2 Replies and 2965 Views Add ins  2965  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 2965
by  John HenleyJump to last post
02/05/2008 1:31 PM
7 Replies and 9776 Views Bill Rate Correction question -- BR120  9776  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 9776
by  chasnikJump to last post
01/16/2008 2:54 PM
1 Replies and 10730 Views Financial Calendar dates reverting?  10730  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 10730
by  John HenleyJump to last post
12/20/2007 9:08 PM
3 Replies and 10941 Views GL190 - some can post, one cannot. Why?  10941  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 10941
by  John HenleyJump to last post
12/03/2007 8:23 PM
2 Replies and 10658 Views CB195 has unposted entries. HELP !!!  10658  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 10658
by  LitoJump to last post
11/13/2007 6:37 PM
1 Replies and 11072 Views Purging A/P Vendor Master AP300  11072  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 11072
by  John HenleyJump to last post
10/31/2007 1:57 PM
5 Replies and 11499 Views AP160 and AP161 Check file  11499  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 11499
by  John HenleyJump to last post
10/23/2007 8:36 AM
2 Replies and 11431 Views auto-load one-time vendors  11431  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 11431
by  Sam SimpsonJump to last post
10/15/2007 2:22 PM
1 Replies and 10895 Views AR48 - Add and Release  10895  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 10895
by  John HenleyJump to last post
10/12/2007 2:05 PM
3 Replies and 12867 Views Invoice/Credit note matching  12867  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 12867
by  John HenleyJump to last post
10/09/2007 12:11 PM
0 Replies and 10176 Views Aged Creditors  10176  0 Started by  Deleted User Does anybody use a good report for aged creditors. Thanks
0 10176
10/09/2007 10:11 AM
1 Replies and 10115 Views Screen Caching Issue in 9.0?  10115  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 10115
by  John HenleyJump to last post
10/05/2007 1:05 PM
2 Replies and 10416 Views Lawson  10416  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 10416
by  Bill IanniJump to last post
09/28/2007 10:59 AM
5 Replies and 12210 Views GL Maintenance Tracking / Statistics  12210  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 12210
by  Deleted UserJump to last post
09/24/2007 10:44 AM
1 Replies and 10453 Views Former employees owing Cobra payments  10453  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 10453
by  John HenleyJump to last post
09/20/2007 1:08 PM
3 Replies and 11536 Views Vendor Statement  11536  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 11536
by  Deleted UserJump to last post
09/16/2007 5:04 PM
1 Replies and 10277 Views UG11.1  10277  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 10277
by  John HenleyJump to last post
09/12/2007 10:49 AM
5 Replies and 12073 Views Mass link sub-account to acct  12073  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 12073
by  John HenleyJump to last post
08/21/2007 6:23 AM
2 Replies and 10764 Views Activity Period Budget Upload  10764  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 10764
by  k-rockJump to last post
06/20/2007 9:10 AM
1 Replies and 10462 Views AP20.7 Distribution  10462  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 10462
by  jjcyeshuaJump to last post
05/23/2007 4:58 PM
1 Replies and 10834 Views A/P Invoice Print  10834  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 10834
by  k-rockJump to last post
05/21/2007 12:43 PM
5 Replies and 14489 Views FAILED JOBS  14489  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 14489
by  Deleted UserJump to last post
05/21/2007 9:37 AM
5 Replies and 10798 Views Problem in creating Activity List  10798  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 10798
by  John HenleyJump to last post
05/18/2007 8:03 AM
6 Replies and 12007 Views RQ approver  12007  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 12007
by  jjcyeshuaJump to last post
05/17/2007 10:20 AM
5 Replies and 11599 Views Duplicate Journal Entries  11599  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 11599
by  John HenleyJump to last post
05/09/2007 5:07 PM
2 Replies and 10974 Views Budget Edit  10974  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 10974
by  jjcyeshuaJump to last post
05/07/2007 10:28 AM
0 Replies and 10729 Views OE Returns Account Overrides  10729  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 10729
04/22/2007 2:04 PM
2 Replies and 10973 Views MS Add-in AC45.1  10973  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 10973
by  Deleted UserJump to last post
04/11/2007 8:00 PM
16 Replies and 16346 Views Invoice creation  16346  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 16346
by  John HenleyJump to last post
04/10/2007 5:49 PM
0 Replies and 10549 Views General Comment  10549  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 10549
04/05/2007 11:34 AM
2 Replies and 11978 Views Out of Balance General Ledger  11978  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 11978
by  Deleted UserJump to last post
03/30/2007 11:25 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 8 of 9 << < 56789 > >>

RSS Feed Available