Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 8 << < 34567 > >>
 Last Post
2 Replies and 1425 Views ARITRANS  1425  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 1425
by  DougABJump to last post
08/27/2012 4:25 PM
5 Replies and 4727 Views PO64.1 PO Line Item History Report?  4727  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 4727
by  Dave McGownJump to last post
08/03/2012 10:24 AM
3 Replies and 2205 Views Suggestions for check printing solutions?  2205  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 2205
by  DougABJump to last post
07/31/2012 3:58 PM
0 Replies and 1603 Views 457 Plan - Company Match  1603  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 1603
07/26/2012 5:22 PM
0 Replies and 1088 Views Comments not attached to invoices  1088  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 1088
07/17/2012 11:59 AM
11 Replies and 2512 Views GHX and email copies of 810's  2512  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 2512
by  Greg MoellerJump to last post
07/17/2012 9:13 AM
0 Replies and 1528 Views Security On GL298  1528  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 1528
07/02/2012 4:27 PM
1 Replies and 1500 Views AC07 criteria include/exclude au's  1500  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 1500
by  JeremyJump to last post
07/02/2012 6:55 AM
1 Replies and 1432 Views Merging many vendors  1432  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 1432
by  Ragu RaghavanJump to last post
06/28/2012 3:11 PM
5 Replies and 1943 Views Fax Integrator 9..0.1.1 install time frame  1943  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 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 1943
by  cindy MHSILJump to last post
06/25/2012 12:30 PM
0 Replies and 1115 Views How do i get a Payment proposal into Lawson  1115  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 1115
06/20/2012 11:18 AM
6 Replies and 2298 Views CA10 Add Ins  2298  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 2298
by  SherryBJump to last post
06/13/2012 1:40 PM
0 Replies and 2021 Views Check Printing/Formatting Solutions  2021  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 2021
06/11/2012 2:59 PM
1 Replies and 1473 Views AM223 to CSV  1473  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 1473
by  JonAJump to last post
06/07/2012 2:22 PM
4 Replies and 2001 Views Determine AR Customer Balance - As At Point-In-Time  2001  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 2001
by  Garth GerwingJump to last post
06/06/2012 2:27 PM
2 Replies and 2170 Views How to Cancel on MA40/MA40.5  2170  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 2170
by  jbertoliJump to last post
05/24/2012 4:32 PM
0 Replies and 1085 Views mobile inbasket - issue with custom form  1085  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 1085
05/09/2012 9:30 AM
5 Replies and 2859 Views Chart of Acct query  2859  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 2859
by  amynelsonJump to last post
05/07/2012 10:50 AM
1 Replies and 1517 Views Adding field to AM260 Report  1517  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 1517
by  Ruma MalhotraJump to last post
05/03/2012 11:53 AM
0 Replies and 1598 Views PD10.3 upload?  1598  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 1598
05/03/2012 8:14 AM
7 Replies and 2724 Views Need to create a consolidating company in Lawson 9.0 but I have no idea how to start  2724  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 2724
by  TeresaEJump to last post
04/27/2012 1:51 PM
0 Replies and 1353 Views Alternative for 'delement'  1353  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 1353
04/26/2012 11:39 AM
2 Replies and 3967 Views Invoice Distribution from AP Payment  3967  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 3967
by  G. MonaghanJump to last post
04/25/2012 2:05 PM
1 Replies and 2496 Views AR Bank Reconciliation - How To Organize?  2496  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 2496
by  jjcyeshuaJump to last post
04/24/2012 6:23 PM
0 Replies and 1330 Views AP20 Vendor select security  1330  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 1330
04/23/2012 2:09 PM
0 Replies and 2100 Views CB55.1 Payment  2100  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 2100
04/20/2012 11:38 AM
5 Replies and 8538 Views WHAT IS NEW LAWSON 9.0.1 FINACE APPLICATIONS  8538  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 8538
by  jjcyeshuaJump to last post
04/18/2012 4:59 PM
3 Replies and 2668 Views Retail Calendar and 13th Period  2668  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 2668
by  AdamJump to last post
04/05/2012 12:36 PM
1 Replies and 1432 Views secure invoice number interface from payroll  1432  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 1432
by  Jimmy ChiuJump to last post
04/03/2012 2:27 PM
0 Replies and 1414 Views ACBR billing  1414  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 1414
03/28/2012 10:54 AM
0 Replies and 993 Views turning on remoteglt  993  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 993
03/28/2012 5:02 AM
0 Replies and 1393 Views Void PD Invoice  1393  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 1393
03/26/2012 5:19 PM
0 Replies and 1556 Views AR Lockbox  1556  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 1556
03/22/2012 10:15 AM
3 Replies and 1620 Views LP Custom calculation routine  1620  3 Started by  bernfc10 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 1620
by  bernfc10Jump to last post
03/12/2012 1:22 PM
0 Replies and 1309 Views DB inquiry processing  1309  0 Started by  bernfc10 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 1309
03/12/2012 9:35 AM
0 Replies and 1137 Views Crystal-Units issue at the AU level  1137  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 1137
03/08/2012 7:35 PM
1 Replies and 3337 Views PP&E rollforward  3337  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 3337
by  mark.cookJump to last post
03/07/2012 7:01 AM
3 Replies and 2608 Views Check reissue report?  2608  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 2608
by  StephanieLJump to last post
02/22/2012 12:16 PM
2 Replies and 1594 Views AP Productivity Query  1594  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 1594
by  Robert SpurrJump to last post
02/17/2012 1:28 PM
0 Replies and 1832 Views Question about Sub Accounts  1832  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 1832
02/17/2012 10:32 AM
1 Replies and 1377 Views What Table are CB Comment stored in  1377  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 1377
by  John HenleyJump to last post
02/16/2012 2:37 PM
6 Replies and 2849 Views AP20 Comments  2849  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 2849
by  Bob CanhamJump to last post
02/10/2012 10:03 AM
2 Replies and 5271 Views GL40.1 Upload Template  5271  2 Started by  RAKESH DESAI How can I build template to upload journal entry (40.1)from Excel.
2 5271
by  dcaianiJump to last post
02/09/2012 9:09 AM
0 Replies and 1485 Views Reverse PO Entry  1485  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 1485
02/03/2012 3:15 PM
0 Replies and 1464 Views Wire Payment entry  1464  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 1464
02/03/2012 2:54 PM
0 Replies and 1979 Views HELP - PO Matching/Pre-Paid Invoice  1979  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 1979
02/03/2012 10:14 AM
6 Replies and 3201 Views Cost Center Level  3201  6 Started by  RAKESH DESAI How Can I change or add cost center level in GL20 I need to add cost center level.
6 3201
by  RAKESH DESAIJump to last post
02/01/2012 11:32 AM
2 Replies and 1870 Views Invoices for void check  1870  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 1870
by  LudyJump to last post
01/30/2012 7:51 AM
0 Replies and 1983 Views Add in for GL20 and AP AM set up programs  1983  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 1983
01/26/2012 11:04 AM
4 Replies and 3292 Views Invoice Dist Out of Balance Error AP520  3292  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 3292
by  Deleted UserJump to last post
01/26/2012 4:24 AM
0 Replies and 1221 Views AR converted transactions  1221  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 1221
01/24/2012 12:46 PM
1 Replies and 2966 Views Freight and MA540  2966  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 2966
by  Robert SpurrJump to last post
01/19/2012 1:44 PM
2 Replies and 2695 Views Query or Crystal report for AP136  2695  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 2695
by  JCardilloJump to last post
01/11/2012 12:14 PM
1 Replies and 2444 Views Asset Transfer Upload  2444  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 2444
by  John HenleyJump to last post
01/09/2012 2:20 PM
1 Replies and 2471 Views lawappinstall failure when installing any CTP in any mode  2471  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 2471
by  troelofsJump to last post
01/06/2012 3:31 PM
3 Replies and 2143 Views Backposting entry  2143  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 2143
by  Ruma MalhotraJump to last post
01/05/2012 1:44 PM
0 Replies and 1068 Views Internal Services Cost Transfers  1068  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 1068
01/05/2012 12:43 PM
0 Replies and 1150 Views Moving RW100 from 8.03 to 9.01  1150  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 1150
01/04/2012 4:05 PM
1 Replies and 2318 Views Help on how to create cash flow statement  2318  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 2318
by  johnJump to last post
01/04/2012 12:43 PM
0 Replies and 1691 Views MSP 7  1691  0 Started by  Mark Larochelle Is/has anyone applied the MSP 7 patch
0 1691
01/04/2012 9:14 AM
0 Replies and 1473 Views CB186 error report  1473  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 1473
12/28/2011 2:25 PM
1 Replies and 3489 Views 1099 Validation report  3489  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 3489
by  Greg MoellerJump to last post
12/13/2011 3:47 PM
0 Replies and 1500 Views AR - Support Both Pre-Authorized Debit & Credit?  1500  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 1500
12/08/2011 4:02 PM
2 Replies and 1929 Views GL221 export to csv  1929  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 1929
by  Tammy GuidryJump to last post
12/05/2011 11:29 AM
2 Replies and 2132 Views .cfg files  2132  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 2132
by  johneJump to last post
12/01/2011 1:59 PM
0 Replies and 1263 Views Reinstate check batch  1263  0 Started by  Boyd Does anyone know if there is a way to reinstate an electronic payment batch that was voided in error
0 1263
12/01/2011 8:52 AM
2 Replies and 3052 Views Putting Invoices on hold  3052  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 3052
by  lmckennJump to last post
11/22/2011 5:21 PM
5 Replies and 1744 Views Hide inactive accounts in user drop down lists  1744  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 1744
by  John HenleyJump to last post
11/16/2011 7:57 PM
4 Replies and 14822 Views Printing 1099 misc income  14822  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 14822
by  JimYJump to last post
11/15/2011 10:01 AM
1 Replies and 2110 Views Report Writer  2110  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 2110
by  Gail GudgelJump to last post
11/10/2011 1:06 PM
3 Replies and 1849 Views Current year Balance rebuild after post closing entry  1849  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 1849
by  Greg MoellerJump to last post
11/07/2011 11:58 AM
0 Replies and 2757 Views Purchasing month end closing process  2757  0 Started by  RAKESH DESAI Does anyone has purchasing closing process or schedule
0 2757
11/01/2011 8:36 AM
1 Replies and 1378 Views Process Documents  1378  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 1378
by  JimYJump to last post
10/14/2011 7:16 AM
1 Replies and 1584 Views How to create new vendor in S3?  1584  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 1584
by  Ragu RaghavanJump to last post
10/12/2011 7:32 AM
1 Replies and 1949 Views AP160 ACH Batch Number  1949  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 1949
by  JillFJump to last post
10/10/2011 3:54 PM
1 Replies and 1792 Views Lawson Approval Codes  1792  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 1792
by  Jimmy ChiuJump to last post
10/05/2011 1:02 PM
1 Replies and 1400 Views Moving banks  1400  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 1400
by  Mark F. HardyJump to last post
09/26/2011 12:31 PM
0 Replies and 1273 Views access restrict  1273  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- Thanks to lawson forum.
0 1273
09/26/2011 9:41 AM
9 Replies and 5821 Views Can't Open Period for Backposting  5821  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 5821
by  RAKESH DESAIJump to last post
09/21/2011 8:47 PM
3 Replies and 2573 Views AP 1-time Vendor numbering - 999000001 series  2573  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 2573
by  Ragu RaghavanJump to last post
09/19/2011 7:10 PM
1 Replies and 1856 Views Subsystem Journal Descriptions  1856  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 1856
by  Ragu RaghavanJump to last post
09/15/2011 12:08 PM
0 Replies and 2526 Views Any Functional Difference: AR Invoice vs Debit Memo?  2526  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 2526
09/14/2011 10:28 AM
2 Replies and 1660 Views Custom Reporting Confusion  1660  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 1660
by  Jeremy HolovacsJump to last post
09/12/2011 11:29 AM
2 Replies and 2742 Views JE Approval Process Flow  2742  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 2742
by  LisaNJump to last post
08/29/2011 10:12 AM
1 Replies and 1438 Views Invoice data  1438  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 1438
by  John HenleyJump to last post
08/24/2011 12:05 PM
1 Replies and 1973 Views Automation Needs?  1973  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 1973
by  jcapoJump to last post
08/02/2011 6:47 PM
2 Replies and 2030 Views Base Currency is a Foreign Currency  2030  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 2030
by  CarlinoJump to last post
07/01/2011 9:04 AM
2 Replies and 1453 Views AR115 - EFT Files and Required Permissions  1453  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 1453
by  Garth GerwingJump to last post
06/22/2011 11:27 AM
0 Replies and 1441 Views A/R EFT Setup/Process Questions  1441  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 1441
06/16/2011 3:10 PM
0 Replies and 1744 Views Asset Insurance Information - AM20.4  1744  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 1744
06/14/2011 5:10 PM
4 Replies and 4214 Views Researching Invoice Scanning, OCR, Workflow solutions  4214  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 4214
by  Gail GudgelJump to last post
06/01/2011 10:16 AM
3 Replies and 1776 Views RW assistance  1776  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 1776
by  Gail GudgelJump to last post
06/01/2011 10:11 AM
3 Replies and 1765 Views Activity Management Upload Utility  1765  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 1765
by  tdosalJump to last post
06/01/2011 8:46 AM
0 Replies and 1541 Views Period of Performance (POP)  1541  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 1541
06/01/2011 8:42 AM
5 Replies and 2157 Views adding comment to asset numbers in the report  2157  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 2157
by  Vijay SJump to last post
05/27/2011 2:11 AM
4 Replies and 1931 Views Creating Assets from AP invoices using AM115  1931  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 1931
by  SaurabhJump to last post
05/21/2011 8:21 AM
2 Replies and 2283 Views PO31.1 Vendor Return  2283  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 2283
by  mikekaskJump to last post
05/12/2011 3:10 PM
3 Replies and 2445 Views Change Import GL journal Sequence Number  2445  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 2445
by  Ruma MalhotraJump to last post
05/06/2011 12:51 PM
4 Replies and 3700 Views Changing Activity Required field in (GL20.3) Using AddInns  3700  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 3700
by  SaurabhJump to last post
04/27/2011 3:44 PM
1 Replies and 1803 Views AM221 and AM270 Reports are out of Sync  1803  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 and using Portal as our interface. Thanks.
1 1803
by  Kevin HaganJump to last post
04/25/2011 9:46 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 8 << < 34567 > >>

RSS Feed Available