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 3 of 9 << < 12345 > >>
 Last Post
2 Replies and 953 Views Customer Comments in AR  953  2 Started by  aphillips Our AR dept has requested a place where they can record conversations with customers. They need to be able to recap their discussions for future reference. The only place I see is AR17.1 but this does not look like it will be easy to use. Can anyone share what they do to record comments and actions
2 953
by  Todd MitchellJump to last post
02/05/2015 9:30 AM
2 Replies and 1245 Views Asset Managment - 8.1  1245  2 Started by  Ron Swanson The user believes that the Current Period Depreciation on an AM260 report is an accumulated to date figure, for the current period and will change any time she runs it. I am certain the CP Depr shows up after AM180 is run. And when AM190 is run I assume the CP Depr is cleared and the YTD, LTD is updated. Can someone verify this sequence for me These are folks on 8.1 with no on site staff who were ever trained on Lawson. I am just trying to look at manuals and help. Thanks.
2 1245
by  Ron SwansonJump to last post
01/15/2015 2:28 PM
1 Replies and 1386 Views APINVOICE OPERATOR  1386  1 Started by  Donna We have a new AP employee who started as a vendor and was given an appropriate Vendor user ID in for AD and Lawson. Now that she is an employee we have assigned a different login for AD and Lawson but the original vendor user is still populating the APINVOICE file. It appears that her new user ID has no impact on populating the value in the APINVOICE OPERATOR field. I tried to find a screen that allows the entry of the Operator ID for any AP table and did not find one. We have a Crysta...
1 1386
by  John HenleyJump to last post
01/05/2015 4:11 PM
0 Replies and 829 Views AR199 Year End Close Mistake  829  0 Started by  zjs5029 Hello Everyone, I ran AR199 without the 'Year End' option clicked to yes. Is there anyway to go back and change the close to year end now
0 829
01/05/2015 1:10 PM
1 Replies and 1167 Views Inactivating a company  1167  1 Started by  dcaiani We have 3 GL companies that are no longer active. Is there a way in Lawson to make them inactive so that nothing can be accidentally posted to them from AP or IN etc. There is a status field in GL10, but it doesn't seem to be where I would accomplish inactivating a company. Any thoughts as to what my best plan of action would be Thanks Dave
1 1167
by  Jimmy ChiuJump to last post
12/17/2014 2:34 PM
0 Replies and 909 Views Aging Reports (AR251) I.P.A.  909  0 Started by  BErnewayn On an aging report (AR251), does I.P.A. stand for Invoice Payment Average Is this closer to a DSO average or is the F.O.R. - Funds Outstanding Ratio closer in measurement to the DSO
0 909
12/15/2014 3:48 PM
0 Replies and 740 Views Asset Managment  740  0 Started by  symfny I'm pretty sure I know the answer to this question... but has anyone used Lawson Asset Management for managing 'physical' assets and tracking its location and any potential related inventory I know Lawson AM manages depreciation and its integration with GL, but the request is simpler than that. We have internal customers wanting to manage equipment which is on a trial, loan, demonstration or evaluation from a vendor. If so, how did you do it Thanks.
0 740
12/15/2014 12:50 PM
2 Replies and 1134 Views Process Level Restriction  1134  2 Started by  Dee Hardy I'm not sure I's posting this problem in the right location. I wrote rules to restrict users by process levels, which works, but it doesn't allow for Drill Around access. For example, I can restrict a user to process level using the rule which looks at ProcessLevelControl and AccountingUnitControl in RMID, but no information is displayed when the users tries to use Drill Around. There should be a way to make this work. Does anyone have any experience with process level restriction and access to ...
2 1134
by  Dee HardyJump to last post
12/09/2014 1:19 PM
1 Replies and 1003 Views G/L Date Error  1003  1 Started by  Chesca Payroll processed the PR197 on Friday 10/17/14 with the G/L Date of 10/08/2014 instead of 10/22/2014. I was hoping that there is a way to back it out and re-post it to the correct date. Does anyone have any ideas for me
1 1003
by  dcaianiJump to last post
12/05/2014 2:40 PM
1 Replies and 1122 Views PO25 Contract Agreements  1122  1 Started by  lars Is there a screen or report that will list all PO20's that used against items in a PO25.6 Vendor Agreement/Contract Or another way of saying it.... We have a PO25.6 Contract in place for copy paper, 4 items to be exact. Our audit team want to see if the Contract items are being used. Th audit team wants to see a list of PO20's that were issued using the 4 items in the contract. Thanks.
1 1122
by  JonAJump to last post
11/26/2014 1:39 PM
1 Replies and 984 Views ERP Selection  984  1 Started by  GeoffB Due to a merger, our new health system has to select either Lawson or McKesson for ERP (Financial & Supply Chain) to move forward with. Has anyone gone through a similar selection process recently between these two vendors who would be willing to share their thought process on which selction you made either way Thanks.
1 984
by  alexrsJump to last post
11/18/2014 6:34 AM
0 Replies and 748 Views Staging table for AP comments  748  0 Started by  L G Like APCINVOICE for APINVOICE or APCVENMAST for APVENMAST. We are trying to interface AP comments along with the AP invoices. Whats the equivalent for APCOMMENTS
0 748
11/17/2014 10:36 PM
1 Replies and 1153 Views AP14.5 TIN Type Change with Add-Ins  1153  1 Started by  Jeremy We are trying to change the TIN type for vendors via add-ins from '0' to '1' in AP14.5 using add-ins. When I map to AP14.5, I get a message telling me 'tax ID must be 9 digits' If I try mapping to AP10.1 and select the TIN type as a hidden field, I get change complete continue, but it doesn't change the TIN type to '1'
1 1153
by  jjcyeshuaJump to last post
11/13/2014 6:49 PM
2 Replies and 968 Views Writing an Income Statement in crystal  968  2 Started by  Melissa I have an RW100 income statement that works, but it takes 8 hours to run. I would like to rewrite this just using the lawson tables in crystal reports, but i'm having trouble with the grouping for my subtotals. I've read a couple posts that said they were able to create a view using the rwrowdet file to control the grouping in crystal, but I'm not sure how to do this/what fields to use. If anyone has information on how I could do this or a diffrent way i could write this I would greatly apprec...
2 968
by  jjcyeshuaJump to last post
11/12/2014 2:29 PM
5 Replies and 1251 Views Non-AR Backout  1251  5 Started by  whitey1287 Is there anyway to back out a Non-AR payment so the payment can be reapplied directly to the appropriate invoice
5 1251
by  Ken UJump to last post
11/06/2014 2:59 PM
0 Replies and 787 Views Allocations  787  0 Started by  Ruma Malhotra Has anybody tries to setup an allocation where you are allocating from multiple and to multiple accounting units a summary account like EBITDA. Can you share the steps used to set up this allocation Thanks, ruma.
0 787
11/04/2014 11:44 AM
6 Replies and 3640 Views ACH and EDI  3640  6 Started by  JonA Does anyone have some straight forward instructions on how to setup ACH via EDI AP is able to get the funds to the vendor's bank but they want to set up EDI to send remittance information and the Lawson KB doesn't really explain how this is set up. I'm on the supply chain side so I'm not completely clear on ACH but the AP manager asked me to help because I know EDI for supply chain. Do we need to do any setups in ED02 or ED10
6 3640
by  jj2020Jump to last post
10/31/2014 11:03 AM
0 Replies and 940 Views Invoice entry AP20.2 Discounts AP22.3  940  0 Started by  chatt New user here (3rd day) and I have a couple of questions which I've asked my staff and they did not know. (1) How do you enter discounts within the AP20.2 {TAXED INVOICE} module on the Main tab I do see a 'Discount' box and have clicked on that, which took me to AP22.3 {DISCOUNT}. My staff instructed me to enter the discounted amount of the invoice in the INV AMOUNT box and then use distribute out the cost to the various GL account(s). The PMT TERMS box is indicated with 'N00' = pay imme...
0 940
10/23/2014 5:06 PM
7 Replies and 1670 Views Asset Management with 2 books??  1670  7 Started by  maluhia1979 My company is trying to create 2 separate books for our asset management. I created a second book as non-posting. This book needs to always contain the historical book value (i.e. can never be impaired over the life of the asset). The original book should have all regular functionality. The hope was that we could create one asset template that will post a newly created asset to both books, but as adjustments are made over the life of the asset, only the posting book would be updated. This ...
7 1670
by  jjcyeshuaJump to last post
10/22/2014 3:48 PM
2 Replies and 2224 Views Lawson Depreciation Reports  2224  2 Started by  JFutrelle Hey guys, I'm rather new to Lawson. We're running version I am trying to figure out how to run depreciation reports for a prior year. The reports that my company has been running (AM280 for instance) don't seem to have a field for run dates(i.e. 1/1/2012 - 12/31/2012). I've been told by those here before me that all depreciation reports have to be run at the end of a given period(on that actual day) to get an accurate depreciation report. That sounded a little ridiculous to m...
2 2224
by  jjcyeshuaJump to last post
10/20/2014 4:00 PM
0 Replies and 623 Views GM System control  623  0 Started by  whitey1287 Is there a GM system control closing job Similar to the other closing jobs
0 623
10/13/2014 11:40 AM
0 Replies and 792 Views Intercompany Relationships  792  0 Started by  Russ M Looking for a suggestion on creating a relationship between two companies in Lawson where an intercompany entry in the GL40 is not require. The scenario would play out like this: Company nbr 1 orders product from company nbr 2. Co nbr 1 bills co nbr 2. There is no payment out the door, instead the dollars would pass from one co to another in the GL. Everytime I walk through the scenario, everything works until co nbr 2 tries to pay nbr 1.
0 792
10/03/2014 2:11 PM
0 Replies and 777 Views Foreign Vendors and 1042S Reporting  777  0 Started by  JenDavis We are looking for insight on how other organizations are handling the withholding section in Lawson. Also, how are you processing/tracking foreign payments and issuing 1042S We were told Lawson doesn't support 1042S and just wanted to discuss how others might be adjusting that that.
0 777
10/03/2014 11:00 AM
1 Replies and 1083 Views Invoices in AP36  1083  1 Started by  Ruma Malhotra We have a process by which we are feeding invoices from external systems into AP36. These invoices are released but have not been approved to be paid. Once they are in AP36 the AP person has to approve the invoice and add the image using onbase before it gets paid. We have had a situation last wekk that about 5k invoices were randomly approved to pay and left AP36 without the AP processor looking at the invoice. We checked into the tables if someone would have accidentally done this but it do...
1 1083
by  darwin collinsJump to last post
10/02/2014 9:24 AM
7 Replies and 4394 Views Balance Sheet Report  4394  7 Started by  Deleted User I am new to Lawson&160; but knows Crystal Reporting.&160; I was asked to create a balance sheet report that contains current and prior year balances.&160; I am not familiar with the General Ledger tables.&160; Can someone get me started on which tables to use to create this report
7 4394
by  AliseJump to last post
09/23/2014 3:37 PM
1 Replies and 1410 Views Accounts Payable Invoice Automation Invoice Scanning  1410  1 Started by  Jack Peters My company is considering implementing Accounts Payable Invoice Automation and I'm wondering if anyone has experience with the scanning side of the process. We use Kofax currently as our scanning solution for other apps and could concievably start with that, but I simply don't know what would be required. Any shared experience would be greatly appreciated!
1 1410
by  Any ideas?Jump to last post
09/09/2014 11:24 AM
0 Replies and 958 Views Load AP161 with Separate Payment & Remit to Document Express  958  0 Started by  Bob Canham We are working on implementing Wells Fargo SPS solution for healthcare vendor electronic payments. The process uses the remit file of the AP161 only, so we have our cash code set up to do a separate payment and remittance file. For our own records, we would like to be able to have a human readable copy of the payment to attach to the invoice for archiving. We use Document Express for check printing today, and it does a good job importing the AP161 as long as the Payment and Remittance are com...
0 958
09/09/2014 9:51 AM
0 Replies and 866 Views Changing Fiscal Year-end Date  866  0 Started by  mmcgOmaha We have been instructed to change the year-end of a small associate company from 6/30 to 12/31. That means that the current period will be 'stub' period. Our understanding is that all history will convert to years ending 12/31. That would make it difficult to reproduce any financial statements for the 12 months 7/1/13 to 6/30/14 without actually doing the math to add and subtract from years ending 12/31. How do others handle the transition
0 866
09/04/2014 12:20 PM
0 Replies and 842 Views How people track Customer Comments In AR?  842  0 Started by  mrw562 Based on the information I am finding Lawson AR does not have a dynamic area to track comments on customer accounts. Does anyone have or is aware of a method to track customer comments obtained by AR reps in Lawson Preferably they would like to be able to pull up all previous comments and add additional comments/status comments up to 140 characters. Anyone else have this issue Or previously performed a customization
0 842
08/26/2014 5:27 PM
1 Replies and 756 Views Prenotification without processing via alternative method  756  1 Started by  Nikki W We would like to submit prenotifications to the bank without cutting checks for invoices that we pulled into Lawson via AP520. We want to wait until the account is verified by the bank and then allow payment. Is there a flag that would allow us to do this on the vendor setup
1 756
by  Mark F. HardyJump to last post
08/26/2014 10:23 AM
0 Replies and 737 Views Tax Reports/Queries by Accounting Unit???  737  0 Started by  Bill Does anyone run a report or a query to attach the Accounting Unit/ Cost Center to a Tax Code and Amount One of our companies that we just added has reporting requirements for additional Use Tax to be reported by County. Only way we are able to do this is if we can tie the AU/CC back to the Distribution Lines with Tax Codes used. I have not been able to find a relation in any of the tables to get this done. Anyone else run into this issue
0 737
08/19/2014 1:28 PM
1 Replies and 842 Views Override Base Zone on JE Header  842  1 Started by  DennisM I'm attempting to determine why any one would ever want to override a Company's Base Zone on a JE Header (GL40.2). Infor provides the functionality, but why would any one wish to perform this action. What would be gained... What would be some of the reasons for doing this... it seems to me it might increase difficulty with elimination entries at month-end. I'm just looking for rationale and/or reasons for ever wanting to override the base zone on a JE Header...
1 842
by  BShortJump to last post
08/19/2014 12:27 PM
2 Replies and 999 Views APINVOICE: MATCH_STATUS and MTCH_ERR_TYPE  999  2 Started by  JonA Can anyone shed some light on what each code number means for... MATCH_STATUS 0 = 1 = 2 = 3 = 4 = 5 = MTCH_ERR_TYPE 0 = 1 = 2 = 3 = 4 = Any others
2 999
by  JonAJump to last post
08/18/2014 11:54 AM
1 Replies and 936 Views Cannot delete non-GL journal entries GL45  936  1 Started by  Ariel I am trying to delete some old entries that are lingering in GL45. However, I am unable to delete those Journal Entries that are in an unreleased state. The error message that I receive is: 'Cannot delete non-GL journal entries'. Any insight on this is much appreciated. I've been carrying stuff forward for years now and would just like to get it out of there. Thanks, -Ariel
1 936
by  Ragu RaghavanJump to last post
08/14/2014 11:32 AM
3 Replies and 5265 Views Recurring Journal Entries  5265  3 Started by  Deleted User I have several recurring journal entries that were set up as automatic zero but post the previous month amounts and have the release status. These entries were than interface to the general ledger and are now posted. Is there an easier way to fix these entries without having to upload or key in the entire entry over I try to copy the entries but since they were set up as automatic zero they have no dollar amounts.
3 5265
by  dcaianiJump to last post
08/07/2014 1:36 PM
10 Replies and 9514 Views How to Upload Journal Entries  9514  10 Started by  rsq2_15 Hello, I'm relatively new to Lawson.&160; I've been using it now for six months.&160; During our budget process, I learned to use the Excel addin to upload account information into FB20.&160; This made things MUCH easier and faster.&160; I know there has to be a way to upload monthly journal entries but I haven't figured out how to do it.&160; Can someone point me toward a good resource for learning how to upload entries into the General Ledger (GL) as well as Recurring Journal (RJ) areas&...
10 9514
by  John HenleyJump to last post
07/24/2014 1:54 PM
3 Replies and 724 Views AC20.4_Activity Budget by Activity  724  3 Started by  whitey1287 Hi, In AC20.4 I have a budget of $20,000 in the amount fields, but next to Total Cost Budget Amount the total is $40,000. Any guidance on this issue is greatly appreciated. Thanks!
3 724
by  whitey1287Jump to last post
07/24/2014 12:22 PM
3 Replies and 1368 Views Cash Book Poor Performance  1368  3 Started by  SteveB Is anyone else experiencing very slow Cash Book performance When users run single line reconciliations, it takes 2 minutes for the process to complete. But when users try to do multiple lines, the process times out in Smart Office and Portal (multiple lines can be successfully processed using LID). We have opened a case with Infor and they had us rebuild indexes on CBTRANS and CBCONSOL which did not solve the issue. To resolve the time out issue, Infor had us increase the read/write time...
3 1368
by  John HenleyJump to last post
07/17/2014 2:46 PM
1 Replies and 1522 Views PA52.1  1522  1 Started by  whitey1287 I am trying to change an activity in PA52.1 -> Selected Items 2 tab. But, I am getting the error message, 'account unit not defined within range for activity.' I have checked AC07 to ensure everything is accurate, but still get the error. Any guidance on this issue is greatly appreciated. Thanks!
1 1522
by  Jason BeardJump to last post
07/16/2014 9:03 PM
6 Replies and 1407 Views Add Image Link in AP150 Output  1407  6 Started by  Giulia We use Image Express by MHC to scan and store all of our AP Invoices. We would like to add a link/hyperlink to the AP150 output report so that a user can see the scanned image when they click on an invoice number in the report. I have been trying to figure out a way to do this via Smart Reports Designer but have been unsuccessful. Has anybody else been able to do this either through Smart Reports Designer, or through any other approach. Or has anybody been successful in re-creating the AP150 out...
6 1407
by  GiuliaJump to last post
07/15/2014 9:27 AM
3 Replies and 1093 Views Tax Codes and Imaging Solution into AP20.2  1093  3 Started by  Bill We are using Perceptive's ImageNow to scan our AP Invoices and add our financial accounting information. We have been a non-profit entity until our recent acquisition of some practices that are for profit. That being said we are having issues with trying to get the proper information to flow into Lawson AP20.2. Does anyone else have this in their world and could offer any tips Thanks!
3 1093
by  BillJump to last post
07/11/2014 10:46 AM
4 Replies and 11985 Views Patient Refund .CSV file  11985  4 Started by  Deleted User I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice
4 11985
by  John HenleyJump to last post
07/07/2014 2:12 PM
2 Replies and 960 Views GL190 - (GL190.prt) modify sort order  960  2 Started by  Tom When I run a GL190 journal posting, I would prefer that the journal posting report (GL190.prt) sort in Company order (it appears the current primary sort is by company but the company numbers are out of order). Can the sort order of the journal posting report (GL190.prt) be modified and, if so, where would that be done Thank you.
2 960
by  TomJump to last post
07/01/2014 3:05 PM
2 Replies and 1382 Views GL20.2  1382  2 Started by  whitey1287 I am trying to update GL20.2 via Add-ins. In the upload I have as my headers: 1._f2:GLN-COMPANY 2._f3:GLN-ACCT-UNIT 3. _f6:GDT-ACCOUNT 4.Sub 5._f1:FC 6._f1:More 7._f29:GLM-ACTIVITY-REQ 8._f33:GLM-ACCT-CAT When I run the upload on thr first row as a test, the result is 'cannot add/delete/change blank detail lines,' but I have each field filled. Any help on what I am doing wrong is very much appreciated. Thanks
2 1382
by  whitey1287Jump to last post
06/19/2014 3:00 PM
0 Replies and 677 Views Lines in MA43  677  0 Started by  BenignVanilla I am looking for documentation on the MA43 screens, and the process of adding line items. Can anyone point me towards a user guide on this process I am trying to debug a process that is adding invoices via AP20, and line items via MA43. We are seeing a condition where the AP20 works fine, the MA43.1 works fine, but when we look at the AP20, the goods amount is twice the invoice amount, even if a single line item exists for the proper amount. When I drill around into the invoice lines, the line ...
0 677
06/16/2014 2:39 PM
4 Replies and 1166 Views Using a WellsFargo Commercial Card in AP  1166  4 Started by  LeslieP The bank wants us to submit a file that can include ACH, Checks and C-Card payments. The file can be either processed immediately or the various parts manipulated in their CEO module. AP161 has some of the information but not all and would require major re-working. Which I can do. But I don't have a test system to play with so I am going to have to test on prod...or build a new productline to test with. Neither of which are appealing. I am considering running the payments through like an...
4 1166
by  Greg MoellerJump to last post
06/04/2014 2:51 PM
0 Replies and 2631 Views Report Writer Training Manual  2631  0 Started by  Vince Does anyone know of a link to a copy of the Lawson Report Writing training manual I Have been out of Lawson for many years and need to refresh my memory. The user guide is not much help.
0 2631
06/02/2014 4:37 PM
3 Replies and 1725 Views Asset Mgmt partial disposal  1725  3 Started by  Diane G We recently purchased land to build a branch office, but did not need all of the land we had to buy. The land was added as one asset with a quantity of 1. We sold off the portion of the land not needed. Now I need to dispose of a percentage of that asset. However, Asset Mgmt won't let me do that because a partial requires a quantity of more than 1. Any ideas
3 1725
by  JRC3769Jump to last post
05/13/2014 1:00 PM
0 Replies and 794 Views Adding additional costs to assets after placed in service  794  0 Started by  erical77 Our fixed asset person is out on medical leave and we don't have contact with her. If I recall, if we need to add to an asset already placed in service, via AM20.3, then this will not show up on an asset addition report. Is this correct Is there a way to rectify this For rollfward and reconciling purposes and for year-end audit, it is much cleaner if this adjustment/addition shows as a current year addition. Thanks for your help.
0 794
05/05/2014 9:04 AM
9 Replies and 1242 Views ESS Pay  1242  9 Started by  Chesca Emp can log into Lawson fine, but no data is displayed for her under paychecks, leave balances, etc. I have no idea how to troubleshoot this one. Any suggestions would be greatly appriceated. &91;IMAGE:755&93;
9 1242
by  ChescaJump to last post
05/02/2014 10:17 AM
2 Replies and 1132 Views Invoice Approval using ProcessFlow  1132  2 Started by  Ollerton I am looking for advice on creating a processflow for invoice approval. I envision using process flow for invoice header and some cases line item approval routed to different departments. I would like to utilize department number for the filter category for the inbasket records. I have not seen anywhere we can associate department number on an invoice. We do incorporate department number in our accounting units so we could use that. If anyone has any advice or sample flows to share I would ...
2 1132
by  OllertonJump to last post
04/30/2014 10:48 PM
2 Replies and 1229 Views Reconcile Received not invoiced between IC and AP  1229  2 Started by  Mary Porter Our Finance department is asking for a report to reconcile the General Ledger PO Receipt Accrual account. The report must compare Inventory Control data for RNI against AP invoiced items, similar to the PO135, so that the AP dept and Materials dept can work the exceptions and close the open receipts. Does anyone have anything or know of any Lawson canned reports that would help them accomplish this
2 1229
by  DaveJump to last post
04/30/2014 7:18 PM
0 Replies and 740 Views sales tax partner  740  0 Started by  tdwcpa I am searching for a sales tax partner for Lawson S3. Please provide recommendations.
0 740
04/22/2014 8:24 PM
0 Replies and 799 Views PR85 - reopen void  799  0 Started by  StacyR Payroll did a void on a payment but posted to the wrong year (2015 vs 2014). Is there a way we can correct this When trying to 'reopen' the void thru PR85 we received the message 'cannot reopen; reversal has been closed'. Has anyone else ran into this and been able to correct
0 799
04/22/2014 10:14 AM
1 Replies and 871 Views Location of GL40.1 attachment comment text  871  1 Started by  Donna What table contains the field that contains the journal entry attachment comments which can be entered in GL40, GL41 or GL45
1 871
by  DonnaJump to last post
04/16/2014 10:52 AM
2 Replies and 1303 Views GL199 Company Values changing  1303  2 Started by  Austin We have come into an interesting issue when some of our companies are running their GL199 closing. The issue is sporadic & not consistent across other companies. What we are seeing is that the company value is changing somehow from a numerical value (eg. 3201) to an 'otoc' value somehow. Has anyone ever come across this here is an excerpt from the exam log of the job below. What makes this more interesting is when we actually recover the job, it completes successfully. Infor has added slight re...
2 1303
by  AustinJump to last post
04/15/2014 2:46 PM
0 Replies and 644 Views Activity Group POP- RNI Interface  644  0 Started by  Ian Does anyone know the answer to the following question I am using the Period of Performance AC10.6 at the Activity group level to stop PO's being set up against a project after a certain date but still allow all other transactions to go through against an activity. I have tested this scenario and everything seems to work. However, the only piece I am not sure of is if the RNI accrual would hit the activity. The RNI accrual has a PO R_System code and I was wondering if the RNI accrual would st...
0 644
04/09/2014 2:30 PM
0 Replies and 708 Views BR120/130 not balancing  708  0 Started by  Basia Has anyone turned burden calculations on and by turning them on, did it throw off your BR120 and BR130 balance
0 708
04/09/2014 1:51 PM
1 Replies and 1410 Views Using MS Excel Database Connection Wizard  1410  1 Started by  Michael Ewing Recently participated in a process review with Infor consultants; one of the recommendations for the Financial users was that they try to use the capabilities of the MS Excel Data Connection Wizard for working with the Lawson/Infor data. Is it possible to connect MS Excel to RW100 reports using an ODBC connection Or do we need to use the OLEDB connector to do this If anyone has done this, would greatly appreciate your sharing a sample of the process. Also, if you could share comments...
1 1410
by  AriJump to last post
04/07/2014 4:51 PM
1 Replies and 811 Views AR20 batch processed under wrong process level  811  1 Started by  Basia Hello....we processed an AR20 batch under the incorrect process level in Lawson. The batch is released and processed (AR190 and 195 have been run as well). Is there are way we can assign this batch to a different AR process level Any help would be greatly appreciated. Thanks in advance.
1 811
by  BasiaJump to last post
03/28/2014 2:40 PM
3 Replies and 2566 Views GL90 csv export name  2566  3 Started by  Mark S Does anyone know how the name of the export file is built We are having an issue when the path name the file name exceeds 60 charaters. It truncates the file name (i.e somtimes we get ...print1.cs....print1.c....pri...).
3 2566
by  DebbieKJump to last post
03/27/2014 1:49 PM
4 Replies and 2400 Views DIFFERENCE B/W COST CENTER AND ACCOUNTING UNIT  2400  4 Started by  batmanprime Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT
4 2400
by  Kat VJump to last post
03/24/2014 10:44 AM
0 Replies and 514 Views Discount with no Net Due  514  0 Started by  Bill Does anyone else have a customer that gives a discount regardless of the due date We are trying to set up the terms to take the 2 discount but does not have a due date. Any thoughts
0 514
03/20/2014 7:54 AM
2 Replies and 934 Views GL double posting LP accruals  934  2 Started by  Chesca My users ran LP198 twice and we now have double posting entries in GL. We are trying to figure out how to reverse this, but nobody in finance have any idea how to. There is a screen GL40 that we normally would use but doesn't have LP only TA. I have attached a sreenshot showing all the sytems except LP. Any suggestions/ideas would be greatful. Thanks
2 934
by  ChescaJump to last post
03/11/2014 1:02 PM
0 Replies and 1196 Views CB185 Cash code not found for bank  1196  0 Started by  Billy Andrews I am adding P-card payment processing at a shop that uses Lawson AP for expense vendor payments and a separate AP system for trade vendor payments. The trade vendor payments are interfaced from the separate system into Lawson via CB500 and reconciled in Lawson. This arrangement has been in use for paper checks with no problems for a long time. I set up a cash code, transaction code, etc. for the P-card payments to expense vendors, and got the outbound electronic file from AP165 going with...
0 1196
02/27/2014 2:28 PM
2 Replies and 970 Views Employer Medical Insurance Costs posted to GL  970  2 Started by  scuba80 Starting in 2014, employer medical insurance premiums are now being tracked in Lawson to report on W2. Prior to this, ther was a manual work around and the employer costs were not in the sysytem. Now that the employer premiums are in Benefits they are posting to the GL causing an astronomical increase to our payrol expense. Is there a way to shut those codes off so they do not post to the GL but we still can report on them.
2 970
by  scuba80Jump to last post
02/26/2014 3:40 PM
0 Replies and 1245 Views Open Payables Report  1245  0 Started by  AP Clerk There are invoices/credits on the report that should be removed. Example: An invoice was entered and then a credit for the same amount was entered. The net result is zero. However the two line are still showing on the report. I tried to remove the lines by AP35. However, it shows no invoices for that vendor. The invoices are prior period/year. Does that matter Or, could I remove the two lines by AP55--even though it is prior period Thanks for your help. I have asked several people i...
0 1245
02/22/2014 1:25 PM
0 Replies and 867 Views AP240  867  0 Started by  AP Clerk After running AP240, there were no hold invoices on the report. However, there were several 'out of balance' invoices. I can go to AP30.3 or 30.4 to adjust amount--my question is--if the invoices are a prior period/year, should the adjustments be done differently
0 867
02/22/2014 1:20 PM
2 Replies and 1038 Views Best Practices for tracking Discounts on Purchase Orders  1038  2 Started by  Margaret We want to track discounts on purchase orders. Our procurement department tried to do this by adding a negative AOC, but that caused a lot of issues when accounts payable tried to enter the invoice. Any tips or suggestions on how to track this Thanks, Margaret
2 1038
by  Kat VJump to last post
02/19/2014 3:58 PM
0 Replies and 1894 Views Journal Entry Data dump  1894  0 Started by  MarirajSankar Hi All, I need query for a data dump of all the GL transactions for 2013 for company X and Y for the year end audit for 2013. I tried but got confused about tables. Here i used only two tables GLCONTROL and GLTRANS Please anyone help on this query. select CONVERT(VARCHAR(4),GLC.COMPANY)'-'CONVERT(VARCHAR(4),GLC.FISCAL_YEAR)'-'CONVERT(VARCHAR(4),GLC.ACCT_PERIOD) '-'CONVERT(VARCHAR(4),GLC.SYSTEM)'-'CONVERT(VARCHAR(4),GLC.JE_TYPE)'-'CONVERT(VARCHAR(4),GLC.CONTROL_GROUP) as JE,CONV...
0 1894
02/19/2014 3:36 PM
2 Replies and 1455 Views Uploading Assets into Lawson Asset Management  1455  2 Started by  Ash I am currently researching how to start uploading assets in a fast and easy way. The current method I use to capitalize assets is to see when an invoice payment hits my asset clearing account and then finding the invoice and keying the asset in using AM20.1. Nothing is automated in my system, so there are no asset templates assigned to invoices or POs. In all the forums I have read so far nothing has fit my particular situation. Just looking for any help anyone can give me. I am fixing to h...
2 1455
by  AshJump to last post
02/19/2014 1:29 PM
2 Replies and 967 Views Nee help figuring out activity structure  967  2 Started by  Basia We currently have activities/grants for Research and Capital however our Marketing department has just requested a new and separate activity structure in Lawson/Infor. I need help in establishing a structure since this will be completely different from our current. What steps should I take to setup a Marketing activity Group that does not want budget editing turned on and only wants to use Activities to monitor their expenses. Any help would be greatly appreciated. Thanks!
2 967
by  BasiaJump to last post
02/19/2014 8:51 AM
1 Replies and 1124 Views PO20.1  1124  1 Started by  MChism Hey guys! I need help again, I am attempting to add a special item into a purchase order. I have done this on several occasions and have never had any issues. Now it is telling me that I can not add the item for this reason: 'Vendor Agreement and/or payment terms cannot be combined'. Does anyone know why it is throwing this error or how to fix it ~~~I have attached a screen shot of the error message. ~~~
1 1124
by  Kat VJump to last post
02/14/2014 1:29 PM
3 Replies and 1589 Views Open A/P Invoices  1589  3 Started by  martyzoet How do I get a list of all open A/P invoices that were open as of a certain date
3 1589
by  BShortJump to last post
02/11/2014 7:54 AM
2 Replies and 1260 Views Lawson Financials S3 Archive/Purge Solutions?  1260  2 Started by  R. Lapierre We are currently looking for a Lawson Third Party Vendor Product with Financials S3 Archive/Purge Solutions We are currently looking at the NTTDATA's 'PARCr2' and Absolute's 'Archive.S3' Product Solutions. Are there any other third party products out there for the Lawson S3 Financial Suite Thank you, Ron Lapierre
2 1260
by  R. LapierreJump to last post
02/07/2014 3:25 PM
0 Replies and 878 Views GL190 journal posting sort order  878  0 Started by  Tom When I run a GL190 journal posting, I would prefer that the journal posting report (GL190.prt) sort in Company order (it appears the current primary sort is by company but the company numbers are out of order). Can the sort order of the journal posting report be modified and, if so, where would that be done Thank you.
0 878
02/03/2014 4:22 PM
1 Replies and 3465 Views Functional user manuals for V 9.0.1  3465  1 Started by  wanda2013 Does anyone know where i can get functional manuals for S3 version 9.0.1 I mean functional user manuals, not the official Lawson user guide (with about 500 sheets ...) I need to provide training regarding Lawson S3 Financial Suite (AP, AR, AM, CB and GL). I have it in a week and i have no time to make them!! :(
1 3465
by  JimYJump to last post
02/02/2014 5:23 PM
1 Replies and 2211 Views AM 255 Depreciation Projection  2211  1 Started by  Boyd Earlier this year we upgraded to v 9.0.&160; In the old version of Lawson 8.03 I&160;was able to export the AM 255 to excel and you would see the information as it appeared on the PDF report.&160; In version 9.0 the projection information is summarized by year for each asset.&160; Does anyone konw how to change this.&160; I also tried to change the flag on Assets in Other Output options to 'D' Detail, but this exported the informaiton by month into three different columns.
1 2211
by  EllenPJump to last post
01/27/2014 4:10 PM
4 Replies and 3239 Views Too Many Decimals  3239  4 Started by  MChism We have a few vendors that use half quantities when ordering. For example an order of envelopes comes in a box of 2,500 we use the UOM of 'M' and typically enter the order for 2.5. Recently we are having issues with Lawson not allowing us to use decimals giving the error message 'too many decimals entered'. Is there a way to fix this We are now trying to match invoices to the PO's and obviously they are not matching becuase the PO will show 2M and the invoice will show 2.5M. Any help would be g...
4 3239
by  MChismJump to last post
01/23/2014 12:30 PM
0 Replies and 745 Views Financial Roll reporting  745  0 Started by  Randy Not sure if this belongs here or LBI. Has anyone had success customing reports that would whow accounting unit summary at highest level, then the next levels downward I'm thinking the dbo.GLCONSOL table would be a start, but wonder if anyone has completed this and how
0 745
01/13/2014 3:49 PM
10 Replies and 12060 Views Budget Upload  12060  10 Started by  jjcyeshua Hello!... lawson people.... I'm in the process of uploading a budget from excel spreadsheet to FBDETAIL, but i can't seem to find the form that would let me add new budget. Knowledge Search in says that i have to use budget interface to convert the new budget data that i have, but when i access FB165 its only generating report. Where should i start the process of uploading the budget and how.. Thanks again in advance
10 12060
by  TesterJump to last post
01/07/2014 4:13 PM
5 Replies and 2044 Views PO230 Error  2044  5 Started by  MChism Each month before month end we run a few jobs to make sure month end goes smoothly. One of those reports is a PO230 report (Unreleased Receiving List). This month we have 5 PO's show up. From the notes that I can find the way to clear them is by going into PO30 and 'release and print' however when I do that it tells me that 'receiver has no line; cannot release'. I have no idea what needs to happen for these items to get cleared before month end. Any insight would be great!
5 2044
by  JonAJump to last post
12/27/2013 3:43 PM
4 Replies and 1125 Views Asset Transfer Load in AM30.1  1125  4 Started by  Ian HI, I have 2000 assets that need to be moved from Account Unit to another within the same company with Asset Management. I am on Lawson 9.1. I have tried to upload into the AM30.1 screen but I am getting the message 'Asset type does not exist'. I know for sure that the asset Type does exist. Has anyone had issues with this before and can you give me insight into where I am going wrong Your help is very much appreciated.
4 1125
by  IanJump to last post
12/23/2013 11:51 AM
5 Replies and 2784 Views Defaulted Payment Terms  2784  5 Started by  Deleted User When entering an invoice in AP20.1 can the default vendor payment terms populate in the pmt terms field when the Vendor is selected Otherwise you have to drill into the vendor number and find out what the default is to know it you need to change it in the AP20 field. Our Data Entry staff would like to know if the field can auto populate from the vendor record.
5 2784
by  dcaianiJump to last post
12/17/2013 8:30 AM
4 Replies and 1110 Views Company Status = Test  1110  4 Started by  Kelly Hello! This is my first post on this forum so go easy on me! :) We are on v9.0.1 and I need to create a new company (which I might be able to copy from another). I first have to check to see if the same AUs are going to be used. I'd rather not copy them over with the company copy and then inactivate them in the new company. This new company will use system codes: GL, AP, CB and RJ. If the company is designated as Test status, is there anyway to truly test the subsystems posting to the GL...
4 1110
by  DeronJump to last post
12/12/2013 3:40 PM
1 Replies and 982 Views AR/BL from Lab Software to interface w Lawson  982  1 Started by  This_Guy Hi There - We have a Lab Application that will be interfacing with the Lawson Billing for all Client Lab Charges. I see the bL520 out there and will probably look to use this for replacing the manual efforts. However, the problem I am running into is the 'Fee Schedule' per Lab Test. For example, Customer 1234 takes Blood Test Ab123 that fee is $30/test - but, the same test AB123 is taken by Customer 6789 and that fee is $50/test. This presents the problem, so does anyone out there have a sim...
1 982
by  Ken UJump to last post
12/10/2013 6:13 PM
0 Replies and 878 Views LPA/IPA naming standards  878  0 Started by  Erin We have Interfaces that start with an assigned interface number (e.g. I114APInterface). Subsequent IPAs that are from called within the main IPA are named free-form (e.g. APControlReport, APMatrixReport, APVendorList) This makes it difficult to know by site what triggers or relates to what without checking out the IPA and review or having a reference doc. Anyone care to weigh in on the plusses and minuses of naming For example, if the above I114APInterface runs and you see APControlRe...
0 878
12/06/2013 4:54 PM
0 Replies and 754 Views Invoice Matching Workfile Cleanup  754  0 Started by  Sandy L We are running Lawson Financial version 9.0 on an IBM I. There is a work file, MATPRLWR that is now almost 10 GB with 936 members. I would like to remove the majority of these members but I am not sure if it will hurt anything else or if perhaps there is a menu option within Lawson that I could run to clean up this file.
0 754
12/04/2013 8:03 AM
0 Replies and 1443 Views Death notice of LACOBRTS  1443  0 Started by  National Trust for Historic Preservation Mon Dec 2 11:22:15 2013: ERROR: Exited with error code 1 Ɖ“…ÓÁæÁ××ùaÁÙ×èÔÕãÈÄÙKƉ•„ÄÂÙ…ƒ…™™–™‰¢Ä£‚¢……™™–™Mùô&93;KÁ„„‰£‰–•“ã…§£‰¢zƉ•„☓مƒM“¦——ù„‚KÄÂÁÙÁ×Èkð&93;ÄÂòÆÁãÁÓÅÙÙÖÙ†–™âØÓŧ…ƒ¤£…`Ö„…zõõðñùa`÷ððøÄÂÁÙÁ×ȉ•ÓÁæÁ××ùÄ•–£¥“‰„†–™–—…™£‰–•KÉÕÆÖÙÔÁãÉÖÕÆÙÖÔãÈÅÓÁãÔKÓÖÇcTPCrash): Received death notification of lacobrts, Uid=14, Pid=719239 Mon Dec 2 11:22:15 2013: Program Code = AR21 , DataArea/DataID = LAWAPP9 Mon Dec 2 ...
0 1443
12/02/2013 12:55 PM
2 Replies and 896 Views Remove a displayed benefit in the add beneificiaries ESS  896  2 Started by  Deleted User I have never worked with Employee Self Service; can I remove one of the displayed benefits from the Beneficiaries display. We do not want employees to be able to add beneficiaries to one of the defined benefits. Thank you if you can help.
2 896
by  LisaJump to last post
11/25/2013 4:46 PM
1 Replies and 814 Views AP155 Payer Address on File  814  1 Started by  Jeremy When running the AP155, can you make it include the payer's address also or does that have to be coded into whatever software (such as MHC) you use to print the checks
1 814
by  JeremyJump to last post
11/20/2013 4:55 PM
3 Replies and 786 Views Online Entries & Interface Source  786  3 Started by  Erin We are using the R_DESC column 'Interface Transaction' to tell us if an invoice was entered online or through an interface. Now we need to determine what external systems are sending in the invoices. Is there a way to determine which system e.g. Billing is sending the interface transaction
3 786
by  John HenleyJump to last post
11/15/2013 12:28 PM
3 Replies and 5601 Views Infor’s Lawson Accounts Payable Invoice Automation system  5601  3 Started by  DougAB I'm curious to know if anyone uses Infor’s Lawson Accounts Payable Invoice Automation system, or any invoice automated system. We deal with many suppliers that send their invoices via EDI, email, and csv files. We want a way to flow these invoices into Lawson and automate the matching process. We'd deal with the fallouts thereafter. Any help is appreciated. Thanks.
3 5601
by  John HenleyJump to last post
11/08/2013 1:07 PM
1 Replies and 1333 Views AP520 and One Time Vendor  1333  1 Started by  jbertoli We would like to upload stipend type of AP invoices. We want to give them the same invoice number (like XXX Stipend) and use the One Time Vendor flag so it will create vendor numbers. Has anyone done this
1 1333
by  brainetJump to last post
11/01/2013 9:22 AM
2 Replies and 757 Views Employer Issued Credit Cards - Where Maintained  757  2 Started by  BradF Is there anyone who does this
2 757
by  Greg MoellerJump to last post
10/31/2013 8:55 AM
8 Replies and 2275 Views Loading Fixed Assets into Lawson AM  2275  8 Started by  Ian I am trying to load new assets from a legacy system into Lawson AM. I have uploaded the assets into the system using AM96.1 (AMASSET), AM97.1(AMASTITEM) and AM98.1 (AMASTBOOK). Everything uploaded successfully. However, When I progress to process then using AM500 I get the following message in my report. 'Conversion nbr exists in AMCNVASSET file, use AM300 to purge' At this point I have run it in non-update mode. Can anyone tell me what this means before I proceed any further It appies...
8 2275
by  Bob CanhamJump to last post
10/24/2013 2:34 PM
1 Replies and 990 Views Converted Assets Not Calculating Depreciation  990  1 Started by  Joanna We are in the process of converting our fixed assets into Lawson. We uploaded the data to populate AM 96, AM97 and AM98. We then ran AM500 and AM170. After that, we ran the AM580 and depreciation is not calculating. Any ideas what to look for
1 990
by  IanJump to last post
10/23/2013 6:04 PM
1 Replies and 907 Views Restricted Funds  907  1 Started by  Vince In the past I have worked at a place that ran all restricted fund transactions through an account (net Assets) on the balance sheet. Now at a place installing Lawson and the cosultant wants transactions through a cost center in the P&L. What do others do I would prefer all through balance sheet.
1 907
by  Bob CanhamJump to last post
10/22/2013 12:14 PM
0 Replies and 767 Views Audit Data? EFT/Banking Information in AR  767  0 Started by  Garth Gerwing There are multiple UI's in the AR module requied to be used to define and maintain EFT-related data: - AR09.2 - Banks - updates table DTCUSTBANK - AR09.6 - EFT - updates table DTCUSTBANK - AR09.5 - EFT Notification - updates table FTCUSTNOTE -------------------------------- However - there appears to be no auditing, by the application, of users having added or maintained this sensitive data (confirmed by Lawson Engineers). The only AR auditing appears to...
0 767
10/21/2013 3:04 PM
0 Replies and 1256 Views Cost Allocation  1256  0 Started by  SN Hi, I am new to the cost allocation module and I need help to understand CA and its links to FB and GL module. I currently have an issue where the amounts for certain AU-Account-sub account combination have values where some combination dont. As far as my understanding goes, once CA110 is run, the cost is allocated according to the mentioned allocations in CA10. Once CA190 is executed the values then moved to GL. Question: What are the sources from where CA110 is getting its input v...
0 1256
10/21/2013 12:25 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 9 << < 12345 > >>

RSS Feed Available