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 8 << < 34567 > >>
Topics
 Replies
 Views
 Last Post
11 Replies and 2476 Views GHX and email copies of 810's  2476  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 2476
by  Greg MoellerJump to last post
07/17/2012 9:13 AM
0 Replies and 1496 Views Security On GL298  1496  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 1496
07/02/2012 4:27 PM
1 Replies and 1475 Views AC07 criteria include/exclude au's  1475  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 1475
by  JeremyJump to last post
07/02/2012 6:55 AM
1 Replies and 1399 Views Merging many vendors  1399  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 1399
by  Ragu RaghavanJump to last post
06/28/2012 3:11 PM
5 Replies and 1913 Views Fax Integrator 9..0.1.1 install time frame  1913  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 1913
by  cindy MHSILJump to last post
06/25/2012 12:30 PM
0 Replies and 1085 Views How do i get a Payment proposal into Lawson  1085  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 1085
06/20/2012 11:18 AM
6 Replies and 2256 Views CA10 Add Ins  2256  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 2256
by  SherryBJump to last post
06/13/2012 1:40 PM
0 Replies and 1974 Views Check Printing/Formatting Solutions  1974  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 1974
06/11/2012 2:59 PM
1 Replies and 1439 Views AM223 to CSV  1439  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 1439
by  JonAJump to last post
06/07/2012 2:22 PM
4 Replies and 1957 Views Determine AR Customer Balance - As At Point-In-Time  1957  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 1957
by  Garth GerwingJump to last post
06/06/2012 2:27 PM
2 Replies and 2145 Views How to Cancel on MA40/MA40.5  2145  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 2145
by  jbertoliJump to last post
05/24/2012 4:32 PM
0 Replies and 1057 Views mobile inbasket - issue with custom form  1057  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 1057
05/09/2012 9:30 AM
5 Replies and 2828 Views Chart of Acct query  2828  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 2828
by  amynelsonJump to last post
05/07/2012 10:50 AM
1 Replies and 1491 Views Adding field to AM260 Report  1491  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 1491
by  Ruma MalhotraJump to last post
05/03/2012 11:53 AM
0 Replies and 1564 Views PD10.3 upload?  1564  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 1564
05/03/2012 8:14 AM
7 Replies and 2670 Views Need to create a consolidating company in Lawson 9.0 but I have no idea how to start  2670  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 2670
by  TeresaEJump to last post
04/27/2012 1:51 PM
0 Replies and 1323 Views Alternative for 'delement'  1323  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 1323
04/26/2012 11:39 AM
2 Replies and 3902 Views Invoice Distribution from AP Payment  3902  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 3902
by  G. MonaghanJump to last post
04/25/2012 2:05 PM
1 Replies and 2444 Views AR Bank Reconciliation - How To Organize?  2444  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 2444
by  jjcyeshuaJump to last post
04/24/2012 6:23 PM
0 Replies and 1293 Views AP20 Vendor select security  1293  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 1293
04/23/2012 2:09 PM
0 Replies and 2061 Views CB55.1 Payment  2061  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 2061
04/20/2012 11:38 AM
5 Replies and 8481 Views WHAT IS NEW LAWSON 9.0.1 FINACE APPLICATIONS  8481  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 8481
by  jjcyeshuaJump to last post
04/18/2012 4:59 PM
3 Replies and 2635 Views Retail Calendar and 13th Period  2635  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 2635
by  AdamJump to last post
04/05/2012 12:36 PM
1 Replies and 1398 Views secure invoice number interface from payroll  1398  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 1398
by  Jimmy ChiuJump to last post
04/03/2012 2:27 PM
0 Replies and 1391 Views ACBR billing  1391  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 1391
03/28/2012 10:54 AM
0 Replies and 968 Views turning on remoteglt  968  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 968
03/28/2012 5:02 AM
0 Replies and 1360 Views Void PD Invoice  1360  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 1360
03/26/2012 5:19 PM
0 Replies and 1531 Views AR Lockbox  1531  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 1531
03/22/2012 10:15 AM
3 Replies and 1597 Views LP Custom calculation routine  1597  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 1597
by  bernfc10Jump to last post
03/12/2012 1:22 PM
0 Replies and 1274 Views DB inquiry processing  1274  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 1274
03/12/2012 9:35 AM
0 Replies and 1111 Views Crystal-Units issue at the AU level  1111  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 1111
03/08/2012 7:35 PM
1 Replies and 3283 Views PP&E rollforward  3283  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 3283
by  mark.cookJump to last post
03/07/2012 7:01 AM
3 Replies and 2578 Views Check reissue report?  2578  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 2578
by  StephanieLJump to last post
02/22/2012 12:16 PM
2 Replies and 1562 Views AP Productivity Query  1562  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 1562
by  Robert SpurrJump to last post
02/17/2012 1:28 PM
0 Replies and 1806 Views Question about Sub Accounts  1806  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 1806
02/17/2012 10:32 AM
1 Replies and 1359 Views What Table are CB Comment stored in  1359  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 1359
by  John HenleyJump to last post
02/16/2012 2:37 PM
6 Replies and 2812 Views AP20 Comments  2812  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 2812
by  Bob CanhamJump to last post
02/10/2012 10:03 AM
2 Replies and 5178 Views GL40.1 Upload Template  5178  2 Started by  RAKESH DESAI How can I build template to upload journal entry (40.1)from Excel.
2 5178
by  dcaianiJump to last post
02/09/2012 9:09 AM
0 Replies and 1456 Views Reverse PO Entry  1456  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 1456
02/03/2012 3:15 PM
0 Replies and 1437 Views Wire Payment entry  1437  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 1437
02/03/2012 2:54 PM
0 Replies and 1958 Views HELP - PO Matching/Pre-Paid Invoice  1958  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 1958
02/03/2012 10:14 AM
6 Replies and 3159 Views Cost Center Level  3159  6 Started by  RAKESH DESAI How Can I change or add cost center level in GL20 I need to add cost center level.
6 3159
by  RAKESH DESAIJump to last post
02/01/2012 11:32 AM
2 Replies and 1840 Views Invoices for void check  1840  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 1840
by  LudyJump to last post
01/30/2012 7:51 AM
0 Replies and 1955 Views Add in for GL20 and AP AM set up programs  1955  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 1955
01/26/2012 11:04 AM
4 Replies and 3224 Views Invoice Dist Out of Balance Error AP520  3224  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 3224
by  Deleted UserJump to last post
01/26/2012 4:24 AM
0 Replies and 1199 Views AR converted transactions  1199  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 1199
01/24/2012 12:46 PM
1 Replies and 2924 Views Freight and MA540  2924  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 2924
by  Robert SpurrJump to last post
01/19/2012 1:44 PM
2 Replies and 2655 Views Query or Crystal report for AP136  2655  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 2655
by  JCardilloJump to last post
01/11/2012 12:14 PM
1 Replies and 2421 Views Asset Transfer Upload  2421  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 2421
by  John HenleyJump to last post
01/09/2012 2:20 PM
1 Replies and 2444 Views lawappinstall failure when installing any CTP in any mode  2444  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 2444
by  troelofsJump to last post
01/06/2012 3:31 PM
3 Replies and 2107 Views Backposting entry  2107  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 2107
by  Ruma MalhotraJump to last post
01/05/2012 1:44 PM
0 Replies and 1045 Views Internal Services Cost Transfers  1045  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 1045
01/05/2012 12:43 PM
0 Replies and 1122 Views Moving RW100 from 8.03 to 9.01  1122  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 1122
01/04/2012 4:05 PM
1 Replies and 2272 Views Help on how to create cash flow statement  2272  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 2272
by  johnJump to last post
01/04/2012 12:43 PM
0 Replies and 1660 Views MSP 7  1660  0 Started by  Mark Larochelle Is/has anyone applied the MSP 7 patch
0 1660
01/04/2012 9:14 AM
0 Replies and 1432 Views CB186 error report  1432  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 1432
12/28/2011 2:25 PM
1 Replies and 3447 Views 1099 Validation report  3447  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 3447
by  Greg MoellerJump to last post
12/13/2011 3:47 PM
0 Replies and 1465 Views AR - Support Both Pre-Authorized Debit & Credit?  1465  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 1465
12/08/2011 4:02 PM
2 Replies and 1902 Views GL221 export to csv  1902  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 1902
by  Tammy GuidryJump to last post
12/05/2011 11:29 AM
2 Replies and 2099 Views .cfg files  2099  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 2099
by  johneJump to last post
12/01/2011 1:59 PM
0 Replies and 1234 Views Reinstate check batch  1234  0 Started by  Boyd Does anyone know if there is a way to reinstate an electronic payment batch that was voided in error
0 1234
12/01/2011 8:52 AM
2 Replies and 2987 Views Putting Invoices on hold  2987  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 2987
by  lmckennJump to last post
11/22/2011 5:21 PM
5 Replies and 1710 Views Hide inactive accounts in user drop down lists  1710  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 1710
by  John HenleyJump to last post
11/16/2011 7:57 PM
4 Replies and 14727 Views Printing 1099 misc income  14727  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 14727
by  JimYJump to last post
11/15/2011 10:01 AM
1 Replies and 2077 Views Report Writer  2077  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 2077
by  Gail GudgelJump to last post
11/10/2011 1:06 PM
3 Replies and 1813 Views Current year Balance rebuild after post closing entry  1813  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 1813
by  Greg MoellerJump to last post
11/07/2011 11:58 AM
0 Replies and 2732 Views Purchasing month end closing process  2732  0 Started by  RAKESH DESAI Does anyone has purchasing closing process or schedule
0 2732
11/01/2011 8:36 AM
1 Replies and 1351 Views Process Documents  1351  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 1351
by  JimYJump to last post
10/14/2011 7:16 AM
1 Replies and 1542 Views How to create new vendor in S3?  1542  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 1542
by  Ragu RaghavanJump to last post
10/12/2011 7:32 AM
1 Replies and 1898 Views AP160 ACH Batch Number  1898  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 1898
by  JillFJump to last post
10/10/2011 3:54 PM
1 Replies and 1753 Views Lawson Approval Codes  1753  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 1753
by  Jimmy ChiuJump to last post
10/05/2011 1:02 PM
1 Replies and 1380 Views Moving banks  1380  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 1380
by  Mark F. HardyJump to last post
09/26/2011 12:31 PM
0 Replies and 1248 Views access restrict  1248  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 1248
09/26/2011 9:41 AM
9 Replies and 5746 Views Can't Open Period for Backposting  5746  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 5746
by  RAKESH DESAIJump to last post
09/21/2011 8:47 PM
3 Replies and 2542 Views AP 1-time Vendor numbering - 999000001 series  2542  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 2542
by  Ragu RaghavanJump to last post
09/19/2011 7:10 PM
1 Replies and 1836 Views Subsystem Journal Descriptions  1836  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 1836
by  Ragu RaghavanJump to last post
09/15/2011 12:08 PM
0 Replies and 2490 Views Any Functional Difference: AR Invoice vs Debit Memo?  2490  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 2490
09/14/2011 10:28 AM
2 Replies and 1633 Views Custom Reporting Confusion  1633  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 1633
by  Jeremy HolovacsJump to last post
09/12/2011 11:29 AM
2 Replies and 2710 Views JE Approval Process Flow  2710  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 2710
by  LisaNJump to last post
08/29/2011 10:12 AM
1 Replies and 1412 Views Invoice data  1412  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 1412
by  John HenleyJump to last post
08/24/2011 12:05 PM
1 Replies and 1946 Views Automation Needs?  1946  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 1946
by  jcapoJump to last post
08/02/2011 6:47 PM
2 Replies and 2003 Views Base Currency is a Foreign Currency  2003  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 2003
by  CarlinoJump to last post
07/01/2011 9:04 AM
2 Replies and 1428 Views AR115 - EFT Files and Required Permissions  1428  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 1428
by  Garth GerwingJump to last post
06/22/2011 11:27 AM
0 Replies and 1411 Views A/R EFT Setup/Process Questions  1411  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 1411
06/16/2011 3:10 PM
0 Replies and 1721 Views Asset Insurance Information - AM20.4  1721  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 1721
06/14/2011 5:10 PM
4 Replies and 4131 Views Researching Invoice Scanning, OCR, Workflow solutions  4131  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 4131
by  Gail GudgelJump to last post
06/01/2011 10:16 AM
3 Replies and 1755 Views RW assistance  1755  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 1755
by  Gail GudgelJump to last post
06/01/2011 10:11 AM
3 Replies and 1742 Views Activity Management Upload Utility  1742  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 1742
by  tdosalJump to last post
06/01/2011 8:46 AM
0 Replies and 1512 Views Period of Performance (POP)  1512  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 1512
06/01/2011 8:42 AM
5 Replies and 2124 Views adding comment to asset numbers in the report  2124  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 2124
by  Vijay SJump to last post
05/27/2011 2:11 AM
4 Replies and 1895 Views Creating Assets from AP invoices using AM115  1895  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 1895
by  SaurabhJump to last post
05/21/2011 8:21 AM
2 Replies and 2234 Views PO31.1 Vendor Return  2234  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 2234
by  mikekaskJump to last post
05/12/2011 3:10 PM
3 Replies and 2410 Views Change Import GL journal Sequence Number  2410  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 2410
by  Ruma MalhotraJump to last post
05/06/2011 12:51 PM
4 Replies and 3640 Views Changing Activity Required field in (GL20.3) Using AddInns  3640  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 3640
by  SaurabhJump to last post
04/27/2011 3:44 PM
1 Replies and 1780 Views AM221 and AM270 Reports are out of Sync  1780  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 1780
by  Kevin HaganJump to last post
04/25/2011 9:46 AM
2 Replies and 1584 Views Blank Line  1584  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 1584
by  Gail GudgelJump to last post
04/20/2011 12:24 PM
1 Replies and 1501 Views ARCUSTOMER.Search_Name Too Short...  1501  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 1501
by  AlJump to last post
04/19/2011 12:56 PM
1 Replies and 2030 Views L_HAPI.L_INDEX creation logic  2030  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 2030
by  Angela CollinsJump to last post
04/15/2011 4:13 PM
4 Replies and 2101 Views Activity Budget/Date Edits  2101  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 2101
by  NickJump to last post
04/10/2011 12:58 PM
4 Replies and 1973 Views Financials Audit Reports  1973  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 1973
by  Wade-TJump to last post
04/01/2011 7:38 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