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 2 of 5 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
5 Replies and 1779 Views CB554  1779  5 Started by  Chesca Would anybody have an idea how the CBPMTLOAD table is loaded or why it would be empty My user is getting an error when submitting the CB554 job and the error suggest there was not any data to process for that run group. I ran a query and indeed there is nothing in this file.
5 1779
by  Bob CanhamJump to last post
05/27/2015 3:59 PM
1 Replies and 799 Views How to find account balances?  799  1 Started by  wally Is there a screen where I can see an accounting unit and all the accounts with their current balances Also which table can I pull this information from. Thank you!
1 799
by  gradtkeJump to last post
05/27/2015 2:05 PM
0 Replies and 970 Views $0 AP invoices  970  0 Started by  gradtke We prepay many of our vendors, so we don't get invoices from them...at least not invoices that we enter into Lawson. Back in Lawson 7, we could enter $0 AP invoices and match them to the PO receipt. As of Lawson 8, we could no longer enter $0 AP invoices into Lawson...so we would create $.01 AP invoices. This just floods our AP with $.01 invoices. MA80 and MA180 just don't seem to be the type of solution that our accounting group is looking for. Does anyone else have a solution they are wil...
0 970
05/27/2015 1:41 PM
4 Replies and 1247 Views Need to find exists table (GL20.2)  1247  4 Started by  wally I need to use addin's to pull information regarding Accounting Units and accounts that have a the relationship say yes it exists (GL20.2). I don't know what table the 'exists' field lives. Anyone know
4 1247
by  DennisMJump to last post
05/20/2015 4:39 PM
2 Replies and 1322 Views Billing Distribution  1322  2 Started by  Loger98 Hey Guy's, Just joined a new company that does monthly billing by emailing invoices on a per partner basis after being released and printed(by the print manger). Imagine sending out 500 emails to different partners. Is there a way to automate this (we use the excel add on to upload/creating the invoices) I am just wondering what other company's do in such matter. I can also provide more information if needed. Thanks.
2 1322
by  NicoleGrassJump to last post
05/07/2015 12:35 PM
0 Replies and 928 Views Financials S3 integration - 3rd party software  928  0 Started by  kal800 Hi, Our company is a developer of Account Receivables suite (invoice distribution, outstanding monitoring, dispute workflow, collection workflow, etc). We have done integrations with many ERP systems - SAP, Oracle, Axapta, etc. As a matter of fact, our potential customer is using Lawson Financials Suite S3 and asks us about the posibility to get integrated. We are doing integration in three areas: 1. Issued invoices - in case of SAP we are fetching iDoc messages using webservice 2. Custo...
0 928
04/10/2015 6:04 AM
0 Replies and 869 Views Posting Hours to General Ledger  869  0 Started by  Nicole M How do you separate shift differential hours or on call hours from posting to the general ledger We need the dollars posting but not the hours because these are not paid hours to calculate FTEs. I see a flag called Post Hours in prtime table. What does this do
0 869
04/09/2015 9:32 AM
9 Replies and 7989 Views AP160 and AP161  7989  9 Started by  Carlotta McCormick You've probably all hashed this to death, but I need assistance. We are using the AP160 currently for our ACH transmission to the bank. We want to use the Remit file to send electronic remittances using MHC's e-Remit software. Our problem is that the Remit file doesn't include vendor location information so that I can link to the databases to pull email information. Example: We have a vendor on AP10.1 that gets checks, but one of their locations on AP10.2 gets ACH. The AP160 Remit doesn't ...
9 7989
by  DebbieAmExJump to last post
04/08/2015 10:37 AM
0 Replies and 1320 Views New Company G/L Setup  1320  0 Started by  Ron Swanson The company I am supporting created a new company in FY 2014 after declaring bankruptcy and closing the old company number. The new company actually stated in Period 03 of FY 2014. It appears the person that set up the new company put the equivalent of Beginning Balance Amounts in the DB or CR fields for Period 03. From there, JE's posted to the accounts through the remainder of the year. At the end of the FY 2014 some issues came up with balances and the rollover to 2015. I think...
0 1320
03/27/2015 2:10 PM
5 Replies and 1679 Views 3rd Party Check Printing  1679  5 Started by  gradtke We are looking for some ideas related to 3rd party check printing. How secure they are etc... How are people pulling the check file from Lawson after they run AP155.
5 1679
by  Todd MitchellJump to last post
03/25/2015 12:02 PM
0 Replies and 838 Views How to upload/import an externally managed CoA for the GL  838  0 Started by  LawsonIntegration To preface, I'm new to inbound Lawson GL technical integrations. I've sourced from it plenty of times but never wrote into it. We are looking to upload an externally managed Chart of Accounts to Lawson as a regular business process to keep various GL systems (not all Lawson) in synch with corporate mandated 'common CoA'. We can create pretty much any format, parent/child, generational, xml, etc but can't find any documentation of how this is done for Lawson GL. Is it as simple as just writ...
0 838
03/17/2015 10:55 AM
0 Replies and 622 Views AP160 to Pay State Withholding  622  0 Started by  Deleted User Good afternoon - not a lot of AP info available..... Is anyone using AP160's NACHA format to pay state withholding taxes Hoping I may be able to pick your brain! We're currently using AP161 and a custom program to reformat that file, but would rather use out of the box if possible. Thanks!!
0 622
03/16/2015 12:37 PM
6 Replies and 1596 Views AP270 Report  1596  6 Started by  Chesca Hello, I am looking for the information on the AP270, if possible to get the cost center and the expense account, which table should I pull from Any help would be great.
6 1596
by  ChescaJump to last post
03/09/2015 12:36 PM
3 Replies and 1517 Views AP Vendor's payment address  1517  3 Started by  Chesca Hello, hope some can help me out here. We have a custom program that creates a vendor's payment history report. It reports vendors ID, name, tax ID, invoice amt, Net Payment Amount, class, and address. The only problem is the some of the address are incorrect because they want to see not the main address but the transaction address. So if a vendor's main address is in IL, but they did the transaction in WNY, the it should report the WNY address. I don't know where this address would be store ot...
3 1517
by  jjcyeshuaJump to last post
03/05/2015 5:27 PM
0 Replies and 986 Views AL tax payments  986  0 Started by  Deleted User Good afternoon - looking for some information regarding paying the state of Alabama withholding taxes via ACH with AP161. According to our users, they have to go to the AL website, and file a report prior to sending the dollars. When the report is filed, they receive a confirmation number, and they have to re-enter this when paying the tax via ACH Doesn't make a lot of sense to me.... So, if you use standard Lawson/Infor AP and pay AL state withholding via AP161, would you share your process...
0 986
02/24/2015 2:56 PM
1 Replies and 1414 Views 1099 State income/tax reporting  1414  1 Started by  Kimm We just found out that Lawson does not support our state's requirement of reporting income and taxes withheld on 1099 forms/filing. This year we can file manually with the State but going forward, we're wondring if anyone has solutions for housing and reporting the state income and tax withheld for both printing and electronic filing We can use the combined State/IRS filing but we still need to report the state data directly. Thanks for your help!
1 1414
by  jjcyeshuaJump to last post
02/10/2015 5:08 PM
2 Replies and 1031 Views Customer Comments in AR  1031  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 1031
by  Todd MitchellJump to last post
02/05/2015 9:30 AM
2 Replies and 1361 Views Asset Managment - 8.1  1361  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 1361
by  Ron SwansonJump to last post
01/15/2015 2:28 PM
1 Replies and 1494 Views APINVOICE OPERATOR  1494  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 1494
by  John HenleyJump to last post
01/05/2015 4:11 PM
0 Replies and 935 Views AR199 Year End Close Mistake  935  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 935
01/05/2015 1:10 PM
1 Replies and 1266 Views Inactivating a company  1266  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 1266
by  Jimmy ChiuJump to last post
12/17/2014 2:34 PM
0 Replies and 989 Views Aging Reports (AR251) I.P.A.  989  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 989
12/15/2014 3:48 PM
0 Replies and 823 Views Asset Managment  823  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 823
12/15/2014 12:50 PM
2 Replies and 1211 Views Process Level Restriction  1211  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 1211
by  Dee HardyJump to last post
12/09/2014 1:19 PM
1 Replies and 1066 Views G/L Date Error  1066  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 1066
by  dcaianiJump to last post
12/05/2014 2:40 PM
1 Replies and 1209 Views PO25 Contract Agreements  1209  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 1209
by  JonAJump to last post
11/26/2014 1:39 PM
1 Replies and 1068 Views ERP Selection  1068  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 1068
by  alexrsJump to last post
11/18/2014 6:34 AM
0 Replies and 799 Views Staging table for AP comments  799  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 799
11/17/2014 10:36 PM
1 Replies and 1250 Views AP14.5 TIN Type Change with Add-Ins  1250  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 1250
by  jjcyeshuaJump to last post
11/13/2014 6:49 PM
2 Replies and 1091 Views Writing an Income Statement in crystal  1091  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 1091
by  jjcyeshuaJump to last post
11/12/2014 2:29 PM
5 Replies and 1321 Views Non-AR Backout  1321  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 1321
by  Ken UJump to last post
11/06/2014 2:59 PM
0 Replies and 856 Views Allocations  856  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 856
11/04/2014 11:44 AM
6 Replies and 3993 Views ACH and EDI  3993  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 3993
by  jj2020Jump to last post
10/31/2014 11:03 AM
0 Replies and 1011 Views Invoice entry AP20.2 Discounts AP22.3  1011  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 1011
10/23/2014 5:06 PM
7 Replies and 1801 Views Asset Management with 2 books??  1801  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 1801
by  jjcyeshuaJump to last post
10/22/2014 3:48 PM
2 Replies and 2333 Views Lawson Depreciation Reports  2333  2 Started by  JFutrelle Hey guys, I'm rather new to Lawson. We're running version 9.0.1.9.153. 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 2333
by  jjcyeshuaJump to last post
10/20/2014 4:00 PM
0 Replies and 674 Views GM System control  674  0 Started by  whitey1287 Is there a GM system control closing job Similar to the other closing jobs
0 674
10/13/2014 11:40 AM
0 Replies and 873 Views Intercompany Relationships  873  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 873
10/03/2014 2:11 PM
0 Replies and 826 Views Foreign Vendors and 1042S Reporting  826  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 826
10/03/2014 11:00 AM
1 Replies and 1201 Views Invoices in AP36  1201  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 1201
by  darwin collinsJump to last post
10/02/2014 9:24 AM
7 Replies and 4510 Views Balance Sheet Report  4510  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 4510
by  AliseJump to last post
09/23/2014 3:37 PM
1 Replies and 1520 Views Accounts Payable Invoice Automation Invoice Scanning  1520  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 1520
by  Any ideas?Jump to last post
09/09/2014 11:24 AM
0 Replies and 1046 Views Load AP161 with Separate Payment & Remit to Document Express  1046  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 1046
09/09/2014 9:51 AM
0 Replies and 961 Views Changing Fiscal Year-end Date  961  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 961
09/04/2014 12:20 PM
0 Replies and 937 Views How people track Customer Comments In AR?  937  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 937
08/26/2014 5:27 PM
1 Replies and 821 Views Prenotification without processing via alternative method  821  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 821
by  Mark F. HardyJump to last post
08/26/2014 10:23 AM
0 Replies and 807 Views Tax Reports/Queries by Accounting Unit???  807  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 807
08/19/2014 1:28 PM
1 Replies and 929 Views Override Base Zone on JE Header  929  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 929
by  BShortJump to last post
08/19/2014 12:27 PM
2 Replies and 1102 Views APINVOICE: MATCH_STATUS and MTCH_ERR_TYPE  1102  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 1102
by  JonAJump to last post
08/18/2014 11:54 AM
1 Replies and 1041 Views Cannot delete non-GL journal entries GL45  1041  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 1041
by  Ragu RaghavanJump to last post
08/14/2014 11:32 AM
3 Replies and 5558 Views Recurring Journal Entries  5558  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 5558
by  dcaianiJump to last post
08/07/2014 1:36 PM
10 Replies and 9986 Views How to Upload Journal Entries  9986  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 9986
by  John HenleyJump to last post
07/24/2014 1:54 PM
3 Replies and 821 Views AC20.4_Activity Budget by Activity  821  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 821
by  whitey1287Jump to last post
07/24/2014 12:22 PM
3 Replies and 1501 Views Cash Book Poor Performance  1501  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 1501
by  John HenleyJump to last post
07/17/2014 2:46 PM
1 Replies and 1765 Views PA52.1  1765  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 1765
by  Jason BeardJump to last post
07/16/2014 9:03 PM
6 Replies and 1522 Views Add Image Link in AP150 Output  1522  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 1522
by  GiuliaJump to last post
07/15/2014 9:27 AM
3 Replies and 1189 Views Tax Codes and Imaging Solution into AP20.2  1189  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 1189
by  BillJump to last post
07/11/2014 10:46 AM
2 Replies and 1031 Views GL190 - (GL190.prt) modify sort order  1031  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 1031
by  TomJump to last post
07/01/2014 3:05 PM
2 Replies and 1459 Views GL20.2  1459  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 1459
by  whitey1287Jump to last post
06/19/2014 3:00 PM
0 Replies and 760 Views Lines in MA43  760  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 760
06/16/2014 2:39 PM
4 Replies and 1308 Views Using a WellsFargo Commercial Card in AP  1308  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 1308
by  Greg MoellerJump to last post
06/04/2014 2:51 PM
0 Replies and 2948 Views Report Writer Training Manual  2948  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 2948
06/02/2014 4:37 PM
3 Replies and 1832 Views Asset Mgmt partial disposal  1832  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 1832
by  JRC3769Jump to last post
05/13/2014 1:00 PM
0 Replies and 862 Views Adding additional costs to assets after placed in service  862  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 862
05/05/2014 9:04 AM
9 Replies and 1317 Views ESS Pay  1317  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 1317
by  ChescaJump to last post
05/02/2014 10:17 AM
2 Replies and 1201 Views Invoice Approval using ProcessFlow  1201  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 1201
by  OllertonJump to last post
04/30/2014 10:48 PM
2 Replies and 1323 Views Reconcile Received not invoiced between IC and AP  1323  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 1323
by  DaveJump to last post
04/30/2014 7:18 PM
0 Replies and 814 Views sales tax partner  814  0 Started by  tdwcpa I am searching for a sales tax partner for Lawson S3. Please provide recommendations.
0 814
04/22/2014 8:24 PM
0 Replies and 868 Views PR85 - reopen void  868  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 868
04/22/2014 10:14 AM
1 Replies and 934 Views Location of GL40.1 attachment comment text  934  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 934
by  DonnaJump to last post
04/16/2014 10:52 AM
2 Replies and 1409 Views GL199 Company Values changing  1409  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 1409
by  AustinJump to last post
04/15/2014 2:46 PM
0 Replies and 699 Views Activity Group POP- RNI Interface  699  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 699
04/09/2014 2:30 PM
0 Replies and 816 Views BR120/130 not balancing  816  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 816
04/09/2014 1:51 PM
1 Replies and 1526 Views Using MS Excel Database Connection Wizard  1526  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 1526
by  AriJump to last post
04/07/2014 4:51 PM
1 Replies and 888 Views AR20 batch processed under wrong process level  888  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 888
by  BasiaJump to last post
03/28/2014 2:40 PM
3 Replies and 2637 Views GL90 csv export name  2637  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 2637
by  DebbieKJump to last post
03/27/2014 1:49 PM
4 Replies and 2696 Views DIFFERENCE B/W COST CENTER AND ACCOUNTING UNIT  2696  4 Started by  batmanprime Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT
4 2696
by  Kat VJump to last post
03/24/2014 10:44 AM
0 Replies and 577 Views Discount with no Net Due  577  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 577
03/20/2014 7:54 AM
2 Replies and 1008 Views GL double posting LP accruals  1008  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 1008
by  ChescaJump to last post
03/11/2014 1:02 PM
0 Replies and 1286 Views CB185 Cash code not found for bank  1286  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 1286
02/27/2014 2:28 PM
2 Replies and 1032 Views Employer Medical Insurance Costs posted to GL  1032  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 1032
by  scuba80Jump to last post
02/26/2014 3:40 PM
0 Replies and 1371 Views Open Payables Report  1371  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 1371
02/22/2014 1:25 PM
0 Replies and 981 Views AP240  981  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 981
02/22/2014 1:20 PM
2 Replies and 1094 Views Best Practices for tracking Discounts on Purchase Orders  1094  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 1094
by  Kat VJump to last post
02/19/2014 3:58 PM
0 Replies and 1977 Views Journal Entry Data dump  1977  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 1977
02/19/2014 3:36 PM
2 Replies and 1556 Views Uploading Assets into Lawson Asset Management  1556  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 1556
by  AshJump to last post
02/19/2014 1:29 PM
2 Replies and 1039 Views Nee help figuring out activity structure  1039  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 1039
by  BasiaJump to last post
02/19/2014 8:51 AM
1 Replies and 1203 Views PO20.1  1203  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 1203
by  Kat VJump to last post
02/14/2014 1:29 PM
3 Replies and 1685 Views Open A/P Invoices  1685  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 1685
by  BShortJump to last post
02/11/2014 7:54 AM
2 Replies and 1406 Views Lawson Financials S3 Archive/Purge Solutions?  1406  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 1406
by  R. LapierreJump to last post
02/07/2014 3:25 PM
0 Replies and 950 Views GL190 journal posting sort order  950  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 950
02/03/2014 4:22 PM
1 Replies and 3795 Views Functional user manuals for V 9.0.1  3795  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 3795
by  JimYJump to last post
02/02/2014 5:23 PM
1 Replies and 2309 Views AM 255 Depreciation Projection  2309  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 2309
by  EllenPJump to last post
01/27/2014 4:10 PM
4 Replies and 3490 Views Too Many Decimals  3490  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 3490
by  MChismJump to last post
01/23/2014 12:30 PM
0 Replies and 792 Views Financial Roll reporting  792  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 792
01/13/2014 3:49 PM
10 Replies and 12212 Views Budget Upload  12212  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 Lawson.com 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 12212
by  TesterJump to last post
01/07/2014 4:13 PM
5 Replies and 2148 Views PO230 Error  2148  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 2148
by  JonAJump to last post
12/27/2013 3:43 PM
4 Replies and 1204 Views Asset Transfer Load in AM30.1  1204  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 1204
by  IanJump to last post
12/23/2013 11:51 AM
5 Replies and 2871 Views Defaulted Payment Terms  2871  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 2871
by  dcaianiJump to last post
12/17/2013 8:30 AM
4 Replies and 1196 Views Company Status = Test  1196  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 1196
by  DeronJump to last post
12/12/2013 3:40 PM
1 Replies and 1050 Views AR/BL from Lab Software to interface w Lawson  1050  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 1050
by  Ken UJump to last post
12/10/2013 6:13 PM
0 Replies and 942 Views LPA/IPA naming standards  942  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 942
12/06/2013 4:54 PM
0 Replies and 838 Views Invoice Matching Workfile Cleanup  838  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 838
12/04/2013 8:03 AM
0 Replies and 1654 Views Death notice of LACOBRTS  1654  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 1654
12/02/2013 12:55 PM
2 Replies and 956 Views Remove a displayed benefit in the add beneificiaries ESS  956  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 956
by  LisaJump to last post
11/25/2013 4:46 PM
1 Replies and 893 Views AP155 Payer Address on File  893  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 893
by  JeremyJump to last post
11/20/2013 4:55 PM
3 Replies and 861 Views Online Entries & Interface Source  861  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 861
by  John HenleyJump to last post
11/15/2013 12:28 PM
3 Replies and 5977 Views Infor’s Lawson Accounts Payable Invoice Automation system  5977  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 5977
by  John HenleyJump to last post
11/08/2013 1:07 PM
1 Replies and 1412 Views AP520 and One Time Vendor  1412  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 1412
by  brainetJump to last post
11/01/2013 9:22 AM
2 Replies and 822 Views Employer Issued Credit Cards - Where Maintained  822  2 Started by  BradF Is there anyone who does this
2 822
by  Greg MoellerJump to last post
10/31/2013 8:55 AM
8 Replies and 2440 Views Loading Fixed Assets into Lawson AM  2440  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 2440
by  Bob CanhamJump to last post
10/24/2013 2:34 PM
1 Replies and 1046 Views Converted Assets Not Calculating Depreciation  1046  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 1046
by  IanJump to last post
10/23/2013 6:04 PM
1 Replies and 997 Views Restricted Funds  997  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 997
by  Bob CanhamJump to last post
10/22/2013 12:14 PM
0 Replies and 831 Views Audit Data? EFT/Banking Information in AR  831  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 831
10/21/2013 3:04 PM
0 Replies and 1464 Views Cost Allocation  1464  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 1464
10/21/2013 12:25 PM
0 Replies and 752 Views Merging Summary Accounts  752  0 Started by  Dixon How do you merge summary accounts in mass efficiently, without going through the painstaking process of moving accounts individually account by account. Some of our summary accounts have a large number of individual GL accounts within them, and we'd like to merge them into one summary account. Thank you.
0 752
10/14/2013 5:35 PM
0 Replies and 1165 Views Adding a new Data Area tonight  1165  0 Started by  Nathan E We are adding a new data area to the production product line tonight. We are working with a very experienced consultant to do the work with us but I wanted to see if any of you had been through this and have any lessons learned you'd like to pass on. Things to look out for Pre-game preparations Post-create procedures Backstory: HR wants to create a new data area and make a copy of Production so they can use it as a historical archive. Create it, copy the data, secure it and lock it from c...
0 1165
10/14/2013 2:02 PM
5 Replies and 1243 Views What Lawson form??  1243  5 Started by  Bev Edwards We have moved to LS9 Security (no more laua). Most of the forms we had access to were removed and now we are piece mealing them back. My director used to have access to an AP form that provided a snap shot of all AP Vendor payments. He also said he was able to compare one fiscal year to another using this form, but cannot remember which one it was. Our IT department is also not able to tell us. We looked in the Excel Add in list since that is our only window to all Lawson forms under eve...
5 1243
by  Greg MoellerJump to last post
10/11/2013 3:27 PM
2 Replies and 1313 Views List of forms to change GL information - Changing GL  1313  2 Started by  Ollerton We are redesigning our GL in Lawson. Does anyone have a list of forms we need to change to update our GL Like HR11, AC07, etc. Thanks, Jim Ollerton
2 1313
by  OllertonJump to last post
10/09/2013 4:38 PM
2 Replies and 1451 Views Managing GL,AP, AR interface fallouts  1451  2 Started by  DougAB We are interfacing transactions over from our OMS system to Lawson every 5 mins. There, of course, will be fallouts from either the importdb's or the interface programs themselves - AR550, AR560, AP510, AP520 and GL165. We are planning to gather all of the log files (.prt's) that have errors in them and put them in a central repository so we can easily identify the issue and resolve them. Couple of questions here: 1) are the output files from either the importdb's or the interface progr...
2 1451
by  John HenleyJump to last post
10/03/2013 5:04 PM
9 Replies and 1275 Views How to tell if a job posted successfully i.e. GL165  1275  9 Started by  Frank I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully I can't seem to find any information like this Thanks Frank
9 1275
by  Greg MoellerJump to last post
10/03/2013 4:43 PM
1 Replies and 974 Views Track new accounts or new accounting units created during a period of time  974  1 Started by  Anna Tian Hi, Everyone, We are asked to provide a list of new accounts & new accounting units created during a period of time. However, we do not have auditing features turned on. Is there any way to obtain this list without the auditing feature Does Lawson stores creation date or update date for Accounts/Accounting units in any tables (other than auditing tables) Also, I would like to know if you do not have auditing features turned on, do you use any controls to track creation or changes of new ...
1 974
by  Anna TianJump to last post
10/02/2013 2:18 PM
1 Replies and 1153 Views Audit for Activities  1153  1 Started by  Lynne Hi, We are trying to see if the budget amount on an activity was changed. Is there an audit table for activities I have been unable to find any history. I looked at GL01.4 and when I select the AC line, the 'Audit' button does not display. We are on 9.0.1. Thanks!
1 1153
by  LynneJump to last post
09/30/2013 7:57 AM
1 Replies and 1417 Views MA540 Vendor Payment Terms v. AP10 Vendor Payment Terms  1417  1 Started by  Shannon R Has anyone else run across this We use GHX for our MA540 files. On one specific vendor, the payment terms coming in through MA540 (payment terms are N30) are over-riding the Vendor Terms set up in AP10 for that specific vendor (N1). We need to pay this vendor at N1. We manually have to go change the date on each invoice or all of the invoices pay late. I can ask the vendor to change the terms on our account to N1, but this doesn't solve the root problem. Why is the MA540 file data over-...
1 1417
by  JonAJump to last post
09/24/2013 9:23 AM
1 Replies and 1102 Views GLTRANS field acct_amount  1102  1 Started by  SN Hi, Please help me understand where does the acct-amount from gltrans get its value from. also shouldn't base-amount and acct-amount have same values I have 2-3 scenarios where the base amount doesn't equal to the acct-amount.
1 1102
by  SNJump to last post
09/21/2013 9:47 PM
15 Replies and 11588 Views EDI 810 Invoices  11588  15 Started by  Deleted User Hi, Anyone have any tips and lessons learned about interfacing drop ship or expense type invoices into MA540 An example would be pharmacy, food, or office suppies. We're in healthcare and use O&M and GHX EDI 810s for for inventory, non-stocks and specials. We are looking for ways to take the data entry load off our AP staff for non receiving type purchase orders. Please post or e-mail to joanna.bledsoejhsmh.org. Looking forward to networking with you.
15 11588
by  Shannon RJump to last post
09/20/2013 10:07 AM
0 Replies and 844 Views Merging with another company  844  0 Started by  Brenda We are merging with another company and need to come up with a way that we can report as company X up until the merger and as company Y the day after the merger. We do not yet know if we will be staying with Lawson or moving to the finanical system they have, right now we just need to figure out a way to have a clean cut off between the two companies and report as Y company going forward. We currently have 23 active companies and we have subsystems and external systems that interface into our ...
0 844
09/18/2013 5:11 PM
3 Replies and 2099 Views Vendor Mergers and Acquisitions  2099  3 Started by  JonA How are vendor mergers and acquisitions handled within your organization If a vendor with active contracts and POs is acquired by another that is not in your vendor master do you add a new vendor and create new contracts/POs or do you change the name on the existing vendor
3 2099
by  JonAJump to last post
09/06/2013 3:05 PM
4 Replies and 1292 Views Report job to csv  1292  4 Started by  Justin R I have an AR250 job. Is there a way I can automically ouput that as a csv file
4 1292
by  Greg MoellerJump to last post
08/27/2013 1:57 PM
2 Replies and 2251 Views BR120 output, need an invoice in a format readable by Crystal Reports  2251  2 Started by  johne when i run br120 now i get the following viewable output files: BR120.prt ... the report showing what was processed/produced custom5 ... a format of the invoice that uses the tilde (~) character to designate the trailing value; e.g. ~STARTHEADER ~field Invoice Number IN 00000001 00000000 ~field Invoice Date ... ... ~ENDHEADER ... invoice1 ... text version of a printable invoice invoice1.pdf ... pdf version of the invoice i'd like to get an invo...
2 2251
by  BaloyJump to last post
08/27/2013 1:28 PM
1 Replies and 1676 Views Change Cash Code on Unpaid Invoices in AP  1676  1 Started by  Ariel Hello, Am on Lawson S3, V9. I would like to mass update any unpaid invoices that are sitting in the AP so that a new cash code overrides the existing cash code that was entered when the initial invoice was created. Now that we have changed bank accounts I would like to an easy automated way to pay old, unpaid invoices from our new account without having to manually change the cash code in AP30.3. Does anyone know of an automated process for this Much Thanks, -Ariel
1 1676
by  Bob CanhamJump to last post
08/20/2013 2:40 PM
0 Replies and 1435 Views Accounts Payable Merging of 2 Vendor Groups  1435  0 Started by  JamesB I've got two companies that are going to merge and I've got both of them in AP as two separate vendor groups. They currently have separate bank accounts, separate check numbering systems, separate vendors, etc. They will soon be sharing a bank account and checks when they merge but they will still enter invoices and other data separately, while coordinating on the check numbers. There doesn't seem to be any precedent for this. Infor has nothing to offer with regard to this and I didn't see an...
0 1435
08/09/2013 1:34 PM
2 Replies and 1955 Views remittance notice for ACH payments  1955  2 Started by  Maynard F. Does anyone have a solution for the automatic sending of remittance notices electronically to vendors who are paid electronically I have considered using process flow or writing a custom program which would run daily. Please send me your suggestions. Thank you.
2 1955
by  Maynard F.Jump to last post
08/07/2013 10:59 AM
1 Replies and 868 Views lp01 drop-down menu  868  1 Started by  Chesca My users can't see the drop-down menu for some reason in Portal. I am able to see it with no problem. Would this be a security issue, any idea what could be the issue
1 868
by  Greg MoellerJump to last post
08/06/2013 2:29 PM
0 Replies and 814 Views Matching in AP55  814  0 Started by  DougAB Here's our scenario: Some of our suppliers charge our corporate credit card immediately when an item is ordered from them. (we provide some of our suppliers our CC b/c we get $ back on purchases). Once our CC statement is available, these charges only show who the supplier is, but does not reference any PO number that we sent them (nor Invoice they sent us). We are trying to find a way to match these charges to the invoices. I spoke with a Lawson business consultant and she said the b...
0 814
08/06/2013 8:43 AM
9 Replies and 2091 Views Interfacing into a Surgical Information System  2091  9 Started by  Bill Timmis We are thinking about creating an interface out of Lawson in to the SIS system. The canned HL7 format reports just don't give us what we need since they are designed to pass Item Master data which is more than is needed by SIS. We are concerned however with an interface about how to account for passing only low unit of measure. Notoriously Purchasing will only have a box available to buy which is the only UOM in the system, but items get expensed by the each. Has anyone done anything similar ...
9 2091
by  Greg MoellerJump to last post
08/05/2013 9:13 AM
1 Replies and 1276 Views AP155 report format limitations  1276  1 Started by  CharlotteM Lawson’s AP155 is only printing 15 characters of the data typed in the Description field from the options tab of AP20.1 (API_Description|ID=_F122) when the field itself is 30 characters long. Can this be changed so the AP155 captures all 30 characters Our check writing program will accept and print them on our check remittance stubs if they were present on the AP155.
1 1276
by  Ragu RaghavanJump to last post
08/03/2013 9:05 AM
4 Replies and 2588 Views What is the best way to create an elimination company?  2588  4 Started by  Deleted User I would like to create an elimination company. I believe I can use the GL110 to do a company copy over and change the company status to 'E' in GL10.0.&160; However, I would like to keep the elimination company simple with less Accounting Units set up, etc. Is there another method Is there anything that I should be&160;aware of Thanks Liz
4 2588
by  MelissaJump to last post
07/27/2013 8:14 PM
0 Replies and 1009 Views Binding Billing API (BLOEL71PD) RPGLE  1009  0 Started by  Cory Hi, Has anyone done a custom interface that generates next invoice number via the BLOEL71PD module We attempted to use this module as suggested in the Lawson documentation, however, this module has multiple links that we cannot find causing compile errors due to undefined symbols. Please share the code if you did. Thanks
0 1009
07/25/2013 4:59 PM
2 Replies and 1830 Views Question on Purging Vendors  1830  2 Started by  Bob Canham We are currently evaluating the AP300 for purging one-time vendors. Based on what we have tested so far, everything seems to be working great to purge these based on a cutoff date. However, we are going to want to purge our regular vendors in the future as well based on a cutoff date. However, from the documentation we've read, the AP300 defines a 'No Activity Vendor' as a vendor who doesn't have a balance in APVENBAL for the current or previous year (Lawson KB 81692). That sounds like it...
2 1830
by  Bob CanhamJump to last post
07/25/2013 10:57 AM
0 Replies and 811 Views How to get copy invoices from M3 in an electronic format  811  0 Started by  Smerrick Hello,I am new to this and have only basic knowledge. Is there a way to retrieve invoices via M3 in electronic format e.g. pdf, csv, etc I know that I can get copy invoices via OIS680 but how do I get these into an electonic format Addins etc cannot be included Any help would be greatly received.Thank youclear
0 811
07/25/2013 6:21 AM
1 Replies and 1187 Views Audit tracking on GL20.2  1187  1 Started by  Melissa I've found the account and accounting unit audit reports, but neither of these tell me who added an account at the AU level in GL20.2. Does anyone know how I can see who made accounts 'exist' for an AU
1 1187
by  John HenleyJump to last post
07/19/2013 10:43 AM
1 Replies and 889 Views Percent Complete Calculation - AC165 and BR165  889  1 Started by  Khristine Is there any difference in percent complete processing between AC165 and BR165 Reason I ask is I used both and nothing seems different in terms of how both update ACPERCCMPL and ACPERCCMPLX and BR130 seems to be updating revenue transactions correctly for contracts Percent Complete. How do I know which one to use Thanks.
1 889
by  John HenleyJump to last post
07/09/2013 6:51 AM
11 Replies and 1893 Views GLAMOUNTS and GLUNITS Tables  1893  11 Started by  BShort I am using Crystal and have used these two tables independently. Now i am joining the tables as the report I am writing needs both sets of information at the department level. Here is my problem: If an AU has both the amount accounts and the units accounts attached for example Salary accounts can have both amounts and units, I can get one or the other to pull correctly but not both when I play with joins. In the one report I have going, my salaried are tripple what they should be. I know it...
11 1893
by  DeronJump to last post
07/02/2013 2:40 PM
1 Replies and 1231 Views Reporting  1231  1 Started by  RitaM My healthcare organization is going live with Lawson in two days and I am looking for a comprehensive list of standard GL reports. Can anyone tell me where I can find this
1 1231
by  Tony ConwayJump to last post
07/01/2013 4:25 AM
3 Replies and 1984 Views Invoice Line item detail  1984  3 Started by  Parx400 I am working on a project where I have most of the Lawson tables extracted and put into ACL(Audit tool). I have Invoice numbers for invoices that were paid in 2011 and 2012 after running APPAYMENT and APINVOICE. I need to know the line item detail of these invoices so I can see what the paid price was fro each item. I have aprox 2.3 mil line items associated with the PO numbers found in APINVOICE. I need to be able to join the POlines that have PO pricing to the actual price paid on the invoice ...
3 1984
by  Bob CanhamJump to last post
06/28/2013 10:34 AM
1 Replies and 2364 Views Cost Center hierarchy  2364  1 Started by  Dichotomy Can cost centers be linked to another 'higher' cost center where each cost center allows posting, and when reports are run for the higher cost center it includes all data from the cost centers linked to it Or would a company have to have a different reporting grouping category and have an extra cost center that represents the higher level expenses In other words, can more than one level have posting capabilities
1 2364
by  Rich BendicksonJump to last post
06/24/2013 2:55 PM
2 Replies and 1401 Views GL192  1401  2 Started by  Rose Evans Hi all, I work in the government sector and it is very important that we retain a view to our committments/encumbrances at the end of a fiscal year as well as maintaining a view historically month to month. I just discovered GL192 which takes a snapshot of your encumbrances/commitments at year end prior to running GL197 (rolls encumbrances/commitments to the next fiscal year). While I understand that this takes a snapshot year end, is GL192 a process that should be run at every month end t...
2 1401
by  Terry WierJump to last post
06/24/2013 2:36 PM
1 Replies and 1246 Views copy/paste functionality from LID vs portal with LSF9  1246  1 Started by  Deleted User We are in the process of converting from LID to portal because of the upgrade to LSF9 security. One major function we seem to be losing is the copy/paste of data say from a GL95 inquiry. The create csv does not seem to adequately replace the copy/paste function. We are looking for any tips that would help us with this. Thank you.
1 1246
by  John HenleyJump to last post
06/11/2013 3:39 PM
2 Replies and 1665 Views Crystal Report-Financial Ratios Chart/Graph  1665  2 Started by  BShort Good day all, I was not sure where to post this topic, so thought here. I have finanial ratios developed and have passed them to a subreport. I need to graph the ratio such as Total Margin now on a graph. In all of the google and reseach so far, the only way to do this in crystal is to send it to a subreport. I 'see' the shared variable now in the subreport, but can not get it to graph. I get an error message 'A print time formula that modifies variables is used in a chart or map detail'. ...
2 1665
by  DonnaJump to last post
06/10/2013 3:35 PM
1 Replies and 1495 Views Adding Vendor Class to AP20.1  1495  1 Started by  Paula @ CSU Our users would like to see vendor class displayed in the same area where vendor name and address now appear on the AP20.1 screen (basic invoice entry). This field was not available in design studio to simply be added - so I took a look at the PD and WS and .scr - as well as the APIN70 library PD & WS and added the vendor class fields and moves where I thought appropriate based on what seemed to be happening with vendor name. I still do not see the field appearing even after successful compi...
1 1495
by  Ragu RaghavanJump to last post
05/29/2013 1:18 PM
1 Replies and 1330 Views Break up details- GL90.1  1330  1 Started by  Suhas HI can anyone please let me know how to obtain the break up details for transaction present in Transaction Analysis(GL90.1). Thanks.
1 1330
by  mark.cookJump to last post
05/21/2013 8:00 AM
2 Replies and 1548 Views Info Browser  1548  2 Started by  Diane G I just set up an Info Browser to get the current balance of one balance sheet account using the CYDAMT field. Why am I getting 10 different amounts The last one IS the current balance, which I need. I don't need to see the other 9. We are on Smart Office version 10.0.5.1
2 1548
by  Diane GJump to last post
05/17/2013 10:08 AM
5 Replies and 1549 Views mx10 interface  1549  5 Started by  Matt We're currently trying to mockup creating an org hierarchy using attributes on accounting units. Our levels are all messed up in GLNAMES and we aren't going to be fixing that anytime soon. So my question is, can we somehow externally interface with mx10 to either create a manual or dynamic list Update that list I'm not seeing anything out of the box that allows such interaction. Am I missing anything
5 1549
by  John HenleyJump to last post
05/16/2013 12:48 PM
0 Replies and 875 Views customer process level and (revenue) account  875  0 Started by  Justin R I am posting invoices to the interface tables ARITRANS and ARIDISTRIB. How do I get to the process level and (revenue) account for a given customer
0 875
05/16/2013 11:54 AM
1 Replies and 1250 Views AP 20.2 Alowing invoice to post over Activity Budget  1250  1 Started by  Chad T We have recently set up a new company. In our previous company setup if we try to process a PO invoice over budget it gives a 'Cost Budget Exceeded' error message. Activities set up under the new company are allowing invoices to post over the activity budget - Where are these parameters managed
1 1250
by  LauraJump to last post
05/16/2013 7:38 AM
0 Replies and 853 Views AM20.3 Add-ins upload to add serial number  853  0 Started by  Laura I moved this to the Add-Ins forum - that's where I intended to post it originally. But if you have an answer, feel free to let me know! --------------------------- We need to be able to add serial numbers to specific line items on an asset in AM20.3. Does anyone know how to do this with add-ins since the field name for serial is always row0 We have assets that can have up to 100 line items and each one needs its own serial number. I haven't tried it yet but the user did and was unsucc...
0 853
05/15/2013 10:18 AM
0 Replies and 2952 Views Bad File status 3 5 on sortfile  2952  0 Started by  Vijay S I got an error Bad File status 3 5 on sortfile in IC130(General Ledger Interface) and job went to needs recovery state. Again Submitted the job, It completed successfully . What could have been the most probable reason(s) for its failure Regards, Vijay
0 2952
05/15/2013 9:56 AM
0 Replies and 866 Views Reopen Year End  866  0 Started by  Ronald We accidently ran AM195 (Year End Close) instead of AM190 (Month End Close) and in doing so we ran different AM190's and deleted the process. How can we reopen the year
0 866
05/14/2013 9:00 AM
0 Replies and 909 Views RW 100-Ratios  909  0 Started by  BShort Good day everyone. I have my Income Statement in RW and it is working great, now we want to add some items to it at the bottomw to create a manager type of dashboard for a better term. I have our statistics loaded in the 9xxxx series so have IP Stat, OP Stat, ER Stat. On RW, I have these showing up great after the my income statement. Now I want to do a ratio of Total Revenue per Total Stat for each department that may have the information. This is where I am stuck. I created another...
0 909
05/13/2013 2:23 PM
3 Replies and 977 Views Where would i find start time end time for daily productivity report  977  3 Started by  Healthcare User I need every employees start time and end time, to produce a daily productivity report. What time they are starting and ending. Labor productivity report. In which table the above information can be found. Thank you very much for the helpful info.
3 977
by  Ruma MalhotraJump to last post
05/13/2013 12:21 PM
3 Replies and 2111 Views AP30.2 Distribution changes post 9.0.1 Upgrade  2111  3 Started by  Margaret We have a Service PO invoice that we entered prior to our upgrade to version 9.0.1 that needs a distribution change. When we try to change the coding in AP30.2, we get an error message 'Cannot add distribution, invoice is unmatched'. Prior to the upgrade our service invoices did not require matching. Does anyone know how to change these types of distributions. I can't find anything useful in the Knowledge Base. Worse case is we can do a journal entry, but we like to keep the AP invoice coding ch...
3 2111
by  KarenBCIJump to last post
05/09/2013 5:04 PM
2 Replies and 2347 Views Grant Tracking: Accounting Units vs. Activities  2347  2 Started by  Michael Grace We are seeing a large increase in our grants volume and would like others opinions on why it is better to use accounting units vs. activities or vica versa. More than likely we are not going to use Lawson Grant Module so that shouldn't be a constraint. Any thoughts are appreciated.
2 2347
by  Michael GraceJump to last post
05/09/2013 12:09 PM
0 Replies and 885 Views Bulk Load of EFT Setup Data?  885  0 Started by  Garth Gerwing We are going to be collecting numerous of customers EFT setup data to support pre-authorized debit payments. Upon discussing with a Lawson Engineer - it was suggested: 1) At Conversion Time: Use AR501 (Customer Conversion) - uses staging table ARCCUST - this wil work nicely (and I've tested) - just include EFT setup data with the rest of the customer data conversion. 2) Post Go-Live: was suggested to use AR550 (Customer Interface) - uses staging table ARICST - I DO ...
0 885
05/06/2013 1:59 PM
2 Replies and 1705 Views How to Require Activity & Account Category  1705  2 Started by  Gary AC07 lets you limit an Activity and/or Account Category to specific GL Company, Accounting Unit, etc. but it doesn't appear to stop a user from entering no Activity/Account Category at all. Any way to require the entry of Activity and Account Category
2 1705
by  CindyJump to last post
05/02/2013 10:21 AM
0 Replies and 912 Views AC500 - report showing duplicated lines..  912  0 Started by  johne and if so, have you searched / found a patch to correct the problem.. QA person is testing against a 9.0.1.8 version of AC500. appears to have the report duplicating the last line of information on the 'Valid Records Listing' section when there is an 'Error Records Listing' section that follows. does not occur when there is not an error record group. I'm not finding anything in any of the Lawson KB areas & was just wanting to see if anyone else is seeing the same issue. header o...
0 912
04/29/2013 3:45 PM
2 Replies and 990 Views GL40 Status Message Account Category Required  990  2 Started by  Ken Carley Does anyone have any ideas why this may be the return message S3 9.0.1 Portal status message reads 'Account Category Required' when selecting &91;Change&93; for a two line entry. Each line's 'FC' is set to 'A'. Thanks for your time! I know this is wrong but I would like to know if anyone has seen it before. :crazy: Regards, Ken
2 990
by  Ken CarleyJump to last post
04/29/2013 1:19 PM
2 Replies and 1471 Views Lawson Excell Add-Ins  1471  2 Started by  Jeff Pratte We have a MS Excel Add-in that has the Lawson server URL hard-coded into the Lawson Add-Ins login screen. How do we change that server address Thanks, Jeff
2 1471
by  John HenleyJump to last post
04/29/2013 8:44 AM
3 Replies and 1235 Views GL security classes for LSF9 security  1235  3 Started by  Deleted User We are in the process of switching to LSF9 security. We are in the early stages of defining the security classes for the General Ledger group and are just wanting to know what items we need to look out for in the set ups. Thank you.
3 1235
by  GeorgetteJump to last post
04/25/2013 11:08 AM
1 Replies and 997 Views Colliding Allocations CA190 GL190  997  1 Started by  Joseph Carfagno Lawson will not process an allocation for a company if a GL190 is running. We normally run the CA190 for company groups. This can leave some allocations in a group processed and others in a released or processed state. This can get very confusing at month end. Both GL190 and CA190 are compiled as non-concurrent for us but I'd like for there to be a way to prevent CA190s from running when a GL190 is running and vice versa. Our Finance people are in muliple locations so coordination of work i...
1 997
by  BarbaraJump to last post
04/14/2013 8:53 AM
0 Replies and 813 Views I need last updated column details on tables  813  0 Started by  Healthcare User Working on a client task to extract delta from all tables now chose 120 tables, Can someone please kindly if you have last updated date column details, which keeps track of record last updated dates. Please i am working on a task, to extract day to day data, based on dates preferably. I see some tables has created dates, which is only kee&91;ping teh created date info. But not updated dates. Does any one has any details on last update details of table rows, i would...
0 813
04/11/2013 8:14 PM
0 Replies and 751 Views PTO GL Questions (XPosted)  751  0 Started by  Kelly H Does your system pass the PTO from the LP to the GL side as the PTO is earned or is the bank balance calculated at the end of the month How often is the LP198 ran
0 751
04/08/2013 10:09 AM
3 Replies and 1292 Views Laser Check Printing File Security  1292  3 Started by  Brian We had a problem with check fraud when an A/P clerk edited the AP161 electronic payment flat file. I cannot lock down the A/P users folder rights because our laser printing software will crash when removing the file after importing. How do others handle this security hole Thanks, Brian
3 1292
by  BrianJump to last post
03/31/2013 12:40 PM
3 Replies and 1228 Views AP270 invoice detail?  1228  3 Started by  clb393 To perform a reconciliation I need to find the employee detail that populated the invoice amount on the AP270. Any idea how i would get there Example - on the AP270 for Vendor 2611xx Invoice 500113030812513xxxx there is a payment amount of $54.00 to United Way. Where would i look to find the employee detail that populated that $54.00 Or should i look within the Voucher Is so, where should i look for that Thanks, Chris
3 1228
by  Greg MoellerJump to last post
03/28/2013 9:24 AM
4 Replies and 877 Views Report over PO  877  4 Started by  sgoins I am trying to find a way to run AP report that provides both invoice as well as PO. Just wondering if anybody had any suggestions on the best way to do this Any help would be appreciated. Thanks!
4 877
by  Greg MoellerJump to last post
03/27/2013 1:07 PM
0 Replies and 974 Views Asset Management S3  974  0 Started by  Leo Montaos If i have an Asset type 'Equipment' and under that type I have 2 assets, 1 asset should allocate the depreciation to multiple cost center and the 2nd asset under this type should not be allocated, how can this be done If i add allocation in AM06.6 this allocation will get assigned on the TYPE level therefore the 2nd asset will also get allocated which is i dont want to happen.. thanks
0 974
03/14/2013 4:09 PM
0 Replies and 1284 Views Asset Management  1284  0 Started by  Leo Montaos Dear Lawson Gurus, Is it Possible to processed a Leased assets in Lawson without using the Leased management In the user guide the last step is LM121 or LM21 is this mandatory Also, i would really appreciate if you could provide to me the best practices in lawson for Asset Management. Thank you..
0 1284
03/14/2013 3:48 PM
1 Replies and 952 Views need help with benchmarking  952  1 Started by  DougAB I am looking for a benchmark as to how long uploading 9000 records would/should take into the AR550 program. I would really appreciate it if someone was willing to upload the attached file that I am providing, or just do one with your own data, and let me know how long it takes for the AR550 to complete. I'm sure you already know, but you would first have to do an 'importdb', then do the AR550. For the 'importdb' - the Options field should be 'ad'; and the DB File Name field should be 'A...
1 952
by  DougABJump to last post
03/12/2013 3:57 PM
0 Replies and 754 Views Prior year reqs  754  0 Started by  TerryL I ran RQ140 and found some old Unreleased reqs and a few that are in Needs Approval status from a prior year that is closed. What is the best way to get rid of those reqs out of the system
0 754
03/11/2013 7:46 PM
2 Replies and 1151 Views How do I create a new ATN-OBJ-ID?  1151  2 Started by  Donna I need to populate forms GL76 and AC46 directly from SQL. We are pulling from a different system and do not want to use Add-Ins. I know that I will need to have an ATN-OBJ-ID and a new GLT-OBJ-ID for the rows that will be inserted into ACCOMMITX and GLCOMMITX. Which table would have the last number used for these fields Are these calculated bases on data in a particular table
2 1151
by  DonnaJump to last post
03/07/2013 5:13 PM
7 Replies and 1250 Views Vendor file read  1250  7 Started by  slm4 I have never tried to read or use the vendor file before. I have been ask to create a file of all of the vendors for export. I need to know the coding to read file sequentially and any checks I would need to do in order to create that. Thanks.
7 1250
by  slm4Jump to last post
03/04/2013 2:30 PM
0 Replies and 886 Views Physical 2 Virtual converstion  886  0 Started by  Chad We have a problem with our physical server that every time that we have to reboot it, it becomes unstable and unusable for users. Infor support can not come up with why this is happening and frankly has not been getting a good direction for a fix from any of the logs. In order to try and get a copy of the physical server, separated from our production server, so that it can be further trouble shoot I did a p2v conversion using vmware standalone converter tool. Everything went well but I can n...
0 886
02/27/2013 12:05 PM
1 Replies and 1390 Views Reconciling A/P to G/L  1390  1 Started by  martyzoet How does one go about reconciling A/P to the General Ledger. In the simplist form of the question, wouldn't the open invoice total equal the G/L A/P account balance If I run AP230, that will give me open invoices as of the run date. But I need open invoices as of year end date (putting the cut-off date in only looks at invoices with that date or prior, not OPEN invoices as of that date). It would seem to be a simple task but I'm unable to determine how to go about it.
1 1390
by  martyzoetJump to last post
02/25/2013 3:18 PM
2 Replies and 1505 Views Consolidation company  1505  2 Started by  Display Name Would be consolidating 2 live companies with the same chart/levels/currency. Both live companies use zone balancing and have intercompany relationships set up. Do I need to set up zone balancing in my elimination or consolidation company Does the elimination company need intercompany relationships to the live companies more to follow, let's start here first... Thank you
2 1505
by  Display NameJump to last post
02/24/2013 7:39 AM
4 Replies and 1177 Views Lawson Monitor  1177  4 Started by  RickyY Hello All, I was wondering if anyone out there have use anything software that monitor Lawson to show performance, connection issue, send out alerts if system is down or performing slower than it should, etc Thanks. ricky
4 1177
by  RickyYJump to last post
02/22/2013 6:21 PM
1 Replies and 3093 Views GL - Reopen Final Close Period  3093  1 Started by  LauraSantos We need to reopen a GL period that was accidentally closed with a Final Close status. I have a ticket open with Lawson support but they have not provided much help. Can anyone confirm if the steps below are correct 1. Create a quick paint utility of GLSYSTEM 2. Update the PER-END-CODE field from F (Final) to L (Limited) for the last period of 2012 (12/31/12). 3. I assume the user will then be able to use the Backpost option to reopen the period to add additional journal entries. 4. ...
1 3093
by  John HenleyJump to last post
02/19/2013 10:42 AM
3 Replies and 1400 Views Accounts payable processing  1400  3 Started by  jwhip I'm looking for some information on how other companies using Lawson upload AP files for National/Large vendors as opposed to keying them in manually or manipulating electronic files from the vendor to load Thanks!!
3 1400
by  Kat VJump to last post
02/18/2013 4:00 PM
0 Replies and 1119 Views User Audit Trail? - AR82.1 - Returned Payment  1119  0 Started by  Garth Gerwing In evaluating the results of AR82.1 - Returned Payment - I am not seeing anything relating to a user/login audit trail on the resulting Debit Memo It would appear that Lawson is ignoring/breaking some of it's own data architecture rules in creating these results: - does not enforce/write a Debit Memo Reason Code (even though this is a required value for any debit memos being entered into AR) - does not write a corresponding TX Batch occurrence (BLINVHDR) - even though the Debit Memo is ...
0 1119
02/15/2013 2:18 PM
0 Replies and 940 Views Open A/P Invoices  940  0 Started by  martyzoet How do I get a list of all open A/P invoices that were open as of a certain date
0 940
02/12/2013 12:54 PM
0 Replies and 2285 Views PFI Workflow Failures  2285  0 Started by  b.rain I'm going to start by apologizing. Not only am I new to Lawson, but I am also new to the company that I'm currently working for. We are having a problem with Lawson which nobody here has been able to track down. Here is a rundown of the issue, as summed up by one of the application owners. ---------------------------------------------------------- 'We have been experiencing several incidents with Lawson ProcessFlow Integrator workflow units not executing. This is causing significant ...
0 2285
02/08/2013 8:03 AM
0 Replies and 1230 Views Vendor Payment Code  1230  0 Started by  nhaines I am looking for best practice in regards to the default setting for vendor payment codes in AP10. Our default setting is set to SYS. We have some vendors set up with a payment code of ACH on AP10 that have multiple remits (locations). These remits will pull as ACH and not SYS because of how the vendor is set up on the main screen in AP10. Idealy we want the system default setting to drive the payment code and not have to override it in the remit (location) forms. Any input or thought is we...
0 1230
02/06/2013 7:07 AM
0 Replies and 964 Views Multiple Orders; One Invoice  964  0 Started by  Michelle Does anyone know if it is possible to merge orders together to create one invoice. I saw that you can merge shipments in the Warehouse, however, the documentation specifially talks about doing this when the ship-to location is the same on both shipments. We have orders that we want to combine on an invoice that have different ship-to locations. What we are looking for is the ability to combine more than one order, possbily for more than one ship-to location, on one system invoice to the custo...
0 964
02/01/2013 9:34 AM
2 Replies and 1039 Views Attribute List (MX10)  1039  2 Started by  Robert Spurr Has anyone come across the following: (Version 9.0.1) We have lists built in MX10 which suddenly fail to produce data. If we replicate the list and making no other changes the new list works. What I found was that the sequence number was missing on the old list (MXLISTDR - Table) So I did a change on the lines of the list, previewed (returned data again) and validated the sequence numbers now existed. We are trying to figure out why this would have happen and any insight would be appreciat...
2 1039
by  Robert SpurrJump to last post
01/25/2013 4:17 PM
1 Replies and 1596 Views Aging Reports (AR251) - F.O.R.  1596  1 Started by  BErnewayn When looking at an Aging Report (AR251), what does F.O.R. stand for at the bottom of each client summary and overall total I believe the term is comparable to the term DSO (Days Sales Outstanding). Thanks.
1 1596
by  John HenleyJump to last post
01/24/2013 4:13 PM
7 Replies and 6004 Views Journal Entry Processes  6004  7 Started by  Greg Wiklund With internal controls, it would not be uncommon for a JE that a staff member creates to have six touch points as it goes from creation to entry (signatures, someone keys, someone reviews in Lawson). Currently, any JE that needs to be keyed into GL40 is on paper to get the necessary signatures. Has anyone had someone design a better way for JE's to get into Lawson, perhaps using process flow We use GL165 for larger imports, but I've envisioned someone creating a spreadsheet, approvals are ca...
7 6004
by  John HenleyJump to last post
01/18/2013 9:28 AM
2 Replies and 1150 Views GLTRANS ACCOUNT and sub_account details  1150  2 Started by  Healthcare User Where can i find descriptions for Account and sub_account fields under GLTRANS table. Thank you very much for the helpful info.
2 1150
by  dcaianiJump to last post
01/17/2013 3:33 PM
0 Replies and 844 Views Calculate Daily productivity in dollars which table  844  0 Started by  Healthcare User I am working in a healthcare on ETL tools, now a requirement assigned to me, is to calculate the daily productivity on each day basis dollar amount. Could you please provide some details on tables. I am currently looking at GLTRANS table based on fiscal year, account, sub_account. But acct_amount and trans_amount fields are showing values zeros mostly and Units_amount has values. which field value should i sum to calculate daily productivity select fiscal_year, acct_period, account, ...
0 844
01/17/2013 4:43 AM
0 Replies and 995 Views Workflow Process  995  0 Started by  Erin We are new to Lawson and some of the staff will be attending Workflow training. For those of you who are experts, what can we do to be best prepared for the training (to maximize learning). Are their certain skill sets required Secondly, Once training is complete, what would be the estimated time someone out of training would take for creating low to max-complexity workflows Thanks!
0 995
01/11/2013 9:55 AM
0 Replies and 966 Views Cell Phone Reimbursement AP vs PR  966  0 Started by  DavidV Given IRC changes in cell phone policies. How are Lawson users handling cell phone reimbursement Are you still using stipends through PR or are you using AP My understanding of the IRC is that cell phone reimbursement is no longer taxable as long as there's a business need. If use PR how are you preventing it from being taxed or are you supplementing the amount to account for tax Any feedback would be appreciated. We are looking to setup a process flow to automate the request and impl...
0 966
01/10/2013 12:10 PM
1 Replies and 882 Views Getting Attribute chgs from AC13.7 to AC13.1  882  1 Started by  johne I'm loading new activity attributes into ACIFATTR for existing activities that have an attribute already assigned for the matrix category being used in the ACIFATTR records. I'm using today as the effective date. Using AC510, the records are found, brought into the system and removed from ACIFATTR. Run AC10 to view the activity, click on the Attributes button to access AC13.1 and I see that the attributes still contain the 'old' values. The 'Eff Date' button now has a...
1 882
by  johneJump to last post
01/08/2013 3:56 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 2 of 5 << < 12345 > >>


RSS Feed Available