Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 5 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
1 Replies and 1481 Views Migrating From Lawson To Oracle EBS GL  1481  1 Started by  Andy Can someone please help with the migration path from Lawson to Oracle Financials GL. More specifically, what do i need to do on the functional side. ThanksVery Much, Andy
1 1481
by  AndyJump to last post
01/05/2013 4:30 PM
0 Replies and 2089 Views Paymode-X  2089  0 Started by  dcaiani I'm looking for Lawson customers that are using Paymode-X (Bottomline Technologies) to make electronic payments. The issues that we are facing are: • Paymode-X assigns each vendor a 20 digit identifier that needs to be entered somewhere in AP10 (APVENMAST). There are a couple of non-critical fields that can house a number of that size. Email, which we currently use. URL, which we currently use. • Are have 8 GL and 8 AP companies and 2 Vendor Groups. We are not planning on having all ...
0 2089
01/04/2013 2:42 PM
0 Replies and 1217 Views New FACTA regulations for Foreign Vendors  1217  0 Started by  JoeD We have to start reporting and withdrawing a percentage of money before paying foriegn vendors.Then we have to submit that money to the IRS. New FACTA regulation also known as 1042. Currently we just created another income code, 1042, and setting vendors up with that. But we need to have a field so we know how much of a percentage to keep and then it would be nice to have it somewhere in the invoice. Anyone else been doing this
0 1217
01/04/2013 11:40 AM
0 Replies and 1121 Views Using Analytics for Medicare cost report calculations  1121  0 Started by  Jbergstrom Trying to find out if anyone is using Lawson Analytics to integrate patient accounting data and finance data to perform the cost allocations and patient revenue allocations necessary for preparing data for Medicare cost reports.
0 1121
01/02/2013 3:38 PM
0 Replies and 908 Views Calc previous month  908  0 Started by  Chesca Is there an API that I can call to calculate the previous month given the parameter current month
0 908
12/20/2012 12:25 PM
0 Replies and 1497 Views Attachments to journal entries  1497  0 Started by  lawsonuser2012 Hello - is there a way to attach journal entry support within lawson, specifically on GL40 screen I'd like to be able to pull up a JE and view the support for it within Lawson. I believe there is a module that allows this - has anyone utilized it and how does it work
0 1497
12/12/2012 7:53 AM
1 Replies and 1328 Views Replicate MA236 form in Crystal  1328  1 Started by  imty Hello All, I am trying to replicate the MA236 form 'PO received but not invoiced' using Crystal since we need an additional field (invoice date) to be added to the report and is currently not included in the report Lawson produces. I have identified the tables that I would need to create the report but I am not sure how to link them properly. I have identified the following tables: APVENMAST APINVOICE POLINE MMDIST I like to know what the proper relationship is between these tables ...
1 1328
by  Ruma MalhotraJump to last post
11/27/2012 1:48 PM
1 Replies and 1090 Views Table containing Reporting Currency Period Totals  1090  1 Started by  darren Is there a table similar to the GLAMOUNTS table which contains the reporting currency period totals instead of the Base Amount totals contained in the GLAMOUNTS table Does that exist For example: When running a GL95 with Type = R Reporting & Currency = USD (in our case), is the begging balance amount stored in a Lawson table for the specifiied account(s) or is the beginning balance calculated at the time of the retrieval Thanks!
1 1090
by  John HenleyJump to last post
11/26/2012 3:31 PM
1 Replies and 1251 Views Asset Reports for Tax Return Preparation  1251  1 Started by  Sabrina Hoppe Our tax accountant is wondering which reports other companies use to get to year-end tax information on assets. We currently run a bunch of different reports that she uses (AM255, AM260, AM280, AM290) to essentially verify that Lawson matches all of her manual Excel tracking. Is there a way to make Lawson the source of truth / avoid all the manual Excel work / just have Lawson kick out the numbers needed for form 4562 Or does anyone have a Crystal or Query Wizard report built that does t...
1 1251
by  Greg MoellerJump to last post
11/14/2012 4:23 PM
4 Replies and 1551 Views RW100 logon failure  1551  4 Started by  ABG We are receiving a logon failure: unknown user name or bad password when running RW100 - we are running 9.0.1. Anyone else running into this
4 1551
by  ABGJump to last post
11/07/2012 8:38 AM
5 Replies and 7006 Views Hyperion Essbase - alternatives?  7006  5 Started by  blong Our accountants currently use Hyperion Essbase on a daily basis to pull financial (GL summary) information via Excel. We use Hyperion Reports for period close reports - P&L's, Revenue/Expense, etc. The financial cube is reloaded periodically via a scheduled Analytic Architect job several times a day to provide timely data. We are due to upgrade our Hyperion products but it is very expensive. I've heard of Cognos and Microsoft has an OLAP product that may work with Analytic Architect also...
5 7006
by  Wouter BornJump to last post
11/06/2012 7:55 AM
1 Replies and 2324 Views AP matching module  2324  1 Started by  Erin Hi everyone, We have the Lawson Financials but have not installed the AP matching module. We currently use inhouse written Matching, Purchasing and Inventorysystems. We will continue to use the inhouse Purchasing and Inventory systems for now but are considering moving to the AP matching module. I am sure once we get the system we will get the tech docs but we would like to find out what minimum fields are needed for 3 way matching from our inhouse systems as soon as we can so we...
1 2324
by  JimYJump to last post
10/23/2012 8:28 AM
2 Replies and 3470 Views AP90 Invoice Attachment URL Location Table  3470  2 Started by  shashank See the attachment for reference. On AP 90, if you drill down for an invoice, you get a pop-up page called 'Drill Around'. There is a list of options on the left section of this page. The first option in the list is 'Invoice URL Attachment'. Expanding this option gives you a link to the invoice image. When you click on the Invoice Image link, you see the Title and the Url on the right section of the page. Which Lawson table holds this title and URL I'm assuming each URL is tied to the ...
2 3470
by  shashankJump to last post
10/18/2012 1:13 PM
3 Replies and 1881 Views APAUDIT Table  1881  3 Started by  rpripstein I'm building a report using the APAUDIT table and in looking in the data dictionary at the Field ID values I'm noticing a bunch of them are blank and a few that my report is pulling are not even on the list. Is there a table in Lawson that would list the Field IDs and a descriptiondefinition Are the missing ones custom and possibly unique to our org Thanks in advance to any advice.
3 1881
by  dcaianiJump to last post
10/16/2012 1:49 PM
8 Replies and 1691 Views AP160 FORMAT - ONE LONG RECORD STRING  1691  8 Started by  JPurvis We are attemping to setup a NACHA file format using AP160. Our file currently is outputting a file that puts the data in one long string. We wanted to get this type of format below. Basically the normal NACHA looking format....any help or thoughts Where are we missing a flag or parameter to get the output to look like this Thanks! 1 data 5 data 8 data 9 data
8 1691
by  JimYJump to last post
10/04/2012 11:44 AM
0 Replies and 1219 Views Actual and Budgeted Salary Dollars Report broken down by Job Class  1219  0 Started by  agersh My Finance department is requesting a crystal report that reports actual and budgeted salary dollars for a given bi-weekly pay period broken down by Job Class. Has anyone done anything like this
0 1219
10/04/2012 9:55 AM
0 Replies and 1439 Views CA10 Allocations Upload  1439  0 Started by  Stephanie Boles If your attempting to complete a large change to your current allocation structure, this may be of some help to you. Please remember that the files attached are specific to my company. You will need to comb through your CA20, to see if there are fields that you are using that I may not be. You will also need to amend your columns to include the data that you will require on both the Query Wizard and the Upload Templete. I suggest you complete this upload in a test environment first, in ord...
0 1439
10/01/2012 5:44 PM
1 Replies and 1246 Views Invoice detail upload  1246  1 Started by  TA Can someone tell me if there is a way to use a Lawson upload to do accounts payable invoice changes TA
1 1246
by  MichelleJump to last post
09/27/2012 11:26 AM
13 Replies and 11173 Views AP - Wells Fargo Payment Manager Service  11173  13 Started by  blong I am looking into utilizing the Wells Fargo Payment Manager service pay our AP vendors in Lawson. The service accepts a single file with several different payment types such as check, ACH, P-Card via Mastercard gateway, etc. Wells Fargo processes the data file and pays each vendor according to the payment type specified. I support our Lawson system from a technical aspect. I'm trying to determine how to best pull the data from Lawson so that it can be manipulated into the Wells Fargo format...
13 11173
by  blongJump to last post
09/27/2012 7:48 AM
0 Replies and 1034 Views Library routine  1034  0 Started by  Chesca Could I write a file/report off a library I am writing custom code in a library LPCUSTOMPD and would like to be able to write to a file. I am new to Lawson.
0 1034
09/25/2012 3:02 PM
6 Replies and 1718 Views ERDs for Newest Version  1718  6 Started by  Erin Does anyone know if there is a set of ERDs on the newest software version (or at least what has changed between the the current and latest versions) Were there a lot of changes
6 1718
by  ErinJump to last post
09/21/2012 3:14 PM
2 Replies and 2308 Views Inbound EDI 810's and multiple vendor locations  2308  2 Started by  Brent Hello. We are attempting to set up to process EDI 810’s in Lawson 9.0.1.5.768, using GHX. We have an issue regarding Trading Partner setups and how we configured our Vendor Locations in AP10.2. We have multiple facilities that have their own Trading Partner ISA ID’s. We have created a Vendor Location for each of our facility locations per each actual Vendor Location in order to have the proper account number in the AP10.2 form for each of our facilities. All of our Vendor Locations are set ...
2 2308
by  BrentJump to last post
09/20/2012 10:56 AM
2 Replies and 1841 Views Return number of days  1841  2 Started by  Chesca Hello, I was wondering if there is a function/API that calculates the difference between two dates and returns a number I coded but I don't think it is calculating correctly. Any help would be greatly appeciated, thanks! Here is my code: MOVE LPC-PRM-THRU-PROC-DATE TO WSDR-FR-DATE. PERFORM 900-DATE-TO-JULIAN. MOVE WSDR-JULIAN-DAYS TO WS-SYS-JULDATE. *===CONVERT EMP ADJ HIRE DATE TO JULIAN DATE MOVE EMP-ADJ-HIRE...
2 1841
by  TracyOJump to last post
09/19/2012 1:17 PM
6 Replies and 1735 Views ACTRANS has OBJ-ID = 0  1735  6 Started by  Lisa In our ACTRANS table, there are many rows where the required key OBJ-ID has a value of 0, but other rows have a value that we can then link to the GLTRANS table. Why is this value sometimes 0, and what process updates it to a valid value Thanks -
6 1735
by  LisaJump to last post
08/31/2012 4:15 PM
0 Replies and 2752 Views Lawson training or navigational guides  2752  0 Started by  DougAB Hi, I was wondering if anyone would be willing to share their Lawson training or navigational guides. We're going to be starting end user training in October and would like some ideas, etc. Thanks, D
0 2752
08/31/2012 10:22 AM
2 Replies and 1570 Views ARITRANS  1570  2 Started by  DougAB I believe the ARITRANS table is a temporary table to interface records to (er, so I'm told). What the corresponding permanent table for ARITRANS after running the AR560 program There is a field called, AIT-USR-FLD-03, in ARITRANS that I'm curious where it gets mapped to after running the AR560. Is there any documentation, in general, where temp table fields get mapped to on permanent tables Thanks in advance, Doug
2 1570
by  DougABJump to last post
08/27/2012 4:25 PM
5 Replies and 4993 Views PO64.1 PO Line Item History Report?  4993  5 Started by  Dave McGown We use PO64.1 a lot to view activity on PO lines. We have been looking but cannot find a report that would print out this same information so we could dump it to excel. Does one exist We would like to be able to look at the PO Line Item History for all our open Capital PO's. (Note we do not have Add-Ins but I do use Crystal Reports). Thanks! Dave
5 4993
by  Dave McGownJump to last post
08/03/2012 10:24 AM
3 Replies and 2328 Views Suggestions for check printing solutions?  2328  3 Started by  DougAB Hi, I'm looking for inexpensive solutions or vendors for check printing solutions. We don't print that many checks per month and wanted to see if anyone has any good, yet inexpensive solutions, or use any 3rd party products, to print their checks. Any help is appreciated!!
3 2328
by  DougABJump to last post
07/31/2012 3:58 PM
0 Replies and 1720 Views 457 Plan - Company Match  1720  0 Started by  Lance Kelley We have existing pre-tax EE contribution 457 plans but now our company is offering a company match to some EEs. I've researched the PR05 and BN15 forms, user manuals, KB, etc. but the information on how to set the company match up seems piecemeal to me. I can't connect the dots yet. If anyone has a 'how-to' helper guide or form names and screenshots as to how you set it up, I'd be very grateful to see anything you might offer. For what it's worth, our company match is defin...
0 1720
07/26/2012 5:22 PM
0 Replies and 1176 Views Comments not attached to invoices  1176  0 Started by  Frank I am new to this, so please forgive me on this question, when users run ap520 there are no errors but a message appears that is saying comments not attached to invoices. Anyone have a clue to this Thanks for any help Frank
0 1176
07/17/2012 11:59 AM
11 Replies and 2642 Views GHX and email copies of 810's  2642  11 Started by  Greg Moeller Recently GHX stopped sending us return email copies of the 810 invoice records. Being in contact with GHX, the email functionality has not been supported for some years, so it will not be reinstated. We've come to rely on the email copy to scan into our ImageNow application and tie to Lawson. Anyone have any suggestions on what they are doing Specifically to appease the auditors that like to see a 'pretty' version of the invoice, and not have to rely on reading an archived version of th...
11 2642
by  Greg MoellerJump to last post
07/17/2012 9:13 AM
0 Replies and 1633 Views Security On GL298  1633  0 Started by  Dennis Amory I am trying to secure the data generated by GL298 so that the user sees only accounts/data related to a particular Process Level.Does anyone know which table(s) the rules should be written on Any other idea of a solution to this Thanks, Dennis
0 1633
07/02/2012 4:27 PM
1 Replies and 1633 Views AC07 criteria include/exclude au's  1633  1 Started by  Sherry Shimek We use AC07.1 Account Assignment to restrict the company, accounting unit, account and subaccount combinations that are allowed to post to activities within an activity group. We would like to further restrict the current AC07.1 for one activity group currently as follows: Company Include 8800 8800 1 AU Include 6622827 6994827 1 Account Include 400000 899999 1 SubAcct Include 0 9999 1 Company Include 8800 8800 2 AU Include 9200837 9299847 2 Account Include 400000 899999 2 SubAcct Incl...
1 1633
by  JeremyJump to last post
07/02/2012 6:55 AM
1 Replies and 1557 Views Merging many vendors  1557  1 Started by  CamM Hi, we have many one time vendors that we need to merge into permanent vendors. Normally we would run AP115, but this can only be run for a single vendor at a time. Is there an easy way to merge a large amount We have hundreds. Thanks! Cam
1 1557
by  Ragu RaghavanJump to last post
06/28/2012 3:11 PM
5 Replies and 2084 Views Fax Integrator 9..0.1.1 install time frame  2084  5 Started by  cindy MHSIL Hello, We are currently using fax integrator and it is stable and supported but we're wanting to upgrade to current version to position ourselves better for 10. Anyone with experiance upgrading to 9.0.1.1 please reply with time frame examples and any lessons learned they experianced. I searched for any patches to the Sept 2011 release and found none on KB. Thank you all in advance for your replies Cindy
5 2084
by  cindy MHSILJump to last post
06/25/2012 12:30 PM
0 Replies and 1212 Views How do i get a Payment proposal into Lawson  1212  0 Started by  Matt D I want to get Payment Proposals from suppliers into Lawson, which form should I be using Using Payment proposals suppliers request early settlements by agreeing to an offer and enables you to pay suppliers early in exchange for discounts
0 1212
06/20/2012 11:18 AM
6 Replies and 2428 Views CA10 Add Ins  2428  6 Started by  Joseph Carfagno I need to add over 100 lines to an allocation. Rather than key everything in, I think it would be easier (and less risky) to create an upload Add In. Does anyone have an upload template they can share Does anyone know of a better way to add many lines to an allocation
6 2428
by  SherryBJump to last post
06/13/2012 1:40 PM
0 Replies and 2137 Views Check Printing/Formatting Solutions  2137  0 Started by  DougAB Hi, We are looking for alternative ways to print checks w/o going with a 3rd party solution vendor, like MHC, etc. We only print a few AP checks per month (~200). Has anyone used a different approach/solution Has anyone used, or know of anyone, who uses Crystal Reports to format their checks out of Lawson Thank you, Doug
0 2137
06/11/2012 2:59 PM
1 Replies and 1646 Views AM223 to CSV  1646  1 Started by  Melissa McGuire Has anyone had an issue in AM module where they've run an AM223 and the report is fine but when sent to CSV something throw it off so the excel sheet is unusable I've attached one....I think there may be a character throwing it off somewhere...but not sure.
1 1646
by  JonAJump to last post
06/07/2012 2:22 PM
4 Replies and 2167 Views Determine AR Customer Balance - As At Point-In-Time  2167  4 Started by  Garth Gerwing Wouild like to hear from anyone who either knows how to reference in Lawson AR - or has developed their own SQL to be able to determine an AR Customers balance as at a point-in-time in the past. EX: Derive Customer Balance as per 5 days ago Any feedback/commentary would be most appreciated - thanks.
4 2167
by  Garth GerwingJump to last post
06/06/2012 2:27 PM
2 Replies and 2298 Views How to Cancel on MA40/MA40.5  2298  2 Started by  jbertoli We have had staff changes and the person that has done this process is gone and of course there is no documentation. We are on an old version of Lawson - 7.2.4. For our Bank Wires, they are entered into MA40 with MA40.5 done to create the payment record. After this, AP26 (release), AP170 (closing), AP175 (Distribution) are all done. We had a payment done incorrectly and need to back it out. We are not sure if we are doing things correctly to back out the payment because when we are done, the ...
2 2298
by  jbertoliJump to last post
05/24/2012 4:32 PM
0 Replies and 1190 Views mobile inbasket - issue with custom form  1190  0 Started by  chris I am trying to get a response from a custom html form within the mobile inbasket. When I use the xmlhttp object with the open and send functions but instead of getting the response I would expect I keep getting a response for the login page. I am passing in proper credentials in the open command and I have double checked the url I am passing is correct as well. Any suggestions or examples would be very much appreciated.
0 1190
05/09/2012 9:30 AM
5 Replies and 3046 Views Chart of Acct query  3046  5 Started by  Don Hi There, I am totally new to lawson. I just start to look at the tables on GLs, and try to build chart of account hierachy, for top to detail GL. I look at two tables, GLCHARTDTL and GLCHARTSUM and I knnow ChartName, so here is my query: SELECT S.CHART_NAME, D.SUMRY_ACCT_ID, D.CHART_SECTION, D.ACCOUNT, D.SUB_ACCOUNT,D.ACCOUNT_DESC, S.SUMMARY_ACCT,S.ACCOUNT_DESC, S.TOTAL_DESC,S.PARENT_OBJ_ID FROM dbo.GLCHARTDTL D inner JOIN GLCHARTSUM S ON D.SUMRY_ACCT_ID = S.SUMRY_ACCT_ID ...
5 3046
by  amynelsonJump to last post
05/07/2012 10:50 AM
1 Replies and 1656 Views Adding field to AM260 Report  1656  1 Started by  Jeanne Boitano How do we go about adding the account number to be pulled in on the AM260 report Thanks ! Jeanne
1 1656
by  Ruma MalhotraJump to last post
05/03/2012 11:53 AM
0 Replies and 1720 Views PD10.3 upload?  1720  0 Started by  JCardillo Hello, We have Excel add-in uploads for user setup in PD10.1 and PD10.2, but PD10.3 seems to allude us, probably because you can only get to PD10.3 via PD10.2. However, in the UWF maker, PD10.3 is a choice. So, I was wondering if anyone out there has been able to defeat the system on this The PD10.3 setup is the most cumbersome and an upload would be very beneficial. Thanks.
0 1720
05/03/2012 8:14 AM
7 Replies and 2909 Views Need to create a consolidating company in Lawson 9.0 but I have no idea how to start  2909  7 Started by  TeresaE We are just looking at creating consolidating financials in Lawson 9.0 this year rather than continue creating them manually in Excel. I am wondering if anyone could point me toward any good articles, instructions on how to go about setting up the consolidating companies because I don't have a clue where to begin.
7 2909
by  TeresaEJump to last post
04/27/2012 1:51 PM
0 Replies and 1463 Views Alternative for 'delement'  1463  0 Started by  sarahula Lawson Masters, I was declaring some new elements on dbdef, I was supposed to specify them as 'strings'. But as a newbie, I used AlphaLower. Now I want to change them to derived 'strings' but it seems to be imposible. I think the element needs to be deleted. I found this tool called 'delement' but when it deletes elements it does it per product line and it deletes all of the unused elements. I want to delete only those that I created by mistake. Please give me some idea on how to do it...
0 1463
04/26/2012 11:39 AM
2 Replies and 4285 Views Invoice Distribution from AP Payment  4285  2 Started by  G. Monaghan I am trying to write a report of cash by activity. The activity is attached to the invoice on AP invoice distribution table (apdistrib) and posts to GL via AP175. When the check is written the entry to GL to cash just clears AP via AP170. There appears to be no way to tie the entry from the AP175 to the corresponding payment done via AP170. Has anyone found a way to accomplish this
2 4285
by  G. MonaghanJump to last post
04/25/2012 2:05 PM
1 Replies and 2827 Views AR Bank Reconciliation - How To Organize?  2827  1 Started by  Garth Gerwing I would very much appreciate to hear from anyone who has had experience setting-up CB/AR in support of reconciling bank account deposits to AR-sourced payment entries in CBTRANS. I've looked extensively at the 'Bank Reconciliation' functionality in the Cash Management (CB) module - and it would appear to be more slanted to AP-related reconciliation. I'm kind of leaning to using the 'Enhanced' reconciliation constructs (CB185-Run option 'R', CB81, CB82). AR submits records to CB upon the re...
1 2827
by  jjcyeshuaJump to last post
04/24/2012 6:23 PM
0 Replies and 1441 Views AP20 Vendor select security  1441  0 Started by  Daksha Desai I hope anyone can help. I am creating a customized AP20.1 form in design studio. Some else handles Security set up so I do not know much about it. The user needs to see Vendors based on the Accounting Unit they enter or are assigned to for Security. How should any security be set up. Is there something I need to add in the form
0 1441
04/23/2012 2:09 PM
0 Replies and 2239 Views CB55.1 Payment  2239  0 Started by  dj I am trying to enter a patient refund in CB55.1. I recently learned of this option rather than continually creating one-time vendors in my AP vendor master. When I try to add the payment in CB55.1, I am prompted to provide the vendor bank information 'Bank ID and Acct require for electronic payments' The issue is that I am using a transaction code of SYS to create a check, not an electronic payment. My Patient Refund vendor is setup with a Payment Code of SYS (cash payment). Finally, my...
0 2239
04/20/2012 11:38 AM
5 Replies and 8767 Views WHAT IS NEW LAWSON 9.0.1 FINACE APPLICATIONS  8767  5 Started by  fdflanig I have a training documentation need to know of any form changes or process changes in 9.0.1 before I update my 9.0 fincae training material. Lawson 9.0.1 is on my horizon. Is 9.0.1 from 9.0 change information available
5 8767
by  jjcyeshuaJump to last post
04/18/2012 4:59 PM
3 Replies and 2804 Views Retail Calendar and 13th Period  2804  3 Started by  Adam We are trying to deal with this 53rd week and we know GL can handle a 13th period, but when we contacted Lawson and they advised us not to turn on the 13th period, but offered no other suggestions to deal with it. I was wondering if there were any retail clients dealing with a 13th period or a 53rd week in Lawson
3 2804
by  AdamJump to last post
04/05/2012 12:36 PM
1 Replies and 1554 Views secure invoice number interface from payroll  1554  1 Started by  heather Currently the interfaced garnishments from payroll have the employee number They want to block it out on the ap90 screens. I wrote a rule to block it out operator ap520 to apinvoice. did not work In pr05 you summarize it -but that is not waht they want. I have blocked out the garnishment comments successfully Trying to figure the blocking the invoice as well. Any suggestions/
1 1554
by  Jimmy ChiuJump to last post
04/03/2012 2:27 PM
0 Replies and 1514 Views ACBR billing  1514  0 Started by  cindi Is there anyone using ACBR to do minimum type billings For example - bill a customer a minimum of $1500 per month but if number of different cases times different rate per case equals more than 1500 - then customer is billed the cases charge Thanks!
0 1514
03/28/2012 10:54 AM
0 Replies and 1094 Views turning on remoteglt  1094  0 Started by  Deleted User Any ramifications if I turn on the flag to create the remoteglt file at any point, as opposed to the beginning of a fiscal/calendar/legislative/whatever year One of our payrolls has never used any type of an automated financial interface, and we'd like to start, sooner rather than later. We don't use Lawson financials here - As a severely GL Challenged individual, I welcome any suggestions!! Thank you!
0 1094
03/28/2012 5:02 AM
0 Replies and 1510 Views Void PD Invoice  1510  0 Started by  Boyd I am having trouble voiding an invoice that was created using PD 570. Is there something that I am missing Surely we can void this type of AP invoice.
0 1510
03/26/2012 5:19 PM
0 Replies and 1647 Views AR Lockbox  1647  0 Started by  MG44 Anyone utilizing the AR Lockbox feature with 9.01 Financials We are looking to utilize and are looking for any information or tips. We use US Bank and have the file format from them. Any info is appreciated. Thanks.
0 1647
03/22/2012 10:15 AM
3 Replies and 1723 Views LP Custom calculation routine  1723  3 Started by  Chesca Our Lawson consultant suggested we add logic to calculate LP vacation accruals. I was provided with this logic but I have no idea what it means or how to code it. I would greatly appreciate any feedback or suggestions with this issue. Thanks! I defined the LP ACR HOURS in WS as whole number. Would I need a compute statement to calculate the ACR Hours Logic: ACR HOURS = If TASERVICE_SERVICE-CODE is included in ACR TASERVICE _SERVICE-CLASS and status <> 9 and SERVICE CODE DATE is ...
3 1723
by  ChescaJump to last post
03/12/2012 1:22 PM
0 Replies and 1408 Views DB inquiry processing  1408  0 Started by  Chesca I want to retrieve a record off the TAEMPSERV and the TASERVICE files. I have populated the set keys (840-FIND-TESSET1). This is my first exposure to custom 4GL code. Does an 860-FIND-INDEX must proceed a find next routine I would appreciate any feedback or suggestions with this issue. Thank you in advance. Here is my custom code: INITIALIZE DB-TES-OBJ-ID. MOVE LPMST-TEM-COMPANY TO DB-COMPANY. MOVE LPMST-TEM-EMPLOYEE ...
0 1408
03/12/2012 9:35 AM
0 Replies and 1229 Views Crystal-Units issue at the AU level  1229  0 Started by  BShort I have been trouble shooting this for the past few days as a note. I am pulling units that I have setup in the Stats area for the GL, for us accounts 9xxxx I am using the following tables and started over today to try and figure out where the issues happen: GLUNITS, GLCONSOL, and GLSYSTEM. Some items I noticed is that the Var.level does not have everything listed on the GLUNITS as it is missing the main level at 010000000000 but has the department level, where as the GLCONSOL does not h...
0 1229
03/08/2012 7:35 PM
1 Replies and 3581 Views PP&E rollforward  3581  1 Started by  Boyd Does anyone know if Lawson has a system report that rolls forward PPE activity from one period to the next I am interested in Beginning balanceadditionsincreases to WIP-disposals etc. Any thoughts are appreciated.
1 3581
by  mark.cookJump to last post
03/07/2012 7:01 AM
3 Replies and 2767 Views Check reissue report?  2767  3 Started by  StephanieL Is there a report I can run that shows a listing of checks reissued over a period of time Thank you.
3 2767
by  StephanieLJump to last post
02/22/2012 12:16 PM
2 Replies and 1719 Views AP Productivity Query  1719  2 Started by  Billi We are looking for a query that can pull how many invoices and lines have been keyed by employee for a given time period. I am having a bit of a hard time trying to figure out fields I can pull to get this information Any thought Thanks.
2 1719
by  Robert SpurrJump to last post
02/17/2012 1:28 PM
0 Replies and 1933 Views Question about Sub Accounts  1933  0 Started by  Saurabh Hi All, We currently only have the Detail Accounts setup without any Sub Accounts. e.g our accounts are setup as 01700 01701 etc We would now like to add some sub accounts so for e.g 01700 - 001 01700 - 002 As far as i can ascertain these seem to be created as New Detail accounts and also seem to be coming up as separate entries in the GL291 (instead of 1 entry for the main 01700 account) Is there a report which i can run to see the combined posting of the account (i.e 01700,0170...
0 1933
02/17/2012 10:32 AM
1 Replies and 1493 Views What Table are CB Comment stored in  1493  1 Started by  Jeff Pratte I created a comment from CB55. Thanks to a post from Jim on the site 'What I Learned Today' I found the Header for the comment in L_HCBM (Header table). But when I looked in the table L_DCBM (Detail table), it was empty. Does anybody know where the rest of my comment is Thanks, Jeff
1 1493
by  John HenleyJump to last post
02/16/2012 2:37 PM
6 Replies and 3022 Views AP20 Comments  3022  6 Started by  Steve Datish We are using addin's to add several invoices to AP20 and would like to add comments to the completed invoice. Is there a way to do this using addin's or another tool Currently we are adding the comment to each individual invoice. Thanks.
6 3022
by  Bob CanhamJump to last post
02/10/2012 10:03 AM
2 Replies and 5645 Views GL40.1 Upload Template  5645  2 Started by  RAKESH DESAI How can I build template to upload journal entry (40.1)from Excel.
2 5645
by  dcaianiJump to last post
02/09/2012 9:09 AM
0 Replies and 1596 Views Reverse PO Entry  1596  0 Started by  RAKESH DESAI I am trying reverse the PO ENtry. I went to GL40.1 and tried to copy & add as reverse value. But it didn't allow me. Anybody has a better idea
0 1596
02/03/2012 3:15 PM
0 Replies and 1563 Views Wire Payment entry  1563  0 Started by  RAKESH DESAI How can I book wire payment entry without matching the invoice. I know I can use the credit memo. But I wan't to show as a payment in vendor's account but I don't want to match invoice.Is that possible
0 1563
02/03/2012 2:54 PM
0 Replies and 2107 Views HELP - PO Matching/Pre-Paid Invoice  2107  0 Started by  soleary I partically prepaid a PO Matching invoice (50 paid, 50 on hold) and it has been received but it still showing up in the PO135. I can't seem to find anywhere in Lawson to match this pre-paid invoice and since it has been received I thought the system automatically matches it. Can anyone help
0 2107
02/03/2012 10:14 AM
6 Replies and 3407 Views Cost Center Level  3407  6 Started by  RAKESH DESAI How Can I change or add cost center level in GL20 I need to add cost center level.
6 3407
by  RAKESH DESAIJump to last post
02/01/2012 11:32 AM
2 Replies and 2008 Views Invoices for void check  2008  2 Started by  Ludy If I need to know what invoices are associated with a void check, what table/s should I look into
2 2008
by  LudyJump to last post
01/30/2012 7:51 AM
0 Replies and 2095 Views Add in for GL20 and AP AM set up programs  2095  0 Started by  Joseph Carfagno Our financials group will soon have to load hundreds of new locations into Lawson. We'd like to use add ins rather than GL161, etc to perform the uploads so that we can use Excel to copy the values we need for accounting units, level groups, attributes etc from our source system and upload them to Lawson. I'd appreciate any sample templates that are out there.
0 2095
01/26/2012 11:04 AM
4 Replies and 3548 Views Invoice Dist Out of Balance Error AP520  3548  4 Started by  Deleted User I'll begin by saying I know virtually NOTHING about AP, except it really isn't (or shouldn't be) a convoluted process.... We're in the final stages of upgrading from v8.1 apps to 9.0.1 and we're having a problem with AP520 for one particular deduction. It's a simple of pay, however, in the new app, this is the only deduction that we receive the above error - distribution out of balance - and we then can't create an AP check. There is no error on the 197, no errors on the 198, and the amo...
4 3548
by  Deleted UserJump to last post
01/26/2012 4:24 AM
0 Replies and 1312 Views AR converted transactions  1312  0 Started by  cindi Outstanding transactions were converted into AR using AR502. Finance Charge invoices were loaded as invoices not as debit memos. Now when running AR137 to apply finance charges, it is including the previous finance charges in the balance to calculate finance charges on. Any ideas how to resolve
0 1312
01/24/2012 12:46 PM
1 Replies and 3158 Views Freight and MA540  3158  1 Started by  bnelson Good morning, I would like to know if anyone processes invoiced Freight in Lawson as AOC Spread (add on cost, spread to each PO line) in an EDI 810 invoice transaction. If so, can you tell me where the Freigth elements go in the MA 540 record lay out so it processes successfully, IE without fataling out. Thank you Bob Nelson
1 3158
by  Robert SpurrJump to last post
01/19/2012 1:44 PM
2 Replies and 2823 Views Query or Crystal report for AP136  2823  2 Started by  JCardillo I'm trying to find the easiest way to create the AP136 in a Crystal Report. I have the APINVOICE and APDISTRIB tables already, but once I connect the APPAYMENT table, the report goes all haywire. But, I'm assuming the APPAYMENT is necessary. Any hints or has anyone done this Thanks.
2 2823
by  JCardilloJump to last post
01/11/2012 12:14 PM
1 Replies and 2551 Views Asset Transfer Upload  2551  1 Started by  TDB I am trying to create an upload that will transfer over 1,100 assets. I tried to make one for the AM30.1 and mapped each column. When I run the upload this error message is displayed 'To-company books are in different periods or years'. Does anyone know how to solve this issue Any help would be appreciated
1 2551
by  John HenleyJump to last post
01/09/2012 2:20 PM
1 Replies and 2568 Views lawappinstall failure when installing any CTP in any mode  2568  1 Started by  gzucker Hey all, I am running into endless frustration with Lawson Support, so I am hoping that this community may be able to assist in some way. I am trying to install the 2011 end of year CTP (although this issue would apply to any CTP). The command fails with the following error: ERROR - 'tar xf D:/PROD/patch_staging/patch.tar' command failed. I have tried running the lawappinstall command both in LID and directly from the command prompt on my server and I get the same error. I am using ...
1 2568
by  troelofsJump to last post
01/06/2012 3:31 PM
3 Replies and 2292 Views Backposting entry  2292  3 Started by  RAKESH DESAI Why my system does not allow to backout the journal entry eventhough I opned the period for backposting allowed
3 2292
by  Ruma MalhotraJump to last post
01/05/2012 1:44 PM
0 Replies and 1142 Views Internal Services Cost Transfers  1142  0 Started by  crichard How do the hospital users out there handle internal transfers from department to department We have many internal services that get requested by our PIs that we then need to perform a cost transfer from the service department to the PI. Our service departments would be similar to many service departments at a hospital (Histology, Radiology, Pharmacy, etc.). The issue that we are faced is that many of these transfers happen monthly and we want to streamline the process while capturing transac...
0 1142
01/05/2012 12:43 PM
0 Replies and 1243 Views Moving RW100 from 8.03 to 9.01  1243  0 Started by  Joe O'Toole We will be upgrading our applications from 8.03 to 9.01 over the next few months and were wondering about migration issues with some of our critical reports written in RW100. Has anyone had trouble porting their 8.03 RW100 reports to 9.01 Thanks.
0 1243
01/04/2012 4:05 PM
1 Replies and 2505 Views Help on how to create cash flow statement  2505  1 Started by  john Looking for direction on how to structure Lawson to create cash flow statement to go along with Balance Sheet and Income Statement. Help!!!
1 2505
by  johnJump to last post
01/04/2012 12:43 PM
0 Replies and 1802 Views MSP 7  1802  0 Started by  Mark Larochelle Is/has anyone applied the MSP 7 patch
0 1802
01/04/2012 9:14 AM
0 Replies and 1587 Views CB186 error report  1587  0 Started by  Jim Howerton Have several entries on error report. Cannot stale-date xxx xxx checknumber Adjustment exists How is this error addressed
0 1587
12/28/2011 2:25 PM
1 Replies and 3635 Views 1099 Validation report  3635  1 Started by  Jeremy AP145 appears to have a problem when aggregated by TIN. If the same TIN is used on more than one vendor the vendors are aggragated to one. However we have found that the information for a giving vendor number isn't always upto date. I have written a report that identifies TIN's with multi vendors however I have not found any rhyme or reason as to with vendors information gets printed for a giving TIN Does anyone have a report or know the criteria.
1 3635
by  Greg MoellerJump to last post
12/13/2011 3:47 PM
0 Replies and 1622 Views AR - Support Both Pre-Authorized Debit & Credit?  1622  0 Started by  Garth Gerwing Lawson AR has EFT capabilities - that are targeted toward a 'Pre-authorized Debit' scenario - I.E. maintains customer bank account data in support of EFT. We will be engaging a credit card 3rd-party vendor in support of processing pre-authorized credit card transactions as well. In effect - pre-auth debit/credit amount to the same general requirements - although the resulting file TX's will need to be distributed to 2 seperate financial institutions: pre-auth debit->bank, pre-auth-credit-&...
0 1622
12/08/2011 4:02 PM
2 Replies and 2073 Views GL221 export to csv  2073  2 Started by  Tammy Guidry I need to run a report for auditors to see when accounts were set up. I ran GL221 which was 22,492 pages and exported to csv. It is stopping around excel line 637,500 and is incomplete. Lawson Support can't offer any suggestions. Does anyone have any ideas Thanks so much!
2 2073
by  Tammy GuidryJump to last post
12/05/2011 11:29 AM
2 Replies and 2265 Views .cfg files  2265  2 Started by  johne Can anyone point me towards a Lawson document, or a listing that someone may have posted, that explains what variables I might expect to see in the &91;ProgramName&93;.cfg files and what those variables do for the program I see some .cfg files for batch job programs (five character program name) and a couple for on-line jobs (BRIP.cfg specifically). I've searched here & on Lawson's Knowledge Base screens and have not had much luck finding anything that explains in detail what th...
2 2265
by  johneJump to last post
12/01/2011 1:59 PM
0 Replies and 1401 Views Reinstate check batch  1401  0 Started by  Boyd Does anyone know if there is a way to reinstate an electronic payment batch that was voided in error
0 1401
12/01/2011 8:52 AM
2 Replies and 3247 Views Putting Invoices on hold  3247  2 Started by  lmckenn I use AP40 to put an invoice on Temp Hold. We now need to put many invoices on hold each day (not at the vendor level and not a permanent hold) It seems tedious to enter each invoice individually on the AP40 - does anybody know a way to achieve this more efficiently -- is there a mass hold or bulk hold -- Thank you!
2 3247
by  lmckennJump to last post
11/22/2011 5:21 PM
5 Replies and 1857 Views Hide inactive accounts in user drop down lists  1857  5 Started by  Sherry Shimek Is there a way to hide inactive accounts in the user drop-down account lists in portal for GL, AP, RQ, and PO, for example We changed our supply general ledger accounts and prefer that the users do not see the old inactive accounts in their account drop down lists. We are hoping to prevent time wasted when users choose inactive accounts prior to being stopped by the 'inactive account' error. Because they have been used in the last fiscal year, we cannot delete these accounts. We have ...
5 1857
by  John HenleyJump to last post
11/16/2011 7:57 PM
4 Replies and 15126 Views Printing 1099 misc income  15126  4 Started by  Deleted User Does anyone know how to 1)Print the 1099 report 2)Adjust the form alignment so the numbers fit exactly in the boxes 3)Change the print orientation to portrait Thanks Nigel Jones
4 15126
by  JimYJump to last post
11/15/2011 10:01 AM
1 Replies and 2311 Views Report Writer  2311  1 Started by  Karen M I am trying to get the data that I have typed in the Row of my RW report to populate on the the report. I have tried using 'row name' under the format of the column and it will not that me use that item. Any advice is appreciated!!! thank you!
1 2311
by  Gail GudgelJump to last post
11/10/2011 1:06 PM
3 Replies and 1968 Views Current year Balance rebuild after post closing entry  1968  3 Started by  RAKESH DESAI How Do I change my current year Balance after the post closing entry in last year Does only GL199 will change it
3 1968
by  Greg MoellerJump to last post
11/07/2011 11:58 AM
0 Replies and 2863 Views Purchasing month end closing process  2863  0 Started by  RAKESH DESAI Does anyone has purchasing closing process or schedule
0 2863
11/01/2011 8:36 AM
1 Replies and 1494 Views Process Documents  1494  1 Started by  New User Gurus, Can anybody tell me where i will get S3 process documents for A/P, A/R, Payroll etc. I need to uderstand step by step process how to create view documents. (e.g. how to create PO) Thanks
1 1494
by  JimYJump to last post
10/14/2011 7:16 AM
1 Replies and 1725 Views How to create new vendor in S3?  1725  1 Started by  New User Hi Iam not able to create new vendor in S3. Iam using AP10 form ID for vendor creation. i fill up all the datails and click on add button i get error saying 'Error occured while performing the transaction' Pls check attached screenshot of error Pls let me know if iam following wrong process for creating new vendor
1 1725
by  Ragu RaghavanJump to last post
10/12/2011 7:32 AM
1 Replies and 2125 Views AP160 ACH Batch Number  2125  1 Started by  wrig We are creating a NACHA ACH file out of AP160. However, the file keeps getting rejected b/c Record Type 5 is 1 character too short. Specifically, the Batch Number field is showing as '000000' when it should be, for example, '0000001.' A look in the specs for this file says that 'Batch Number Assigned in Ascending Order, Hard Coded in Source.' Any ideas why it is showing up as '00000' (1 digit short)
1 2125
by  JillFJump to last post
10/10/2011 3:54 PM
1 Replies and 1944 Views Lawson Approval Codes  1944  1 Started by  Brett Townsend In getting ready for this year’s audit, I’ve run the approval codes report and I’ve noticed that some approval codes are different. Should they all be the same For Example: Approval Code DIMEB Can Lower Levels be Skipped – NO Printed Copy Required – NO Approval Code EESVC & CBWTO Can Lower Levels be Skipped – YES Printed Copy Required – NO What is the difference between the 2 Should they be the same &91;IMAGE:432&93;
1 1944
by  Jimmy ChiuJump to last post
10/05/2011 1:02 PM
1 Replies and 1509 Views Moving banks  1509  1 Started by  Brett Townsend We are in the process of changing banks and I have a AP Supervisor who is asking if there is anywhere in Lawson that she needs to make changes to reflect the bank information. I'm pretty sure that she only deals with AP. Thanks for anyone who helps.
1 1509
by  Mark F. HardyJump to last post
09/26/2011 12:31 PM
0 Replies and 1389 Views access restrict  1389  0 Started by  Deleted User Hi I want to restrict the user access in LID. but when i delete the user access. in lid it is not updating in VALID FCs and even the user still able to access the GL45. is any one tell me the steps how to restrict the user access in LID.. even i after making changes in the form secuirity i rebuild secuirity dictionary. my id- ak.satishhotmail.com Thanks to lawson forum.
0 1389
09/26/2011 9:41 AM
9 Replies and 6197 Views Can't Open Period for Backposting  6197  9 Started by  RAKESH DESAI Hi, I am trying to change the entry in period 7 which was closed. But I can't reopen the period
9 6197
by  RAKESH DESAIJump to last post
09/21/2011 8:47 PM
3 Replies and 2706 Views AP 1-time Vendor numbering - 999000001 series  2706  3 Started by  RajR Hello All, Can anyone tell me whether is it possible to change the one-time Vendor number format from 999000001 to 990000001 I understand that Lawson stores the Last-One-Time Vendor in APVENGROUP table Is the prefix 999 hardcoded somewhere in the code or database I also understand that it looks at the Vendor Class to make a determination whether the vendor should be a one time vendor. I understand that if we find a way to change the one time vendor number ...
3 2706
by  Ragu RaghavanJump to last post
09/19/2011 7:10 PM
1 Replies and 1962 Views Subsystem Journal Descriptions  1962  1 Started by  BMAE We recently went live with Lawson payroll and are wondering how the description of journals posted from subsystems can be changed to be more informative. For example, the bi-weekly payroll posting entry has a description of 'expense accrual' for each entry posted. We would prefer to change the description to something like 'Payroll PPE 08132011' so that review in GL90 would differntiate the various entries.
1 1962
by  Ragu RaghavanJump to last post
09/15/2011 12:08 PM
0 Replies and 2647 Views Any Functional Difference: AR Invoice vs Debit Memo?  2647  0 Started by  Garth Gerwing Can anyone provide any feedback RE whether or not there are any functional differences between an AR 'Invoice' and an AR 'Debit Memo' For all intense purposes - these appear to be 'TX Types' - and possibly as a means to organize/track transactions in AR. Granted - you may also have seperate distributions assigned to each. But, beyond that, is there any deviations between these two 'TX Types' by which Lawson AR will treat them differently from a functionality/data perspective Any feedback...
0 2647
09/14/2011 10:28 AM
2 Replies and 1780 Views Custom Reporting Confusion  1780  2 Started by  Jeremy Holovacs I'll apologize first because I don't even know if this is the appropriate place to ask this. I come from a pretty heave database and development background, but this is the first time I've had to get in deep with Lawson. My boss has asked for a report of active AP vendors with information like payment terms and invoice history. I thought it would be relatively straightforward to locate this information, but I was not counting on the data organization in the Lawson DB being so... non-intuiti...
2 1780
by  Jeremy HolovacsJump to last post
09/12/2011 11:29 AM
2 Replies and 2923 Views JE Approval Process Flow  2923  2 Started by  Gordon I have made a custom GL41 for use in the JE Approval PF. The page with the form does not populate. Has anyone experienced the same problem. I did not find a delivered htm to use for default display like we have for RSS. RSS delivered recsum.htm as the approval screen. I had to create an approval form for JE Approval. Does anyone have the default htm that suppossedly comes with JE Approval we can try
2 2923
by  LisaNJump to last post
08/29/2011 10:12 AM
1 Replies and 1546 Views Invoice data  1546  1 Started by  Maique I'm writing reports agains s3 AP Invoice Data, but users are cancelling (deleting) invoices via AP20.1 and I do not know the criteria to not to show them in my report.
1 1546
by  John HenleyJump to last post
08/24/2011 12:05 PM
1 Replies and 2094 Views Automation Needs?  2094  1 Started by  Paper_AP Hi everyone. Currently I work full time in AP for a high end retailer who uses Lawson Desktop 9 for financials and HR management. I am a part time software developer and have come to know Lawson very well over the past 2 years. I have developed a suite of 3rd party applications that 'sit' on top of the Lawson interface and allow for all types of automation that require very little support and are easy for the general user to understand. The applications use the Lawson forms to interact and th...
1 2094
by  jcapoJump to last post
08/02/2011 6:47 PM
2 Replies and 2154 Views Base Currency is a Foreign Currency  2154  2 Started by  Boyd I am in the process of setting up a company in Lawson with a Base currency of Brazilian Reals. This will be my first venture into setting up a company with a base currency other USD. Does anyone have any thoughts on setup or issues that may arise in processing AR or AP in this company. Any thoughts are appreciated.
2 2154
by  CarlinoJump to last post
07/01/2011 9:04 AM
2 Replies and 1565 Views AR115 - EFT Files and Required Permissions  1565  2 Started by  Garth Gerwing We are attempting to test the AR EFT process(s) - and are running into an issue whereby the EFT payment file(s) are being created - but are empty (0KB) where there should be data written. We setup the 3 required directories under productline\work\ - as the job required these be present before exeucting. Upon closer inspection of the job log - we noted a 'Security Violation' line being written. Anyone have any ideas as to what might be the issue here
2 1565
by  Garth GerwingJump to last post
06/22/2011 11:27 AM
0 Replies and 1528 Views A/R EFT Setup/Process Questions  1528  0 Started by  Garth Gerwing With regards to the setup and processing options for A/R EFT - I have the following questions: 1) Is there any way of creating a 'minimum threshhold' for EFT generation I.E. any debit balances < a given $ amount get ignored 2) Credit Balances: it would appear that the EFT process will pick up any credit balances for EFT customers and create a 'credit EFT' transaction - whereby the customer's account will be credited (as opposed to being debited). Is there any way to turn this off ...
0 1528
06/16/2011 3:10 PM
0 Replies and 1842 Views Asset Insurance Information - AM20.4  1842  0 Started by  LauraSantos We charge auto liability insurance to each of our locations based on the number of company vehicles they use. Right now, it is a manual process where someone will extract asset information from the AM module, group the vehicles by location and then create a spreadsheet to calculate the total liability insurance per location. They then upload the total using excel add-ins into a journal entry to charge the locations for the insurance. This is something they have to do each month. Can anyone...
0 1842
06/14/2011 5:10 PM
4 Replies and 4403 Views Researching Invoice Scanning, OCR, Workflow solutions  4403  4 Started by  RMc We are looking at possible solutions to scan our invoices, use OCR and workflow technology to route them and then interface into Lawson. I'm wondering if anyone is doing this today, what software solutions were chosen, what the experience has been, etc. Any information would be greatly appreciated! Thanks in advance! Reed
4 4403
by  Gail GudgelJump to last post
06/01/2011 10:16 AM
3 Replies and 1855 Views RW assistance  1855  3 Started by  Boyd I am a RW novice and need assistance creating a report. The report (a standard income statement) I would like to create is for a certain level group that I created. I would like the report to show only the information from the level group and at the same time consolidate the results of like accounting units into one on the report. So far the only luck I have had is to either show one of the accounting units or the consolidated group. As of now I am using a style 1 report. Any thoughts are...
3 1855
by  Gail GudgelJump to last post
06/01/2011 10:11 AM
3 Replies and 1874 Views Activity Management Upload Utility  1874  3 Started by  AD Hello, What are the steps needed to design an uplod utility for activities instead of manually adding them in using AC10.1
3 1874
by  tdosalJump to last post
06/01/2011 8:46 AM
0 Replies and 1675 Views Period of Performance (POP)  1675  0 Started by  tdosal We are exploring the option of implementing the POP functionality to prevent users from entering requisitions and PO's on the last day right before a grant ends (our grants our tracked using Lawson activities). How and why does your organization use this functionality Tina Dosal Moffitt Cancer Center
0 1675
06/01/2011 8:42 AM
5 Replies and 2264 Views adding comment to asset numbers in the report  2264  5 Started by  Vijay S I need to add comments on Asset numbers in the report via using Lawson API for comments. I just figured out that the table used for comments for Asset is L_HAST and L_DAST. Has anyone done it before I am bit confused as notb sure from where to start it. Could anyone suggest.
5 2264
by  Vijay SJump to last post
05/27/2011 2:11 AM
4 Replies and 2085 Views Creating Assets from AP invoices using AM115  2085  4 Started by  Saurabh Hi This is on 8.1 MSP5. Am trying to create an asset from an AP invoice using the AM115 session but keep getting message 'Account not defined'.&91;00999/8020&93; The AP invoice is linked to a PO which has the asset item (which was linked to an asset template) The PO line is against a Bal Sheet AU &91;00999&93; and Bal Sheet Account The 8020 Account is a P&L account which seems to be coming from AM06 (see screenshot for more info on setup) Does anyone use this routine to convert...
4 2085
by  SaurabhJump to last post
05/21/2011 8:21 AM
2 Replies and 2573 Views PO31.1 Vendor Return  2573  2 Started by  mikekask I'm trying to do an SQL extract of data related to the PO31 form and PO231 report. In particular, the Reason code. I'm not just talking about a list of Reason codes, but the data associated with this form; like Company, Return number, Vendor, Reason Code. I'm looking to isolate the records with a Reason code of 'WCR'. I need the table locations of this data. Any help would be greatly appreciated. Thank you.
2 2573
by  mikekaskJump to last post
05/12/2011 3:10 PM
3 Replies and 2576 Views Change Import GL journal Sequence Number  2576  3 Started by  AD Hello, How do I go about changing the sequence number of the next GL journal number used through GL165 process
3 2576
by  Ruma MalhotraJump to last post
05/06/2011 12:51 PM
4 Replies and 3961 Views Changing Activity Required field in (GL20.3) Using AddInns  3961  4 Started by  Saurabh Hi All, Apologies if this is not the right forum. I have around 150 accounts which i need to set the Activity flag to be Yes (in GL20.3) Trying to use the Addinns to make the change , the message after update says 'Window Changed - Update Form To Save' and the change does not seem to have been made Regards Saurabh
4 3961
by  SaurabhJump to last post
04/27/2011 3:44 PM
1 Replies and 1897 Views AM221 and AM270 Reports are out of Sync  1897  1 Started by  MicheleW It appears that in our last months AM work some transactions made it through to AM20.5 and were processed successfully. However, where ever the data is for the AM221 report these transactions are missing to AM221 and AM270 no longer balance. Does anyone know where the transactions come from for these reports, as it appears they are not the same. We're on 9.0.1.5.153 and using Portal as our interface. Thanks.
1 1897
by  Kevin HaganJump to last post
04/25/2011 9:46 AM
2 Replies and 1733 Views Blank Line  1733  2 Started by  TommyT How do I add some blank spaces between the last line of the format and the first detail line on an RW100 report
2 1733
by  Gail GudgelJump to last post
04/20/2011 12:24 PM
1 Replies and 1652 Views ARCUSTOMER.Search_Name Too Short...  1652  1 Started by  Garth Gerwing Customer name in AR appears to have a maximum length of 30 characters - of which, is a tad limiting (based on existing enterprise customer name usage/definition). Am I missing something - or - does anyone have any tips/techniques as to how to expand upon the size here I am assuming that: - Changing the attribute definition at the DB level - would cause a ripple-effect of possible form and reporting changes down the line (ideally - we want no customization that is required to be maintained)...
1 1652
by  AlJump to last post
04/19/2011 12:56 PM
1 Replies and 2186 Views L_HAPI.L_INDEX creation logic  2186  1 Started by  Travis HI, I work for an EPP solutions company and my client is using Lawson 8.3 database. I am working on an interface that stores invoice image URLs. They are linked using the L_INDEX column to our system. From my understanding, Lawson starts with the L_INDEX of ZZZZ and goes down alphabetically. My questions is, what would happen if an L_INDEXes existed that started with YZZZ - YAAA Would Lawson keep going down until it found an un-used index or would it replace the index that is alread...
1 2186
by  Angela CollinsJump to last post
04/15/2011 4:13 PM
4 Replies and 2246 Views Activity Budget/Date Edits  2246  4 Started by  tdosal For as long as i can remember we have used both date and budget edits for our activities within the other Lawson modules (PO, AP, GL). We have always struggled with these edits because our current business process requires us to contantly manually override these edits. If you are currently using the budget/date edits within Lawson AC, how do you maintain them, so that there is not so much manual intervention
4 2246
by  NickJump to last post
04/10/2011 12:58 PM
4 Replies and 2167 Views Financials Audit Reports  2167  4 Started by  Wade-T We have been looking over the audit reports for BN/HR/PA/PR to see who changed what and when, but have had trouble finding corresponding reports in the finance area. We are most interested in CB/AR/AM/GL. I saw some posts stating that the financial audits are not so good unless you are running Lawson Security and Portal. We are running the 9.0.0.9 environment, 9.0.0.5 apps, and have most of our users in LSF. Only 12-15 LID users remain (also the ones with widest access). What type of repo...
4 2167
by  Wade-TJump to last post
04/01/2011 7:38 AM
2 Replies and 3159 Views SQL Extract of vendor 1099 indicator and payment code  3159  2 Started by  mikekask Hi, I am writing an SQL extract program to get this information. I am trying to find on what table the vendor 1099 indicator is located. I was told the INCOME_CODE can be used for this but nothing there. I am also looking for the table where the Vendor Payment Code field (from the AP10.5 form) is located. Mike
2 3159
by  Vijay SJump to last post
03/22/2011 2:22 AM
9 Replies and 7025 Views Asset Management Module - General feedback  7025  9 Started by  Saurabh Hi All, I work in Not for profit Healthcare charity Organisation using Lawson S3. We are looking at using the Asset Management module. Was wondering if people had any feedback on the module and things to be aware of when implementing this module. Also any fedback on standard reports which come with the module Regards Saurabh
9 7025
by  Ruma MalhotraJump to last post
03/11/2011 2:29 PM
1 Replies and 1496 Views ARCUSTOMER integration  1496  1 Started by  Todd Mitchell I am wondering if anyone has developed a best practice for continuous integration with customer related information. We are integrating from another system that is and will continue to be the owner of the data. We need to interface with this data and using deltas (for both adds and changes) update Lawson. Right now we are developing a process to use ARICST and AR550 as an ongoing integration point. My main question is if anyone has developed a better ongoing process
1 1496
by  John HenleyJump to last post
03/08/2011 11:22 AM
4 Replies and 1946 Views Purging PRDISTRIB Records?  1946  4 Started by  Deleted User Can anyone tell me the ramifications of purging some past years prdistrib records Our file is getting enormous, and it's almost impossible to research anything at this point. Thanks for any input! Stephanie
4 1946
by  Deleted UserJump to last post
03/01/2011 4:22 AM
1 Replies and 1849 Views Report Writer - Multiple Levels  1849  1 Started by  Josh I need to build a report that captures activity for all levels of the following company ranges: Co 1200-1299 Co 1500-1599 Co 1600-1699 And level one = 100 and level two = 0-99 for company 1100. Does the question make sense Somewhat of a novice on report writer so any potential responses can be 'dumbed' down as much as possible. Thanks!
1 1849
by  mark.cookJump to last post
02/25/2011 1:53 PM
0 Replies and 1521 Views Cash Ledger deposits  1521  0 Started by  SK Has anyone tried to bring in credit card payments into the CB module as deposits How would the same transaction number be assigned to CB, credit card processor data, and get transferred to the bank Thx.
0 1521
02/21/2011 10:52 AM
6 Replies and 2346 Views Asset Management - old assets  2346  6 Started by  cynthia My company has implemented AM with new assets acquired beginning Sept. We uploaded 'old' assets in our test environment and ran the reports to verify the results with our GL balances. When the conversion files were uploaded we called the book OLDCAPS. We indicated it as Non-Posting because the assets were already recorded in GL as fixed assets, as well as their corresponding depreciation exp and accumulated depreciation. These conversion files covered all assets prior to Sept 2010. My questi...
6 2346
by  cynthiaJump to last post
02/15/2011 1:48 PM
0 Replies and 1685 Views Lawson and DSS  1685  0 Started by  JonA Our current DSS uses the CDM to analyze supply cost data. But we in Materials are a little wary of this because we have no interface between Lawson Procurement and the CDM. So how does finance get accurate supply cost data Is anyone out there interfacing Lawson to a DSS Our vision for a DSS would give us the ability to slice and dice data down to the cost per procedure (DRG), per physician, per vendor, per implant, etc.
0 1685
02/10/2011 3:26 PM
1 Replies and 1527 Views AC 130 goes into recovery  1527  1 Started by  Kishan hi guys I ran AC130 for allocation group the other day and it went into recovery with message 'storeDBRec error is Record not locked (8)' ALLOC-NAME = XXXXXX I ran AC130 again today it completed successfully. I cant even debug as AC130 is not going into recovery. Lawson 8.0.3 Any idea why such unpredictable behaviour
1 1527
by  mark.cookJump to last post
02/08/2011 7:33 AM
2 Replies and 1407 Views Vendor Master Management re: Insurance Carriers  1407  2 Started by  Sheila My organization recently started accepting payments from Medicare and other third-party insurance companies. Our current policies and procedures for maintaining the vendor master files require us to obtain a W-9 from the vendor in order to properly identify them using their Federal TIN. We also verify that the vendor is not on any excluded/debarred lists from participation in federal health care programs. In the case of insurance companies, we don't pay them for goods or services, but ...
2 1407
by  SheilaJump to last post
02/07/2011 12:29 PM
0 Replies and 1444 Views AC10 error when trying to delete; Old Lawson version  1444  0 Started by  jbertoli First I am on an old Lawson version - 7.2.4. I have used the Activity move process (AC11, AC110, AC10.5, AC120) to move activities from one group to another in order to clean up some keystroke error when a level was originally set up. Now when I try to delete the dummy level 2 activity I create for the interim move, the AC10 screen gives me the message 'Cannot delete; subordinates exist in pending changes'. Where are these pending changes Joanne
0 1444
02/04/2011 11:41 AM
0 Replies and 1798 Views Multi-Ledger  1798  0 Started by  Bill Hi all- I work for a County government which uses Lawson Multi-Ledger to map multi-companies with different fiscal year end dates to the same December year end for financial reporting. Since we upgraded a year ago to 9.0 we have had to work around problems which we have encountered. Now we are experiencing a mission critical problem. General ledger balances (of a new company added throughout 2010) are NOT pulling through to the Multi-Ledger. The company has been added, mapped to our Multi-le...
0 1798
02/03/2011 9:45 AM
0 Replies and 1504 Views APINVOICE-AUTH-CODE or User for AP Invoice Release?  1504  0 Started by  Gary Is there a way to pull what user Released an AP Invoice The APINVOICE-AUTH-CODE captures who entered an invoice. I also need who Released the AP Invoice.
0 1504
01/27/2011 10:38 AM
5 Replies and 2401 Views AP Year End Issues  2401  5 Started by  mark.cook In case you guys have not run into this yet, the AP year end patches have caused two issues we have found so far that I want to make sure you know about. There are at least 2 patches out after the year end updates came out to fix issues. AP10 Tax ID field gets blanked out on Add/Change (CTP 75438 to correct) IC141 is bringing over the requisition without an account number (JT198761 /CTP 75784 available yesterday on website)
5 2401
by  Sherry S.Jump to last post
01/26/2011 4:26 PM
4 Replies and 2668 Views Need to Post entry or Adjust Year End balance (HELP!)  2668  4 Started by  jjcyeshua Hi All, I'm hoping that a guru in here will be able to give me an insight on how to fix our problem.... recently we closed our Fiscal Year 2009. (so now, GL10 shows Current year as 2011, Last Year 2010). but after reviewing our Statements, it showed that there was a incorrect posting that's affecting our FY09 ending balance. Is there a way to fix this I read the Financial Conversion Guide, but realized that running GL65 is not possible because our calendar year is not open for Fiscal y...
4 2668
by  D_HumpJump to last post
01/26/2011 8:56 AM
2 Replies and 1428 Views Null file name  1428  2 Started by  Kishan I am getting an error 'Null file name used in a file operation'. Pls let me know why such an error is arising...
2 1428
by  KishanJump to last post
01/13/2011 7:19 AM
3 Replies and 1597 Views Attaching specific account categories to an activity  1597  3 Started by  Saurabh This is on MSP8.1 (SQL backend). We have recently started to use activity management for tracking our refurbishment projects. To enable us to do this tracking we have have created a number of account categories. Would like to know if there is a way wherein i can restrict certain accnt categories to an activity. e.g Posting Activity - CONSTRUCTION I have number of categories e.g MRKTNG,CLNG,ARCHI,PKG1,PKG2,PKG3 What i would like to do is to set a link between CONSTRUCTION and PKG1,PKG2...
3 1597
by  jbertoliJump to last post
12/22/2010 5:08 PM
2 Replies and 3537 Views AP161 Remittance File Format  3537  2 Started by  Stewart Bond We are trying to identify the proper specs for the AP161ELECTREM file generated by AP161. The specs in the Lawson documentation do not match the format we see in the data file that is generated. If anyone has the proper specifications, please forward them. Thank you.
2 3537
by  jbertoliJump to last post
12/22/2010 5:03 PM
1 Replies and 1370 Views MAINDTL on Header Level Match  1370  1 Started by  Randall Hi all, We're trying to investigate whether or not when an invoice matches at the header level, if the values in MAINVDTL populate with the PO Line information. We've entered in several invoices without line detail and matched within tolerance. When drilling on the invoice, you see invoice line detail. It appears to all be the PO line information, but needed to verify. Also, I would assume, that the MAINVDTL populates with the invoice detail when there is a detail level match We'r...
1 1370
by  RobinLuceJump to last post
12/20/2010 4:45 PM
1 Replies and 1710 Views Invoice Discount Amounts  1710  1 Started by  Randall Hi all, I'll be the first to admin I have a little bit of functional knowledge in the financial arena, but by no means an expert. I have a question that I haven't been able to track down the resolution. We're undertaking an initiative to take the correct discounts on our invoices based on certain scenarios. After the calculation, we're attempting to change the amount of the discount on the AP22.3 screen (from the discount button on the main tab of AP20). After this is done and the inv...
1 1710
by  RandallJump to last post
12/07/2010 4:19 PM
3 Replies and 1714 Views GL291 Trial Balances Recreation with SQL  1714  3 Started by  Deleted User We are running GL291 with just Individual Reporting set to Company. Type set to 'A' and Report Sequence set to Level... Has anyone recreated this report with SQL If so I would be interested in seeing it. Thanks.
3 1714
by  DeronJump to last post
11/23/2010 2:40 PM
3 Replies and 1735 Views Relationships between ACTRANS AND MAPOINV or PURCHORDER  1735  3 Started by  Deleted User I'm trying to get a PO_NUMBER or INVOICE from ACTRANS. What's the key relation between ACTRANS and ( MAPOINV or PURCHORDER ) And also what's the REFERENCE in ACTRANS I thought it is PO_NUMBER or INVOICE when the transaction is 'AP'.
3 1735
by  Vijay SJump to last post
11/06/2010 10:28 AM
3 Replies and 2504 Views Project And Activity Accounting  2504  3 Started by  Nadyne Does anyone use project and activity accounting to track their funds activities
3 2504
by  NadyneJump to last post
11/02/2010 9:25 AM
0 Replies and 1342 Views Lawson C routines  1342  0 Started by  Kishan Can anyone tell me where I can find the 'C' rountines in Lawson sytem
0 1342
10/22/2010 5:42 AM
8 Replies and 2091 Views Report giving details of Actual and Commitments for an Activity  2091  8 Started by  Saurabh Hi All This is on LSF9.0.0.4, 8.1 MSP5. I am looking for a report which gives breakdown of 'Actual' and 'Commitment' for an Activity Group/Activity. I am able to get details of Commitments via AC298 but can't seem to find anything for Actuals. Any ideas Regards Saurabh
8 2091
by  SaurabhJump to last post
10/20/2010 4:36 PM
1 Replies and 1308 Views US Deposits in foreign country  1308  1 Started by  Greg Wiklund We have operations in a foreign country and have a bank account where we are storing USD. When I run my RW100's to consolidate, I want that dollar amount to appear; not a converted amount. Any time I want that money back, $20,000, I will get the $20,000 back, not a converted amount, so it should be on my books as $20,000, regardless of the base currency in that other country/company. Does anyone else conduct their operations this way
1 1308
by  Greg WiklundJump to last post
10/14/2010 2:31 PM
9 Replies and 2266 Views INTERFACING INVOICES AND PAYMENTS FROM A 3RD PARTY SYSTEM  2266  9 Started by  Barry Ghotra I have a situation where I need to electronically bring invoices from another system or a 3rd party provider that handles reimbursement expenses. Some times these payments need to be processed from Lawson but in certain cases the payment might have been posted as a direct deposit by the 3rd party provider. I understand that I can load the data into APCINVOIC APCDISTRIB and then run the AP520 to populate the application tables etc. But what about the pre-paid invoices. I also noticed the CVI-R...
9 2266
by  Ruma MalhotraJump to last post
10/13/2010 3:26 PM
6 Replies and 2327 Views 3rd party Order-to-Pay To Lawson Interface  2327  6 Started by  RajR Is there a way where we can interface our 3rd part software Order-to-Pay system and interface it to Lawson for Electronic payment The idea is to pay electronically using our Order-to-Pay system and send over the transaction to Lawson AP for record purposes Also I should be able to send info of Discount Codes from the Order-to-Pay system to Lawson. There won't be any transaction happening in Lawson, but I should be able to pull up the info in Lawson, if I have to see what electronic payme...
6 2327
by  Barry GhotraJump to last post
10/13/2010 9:52 AM
0 Replies and 2006 Views Wire Payments through Lawson  2006  0 Started by  Eddie Smith Our Treasury department does a lot of wire payments through their banks, both domestically and internationally (USD as well as other currencies)and then give us the information and we enter thme into Lawson as manual 'MAN' AP payments. We would like to have Lawson create the wire payments and eliminate the double keying that exists today. If anyone is doing wires via Lawson we would appreciate any help on how to set this process up in Lawson.
0 2006
09/29/2010 12:04 PM
2 Replies and 1580 Views Associate an Employee with APDISTRIB table?  1580  2 Started by  Bidur I am trying to figure out how to relate an Employee with APDISTRIB Table or AP Transactions. Any input will be appreciated! Thanks.
2 1580
by  Ruma MalhotraJump to last post
09/29/2010 10:10 AM
0 Replies and 1251 Views Getting Details of Commitments and Actual  1251  0 Started by  Saurabh Hi This is on LSF 9.0.0.4, Apps 8.1 MSP5 When running the AC295 (Activity Summary) it shows both the Committed and Actual Separately. However the AC298 (Commitment details) only seem to be showing details for Commitment, no information for Actuals. Am i missing something or is there another report which will show both (incl Actual amnt entered directly in AC modules) Regards Saurabh
0 1251
09/23/2010 5:16 PM
4 Replies and 2413 Views move accounting units between zones  2413  4 Started by  chaprob Our finance department has decided to restructure so that a group - but not all - of accounting units that currently exist in one facility (Company 100 - Corp 001) are moved to another (Company 100 - Corp 002). Looking for ideas on how best to move accounting units (GL20) but leave history intact in the old facility. AR and HR need the accounting units to stay the same on both corps, however Lawson support says all of the accounting unit's history moves when the acctg unit is moved. Our admin...
4 2413
by  chaprobJump to last post
09/22/2010 11:08 AM
3 Replies and 1692 Views Migrating accounts payable from LID to Portal in 9.0 release  1692  3 Started by  Deleted User We are currently testing portal for a/p. Are there any major teaching hospitals currently using portal for accounts payable, that can share their experience with that conversion with us. We have several major concerns, including substantial increased a/p processing time
3 1692
by  JillFJump to last post
09/20/2010 3:19 PM
1 Replies and 2290 Views AP300 Vendor Purge  2290  1 Started by  Deleted User Can anyone tell me the pro's & con's of running this job.
1 2290
by  DebEJump to last post
09/17/2010 5:21 PM
1 Replies and 2269 Views Currency Exchange Rate Provider  2269  1 Started by  BrianP Can anyone suggest an exchange rate service provider We are researching muli-currency for 9.0.0x and would like to incorporate an exchange rate interface. Does anyone have experience with services provided by OANDA
1 2269
by  John HenleyJump to last post
09/16/2010 4:16 PM
1 Replies and 1575 Views AC41.4 Resource Time Entry Upload  1575  1 Started by  MEllis We are trying to create an ac41.4 upload template. Each time we run the upload the GL Offset accounting unit changes to something other than what we are specifying. What could cause this
1 1575
by  BobCJump to last post
09/15/2010 4:10 PM
0 Replies and 1346 Views Vertex 3.3 and LSF 901 Technology  1346  0 Started by  Deleted User I've recently done an upgrade of our Vertex software and database files from version 2 to version 3.3. We are required to do this upgrade before the end of the year. The database files are still in the version 3.1 ISAM format. When I tried to use TX40 after the migration of the database files, I got the following error message: 'Quantum Err: Open failed.' How can I fix this
0 1346
09/07/2010 4:49 PM
1 Replies and 2665 Views Activity Commitment Detail Report link to PO Line Detail  2665  1 Started by  Carl Gifford I am trying to write an AC Committment Detail report in Crystal (using SQL) and would like to be able to reference the specific PO Line (POLINE) record. Is this possible. I am using the ACCOMMITX table and can find the PO from this table, but I cannot seem to find a link to the specific PO Line. Is this possible Thanks,
1 2665
by  Eddie SmithJump to last post
08/24/2010 7:04 AM
1 Replies and 1595 Views Auto load GL22.2  1595  1 Started by  Matthew Nye What is the best way to go about loading large amounts of rows for a manual account list Thanks, Matt
1 1595
by  Brad SchauerJump to last post
08/13/2010 3:05 PM
0 Replies and 2070 Views Double entry for Credit memos in AR  2070  0 Started by  Deleted User Hello colleagues, I would like to get some details on what GL account codes are hit when a credit memo is created in AR42 and it is applied to an open invoice.I ask this because there is a client who raised credit memos in AR42 and then applied these to open invoices and therafter these memos were released and was followed up by Application closing and distribution closing but there was no effect on 12001 account in GL even if GL190 was also run.The double entry seemed to have not taken place...
0 2070
08/09/2010 1:32 PM
13 Replies and 13407 Views Accounts Payable Aging Report  13407  13 Started by  Katfra Hello, First of all, is there a report in Lawson that i could run that shows me an AP Aging Currently I use AP136 to show me what my AP for the month is. Secondly, I'm attempting to create an aging report in Crytal since i wasn't sure if Lawson had one but having trouble with what table to use to pull the amount that shows up in my AP136. I'm currently using APDISTRIB as well as APINVOICE. Can anyone assist me in this Thanks, Frank
13 13407
by  KatfraJump to last post
08/09/2010 1:02 PM
6 Replies and 1850 Views AC410 in Crystal Reports  1850  6 Started by  ErikaS Good Morning, My organization is new to Lawson (implementing) and I'm wondering if anyone has been able to recreate the AC410 report using Crystal Reports (not through LBI). Thanks, Erika
6 1850
by  Kevin HaganJump to last post
08/05/2010 12:10 PM
3 Replies and 3288 Views AP: Number of Check Runs  3288  3 Started by  Deleted User Is there a way to find out how many check runs, or in Lawson terms how many times AP150, AP155, or AP170 has been run for a given time frame I can build a report if needed, but I don't know if there is a table that houses that info.
3 3288
by  SeanJump to last post
08/03/2010 6:47 PM
1 Replies and 1341 Views Commitments transferred from non-Lawson system  1341  1 Started by  Margaret Has anyone had any experience with commitments and how to handle at go live We currently use an encumbrance system and are trying to determine how to treat open POs in our old system at go live and whether we should convert the POs to Lawson and pay from Lawson or somehow continue to use the current(old) system and either use reports out of both systems and pay out the open POs in the old system or what We are implementing GL, AP, PO, AC, HR/PR, CB, AM, LM...I think that's it...and go l...
1 1341
by  Ruma MalhotraJump to last post
08/03/2010 6:00 PM
0 Replies and 3164 Views Manual controls around ACH/EFT payments in Lawson AP  3164  0 Started by  Deleted User We are beginning to implement electronic payments out of Lawson AP, but would like some guidance around setting up manual controls. What do others do to ensure the right vendors are being paid the proper amounts when paying electronically
0 3164
08/02/2010 12:33 PM
0 Replies and 1285 Views Renumber Account Utility?  1285  0 Started by  Jeff N Are there any utilities that allow you to renumber a Lawson account so the account detail is available in the new account I need to move some investment accounts to a different part of the balance sheet and would like the history to go with them. I used to work with MAS200 and there was a utility to do this. Thanks Jeff
0 1285
07/20/2010 10:23 AM
7 Replies and 3377 Views APDISTRIB Entry/Create Date?  3377  7 Started by  Gary I'm trying to report AP transactions by the date they were actually entered. I'm not finding that date anywhere. There's an APINVOICE create date - not the same thing. There's a GLTRANS R_DATE which does not appear to be the correct thing and isn't useful for this report as it is not created until the transaction is posted. I figured it would be in the APAPDHIST file but I'm not finding it anywhere. If nothing else, isn't there a transaction history file somewhere that would have it THANK...
7 3377
by  GaryJump to last post
07/20/2010 7:39 AM
6 Replies and 1617 Views RW Row files  1617  6 Started by  Matthew Nye Im creating a row file in RW10.4. It seems the description is limited to 30 characters. Is there any other display options for row description that would allow for more characters Thanks, Matt
6 1617
by  Ruma MalhotraJump to last post
07/16/2010 4:58 PM
1 Replies and 1770 Views Moving Lawson databse from DB2 z/OS to DB2 AIX  1770  1 Started by  nicks New to the Lawson world and am trying to find documentaiton on the steps necessary and utilities provided to move the underlying Lawson Financials database from DB2 z/OS to DB2 on AIX. I understand there are databse definition and data movement utilities provided but am looking for a source of information that maps out the high level steps necessary. The DB2 AIX software installation/configuration is done already.
1 1770
by  Vijay SJump to last post
07/14/2010 8:33 AM
3 Replies and 1543 Views Sharing Posting Activities within an Activity Group  1543  3 Started by  Saurabh Hi All This is on 8.1 0 MSP5 on LSF9.0.0.4 We have just recently started using the Activity module. The initial setup had been very simple and works fine. We would now like to track certain complex projects (like Major Refurbishment projects etc). When trying to setup the various Activities I find that I am not able to use Activities across the summary level.(see attached document for an example setup we would like to be done.) e.g We are having to dup...
3 1543
by  Ruma MalhotraJump to last post
07/12/2010 3:04 PM
1 Replies and 2271 Views How do I make a partial payment on an AP invoice?  2271  1 Started by  AD Hello, What steps do I have to take to process a partial payment on an AP invoice
1 2271
by  John HenleyJump to last post
07/12/2010 8:29 AM
1 Replies and 2166 Views Upload Wizard Login Server Name  2166  1 Started by  Jodi Hi, Some users of the Lawson Upload Wizard have to keep typing the server name in the login box where others have the server name in their drop down box. I can't figure out how to change it so everyone has the server name in the login box. Does anyone have any ideas Thanks, Jodi
1 2166
by  SaurabhJump to last post
07/09/2010 6:58 AM
0 Replies and 1176 Views Daily Exchange Rate vs Single Monthly Exchange Rate  1176  0 Started by  Melissa McGuire Does anyone have any dealings with these Any pros or cons you can share
0 1176
07/07/2010 10:37 AM
2 Replies and 2270 Views Lawson 8.03 in 9.01 environment  2270  2 Started by  Deleted User I have the financial application in lawson 8.03 that we use as historical. Few users still go there to check on the history, However we upgraded to 9.01 env last month and now I need to think about that application and copy the product line over to our new environment. Does anybody knows if I am going to encounter any problems in the new environment. I do not want to convert all of the programs to the new lawson App version 9.01. Any comment will be appreciated.
2 2270
by  Deleted UserJump to last post
07/02/2010 8:31 AM
7 Replies and 2272 Views Index which table??????????  2272  7 Started by  Vijay S I have only acess to LID(No portal access, no query wizard access and no database access). I want to know that which index belongs to which table!!!!!!!!!!! I mean to say is there any trick (or utility) to know which index belongs to which table:
7 2272
by  Vijay SJump to last post
07/01/2010 11:31 AM
2 Replies and 1607 Views Terms Code Description  1607  2 Started by  Deleted User What table can I find the terms code description. I am building a MSaddins query and can include the terms code but it is a meaningless number with out the definition. Can someone tell me what table I might find the terms code definition Thanks.
2 1607
by  Deleted UserJump to last post
07/01/2010 11:17 AM
3 Replies and 1493 Views Transferring Activity commitment  1493  3 Started by  Saurabh Hi All This is for Apps 8.1 0 MSP5. We currently use the AC module to track some of our IT projects. Unfortunately I had to create a Purchase order (via requisition) using a dummy activity code. The PO has just been released and issued (not received or matched) Now that i have setup the correct activity i have gone into PO20 and changed the Activity and Account Group to be the correct value. Reissued and Released the PO and was expecting the commitment to now show up againt this new Activity....
3 1493
by  Ruma MalhotraJump to last post
07/01/2010 10:30 AM
3 Replies and 1789 Views Adding new levels to AU Hierarchy  1789  3 Started by  Deron We currently have 3 levels defined for our accounting units: Line of Bus - 3 Department - 3 Cost Center - 4 leaving 2 unused levels. Our reporting requirements are changing and the current hierarchy does not give us the level of detail we need. Is it possible to expand our hierarchy to include the 2 unused levels, making my hierarchy look like this: Line of Bus - 3 Department - 3 New Hierarchy 1 - 4 New Hierarchy 2 - 4 Cost Center - 4 Thanks for any ...
3 1789
by  Ruma MalhotraJump to last post
07/01/2010 8:01 AM
1 Replies and 2709 Views Round cost allocation to allocate all costs  2709  1 Started by  Sherry Shimek A user allocates benefits costs from the Benefits Accounting unit to the department accounting units using Cost Allocation. Is there a way to round the amounts so the Benefits Accounting Unit is reduced to zero automatically for each account instead of leaving a few pennies presumably due to rounding
1 2709
by  Gail GudgelJump to last post
06/28/2010 3:30 PM
4 Replies and 7677 Views Lawson Portal Screens  7677  4 Started by  PZ I know you can use 'Ctrl-Shift-O' to view the name of the corresponding field from a screen in Lawson Portal. Is there a way to identify the name of the table as well
4 7677
by  mark.cookJump to last post
06/23/2010 6:43 AM
4 Replies and 2443 Views Vendors with no activity  2443  4 Started by  jacobske We are trying to clean up our vendor master, In doing so we want to find vendors with no activity. I see there is no canned Lawson report for this - but in trying to create in crystal, we are a multi company facility - and using the APVENBAL table isnt proving to be that easy to use b/c it shows Last Payment date. I am sure there is a way to do this - but I am not a crystal expert by any means - so if anyone has done something similar to this, any information is greatly appreciated!
4 2443
by  Eddie SmithJump to last post
06/16/2010 2:18 PM
2 Replies and 1772 Views IC11  1772  2 Started by  ARaja IC11 takes longer time to respond, when delete action is performed. In 8.0.2 Applications, it is faster, But in 9.0.1 Application,it takes more time to process(nearly 15 minutes).
2 1772
by  ARajaJump to last post
06/16/2010 12:00 AM
2 Replies and 1578 Views ERDs  1578  2 Started by  Jeff Have been trying to access the ERDs on this site for two days now with no response. Are others having a similar issue Jeff
2 1578
by  John HenleyJump to last post
06/15/2010 9:59 AM
1 Replies and 7717 Views Identifying a 3 way match PO/Invoice/Receipt with SQL  7717  1 Started by  mikekask I am trying to extract by SQL a count of the total PO lines of PO's that have a 3 way match of PO/Invoice/Receipt. I am using this total as the denominator to calculate the percentage of electronically processed PO's versus non-electronically processed PO's that could potentially be electronically processed. I've been told that to be electronically processed there has to be a three way match. For my numerator of the electronically processed PO's I am matching the POLINE table with the APINVOICE...
1 7717
by  Ruma MalhotraJump to last post
06/11/2010 11:21 AM
4 Replies and 3166 Views Location of GL Distribution fields for PO20.1 form  3166  4 Started by  mikekask Hi, I am trying to access the PO20.1 form GL distribution fields (for GL posting) with an SQL query and I haven't been able to find out where these fields are located. I looked at the POLINE table definition and didn't see anything. Does anyone know where these fields are These are the fields at the bottom of the PO20.1 form for the tab that says 'Line Detail'. I am particularly looking for the fields under the 'Account' label which are Accounting Unit, Account, and Sub Account and also th...
4 3166
by  DennisMJump to last post
06/01/2010 11:45 AM
2 Replies and 1303 Views Duplicate Record Error  1303  2 Started by  Boyd We just upgraded from 9.0.0 to 9.0.1. Many of our users are receiving duplicate record errors. So far, we have experienced this in GL, AR and AM. The user gets the message when they are trying to add an entry with multiple lines of coding.
2 1303
by  BoydJump to last post
05/26/2010 4:06 PM
0 Replies and 1824 Views Invoice Approval Routing  1824  0 Started by  Tricia Can anyone help me with invoice routing for invoices with multiple distribution lines that have different AUs. The invoices are routing by total invoice amount and the AU. Right now its routing by the first AU in line on AP20, regardless of how many AUs are listed. I tried using AP52 to interface these in an unreleased status so we can use a suffix for each line, so they route separatly. But, it isn't possible to interface an unreleased invoice on AP52 with a suffix and the flow is triggered ...
0 1824
05/24/2010 9:26 AM
2 Replies and 1605 Views Table and Field Location of Purchase Order Comments  1605  2 Started by  mikekask Hello, I am trying to find out the field name and table name for the Purchase Order comments field. Thanks. Mike
2 1605
by  mikekaskJump to last post
05/24/2010 8:49 AM
4 Replies and 1701 Views BR120  1701  4 Started by  Deleted User Hi, I am a brend new user of S3 and I run BR120 for 0 (unreleased) status instead of processed (3) in update run. So I generated a physical invoice but the invoice is in the system as 'unreleased', so AR can't see it. In the trx BR20.5 there is an option to release it, but I am not sure if it won't create any bug. I was trying this in the testing environment, but it didn't work, I've got an error message. Could you please help me Thanks many times.
4 1701
by  Brad SchauerJump to last post
05/20/2010 6:41 AM
10 Replies and 2784 Views Lawson PO and AR screens freezing up  2784  10 Started by  Johnbaby We've been having mutiple users' screens freeze up in both AR and PO. They have to log off and back in to continue. I've reproduced the problem myself. For example PO20, PO30, RQ10, AR20, AR30... hangs up in po30.1 while receiving; hangs up whenever changing screens; when trying to release receiver; also happens when paging up & down. hangs up at different stages, not always the same places. Please help - the users have been having a terrible time. John
10 2784
by  JohnbabyJump to last post
05/18/2010 5:47 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 3 of 5 << < 12345 > >>


RSS Feed Available