I'm trying to query the Note to Buyer field, which resides in the RQ10 Vendor field drill down. Can anyone tell me what database table I can find that in Thanks, Chris

We normally escheat our AP checks on a regular schedule. However, our patient accounting department has done due diligence on some of our patient refund checks and would like to escheat those early. We can't find an easy way to do this though as those payments come out of our main checking account. The only way I can see to do it is to stale date everything, manually escheat the patient refunds, and then manually reinstate all of the checks. Does anyone do this and know an easier way

We converted to Infor/Lawson from PeopleSoft recently. In PS, we included PO line level in our Budget Advisor AP reports. Currently in Infor, we still include PO purchases in our month end AP BA reports; that current build summarizes PO data at the PO level for each GL account/AU (rather than PO line level detail). However, we have problems pulling in relevant description b/c the PO description available for us to use is not necessarily indicative of all the items purchased on the PO. This has...

Good Morning, I am working on creating an MS Add-in upload template for manual deposits entered into CB10 (Cash Receipt Deposit). The upload needs to create the Deposit 'header' in CB10.1, populate the breakdown of the deposit for CB10.3 and allow for overwrite account details in CB10.4 as needed. My company does not utilize the Journal Book option. Attached is the working copy of my template. First tab loads CB10.1 (deposit header) loads perfectly. The second upload to attach the detail t...

Hi, We just upgraded to Lawson v10 and are using IE 11. Has anyone encountered an issue in AP90.1 where after inquiring for a vendor, you hit next or previous and the whole screen doesn't refresh We have an end user who was inquiring a vendor invoice. She noticed that if a vendor has multiple invoices that takes up the whole screen and when she clicked on Next or Previous where the next vendor has one invoice, the rest of the screen is still showing the PL and User Field 1 data from t...

Using just three criteria: COMPANY equal company number (just one) APVENMAST.VEN-CLASS equal class (just one) APPAYMENT.CHECK-DATE = greater than or equal too a given date Table is large and query runs for about an hour and a half. Didn't know if someone knew if there was an index I could select that might speed this up, at least a little bit. Currently no Index\Key Value set in query. Thanks!

We have used Convey to produce our 1099 forms in the past. This product is being sunset in the near future, so we're looking for other options. How are others producing their 1099 forms and IRS file Are you using Lawson with MHC Or are you using some other 3rd party

Having become 'affiliated' with a larger company, we are moving away from our own Lawson system onto a corporate system but we are not there yet. We have discontinued our use of Lawson HR / payroll applications as of a year ago. Being on 9.0.1 our extended support is sunset as of the end of May 2017. We will not be ready to move off of our Lawson IC / AP system for a while yet. We have been quoted a very large sum to upgrade our system to v10 (or whatever is current) including migrating to Lawso...

We have quite a few assets that need to be added to our Lawson system before our fiscal year-end which is June 30. I have been told that AM500 may be our only options; however, that does not create the GL journal entries automatically and we would have to manually create them after loading the assets. Has anyone completed a mass addition of assets If so, what process did you use Any information on how to do this mass addition is greatly appreciated. Thanks, Rhonda

Hello, I work with Infor daily and I have noticed that some screens such as the AC290 have a print manager button but others do not. Is there a way to add a print manager button to the GL90 instead of having to open a new tab and searching print manager

Hi - thanks in advance for any feedback. We want to add Payee Name to our positive pay file to Bank of America for AP. Initially - it seemed as simple as taking the Legal Name from AP10 (APVENMAST) and putting it into the Payee Name in the CD0200R record for BofA. In our Lawson system - our AP staff also may put additional 'payee' information in the first couple of address lines and then have the last line for the actual address. Bank of America is failing all of these payments because they ...

We recently upgraded to Lawson 10. Somehow in the process, I lost the ability to just enter the first letter of a field, hit my down arrow and have the next item in the selection populate. For example, when entering a new asset, we have 40 locations. I could enter a P hit my down arrow once and Perry would populate. I have not been able to find a setting to change this. If I right click on a field it says - Select from data list Enter This is minor, but annoying.

