Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 2 of 5 << < 12345 > >>
 Last Post
4 Replies and 1540 Views APINVOICE  1540  4 Started by  Chesca How do I get a list of all invoices that have been paid from certain date I need to provide auditors with a crystal report
4 1540
by  JonAJump to last post
06/22/2015 3:18 PM
2 Replies and 1431 Views Par Counts  1431  2 Started by  Chesca Does anybody know what job on the MSCM side (MSCM9_TASK table) uploads/sends the counts to MSCM Is it the outboundscheduler job I am trying to figure out how and when the HH orders get uploaded into MSCM
2 1431
by  ChescaJump to last post
06/17/2015 8:39 AM
2 Replies and 14525 Views GLAMOUNTS VS GLTRANS  14525  2 Started by  Deleted User I am writing an extract of GL account balances from Lawson and I am trying to find out which table to use for this. Historically, I have used GLAMOUNTS to gather all the data from the most recently closed period in Lawson. However, the Lawson users report GL amounts from GL95.1, which uses GLTRANS as the source. Can someone provide a description of what each one is supposed to be for and which one is more accurate for the closed period. I have found about a 3.5 difference between th...
2 14525
by  AndreaCibaJump to last post
06/12/2015 9:08 AM
0 Replies and 925 Views Match exceptions  925  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 925
06/11/2015 9:52 AM
0 Replies and 900 Views Match exceptions  900  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 900
06/11/2015 9:52 AM
5 Replies and 1686 Views Posted transactions' time stamp  1686  5 Started by  Lawson Beginner Hi, We needed to send some GL update reports on a daily basis to a few third party vendors. In order to avoid duplication of the records sent, we ideally liked to filter the GL transactions in the DB based on the posted time stamp and schedule a job to run once a day. However, we developed a circuitous work-around to meet this requirement. Currently, we are trying to eliminate the work-around and send the list of GL transactions based on the posted time stamp (please note that it is not ...
5 1686
by  Lawson BeginnerJump to last post
06/09/2015 8:44 AM
1 Replies and 1196 Views GL Account Reconcilitation  1196  1 Started by  MichiganMan22 I've recently been given a lot more job duties so I'm looking to make my account reconciliation process more efficient to save time. I currently run a GL 290 and use that information to complete account rec schedules. What are your best practices for reconciling accounts What reports do you pull from Lawson to streamline the process
1 1196
by  TracyOJump to last post
06/08/2015 8:58 AM
0 Replies and 787 Views accrued expenses  787  0 Started by  wally How do I find what has accrued for specific accounts Is there a screen or a table I can reference thanks
0 787
06/04/2015 8:18 AM
0 Replies and 1078 Views Handling code on invoice  1078  0 Started by  Deleted User We use PO code for PO. Based on the PO codes,AP decides which handling code to select. Now our operations want to get rid of PO code. Anyone have input on how to handle this at AP side so they don't have to select a handling code
0 1078
06/04/2015 7:57 AM
0 Replies and 1058 Views Lawson EDI GTIN setup  1058  0 Started by  Chesca We are getting ready to use the Lawson EDI GTIN and I (IT) am being asked to give a guesstimate on how much time would take to implement. I was wondering if anyone is using the GTIN and can provide any feedback. Is it a simple/complex setup Would the users or IT be doing the setup and loads We are on ESP 13 and MSP 9, Lawson 9 technology.
0 1058
06/03/2015 8:31 AM
0 Replies and 1215 Views Smart Reconciliation  1215  0 Started by  BarbB Anyone using Smart Reconciliation that is willing to share their setup/best practice in regards to who works what Currently our buyers work the MA64 and MA60. When we went live in 2004 'Matching' was listing in the Procurement suite and assigned to the buyers. As we have been testing Smart Reconciliation we are wondering if AP should be more involved in this function. Thanks in advance for your help with this project.
0 1215
06/02/2015 1:49 PM
2 Replies and 1487 Views Req- operator ID  1487  2 Started by  Chesca We are having an issue with some Reqs that are being created with an unknown operator ID= 'essuser'. We looked in security and there isn't such user. The requester is a Handheld device and header source is Upgrade. I have attached a screenshot.
2 1487
by  ChescaJump to last post
05/28/2015 2:25 PM
2 Replies and 5113 Views cancel matched invoice that is out of balance  5113  2 Started by  Kenny B I have a matched invoice that I would like to cancel. The catch is that is will not let me cancel, because the system has it marked payment out of balance. Would anyone happen to know why the system will not let me cancel in MA75.1 The error received is 'cannot cancel; payments out of balance'. &160; I show no payments associated with this invoice. &160; Thank you, Kenny Brewer
2 5113
by  MaryannJump to last post
05/28/2015 11:42 AM
5 Replies and 1957 Views CB554  1957  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 1957
by  Bob CanhamJump to last post
05/27/2015 3:59 PM
1 Replies and 865 Views How to find account balances?  865  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 865
by  gradtkeJump to last post
05/27/2015 2:05 PM
0 Replies and 1060 Views $0 AP invoices  1060  0 Started by  gradtke We prepay many of our vendors, so we don't get invoices from 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 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 1060
05/27/2015 1:41 PM
4 Replies and 1430 Views Need to find exists table (GL20.2)  1430  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 1430
by  DennisMJump to last post
05/20/2015 4:39 PM
2 Replies and 1404 Views Billing Distribution  1404  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 1404
by  NicoleGrassJump to last post
05/07/2015 12:35 PM
0 Replies and 993 Views Financials S3 integration - 3rd party software  993  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 993
04/10/2015 6:04 AM
0 Replies and 925 Views Posting Hours to General Ledger  925  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 925
04/09/2015 9:32 AM
9 Replies and 8361 Views AP160 and AP161  8361  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 8361
by  DebbieAmExJump to last post
04/08/2015 10:37 AM
0 Replies and 1444 Views New Company G/L Setup  1444  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 1444
03/27/2015 2:10 PM
5 Replies and 1862 Views 3rd Party Check Printing  1862  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 1862
by  Todd MitchellJump to last post
03/25/2015 12:02 PM
0 Replies and 883 Views How to upload/import an externally managed CoA for the GL  883  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 883
03/17/2015 10:55 AM
0 Replies and 662 Views AP160 to Pay State Withholding  662  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 662
03/16/2015 12:37 PM
6 Replies and 1681 Views AP270 Report  1681  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 1681
by  ChescaJump to last post
03/09/2015 12:36 PM
3 Replies and 1669 Views AP Vendor's payment address  1669  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 1669
by  jjcyeshuaJump to last post
03/05/2015 5:27 PM
0 Replies and 1029 Views AL tax payments  1029  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 1029
02/24/2015 2:56 PM
1 Replies and 1504 Views 1099 State income/tax reporting  1504  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 1504
by  jjcyeshuaJump to last post
02/10/2015 5:08 PM
2 Replies and 1114 Views Customer Comments in AR  1114  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 1114
by  Todd MitchellJump to last post
02/05/2015 9:30 AM
2 Replies and 1491 Views Asset Managment - 8.1  1491  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 1491
by  Ron SwansonJump to last post
01/15/2015 2:28 PM
1 Replies and 1582 Views APINVOICE OPERATOR  1582  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 1582
by  John HenleyJump to last post
01/05/2015 4:11 PM
0 Replies and 1028 Views AR199 Year End Close Mistake  1028  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 1028
01/05/2015 1:10 PM
1 Replies and 1356 Views Inactivating a company  1356  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 1356
by  Jimmy ChiuJump to last post
12/17/2014 2:34 PM
0 Replies and 1049 Views Aging Reports (AR251) I.P.A.  1049  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 1049
12/15/2014 3:48 PM
0 Replies and 883 Views Asset Managment  883  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 883
12/15/2014 12:50 PM
2 Replies and 1301 Views Process Level Restriction  1301  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 1301
by  Dee HardyJump to last post
12/09/2014 1:19 PM
1 Replies and 1118 Views G/L Date Error  1118  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 1118
by  dcaianiJump to last post
12/05/2014 2:40 PM
1 Replies and 1317 Views PO25 Contract Agreements  1317  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 1317
by  JonAJump to last post
11/26/2014 1:39 PM
1 Replies and 1166 Views ERP Selection  1166  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 1166
by  alexrsJump to last post
11/18/2014 6:34 AM
0 Replies and 851 Views Staging table for AP comments  851  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 851
11/17/2014 10:36 PM
1 Replies and 1345 Views AP14.5 TIN Type Change with Add-Ins  1345  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 1345
by  jjcyeshuaJump to last post
11/13/2014 6:49 PM
2 Replies and 1222 Views Writing an Income Statement in crystal  1222  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 1222
by  jjcyeshuaJump to last post
11/12/2014 2:29 PM
5 Replies and 1406 Views Non-AR Backout  1406  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 1406
by  Ken UJump to last post
11/06/2014 2:59 PM
0 Replies and 904 Views Allocations  904  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 904
11/04/2014 11:44 AM
6 Replies and 4372 Views ACH and EDI  4372  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 4372
by  jj2020Jump to last post
10/31/2014 11:03 AM
0 Replies and 1104 Views Invoice entry AP20.2 Discounts AP22.3  1104  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 1104
10/23/2014 5:06 PM
7 Replies and 1891 Views Asset Management with 2 books??  1891  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 1891
by  jjcyeshuaJump to last post
10/22/2014 3:48 PM
2 Replies and 2463 Views Lawson Depreciation Reports  2463  2 Started by  JFutrelle Hey guys, I'm rather new to Lawson. We're running version I am trying to figure out how to run depreciation reports for a prior year. The reports that my company has been running (AM280 for instance) don't seem to have a field for run dates(i.e. 1/1/2012 - 12/31/2012). I've been told by those here before me that all depreciation reports have to be run at the end of a given period(on that actual day) to get an accurate depreciation report. That sounded a little ridiculous to m...
2 2463
by  jjcyeshuaJump to last post
10/20/2014 4:00 PM
0 Replies and 713 Views GM System control  713  0 Started by  whitey1287 Is there a GM system control closing job Similar to the other closing jobs
0 713
10/13/2014 11:40 AM
0 Replies and 959 Views Intercompany Relationships  959  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 959
10/03/2014 2:11 PM
0 Replies and 870 Views Foreign Vendors and 1042S Reporting  870  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 870
10/03/2014 11:00 AM
1 Replies and 1305 Views Invoices in AP36  1305  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 1305
by  darwin collinsJump to last post
10/02/2014 9:24 AM
7 Replies and 4664 Views Balance Sheet Report  4664  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 4664
by  AliseJump to last post
09/23/2014 3:37 PM
1 Replies and 1599 Views Accounts Payable Invoice Automation Invoice Scanning  1599  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 1599
by  Any ideas?Jump to last post
09/09/2014 11:24 AM
0 Replies and 1148 Views Load AP161 with Separate Payment & Remit to Document Express  1148  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 1148
09/09/2014 9:51 AM
0 Replies and 1055 Views Changing Fiscal Year-end Date  1055  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 1055
09/04/2014 12:20 PM
0 Replies and 1019 Views How people track Customer Comments In AR?  1019  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 1019
08/26/2014 5:27 PM
1 Replies and 907 Views Prenotification without processing via alternative method  907  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 907
by  Mark F. HardyJump to last post
08/26/2014 10:23 AM
0 Replies and 884 Views Tax Reports/Queries by Accounting Unit???  884  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 884
08/19/2014 1:28 PM
1 Replies and 1006 Views Override Base Zone on JE Header  1006  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 1006
by  BShortJump to last post
08/19/2014 12:27 PM
2 Replies and 1206 Views APINVOICE: MATCH_STATUS and MTCH_ERR_TYPE  1206  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 1206
by  JonAJump to last post
08/18/2014 11:54 AM
3 Replies and 5852 Views Recurring Journal Entries  5852  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 5852
by  dcaianiJump to last post
08/07/2014 1:36 PM
10 Replies and 10409 Views How to Upload Journal Entries  10409  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 10409
by  John HenleyJump to last post
07/24/2014 1:54 PM
3 Replies and 911 Views AC20.4_Activity Budget by Activity  911  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 911
by  whitey1287Jump to last post
07/24/2014 12:22 PM
3 Replies and 1579 Views Cash Book Poor Performance  1579  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 1579
by  John HenleyJump to last post
07/17/2014 2:46 PM
1 Replies and 2088 Views PA52.1  2088  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 2088
by  Jason BeardJump to last post
07/16/2014 9:03 PM
6 Replies and 1620 Views Add Image Link in AP150 Output  1620  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 1620
by  GiuliaJump to last post
07/15/2014 9:27 AM
3 Replies and 1277 Views Tax Codes and Imaging Solution into AP20.2  1277  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 1277
by  BillJump to last post
07/11/2014 10:46 AM
2 Replies and 1075 Views GL190 - (GL190.prt) modify sort order  1075  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 1075
by  TomJump to last post
07/01/2014 3:05 PM
2 Replies and 1569 Views GL20.2  1569  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 1569
by  whitey1287Jump to last post
06/19/2014 3:00 PM
0 Replies and 829 Views Lines in MA43  829  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 829
06/16/2014 2:39 PM
4 Replies and 1410 Views Using a WellsFargo Commercial Card in AP  1410  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 1410
by  Greg MoellerJump to last post
06/04/2014 2:51 PM
0 Replies and 3248 Views Report Writer Training Manual  3248  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 3248
06/02/2014 4:37 PM
3 Replies and 1929 Views Asset Mgmt partial disposal  1929  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 1929
by  JRC3769Jump to last post
05/13/2014 1:00 PM
0 Replies and 930 Views Adding additional costs to assets after placed in service  930  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 930
05/05/2014 9:04 AM
9 Replies and 1377 Views ESS Pay  1377  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 1377
by  ChescaJump to last post
05/02/2014 10:17 AM
2 Replies and 1264 Views Invoice Approval using ProcessFlow  1264  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 1264
by  OllertonJump to last post
04/30/2014 10:48 PM
2 Replies and 1423 Views Reconcile Received not invoiced between IC and AP  1423  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 1423
by  DaveJump to last post
04/30/2014 7:18 PM
0 Replies and 865 Views sales tax partner  865  0 Started by  tdwcpa I am searching for a sales tax partner for Lawson S3. Please provide recommendations.
0 865
04/22/2014 8:24 PM
0 Replies and 911 Views PR85 - reopen void  911  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 911
04/22/2014 10:14 AM
1 Replies and 995 Views Location of GL40.1 attachment comment text  995  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 995
by  DonnaJump to last post
04/16/2014 10:52 AM
2 Replies and 1584 Views GL199 Company Values changing  1584  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 1584
by  AustinJump to last post
04/15/2014 2:46 PM
0 Replies and 738 Views Activity Group POP- RNI Interface  738  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 738
04/09/2014 2:30 PM
0 Replies and 911 Views BR120/130 not balancing  911  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 911
04/09/2014 1:51 PM
1 Replies and 1611 Views Using MS Excel Database Connection Wizard  1611  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 1611
by  AriJump to last post
04/07/2014 4:51 PM
1 Replies and 957 Views AR20 batch processed under wrong process level  957  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 957
by  BasiaJump to last post
03/28/2014 2:40 PM
3 Replies and 2723 Views GL90 csv export name  2723  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 2723
by  DebbieKJump to last post
03/27/2014 1:49 PM
4 Replies and 3143 Views DIFFERENCE B/W COST CENTER AND ACCOUNTING UNIT  3143  4 Started by  batmanprime Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT
4 3143
by  Kat VJump to last post
03/24/2014 10:44 AM
0 Replies and 617 Views Discount with no Net Due  617  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 617
03/20/2014 7:54 AM
2 Replies and 1070 Views GL double posting LP accruals  1070  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 1070
by  ChescaJump to last post
03/11/2014 1:02 PM
0 Replies and 1374 Views CB185 Cash code not found for bank  1374  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 1374
02/27/2014 2:28 PM
2 Replies and 1075 Views Employer Medical Insurance Costs posted to GL  1075  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 1075
by  scuba80Jump to last post
02/26/2014 3:40 PM
0 Replies and 1486 Views Open Payables Report  1486  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 1486
02/22/2014 1:25 PM
0 Replies and 1032 Views AP240  1032  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 1032
02/22/2014 1:20 PM
2 Replies and 1139 Views Best Practices for tracking Discounts on Purchase Orders  1139  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 1139
by  Kat VJump to last post
02/19/2014 3:58 PM
0 Replies and 2037 Views Journal Entry Data dump  2037  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 2037
02/19/2014 3:36 PM
2 Replies and 1684 Views Uploading Assets into Lawson Asset Management  1684  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 1684
by  AshJump to last post
02/19/2014 1:29 PM
2 Replies and 1126 Views Nee help figuring out activity structure  1126  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 1126
by  BasiaJump to last post
02/19/2014 8:51 AM
1 Replies and 1267 Views PO20.1  1267  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 1267
by  Kat VJump to last post
02/14/2014 1:29 PM
3 Replies and 1869 Views Open A/P Invoices  1869  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 1869
by  BShortJump to last post
02/11/2014 7:54 AM
2 Replies and 1508 Views Lawson Financials S3 Archive/Purge Solutions?  1508  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 1508
by  R. LapierreJump to last post
02/07/2014 3:25 PM
0 Replies and 1001 Views GL190 journal posting sort order  1001  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 1001
02/03/2014 4:22 PM
1 Replies and 4158 Views Functional user manuals for V 9.0.1  4158  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 4158
by  JimYJump to last post
02/02/2014 5:23 PM
1 Replies and 2391 Views AM 255 Depreciation Projection  2391  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 2391
by  EllenPJump to last post
01/27/2014 4:10 PM
4 Replies and 3738 Views Too Many Decimals  3738  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 3738
by  MChismJump to last post
01/23/2014 12:30 PM
0 Replies and 827 Views Financial Roll reporting  827  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 827
01/13/2014 3:49 PM
10 Replies and 12367 Views Budget Upload  12367  10 Started by  jjcyeshua Hello!... lawson people.... I'm in the process of uploading a budget from excel spreadsheet to FBDETAIL, but i can't seem to find the form that would let me add new budget. Knowledge Search in says that i have to use budget interface to convert the new budget data that i have, but when i access FB165 its only generating report. Where should i start the process of uploading the budget and how.. Thanks again in advance
10 12367
by  TesterJump to last post
01/07/2014 4:13 PM
5 Replies and 2265 Views PO230 Error  2265  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 2265
by  JonAJump to last post
12/27/2013 3:43 PM
4 Replies and 1246 Views Asset Transfer Load in AM30.1  1246  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 1246
by  IanJump to last post
12/23/2013 11:51 AM
5 Replies and 2936 Views Defaulted Payment Terms  2936  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 2936
by  dcaianiJump to last post
12/17/2013 8:30 AM
4 Replies and 1256 Views Company Status = Test  1256  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 1256
by  DeronJump to last post
12/12/2013 3:40 PM
1 Replies and 1117 Views AR/BL from Lab Software to interface w Lawson  1117  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 1117
by  Ken UJump to last post
12/10/2013 6:13 PM
0 Replies and 976 Views LPA/IPA naming standards  976  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 976
12/06/2013 4:54 PM
0 Replies and 896 Views Invoice Matching Workfile Cleanup  896  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 896
12/04/2013 8:03 AM
0 Replies and 1805 Views Death notice of LACOBRTS  1805  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 1805
12/02/2013 12:55 PM
2 Replies and 1007 Views Remove a displayed benefit in the add beneificiaries ESS  1007  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 1007
by  LisaJump to last post
11/25/2013 4:46 PM
1 Replies and 951 Views AP155 Payer Address on File  951  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 951
by  JeremyJump to last post
11/20/2013 4:55 PM
3 Replies and 905 Views Online Entries & Interface Source  905  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 905
by  John HenleyJump to last post
11/15/2013 12:28 PM
3 Replies and 6416 Views Infor’s Lawson Accounts Payable Invoice Automation system  6416  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 6416
by  John HenleyJump to last post
11/08/2013 1:07 PM
1 Replies and 1482 Views AP520 and One Time Vendor  1482  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 1482
by  brainetJump to last post
11/01/2013 9:22 AM
2 Replies and 867 Views Employer Issued Credit Cards - Where Maintained  867  2 Started by  BradF Is there anyone who does this
2 867
by  Greg MoellerJump to last post
10/31/2013 8:55 AM
8 Replies and 2624 Views Loading Fixed Assets into Lawson AM  2624  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 2624
by  Bob CanhamJump to last post
10/24/2013 2:34 PM
1 Replies and 1077 Views Converted Assets Not Calculating Depreciation  1077  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 1077
by  IanJump to last post
10/23/2013 6:04 PM
1 Replies and 1046 Views Restricted Funds  1046  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 1046
by  Bob CanhamJump to last post
10/22/2013 12:14 PM
0 Replies and 881 Views Audit Data? EFT/Banking Information in AR  881  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 881
10/21/2013 3:04 PM
0 Replies and 1628 Views Cost Allocation  1628  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 1628
10/21/2013 12:25 PM
0 Replies and 828 Views Merging Summary Accounts  828  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 828
10/14/2013 5:35 PM
0 Replies and 1218 Views Adding a new Data Area tonight  1218  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 1218
10/14/2013 2:02 PM
5 Replies and 1291 Views What Lawson form??  1291  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 1291
by  Greg MoellerJump to last post
10/11/2013 3:27 PM
2 Replies and 1368 Views List of forms to change GL information - Changing GL  1368  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 1368
by  OllertonJump to last post
10/09/2013 4:38 PM
2 Replies and 1517 Views Managing GL,AP, AR interface fallouts  1517  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 1517
by  John HenleyJump to last post
10/03/2013 5:04 PM
9 Replies and 1342 Views How to tell if a job posted successfully i.e. GL165  1342  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 1342
by  Greg MoellerJump to last post
10/03/2013 4:43 PM
1 Replies and 1042 Views Track new accounts or new accounting units created during a period of time  1042  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 1042
by  Anna TianJump to last post
10/02/2013 2:18 PM
1 Replies and 1240 Views Audit for Activities  1240  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 1240
by  LynneJump to last post
09/30/2013 7:57 AM
1 Replies and 1550 Views MA540 Vendor Payment Terms v. AP10 Vendor Payment Terms  1550  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 1550
by  JonAJump to last post
09/24/2013 9:23 AM
1 Replies and 1174 Views GLTRANS field acct_amount  1174  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 1174
by  SNJump to last post
09/21/2013 9:47 PM
15 Replies and 11992 Views EDI 810 Invoices  11992  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 Looking forward to networking with you.
15 11992
by  Shannon RJump to last post
09/20/2013 10:07 AM
0 Replies and 888 Views Merging with another company  888  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 888
09/18/2013 5:11 PM
3 Replies and 2197 Views Vendor Mergers and Acquisitions  2197  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 2197
by  JonAJump to last post
09/06/2013 3:05 PM
4 Replies and 1353 Views Report job to csv  1353  4 Started by  Justin R I have an AR250 job. Is there a way I can automically ouput that as a csv file
4 1353
by  Greg MoellerJump to last post
08/27/2013 1:57 PM
2 Replies and 2317 Views BR120 output, need an invoice in a format readable by Crystal Reports  2317  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 2317
by  BaloyJump to last post
08/27/2013 1:28 PM
1 Replies and 1843 Views Change Cash Code on Unpaid Invoices in AP  1843  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 1843
by  Bob CanhamJump to last post
08/20/2013 2:40 PM
0 Replies and 1482 Views Accounts Payable Merging of 2 Vendor Groups  1482  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 1482
08/09/2013 1:34 PM
2 Replies and 2014 Views remittance notice for ACH payments  2014  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 2014
by  Maynard F.Jump to last post
08/07/2013 10:59 AM
1 Replies and 912 Views lp01 drop-down menu  912  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 912
by  Greg MoellerJump to last post
08/06/2013 2:29 PM
0 Replies and 854 Views Matching in AP55  854  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 854
08/06/2013 8:43 AM
9 Replies and 2193 Views Interfacing into a Surgical Information System  2193  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 2193
by  Greg MoellerJump to last post
08/05/2013 9:13 AM
1 Replies and 1378 Views AP155 report format limitations  1378  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 1378
by  Ragu RaghavanJump to last post
08/03/2013 9:05 AM
4 Replies and 2677 Views What is the best way to create an elimination company?  2677  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 2677
by  MelissaJump to last post
07/27/2013 8:14 PM
0 Replies and 1056 Views Binding Billing API (BLOEL71PD) RPGLE  1056  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 1056
07/25/2013 4:59 PM
2 Replies and 1900 Views Question on Purging Vendors  1900  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 1900
by  Bob CanhamJump to last post
07/25/2013 10:57 AM
0 Replies and 852 Views How to get copy invoices from M3 in an electronic format  852  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 852
07/25/2013 6:21 AM
1 Replies and 1288 Views Audit tracking on GL20.2  1288  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 1288
by  John HenleyJump to last post
07/19/2013 10:43 AM
1 Replies and 944 Views Percent Complete Calculation - AC165 and BR165  944  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 944
by  John HenleyJump to last post
07/09/2013 6:51 AM
11 Replies and 2024 Views GLAMOUNTS and GLUNITS Tables  2024  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 2024
by  DeronJump to last post
07/02/2013 2:40 PM
1 Replies and 1295 Views Reporting  1295  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 1295
by  Tony ConwayJump to last post
07/01/2013 4:25 AM
3 Replies and 2233 Views Invoice Line item detail  2233  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 2233
by  Bob CanhamJump to last post
06/28/2013 10:34 AM
1 Replies and 2636 Views Cost Center hierarchy  2636  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 2636
by  Rich BendicksonJump to last post
06/24/2013 2:55 PM
2 Replies and 1436 Views GL192  1436  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 1436
by  Terry WierJump to last post
06/24/2013 2:36 PM
1 Replies and 1311 Views copy/paste functionality from LID vs portal with LSF9  1311  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 1311
by  John HenleyJump to last post
06/11/2013 3:39 PM
2 Replies and 1765 Views Crystal Report-Financial Ratios Chart/Graph  1765  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 1765
by  DonnaJump to last post
06/10/2013 3:35 PM
1 Replies and 1567 Views Adding Vendor Class to AP20.1  1567  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 1567
by  Ragu RaghavanJump to last post
05/29/2013 1:18 PM
1 Replies and 1410 Views Break up details- GL90.1  1410  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 1410
by  mark.cookJump to last post
05/21/2013 8:00 AM
2 Replies and 1619 Views Info Browser  1619  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
2 1619
by  Diane GJump to last post
05/17/2013 10:08 AM
5 Replies and 1643 Views mx10 interface  1643  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 1643
by  John HenleyJump to last post
05/16/2013 12:48 PM
0 Replies and 909 Views customer process level and (revenue) account  909  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 909
05/16/2013 11:54 AM
1 Replies and 1301 Views AP 20.2 Alowing invoice to post over Activity Budget  1301  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 1301
by  LauraJump to last post
05/16/2013 7:38 AM
0 Replies and 914 Views AM20.3 Add-ins upload to add serial number  914  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 914
05/15/2013 10:18 AM
0 Replies and 3242 Views Bad File status 3 5 on sortfile  3242  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 3242
05/15/2013 9:56 AM
0 Replies and 919 Views Reopen Year End  919  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 919
05/14/2013 9:00 AM
0 Replies and 940 Views RW 100-Ratios  940  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 940
05/13/2013 2:23 PM
3 Replies and 1049 Views Where would i find start time end time for daily productivity report  1049  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 1049
by  Ruma MalhotraJump to last post
05/13/2013 12:21 PM
3 Replies and 2228 Views AP30.2 Distribution changes post 9.0.1 Upgrade  2228  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 2228
by  KarenBCIJump to last post
05/09/2013 5:04 PM
2 Replies and 2484 Views Grant Tracking: Accounting Units vs. Activities  2484  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 2484
by  Michael GraceJump to last post
05/09/2013 12:09 PM
0 Replies and 935 Views Bulk Load of EFT Setup Data?  935  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 935
05/06/2013 1:59 PM
2 Replies and 1804 Views How to Require Activity & Account Category  1804  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 1804
by  CindyJump to last post
05/02/2013 10:21 AM
0 Replies and 958 Views AC500 - report showing duplicated lines..  958  0 Started by  johne and if so, have you searched / found a patch to correct the problem.. QA person is testing against a 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 958
04/29/2013 3:45 PM
2 Replies and 1034 Views GL40 Status Message Account Category Required  1034  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 1034
by  Ken CarleyJump to last post
04/29/2013 1:19 PM
2 Replies and 1542 Views Lawson Excell Add-Ins  1542  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 1542
by  John HenleyJump to last post
04/29/2013 8:44 AM
3 Replies and 1284 Views GL security classes for LSF9 security  1284  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 1284
by  GeorgetteJump to last post
04/25/2013 11:08 AM
1 Replies and 1149 Views Colliding Allocations CA190 GL190  1149  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 1149
by  BarbaraJump to last post
04/14/2013 8:53 AM
0 Replies and 851 Views I need last updated column details on tables  851  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 851
04/11/2013 8:14 PM
0 Replies and 783 Views PTO GL Questions (XPosted)  783  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 783
04/08/2013 10:09 AM
3 Replies and 1360 Views Laser Check Printing File Security  1360  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 1360
by  BrianJump to last post
03/31/2013 12:40 PM
3 Replies and 1303 Views AP270 invoice detail?  1303  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 1303
by  Greg MoellerJump to last post
03/28/2013 9:24 AM
4 Replies and 955 Views Report over PO  955  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 955
by  Greg MoellerJump to last post
03/27/2013 1:07 PM
0 Replies and 1010 Views Asset Management S3  1010  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 1010
03/14/2013 4:09 PM
0 Replies and 1376 Views Asset Management  1376  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 1376
03/14/2013 3:48 PM
1 Replies and 1001 Views need help with benchmarking  1001  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 1001
by  DougABJump to last post
03/12/2013 3:57 PM
0 Replies and 784 Views Prior year reqs  784  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 784
03/11/2013 7:46 PM
2 Replies and 1203 Views How do I create a new ATN-OBJ-ID?  1203  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 1203
by  DonnaJump to last post
03/07/2013 5:13 PM
7 Replies and 1322 Views Vendor file read  1322  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 1322
by  slm4Jump to last post
03/04/2013 2:30 PM
0 Replies and 944 Views Physical 2 Virtual converstion  944  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 944
02/27/2013 12:05 PM
1 Replies and 1469 Views Reconciling A/P to G/L  1469  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 1469
by  martyzoetJump to last post
02/25/2013 3:18 PM
2 Replies and 1575 Views Consolidation company  1575  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 1575
by  Display NameJump to last post
02/24/2013 7:39 AM
4 Replies and 1221 Views Lawson Monitor  1221  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 1221
by  RickyYJump to last post
02/22/2013 6:21 PM
1 Replies and 3357 Views GL - Reopen Final Close Period  3357  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 3357
by  John HenleyJump to last post
02/19/2013 10:42 AM
3 Replies and 1457 Views Accounts payable processing  1457  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 1457
by  Kat VJump to last post
02/18/2013 4:00 PM
0 Replies and 1189 Views User Audit Trail? - AR82.1 - Returned Payment  1189  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 1189
02/15/2013 2:18 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