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 5 of 5 << < 12345
 Last Post
1 Replies and 10517 Views Former employees owing Cobra payments  10517  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 10517
by  John HenleyJump to last post
09/20/2007 1:08 PM
3 Replies and 11686 Views Vendor Statement  11686  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 11686
by  Deleted UserJump to last post
09/16/2007 5:04 PM
1 Replies and 10353 Views UG11.1  10353  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 10353
by  John HenleyJump to last post
09/12/2007 10:49 AM
5 Replies and 12294 Views Mass link sub-account to acct  12294  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 12294
by  John HenleyJump to last post
08/21/2007 6:23 AM
2 Replies and 10867 Views Activity Period Budget Upload  10867  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 10867
by  k-rockJump to last post
06/20/2007 9:10 AM
1 Replies and 10534 Views AP20.7 Distribution  10534  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 10534
by  jjcyeshuaJump to last post
05/23/2007 4:58 PM
1 Replies and 10920 Views A/P Invoice Print  10920  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 10920
by  k-rockJump to last post
05/21/2007 12:43 PM
5 Replies and 14908 Views FAILED JOBS  14908  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 14908
by  Deleted UserJump to last post
05/21/2007 9:37 AM
5 Replies and 10870 Views Problem in creating Activity List  10870  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 10870
by  John HenleyJump to last post
05/18/2007 8:03 AM
6 Replies and 12248 Views RQ approver  12248  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 12248
by  jjcyeshuaJump to last post
05/17/2007 10:20 AM
5 Replies and 11744 Views Duplicate Journal Entries  11744  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 11744
by  John HenleyJump to last post
05/09/2007 5:07 PM
2 Replies and 11080 Views Budget Edit  11080  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 11080
by  jjcyeshuaJump to last post
05/07/2007 10:28 AM
0 Replies and 10817 Views OE Returns Account Overrides  10817  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 10817
04/22/2007 2:04 PM
2 Replies and 11062 Views MS Add-in AC45.1  11062  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 11062
by  Deleted UserJump to last post
04/11/2007 8:00 PM
16 Replies and 16702 Views Invoice creation  16702  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 16702
by  John HenleyJump to last post
04/10/2007 5:49 PM
0 Replies and 10630 Views General Comment  10630  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 10630
04/05/2007 11:34 AM
2 Replies and 12251 Views Out of Balance General Ledger  12251  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 12251
by  Deleted UserJump to last post
03/30/2007 11:25 AM
11 Replies and 14850 Views Bank Recs  14850  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 14850
by  Deleted UserJump to last post
03/30/2007 8:30 AM
7 Replies and 12539 Views Tax Calculation - Invoice Processing  12539  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 12539
by  John HenleyJump to last post
03/12/2007 5:47 PM
5 Replies and 12770 Views GLTRANS - (Incremental update to DW) Identifying newly inserted or updated records  12770  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 12770
by  debika_sharmaJump to last post
03/06/2007 11:59 AM
6 Replies and 12561 Views Importing Patient refunds  12561  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 12561
by  Roger FrenchJump to last post
10/12/2006 1:33 PM
1 Replies and 12621 Views Test Scripts for 8.1  12621  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 12621
by  Ken PtakJump to last post
09/22/2006 12:33 PM
0 Replies and 11128 Views 9.0 issues to watch on first close?  11128  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 11128
09/06/2006 5:47 PM
3 Replies and 11894 Views Lawson AR set up  11894  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 11894
by  Deleted UserJump to last post
08/29/2006 10:03 AM
1 Replies and 11496 Views Duplicate Invoices  11496  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 11496
by  Bill IanniJump to last post
08/26/2006 1:23 PM
1 Replies and 11781 Views GL90  11781  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 11781
by  John CrudeleJump to last post
07/11/2006 2:42 PM
1 Replies and 11391 Views OERTL 227 Error  11391  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 11391
by  John HenleyJump to last post
07/10/2006 12:45 PM
1 Replies and 11582 Views Activations and Inactivations  11582  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 11582
by  John HenleyJump to last post
06/27/2006 3:50 PM
5 Replies and 12582 Views Parameter Update Programs  12582  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 12582
by  Bill IanniJump to last post
04/22/2006 11:12 AM
4 Replies and 13139 Views Report Writer  13139  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 13139
by  John HenleyJump to last post
03/16/2006 3:34 PM
1 Replies and 12167 Views Lawson 6.1 Documentation  12167  1 Started by  Scott Krueger Hello All, I am looking or Lawson 6.1 documentation for the iSeries(AS/400) Does anybody out there have a copy of this documentation. I am looking for the technical documentation for this release. Thanks
1 12167
by  John HenleyJump to last post
03/15/2006 8:12 AM
1 Replies and 12032 Views GMCODES  12032  1 Started by  Deleted User We have this table included in our Activities Module but the details are not listed in the Data Dictionary.
1 12032
by  John HenleyJump to last post
07/28/2005 3:15 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 5 << < 12345

RSS Feed Available