Good Morning We recently upgraded to Smart Recon SMR_10000516 and Smart Recon is VERY slow. Has anyone else had this issue thanks brooke

My users accidentally final-closed periods FY17 periods 1-12 while. They try to run the GL199 but the system won't let them change the FY17 periods back to limit-close. I put a ticket with Lawson but unfortunately there is no way for the system to undo a Final Closed period. They suggested a resolution but it's out of their scope and will be use at our own discretion. Do you know another way to do this

I have been trying to figure out what will be the primary keys required to make a lawson query to pull information of the AP10.5 Form My understanding - 1)AP10 need the 1. VEN-VENGROUP AND 2. VEN-VENDOR to inquire the information of that form 2)AP10.5 needs 1.APX-VENDOR to inquire and change - Lawson query - _PDL=TEST&_TKN=AP10.5&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&APX-COMPANY=100&APX-TERM-CODE=&APX-VENDOR=56302&_DELIM=09&_OUT=XML&_EOT=TRUE I inte...

How do you process a credit memo when it comes via EDI and is translated to the MA540CSV file Our AP departments says they error out and they just deleted them and request a paper credit memo from the vendor. The Infor/Lawson KB says that you can receive credit memos via EDI but doesn't say anything about how to process them with MA540.

We are looking for the best way to report and track projects in our general ledger account for CIP. We are considering using either activities or subaccounts. Does anyone have any advice as to which would be the best option Does anyone have any general advice for using subaccounts Pros and cons Thanks, ED

I have a group of pre-existing accounts that are active in some accounting units and inactive in other accounting units.  I want to make these accounts active for all accounting units.  I have tried using GL 100 (Mass Chart Acct Change Delete) and GL 121 (Mass Account Addition).  Does anyone know how to do this

Hello All, Am facing an error while submitting jobs in INFOR Lawson... Here is the Error message....Can any one please help me out to fix this... JobSubmitter:handleError():Job Submit Failed, check your parameters. Details: com.lawson.ios.common.impl.CGIResponseException: JobSubmitter:handleError():Job Submit Failed, check your parameters. at com.lawson.ios.jobs.job.impl.JobSubmitter.handleError(JobSubmitter.java:308) at com.lawson.ios.jobs.job.impl.JobSubmitter.submitJob(Job...

Currently when we run PO135, it doesn't appear that the POs that are coded to Activities (construction projects & fund accounting) are hitting AC. They are hitting the GL, causing a difference between the GL & AC. What is best practice - to leave these as reconciling items between AC & GL or load these POs into AC We have only been live with Lawson a short time so any input is appreciated. Thanks!

We use a CB deposit upload template to record various deposits throughout the organization. We use the description field of the upload to describe what the deposit relates to & load that into CB. However, once we post those transactions into the GL, the detailed description from the template does not show; rather, the JE is a 'summarized transaction' or 'misc GL deposit'. Is there a way to have these detailed descriptions to come over to the GL

Hi, any customers out there that use Cerner Millennium to Lawson GL s3

Hi everybody, Has anyone integrated Lawson with Raiser’s Edge Fund Raising Software If so, in which Lawson modules are you interfacing Raiser’s Edge Fund Raising Software transactions Thanks for reading my post! Joanna

My MSCM screen is not working. I can log on but cannot see my reports in Par Counting. Two other users have reported the same problem. It's not happening to every user, which is so weird. I put a ticket with Lawson but they don't seem to know what is causing this issue.

We have a person who keys in patient refunds to our Lawson system. She needs to be able to create one-time vendors for this (as the patient becomes a vendor). However we don't want the person to have the ability to go into the Vendor screens and just add new vendors. Is there a way to allow for adding one-time vendors only We are on Applications v 9.0.1.9 and LAUA security at this point.