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 5 of 9 << < 34567 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 1153 Views Actual and Budgeted Salary Dollars Report broken down by Job Class  1153  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 1153
10/04/2012 9:55 AM
0 Replies and 1386 Views CA10 Allocations Upload  1386  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 1386
10/01/2012 5:44 PM
1 Replies and 1183 Views Invoice detail upload  1183  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 1183
by  MichelleJump to last post
09/27/2012 11:26 AM
13 Replies and 10859 Views AP - Wells Fargo Payment Manager Service  10859  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 10859
by  blongJump to last post
09/27/2012 7:48 AM
0 Replies and 977 Views Library routine  977  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 977
09/25/2012 3:02 PM
6 Replies and 1620 Views ERDs for Newest Version  1620  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 1620
by  ErinJump to last post
09/21/2012 3:14 PM
2 Replies and 2200 Views Inbound EDI 810's and multiple vendor locations  2200  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 2200
by  BrentJump to last post
09/20/2012 10:56 AM
2 Replies and 1742 Views Return number of days  1742  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 1742
by  TracyOJump to last post
09/19/2012 1:17 PM
6 Replies and 1646 Views ACTRANS has OBJ-ID = 0  1646  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 1646
by  LisaJump to last post
08/31/2012 4:15 PM
0 Replies and 2554 Views Lawson training or navigational guides  2554  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 2554
08/31/2012 10:22 AM
2 Replies and 1481 Views ARITRANS  1481  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 1481
by  DougABJump to last post
08/27/2012 4:25 PM
5 Replies and 4825 Views PO64.1 PO Line Item History Report?  4825  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 4825
by  Dave McGownJump to last post
08/03/2012 10:24 AM
3 Replies and 2252 Views Suggestions for check printing solutions?  2252  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 2252
by  DougABJump to last post
07/31/2012 3:58 PM
0 Replies and 1654 Views 457 Plan - Company Match  1654  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 1654
07/26/2012 5:22 PM
0 Replies and 1116 Views Comments not attached to invoices  1116  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 1116
07/17/2012 11:59 AM
11 Replies and 2563 Views GHX and email copies of 810's  2563  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 2563
by  Greg MoellerJump to last post
07/17/2012 9:13 AM
0 Replies and 1569 Views Security On GL298  1569  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 1569
07/02/2012 4:27 PM
1 Replies and 1559 Views AC07 criteria include/exclude au's  1559  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 1559
by  JeremyJump to last post
07/02/2012 6:55 AM
1 Replies and 1475 Views Merging many vendors  1475  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 1475
by  Ragu RaghavanJump to last post
06/28/2012 3:11 PM
5 Replies and 1997 Views Fax Integrator 9..0.1.1 install time frame  1997  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 1997
by  cindy MHSILJump to last post
06/25/2012 12:30 PM
0 Replies and 1154 Views How do i get a Payment proposal into Lawson  1154  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 1154
06/20/2012 11:18 AM
6 Replies and 2359 Views CA10 Add Ins  2359  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 2359
by  SherryBJump to last post
06/13/2012 1:40 PM
0 Replies and 2067 Views Check Printing/Formatting Solutions  2067  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 2067
06/11/2012 2:59 PM
1 Replies and 1549 Views AM223 to CSV  1549  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 1549
by  JonAJump to last post
06/07/2012 2:22 PM
4 Replies and 2071 Views Determine AR Customer Balance - As At Point-In-Time  2071  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 2071
by  Garth GerwingJump to last post
06/06/2012 2:27 PM
2 Replies and 2225 Views How to Cancel on MA40/MA40.5  2225  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 2225
by  jbertoliJump to last post
05/24/2012 4:32 PM
0 Replies and 1128 Views mobile inbasket - issue with custom form  1128  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 1128
05/09/2012 9:30 AM
5 Replies and 2926 Views Chart of Acct query  2926  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 2926
by  amynelsonJump to last post
05/07/2012 10:50 AM
1 Replies and 1561 Views Adding field to AM260 Report  1561  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 1561
by  Ruma MalhotraJump to last post
05/03/2012 11:53 AM
0 Replies and 1640 Views PD10.3 upload?  1640  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 1640
05/03/2012 8:14 AM
7 Replies and 2792 Views Need to create a consolidating company in Lawson 9.0 but I have no idea how to start  2792  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 2792
by  TeresaEJump to last post
04/27/2012 1:51 PM
0 Replies and 1392 Views Alternative for 'delement'  1392  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 1392
04/26/2012 11:39 AM
2 Replies and 4078 Views Invoice Distribution from AP Payment  4078  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 4078
by  G. MonaghanJump to last post
04/25/2012 2:05 PM
1 Replies and 2619 Views AR Bank Reconciliation - How To Organize?  2619  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 2619
by  jjcyeshuaJump to last post
04/24/2012 6:23 PM
0 Replies and 1369 Views AP20 Vendor select security  1369  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 1369
04/23/2012 2:09 PM
0 Replies and 2149 Views CB55.1 Payment  2149  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 2149
04/20/2012 11:38 AM
5 Replies and 8623 Views WHAT IS NEW LAWSON 9.0.1 FINACE APPLICATIONS  8623  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 8623
by  jjcyeshuaJump to last post
04/18/2012 4:59 PM
3 Replies and 2717 Views Retail Calendar and 13th Period  2717  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 2717
by  AdamJump to last post
04/05/2012 12:36 PM
1 Replies and 1476 Views secure invoice number interface from payroll  1476  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 1476
by  Jimmy ChiuJump to last post
04/03/2012 2:27 PM
0 Replies and 1452 Views ACBR billing  1452  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 1452
03/28/2012 10:54 AM
0 Replies and 1029 Views turning on remoteglt  1029  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 1029
03/28/2012 5:02 AM
0 Replies and 1444 Views Void PD Invoice  1444  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 1444
03/26/2012 5:19 PM
0 Replies and 1592 Views AR Lockbox  1592  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 1592
03/22/2012 10:15 AM
3 Replies and 1656 Views LP Custom calculation routine  1656  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 1656
by  ChescaJump to last post
03/12/2012 1:22 PM
0 Replies and 1347 Views DB inquiry processing  1347  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 1347
03/12/2012 9:35 AM
0 Replies and 1168 Views Crystal-Units issue at the AU level  1168  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 1168
03/08/2012 7:35 PM
1 Replies and 3429 Views PP&E rollforward  3429  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 3429
by  mark.cookJump to last post
03/07/2012 7:01 AM
3 Replies and 2662 Views Check reissue report?  2662  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 2662
by  StephanieLJump to last post
02/22/2012 12:16 PM
2 Replies and 1647 Views AP Productivity Query  1647  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 1647
by  Robert SpurrJump to last post
02/17/2012 1:28 PM
0 Replies and 1870 Views Question about Sub Accounts  1870  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 1870
02/17/2012 10:32 AM
1 Replies and 1419 Views What Table are CB Comment stored in  1419  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 1419
by  John HenleyJump to last post
02/16/2012 2:37 PM
6 Replies and 2916 Views AP20 Comments  2916  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 2916
by  Bob CanhamJump to last post
02/10/2012 10:03 AM
2 Replies and 5417 Views GL40.1 Upload Template  5417  2 Started by  RAKESH DESAI How can I build template to upload journal entry (40.1)from Excel.
2 5417
by  dcaianiJump to last post
02/09/2012 9:09 AM
0 Replies and 1519 Views Reverse PO Entry  1519  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 1519
02/03/2012 3:15 PM
0 Replies and 1502 Views Wire Payment entry  1502  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 1502
02/03/2012 2:54 PM
0 Replies and 2037 Views HELP - PO Matching/Pre-Paid Invoice  2037  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 2037
02/03/2012 10:14 AM
6 Replies and 3263 Views Cost Center Level  3263  6 Started by  RAKESH DESAI How Can I change or add cost center level in GL20 I need to add cost center level.
6 3263
by  RAKESH DESAIJump to last post
02/01/2012 11:32 AM
2 Replies and 1927 Views Invoices for void check  1927  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 1927
by  LudyJump to last post
01/30/2012 7:51 AM
0 Replies and 2030 Views Add in for GL20 and AP AM set up programs  2030  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 2030
01/26/2012 11:04 AM
4 Replies and 3385 Views Invoice Dist Out of Balance Error AP520  3385  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 3385
by  Deleted UserJump to last post
01/26/2012 4:24 AM
0 Replies and 1254 Views AR converted transactions  1254  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 1254
01/24/2012 12:46 PM
1 Replies and 3034 Views Freight and MA540  3034  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 3034
by  Robert SpurrJump to last post
01/19/2012 1:44 PM
2 Replies and 2738 Views Query or Crystal report for AP136  2738  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 2738
by  JCardilloJump to last post
01/11/2012 12:14 PM
1 Replies and 2478 Views Asset Transfer Upload  2478  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 2478
by  John HenleyJump to last post
01/09/2012 2:20 PM
1 Replies and 2506 Views lawappinstall failure when installing any CTP in any mode  2506  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 2506
by  troelofsJump to last post
01/06/2012 3:31 PM
3 Replies and 2198 Views Backposting entry  2198  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 2198
by  Ruma MalhotraJump to last post
01/05/2012 1:44 PM
0 Replies and 1095 Views Internal Services Cost Transfers  1095  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 1095
01/05/2012 12:43 PM
0 Replies and 1180 Views Moving RW100 from 8.03 to 9.01  1180  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 1180
01/04/2012 4:05 PM
1 Replies and 2391 Views Help on how to create cash flow statement  2391  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 2391
by  johnJump to last post
01/04/2012 12:43 PM
0 Replies and 1732 Views MSP 7  1732  0 Started by  Mark Larochelle Is/has anyone applied the MSP 7 patch
0 1732
01/04/2012 9:14 AM
0 Replies and 1516 Views CB186 error report  1516  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 1516
12/28/2011 2:25 PM
1 Replies and 3547 Views 1099 Validation report  3547  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 3547
by  Greg MoellerJump to last post
12/13/2011 3:47 PM
0 Replies and 1549 Views AR - Support Both Pre-Authorized Debit & Credit?  1549  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 1549
12/08/2011 4:02 PM
2 Replies and 1980 Views GL221 export to csv  1980  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 1980
by  Tammy GuidryJump to last post
12/05/2011 11:29 AM
2 Replies and 2182 Views .cfg files  2182  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 2182
by  johneJump to last post
12/01/2011 1:59 PM
0 Replies and 1309 Views Reinstate check batch  1309  0 Started by  Boyd Does anyone know if there is a way to reinstate an electronic payment batch that was voided in error
0 1309
12/01/2011 8:52 AM
2 Replies and 3118 Views Putting Invoices on hold  3118  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 3118
by  lmckennJump to last post
11/22/2011 5:21 PM
5 Replies and 1778 Views Hide inactive accounts in user drop down lists  1778  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 1778
by  John HenleyJump to last post
11/16/2011 7:57 PM
4 Replies and 14935 Views Printing 1099 misc income  14935  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 14935
by  JimYJump to last post
11/15/2011 10:01 AM
1 Replies and 2154 Views Report Writer  2154  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 2154
by  Gail GudgelJump to last post
11/10/2011 1:06 PM
3 Replies and 1892 Views Current year Balance rebuild after post closing entry  1892  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 1892
by  Greg MoellerJump to last post
11/07/2011 11:58 AM
0 Replies and 2795 Views Purchasing month end closing process  2795  0 Started by  RAKESH DESAI Does anyone has purchasing closing process or schedule
0 2795
11/01/2011 8:36 AM
1 Replies and 1419 Views Process Documents  1419  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 1419
by  JimYJump to last post
10/14/2011 7:16 AM
1 Replies and 1641 Views How to create new vendor in S3?  1641  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 1641
by  Ragu RaghavanJump to last post
10/12/2011 7:32 AM
1 Replies and 2022 Views AP160 ACH Batch Number  2022  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 2022
by  JillFJump to last post
10/10/2011 3:54 PM
1 Replies and 1842 Views Lawson Approval Codes  1842  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 1842
by  Jimmy ChiuJump to last post
10/05/2011 1:02 PM
1 Replies and 1437 Views Moving banks  1437  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 1437
by  Mark F. HardyJump to last post
09/26/2011 12:31 PM
0 Replies and 1316 Views access restrict  1316  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 1316
09/26/2011 9:41 AM
9 Replies and 5976 Views Can't Open Period for Backposting  5976  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 5976
by  RAKESH DESAIJump to last post
09/21/2011 8:47 PM
3 Replies and 2618 Views AP 1-time Vendor numbering - 999000001 series  2618  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 2618
by  Ragu RaghavanJump to last post
09/19/2011 7:10 PM
1 Replies and 1895 Views Subsystem Journal Descriptions  1895  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 1895
by  Ragu RaghavanJump to last post
09/15/2011 12:08 PM
0 Replies and 2567 Views Any Functional Difference: AR Invoice vs Debit Memo?  2567  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 2567
09/14/2011 10:28 AM
2 Replies and 1704 Views Custom Reporting Confusion  1704  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 1704
by  Jeremy HolovacsJump to last post
09/12/2011 11:29 AM
2 Replies and 2782 Views JE Approval Process Flow  2782  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 2782
by  LisaNJump to last post
08/29/2011 10:12 AM
1 Replies and 1479 Views Invoice data  1479  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 1479
by  John HenleyJump to last post
08/24/2011 12:05 PM
1 Replies and 2010 Views Automation Needs?  2010  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 2010
by  jcapoJump to last post
08/02/2011 6:47 PM
2 Replies and 2082 Views Base Currency is a Foreign Currency  2082  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 2082
by  CarlinoJump to last post
07/01/2011 9:04 AM
2 Replies and 1501 Views AR115 - EFT Files and Required Permissions  1501  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 1501
by  Garth GerwingJump to last post
06/22/2011 11:27 AM
0 Replies and 1471 Views A/R EFT Setup/Process Questions  1471  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 1471
06/16/2011 3:10 PM
0 Replies and 1774 Views Asset Insurance Information - AM20.4  1774  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 1774
06/14/2011 5:10 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 9 << < 34567 > >>


RSS Feed Available