Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 512345 > >>
Topics
 Replies
 Views
 Last Post
1 Replies and 130 Views Lease Management Uploads  130  1 Started by  itsjustme We are implementing Lease Management (LM) module and are wanting to upload them rather than key them in. Since we are new to this module, creating our own mapping we could miss some fields that we would need later etc so looking for someone who has done that already. Thanks Dave
1 130
by  LynnetteJump to last post
08/15/2018 12:41 PM
0 Replies and 42 Views Entering Invoice for Closed PO Line  42  0 Started by  Jeremy We are reevaluating several of our practices and one that has come us is invoices for PO Lines that are closed. How do other handle these I'm not sure if there's a way or a setting that would allow the match screen (MA43) to display PO lines that are closed so we could enter the invoice for the PO line and let it trigger a buyer message or something like that. Is this possible How do others handle these types of invoices
0 42
08/14/2018 3:34 PM
3 Replies and 523 Views GL monthly balances  523  3 Started by  Chesca I need to dump data from Lawson for budgeting analysis and need help with finding the right data fields/databases to pull from. Is there a Lawson screen/table that stores monthly activity for income statements accounts and ending balances for balance sheet accounts Any input would be greatly appreciated
3 523
by  blongJump to last post
07/19/2018 10:25 AM
0 Replies and 107 Views Credit Memo for Service PO  107  0 Started by  Jeremy Here are the details of my example: PO with one amount-type service line for $1000. Invoice comes in for $1000 and is fully matched and paid. PO Line is now 'closed' but PO190 not yet ran, so header is still open. We should have only been invoiced partially, let's say for $500. Credit memo for $500 comes in. So, what I have done is entered the credit memo information, including the information on the Misc. tab, selecting the original invoice. Then, go to MA42.1 - Memo Line Detail - Purc...
0 107
07/13/2018 3:34 PM
3 Replies and 239 Views Tables needed to view PO and financial activity  239  3 Started by  Chesca We are trying to extract AP and PO data for financial reporting and not sure what tables would give me purchase order info including accounting unit/account/sub account, fiscal year/month, number of units order, cost per item, invoice number, invoice date, invoice status, PO number, line number, line description, vendor code/name, check number, journal number, journal entry ID, line number, and check date/payment date Thanks in advance for your assistance
3 239
by  Kat VJump to last post
07/09/2018 10:10 AM
0 Replies and 78 Views Statistical by day data  78  0 Started by  Chesca Hello, what Lawson tables would I need to join to create a crystal report showing company, unit cost center, account, sub account, start date, and amount I was thinking possibly the GLTRANS, thanks in advance for your assistance.
0 78
06/27/2018 9:52 AM
5 Replies and 3065 Views AP Invoice Report  3065  5 Started by  Chesca Hello, does anybody know if there is a Lawson report to see how many invoices are processed by each A/P clerk
5 3065
by  ChescaJump to last post
06/26/2018 2:12 PM
3 Replies and 345 Views Extracting Detailed Journal Entries  345  3 Started by  Chesca I am trying to write an GL detail report in Crystal or SQL that should include the following data. I think I can get most of the information from GLTRANS. Lawson suggested I extract the data from GL90 but that seems very simple Company department code account code as assigned by client in their GL Sub account Fiscal Month Fiscal year amount Post date of the transaction line Item description of the transaction line Journal number Journal line...
3 345
by  ChescaJump to last post
06/25/2018 8:20 AM
2 Replies and 257 Views Tables Needed to View Spend for Activity  257  2 Started by  MChism My Director is requesting report that will show all spend for a particular activity. I can't look at a canned report as I need to pull data from our expense management system. I need to look at the fields on paid invoices as this will capture both Lawson data and Expense management data. What fields do I need to build a Crystal report for this
2 257
by  ChescaJump to last post
06/25/2018 8:17 AM
1 Replies and 504 Views Cash Reconciliation  504  1 Started by  Boyd We are having trouble reconciling a CB bank account to GL. We have verified that all transactions are present in the bank account, CB and GL. Also, we verified that our beginning balance matches the ending balance from 12/31/17. We have run out of places to look. Any thoughts/tips/tricks are appreciated.
1 504
by  Darrin MichaelJump to last post
06/14/2018 10:36 AM
2 Replies and 305 Views Understanding Inv Discrepancy Scenerios  305  2 Started by  Casy We have noticed that sometimes quantity issues will appear on MA236 and sometimes they will go to MA64. We want to know the criteria that would cause a quantity issue to go to one or the other so we can better work our invoice discrepancies. Has anyone else experienced this
2 305
by  CasyJump to last post
06/11/2018 8:29 AM
0 Replies and 125 Views AP/PO System Setup  125  0 Started by  Boyd We are in the process of setting up a new company in Lawson. Unfortunately, our most recent process narratives for AP, PO, MA and IC don't appear to be the latest and greatest. Therefore we can't seem to get MA and IC fully set up. Is someone willing to share set up process documentation for MA and IC We are on version 10.
0 125
06/08/2018 12:11 PM
1 Replies and 242 Views AM135 error  242  1 Started by  Boyd We are trying to transfer assets in AM between companies. When we complete this on a line by line basis in AM, all seems to work fine. When we attempt to complete this using AM135 we receive the following error message: 'To-company accounting unit does not exist'. Any thoughts are appreciated.
1 242
by  Bob CanhamJump to last post
06/06/2018 3:29 PM
1 Replies and 232 Views Paying a vendor different from vendor on PO  232  1 Started by  JonA St. Jude was purchased by Abbott last year. We updated the vendor on all open St. Jude POs in January. Some could not be changed due to previously matched invoices. We have an invoice for one of these POs that AP needs to pay to Abbott. I'm on the procurement side so I'm no that familiar with AP processing. Can AP match the PO and change the vendor on their side to pay to Abbott even though the PO vendor is St. Jude
1 232
by  TWieseJump to last post
06/06/2018 9:23 AM
1 Replies and 258 Views Adding new Item Type codes  258  1 Started by  Brett Our finance department is creating requisitions with the Quantity field populated with the dollar amount and the unit cost field with 1 for PO's that are for services. They are also making all requisitions a special type and not using the service type when creating these. The reason being from what I have heard is you can't receive on Service PO's and there are no reports for viewing open Service PO's. One suggestion I had was to add another item type code to identify it as Special\Service or wh...
1 258
by  Kat VJump to last post
06/04/2018 3:51 PM
2 Replies and 558 Views Accounts Receivable to sell products  558  2 Started by  Casy Is anyone using the AR system to key in product sales We are looking to do this but currently do not have the AR system set up at all so trying to see if this is an option for that part of the application.
2 558
by  RussMulJump to last post
06/01/2018 9:05 AM
1 Replies and 411 Views OnBase Expense Report interface to AP and Pay though PR  411  1 Started by  MattB Hello all, We are looking to develop an OnBase form for entry and approval routing of expense reports. After submission the reports would sit in an audit queue until approved. After approval we would run a report and extract of 'approved pending payment' reports. We are working though option of import into Lawson. Since they will be paid through payroll that would be our preference but can't figure out how to have one payment code with multiple expense distribution lines. Our other t...
1 411
by  KellyJump to last post
05/17/2018 4:05 PM
6 Replies and 12686 Views Patient Refund .CSV file  12686  6 Started by  Deleted User I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice
6 12686
by  KellyJump to last post
05/02/2018 11:39 AM
1 Replies and 609 Views Duns Numbers for Vendors  609  1 Started by  Eviecat21 Is there a field where the DUNS number can be maintained for a vendor
1 609
by  Kat VJump to last post
04/25/2018 12:11 PM
0 Replies and 192 Views Smart Reconciliation  192  0 Started by  Casy We have read through the user guide but were hoping to find a training video or additional documentation to ensure we are using it correctly. I haven't seen any videos on Infor Campus related to this. Does anyone know of any resources we could use to train our end users Thank you!
0 192
04/25/2018 12:06 PM
1 Replies and 788 Views Messaging for Discrepant Invoices  788  1 Started by  Casy Currently our buyers work messages on MA64 but we don't have a good way to send these messages back to Accounting when needed. We are considering building the AP Clerks as buyers so that they can view these messages OR building an AP buyer user that all AP Clerks can use to view their messages on this screen. Has anyone ever tried to do this before and if so, how did you achieve it Thank you!
1 788
by  Kat VJump to last post
04/03/2018 12:10 PM
8 Replies and 781 Views Report of Completed Jobs  781  8 Started by  hussey1213 Does anyone know if there is a way to get a dump/report of Completed user jobs We're trying to perform some job analysis; determine run times, number of times users are running jobs, etc. In LID I can copy from Completed Jobs in jobschd manually but that's going to be time consuming. Any help would be greatly appreciated. Thank you.
8 781
by  hussey1213Jump to last post
03/28/2018 9:18 AM
1 Replies and 882 Views GL65.5 Errors  882  1 Started by  J Haveman I am using a Infor-provided IPA flow which drops a file into the /work/GL65CSV folder. It then attempts to execute a GL65.5 to import the CSV file. I get an error every time in the Work Unit log: File has already been processed. (I can also do this via Portal and get the same errors when executing GL65.5 directly without the IPA flow.) When I look at the LAPM log, I see different errors: 1) 'CSV Hdr Read Error: Fld Name A-N-Y--F-I-E-L-D--N-A-M-E Not Found' 2) File GL65CSV Al...
1 882
by  Jason BeardJump to last post
03/16/2018 9:20 AM
1 Replies and 962 Views Portal Cannot Load because of SSO Compenent  962  1 Started by  alarson90187 Hello, We recently went through a system conversion to a different ERP and we were still using Lawson 9.0.4. Today the system is tossing the servlet call /ssoconfig/SSOCfgInfoServlet error and we can't connect through portal. I can RDP into the machine, connect to LID, and LDAP bind to our active directory. But I cannot figure out why this error is popping up now. I cannot access the Lawson RM or Lawson Security tools, i receive an SSO connection failure response. I know this is way ...
1 962
by  Jason BeardJump to last post
03/09/2018 3:18 PM
1 Replies and 1728 Views Vertex O series failure on v10  1728  1 Started by  Big_Mike So our issues have been going on for almost a year. As it turns out we are one of two clients on S3 version 10, on a windows platform, attempting to use the Vertex O series. We have multiple environments and have not had any success with configuring, patching, etc getting the systems to talk to each other correctly. Our other integration's, which number in the 100's, run flawlessly. The keep or toss moment is here as its' implementation is holding up several large initiatives and I was hopin...
1 1728
by  Jeremy_T.Absolute!Jump to last post
02/09/2018 11:26 AM
4 Replies and 1898 Views Remove items PO135  1898  4 Started by  rhorn01 We are fairly new to Lawson/Infor . . . in reviewing the latest PO135 we have identified items that have been paid outside of the PO and items that need to be removed for other reasons. What is the best way to remove these items from the PO135 Do we manually close the PO I have seen some references to the MA180, but we had one consultant advise us not to run that report. Any specific information/screen names would be helpful. Any best practices in monitoring this report Thanks!
4 1898
by  Kat VJump to last post
02/08/2018 3:42 PM
0 Replies and 183 Views SmartOffice Scripts not Saving to User Profile  183  0 Started by  Marcus Santodonato I have an issue in SmartOffice. After going to 'Tools > Personalization > Scripts > Add Script > Save', the script is not being retained in the user's profile settings after they log out. This particular script is supposed to add a couple of buttons to the PO20.1 screen. The buttons are added successfully at first but then when the user logs out and logs back in, the buttons are gone. We are running version 10.2.1
0 183
02/05/2018 9:47 AM
0 Replies and 206 Views SOP for Procurement and AP on Vendor Return  206  0 Started by  MChism I'm struggling to find the accurate process for both purchasing and accounts payable to process a return. Our issue with our current process is that our purchasing team will process a return in PO31 for an item. The credit will then be processed by accounts payable and will keep the PO closed. When the replacement item comes in, AP attempt to match to the same PO as referenced on the invoice and they will receive an error that the credit can not be processed on a closed PO. I feel that there...
0 206
02/02/2018 11:49 AM
0 Replies and 210 Views Changing Pay Group on Company  210  0 Started by  Deron We want to change a company's pay group. When we type in the new pay group and press change on AP00.4, we receive the following error: 'Invoices entered; use AP101 to update pay group'. There are no unpaid invoices for this company. When we run AP101, we receive 'No Data in Report File - Check Report Parameters for Possible Error Message'. Any ideas
0 210
01/31/2018 5:36 PM
8 Replies and 1400 Views Huge error-rpt files created when report errors  1400  8 Started by  Kert490 We have had several instances where our Lawson drive space was suddenly eaten up with no warnings, going from under 50 to over 95 and causing failures. We have found that the space is being taken up by error files in the users print directory. There are 2 files created: error-rpt (around 40 GB) and error_rpt.dtl (around 5 GB). These are much larger than the normal files that are created when a report errors. We can go through and delete the files and restore the space, but we would like...
8 1400
by  Kwane McNealJump to last post
01/30/2018 6:28 PM
1 Replies and 1502 Views Upgrade from V10 to V11  1502  1 Started by  PeshWen We are headed to the West Coast Mega Meeting in Newport Beach, CA in a few weeks and we would love to chat with someone who is in a healthcare setting who has gone through the upgrade from V10 to V11. Does anyone know of a company that has It doesn't necessarily have to be in a healthcare setting also. Thanks.
1 1502
by  AlanKJump to last post
01/10/2018 7:47 PM
7 Replies and 3336 Views PO120 EDI orders  3336  7 Started by  Chesca I want to be able to run a multistep job that will create and release POs, create EDI orders and then transmit all these POS at once to GHX. Does anybody know if this is possible or do I need to schedule a PO120 and an ED501 for each vendor PO100 for vendor A and location A and B, vendor B location A, Vendor C location D PO120 same as above ED501 - take all the EDI orders created by PO120 and transmit to GHX
7 3336
by  darwin collinsJump to last post
12/16/2017 5:11 PM
0 Replies and 188 Views AP30.2 and Missing PO from original distribution  188  0 Started by  kcollins_jax We often have to redistribute an expense that has already been paid. So we use AP3.02 to complete the redistribution. However, we are not able to include the PO associated with that purchase, and therefore the PO is no longer connected to the expense in it's new distribution. We're told this is by design, and the only way to change this would be to redo the entire AP process. Is there another way
0 188
12/11/2017 9:47 AM
2 Replies and 1634 Views Fiscal Year change to Calendar year  1634  2 Started by  TWiese Our organization just announced its being sponsored by another Healthcare Ministry. They currently run their financials on a calendar year. We closed FY17 in June. We started FY18 in July. I need ideas as to how others have worked with this type of situation(moving 6 months of data into a new FY) I have been given instructions to use GL500 but the logic does not make sense for our particular situation. What happens to the first 6 months that are also reflected in Flex Budgeting, AC/AM. H...
2 1634
by  Len PJump to last post
12/01/2017 1:46 PM
2 Replies and 1693 Views Smart Reconciliation  1693  2 Started by  Patricia Mane Who out in the Lawson world is using Smart Reconciliation We have this product and of course like all others, the User Guide doesn't provide adequate instructions. Thanks Trish
2 1693
by  JeremyJump to last post
11/10/2017 1:15 PM
7 Replies and 3010 Views Processing Vendor Refunds  3010  7 Started by  Radu I am trying to figure out a way to recognize vendor refunds through the AP module so that, when I process 1099s, the amount paid to the vendor shows up correctly. Historically, we just booked the refunds manually in the GL module, but obviously this does not reduce the amount reported on 1099s. The subsequent process was to create offsetting credit and debit memos in AP and a cash transaction in CB, but again the offsetting credit and debit memos do not reduce the reported 1099 amount. Ultima...
7 3010
by  JeremyJump to last post
11/10/2017 7:38 AM
3 Replies and 2332 Views LID Commands  2332  3 Started by  Evil Beagle I've got a question in regards to LID commands. I've run help to get a list of commands for LID. What I'm trying to accomplish is, simply, listing the files within the currently selected folder. According to help, 'DIR' is the command. However, running DIR in any folder gives me 'dir: file not found'. Has anyone else run into this issue
3 2332
by  Ray JuodisJump to last post
11/03/2017 9:23 AM
2 Replies and 1533 Views Status on Req in RQC compared to Shipment status on WH80  1533  2 Started by  Bev Edwards A req in RQC shows a req as Processed. A Shipment status on the same req number shows a status of Closed. On the example I have attached, there is a b/o or 10. Is the status on the WH80 for the shipment number to show the qty that was shipped is Complete It sounds as if the director thinks these two status messages should be reflecting the same thing, but when I look at them, that's not how I understand it.
2 1533
by  Bev EdwardsJump to last post
10/25/2017 3:13 PM
1 Replies and 1664 Views MX Attribute List maintenance  1664  1 Started by  jrbledsoe Does anyone know the best way to delete or purge attribute lists If you have automatic and manual attribute lists that you are no longer need or use, what's the best way to remove them Thanks for reading my post
1 1664
by  LynnetteJump to last post
10/16/2017 4:36 PM
0 Replies and 313 Views Payroll posting to first open period  313  0 Started by  Lynnette We have an ongoing issue during the first 8 days of the month while we are working on month end. In the 8 days of the month that we do not have the calendar closed for the previous month, If the PR team makes a payroll adjustment for a previous month, the transactions post to the current open month. I always wondered why their wasn't a control on PR like there is on IC and AP. I was just curious on how others are handling these types of situations.
0 313
10/12/2017 4:14 PM
0 Replies and 329 Views Payroll Reconciliation to GL  329  0 Started by  Lynnette Does anyone know what table (on the PR side) the detail of the payroll accrual can be found in I'm trying to write a report for managers that ties the GL for the month back to Payroll. The one piece I'm missing is the system generated detail for the payroll accrual.
0 329
10/12/2017 4:06 PM
1 Replies and 1740 Views GL Maintenance  1740  1 Started by  MChism Hello all! We are restricting roughly a dozen GL accounts to only allow postings from the GL system. Primarily disallowing systems such as AP, PO IC to hit these GL's. We made these changes in GL00.1 - GL00.3 - GL00.4 and then GL03.5. My question is, do any of you have experience with making sure that these GL's are never opened back up Can we add comments or notes as to why we are closing these to only the GL system I fear that in a year or two we will have an invoice or requisition e...
1 1740
by  LynnetteJump to last post
10/12/2017 3:51 PM
0 Replies and 300 Views Allocations to multiple companies/locations  300  0 Started by  Tanya_D I have a client that is new to Lawson allocations. She was left with no documentation on the allocations and is trying to rebuild for the new fiscal year. Her question is, Can an allocation be written say From Company 1 to Companies 2,3, & 4, along with multiple AUs on each company
0 300
10/11/2017 2:08 PM
1 Replies and 1510 Views how to extract different legder into excel  1510  1 Started by  Sdcaqd Hello, everyone! I'm new to Lawson and I have the following questions: 1.How to extract the whole general ledger into excel (not in PDF) 2.I'd like to see sales ledger based on customer name, e.g. all the sales invoices issued to customer A.How to generate that report 3.How to generate AP aging report 4.How to create accounts and sub accounts Thanks a lot !:)
1 1510
by  rhorn01Jump to last post
10/09/2017 12:04 PM
0 Replies and 330 Views AC298 - Activity Amount Column  330  0 Started by  timbomom What is the source of the Activity Amount Column in AC298 Thanks in advance! Patricia
0 330
09/22/2017 6:13 PM
0 Replies and 505 Views Using AP230 to tie to AP GL account  505  0 Started by  Becky W Our auditors wanted us to supply them with an Open Payables Report which tied to the AP GL account. When running the AP230, it did not tie to the GL. One reason I have determined is that invoices for which a messages exists appear on the AP230, but have not been posted to the GL yet. I need help thinking of why invoices would be posted to the GL, but not on the AP230. Any suggestions PS-I know the AP136 is the report that will tell us exactly what ties to the AP GL account but it does no...
0 505
09/20/2017 9:45 AM
1 Replies and 1476 Views AC10 Audit Table?  1476  1 Started by  PD Does anyone know the audit table name for AC10 I would like to think that such a thing exist to be able to capture change(s) that take place. If this is not the right forum for this question, please let me know. Thanks,
1 1476
by  John HenleyJump to last post
09/18/2017 10:25 AM
0 Replies and 407 Views AR zero or negative payment  407  0 Started by  Todd Mitchell We are currently working on a project in which a customer has the ability to pay their invoices via credit card. On some occasions, the amount of credits could be the same or exceed the amount of invoices, resulting in a zero dollar payment or a negative payment. In the Lawson EFT world (AR115), Lawson creates a debit memo to offset the amount of the negative payment and then interjects a zero dollar payment into the payment table. Has anyone had to create a similar situation and if so, how...
0 407
09/11/2017 2:30 PM
0 Replies and 383 Views MA126  383  0 Started by  Patricia Mane Good morning- Who has and is willing to share process related to working the MA126 Error Report We have had several changes in our AP Department and I am working to create simple Work Instructions so they new staff is able to do their jobs efficiently. Any help or guidance would be greatly appreciated. Thanks Trish
0 383
09/01/2017 8:06 AM
10 Replies and 2220 Views PO100-Purchase orders  2220  10 Started by  Chesca For some strange reason, all of the sudden the PO100 auto job is now creating purchase orders intol 1 single PO for different ship to locations/Pyxis locations. We need to have 1 purchase order created for Each Separate Location. So if we have orders from Location 1X & 2X for example - these must each get their own PO number. They can not be combined into 1 Purchase Order. Up to RQ500 the settings/parameters were fine and it created individual source documents.. Once the PO100 ran - it took...
10 2220
by  ChescaJump to last post
08/29/2017 2:50 PM
0 Replies and 310 Views Asset Management (AM) system - Upload Adjustments  310  0 Started by  NorthMemorial We are in the process of using the Addins Upload Wizard for adding assets. Is there a way to use a uploader wizard for adjustments as well Any information would be great. Thank you.
0 310
08/24/2017 11:53 AM
3 Replies and 1477 Views AP10.2 Contact Account Number  1477  3 Started by  pglibra Hello, I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number. What tables do I need and how do I link them in Access Thank you
3 1477
by  JimYJump to last post
08/22/2017 9:34 AM
7 Replies and 2259 Views GL Beginning Balance Not Updated at year end  2259  7 Started by  Peter HELP!!! :) We are on Fiscal Calendar and last month Did a Limited year end Close Option 'L' in GL199 but did not Run the 'N' Next Year beginning balance Option first. Now we are in the New Year but the beginning balances are not updated. Is there any way for me to update the balances for the current period.. I tried running GL199 again with a Last Year period 12 and 'N' option but it would not let me. Many Many Thanks I am desperate.
7 2259
by  Mira GuirguisJump to last post
08/02/2017 3:30 PM
2 Replies and 1692 Views Note To Buyer field in RQ10 vendor drill down  1692  2 Started by  clb393 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
2 1692
by  clb393Jump to last post
07/31/2017 7:46 AM
0 Replies and 417 Views Stale Date/Escheat a small group of checks  417  0 Started by  Bob Canham 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
0 417
07/27/2017 9:03 AM
0 Replies and 341 Views Budget Advisor/Kaufman Hall Reports  341  0 Started by  rhorn01 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...
0 341
07/21/2017 4:08 PM
0 Replies and 359 Views CB10 Upload  359  0 Started by  AnonymousEmployee 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...
0 359
07/17/2017 10:12 AM
1 Replies and 1584 Views AP90.1 portal screen  1584  1 Started by  YEEXCE1 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...
1 1584
by  JimYJump to last post
07/14/2017 5:40 AM
3 Replies and 1719 Views AP Vendor Query Speed  1719  3 Started by  StvG 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!
3 1719
by  StvGJump to last post
07/07/2017 8:34 AM
4 Replies and 1610 Views 1099 Production  1610  4 Started by  Bob Canham 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
4 1610
by  O. JohnsonJump to last post
07/06/2017 11:05 AM
7 Replies and 1898 Views printing 1099's on sunset version 9.0.1  1898  7 Started by  Russell Spreeman 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...
7 1898
by  Eric99Jump to last post
06/20/2017 8:55 AM
2 Replies and 1635 Views Asset Management Mass Addition  1635  2 Started by  Rhonda Cordes 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
2 1635
by  KellyJump to last post
05/31/2017 4:19 PM
2 Replies and 1671 Views Print Manager/GL90  1671  2 Started by  Jason Bobbin 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
2 1671
by  John HenleyJump to last post
05/28/2017 3:43 PM
0 Replies and 776 Views Positive Pay - Bank of America  776  0 Started by  LauraPat 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 ...
0 776
05/23/2017 2:22 PM
0 Replies and 539 Views Select from data list  539  0 Started by  Diane G 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.
0 539
05/17/2017 3:55 PM
0 Replies and 496 Views Smart Recon  496  0 Started by  brooke Good Morning We recently upgraded to Smart Recon SMR_10000516 and Smart Recon is VERY slow. Has anyone else had this issue thanks brooke
0 496
05/16/2017 10:20 AM
0 Replies and 407 Views GL199-final closed periods back to limit-close  407  0 Started by  Chesca 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
0 407
05/16/2017 7:48 AM
1 Replies and 1684 Views AP10 & AP10.5 - update through IPA - Lawson Transaction.  1684  1 Started by  Bonde 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...
1 1684
by  BondeJump to last post
05/15/2017 1:10 PM
5 Replies and 3070 Views EDI and Credit Memos  3070  5 Started by  JonA 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.
5 3070
by  JeremyJump to last post
05/12/2017 9:33 AM
3 Replies and 1686 Views Sub Account vs Activities  1686  3 Started by  Eddee 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
3 1686
by  JeremyJump to last post
05/03/2017 1:22 PM
8 Replies and 7096 Views Activate account for all accounting units  7096  8 Started by  Paul I have a group of pre-existing accounts that are active in some accounting units and inactive in other accounting units.&160; I want to make these accounts active for all accounting units.&160; I have tried using GL 100 (Mass Chart Acct Change Delete) and GL 121 (Mass Account Addition).&160; Does anyone know how to do this
8 7096
by  Mark F. HardyJump to last post
03/31/2017 3:15 PM
0 Replies and 727 Views Error while submitting Jobs in infor lawson  727  0 Started by  roogi 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...
0 727
03/28/2017 3:17 AM
2 Replies and 1750 Views PO135 - AC  1750  2 Started by  rhorn01 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!
2 1750
by  JonAJump to last post
03/16/2017 1:03 PM
2 Replies and 1520 Views Descriptions from CB Upload Template into GL  1520  2 Started by  rhorn01 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
2 1520
by  rhorn01Jump to last post
03/15/2017 3:21 PM
3 Replies and 1815 Views Cerner Millennium - Lawson GL  1815  3 Started by  JasonP Hi, any customers out there that use Cerner Millennium to Lawson GL s3
3 1815
by  Keith AnetsbergerJump to last post
03/03/2017 2:36 PM
4 Replies and 3254 Views Raiser’s Edge Fund Raising Software  3254  4 Started by  Deleted User 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
4 3254
by  SWilkinsJump to last post
03/02/2017 3:48 PM
1 Replies and 1531 Views MSCM Par counting Report-blank  1531  1 Started by  Chesca 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.
1 1531
by  JonAJump to last post
02/09/2017 8:21 AM
3 Replies and 1817 Views add one-time vendor  1817  3 Started by  Russell Spreeman 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.
3 1817
by  MattBJump to last post
02/03/2017 12:55 PM
1 Replies and 1550 Views GLTRANSREL  1550  1 Started by  Chesca Does anybody know if the GLTRANSREL table/layout was changed in Lawson 10
1 1550
by  alexrsJump to last post
02/02/2017 10:24 AM
2 Replies and 1651 Views PO copy to requestor  1651  2 Started by  HurricaneRax Is there a way to automatically send a copy of a PO to the requestor on record Is that something that can be built in This would be in addition to sending out to vendor via EDI, Fax/Email, etc that is already populated on the PO. Thanks.
2 1651
by  JimYJump to last post
01/31/2017 6:13 AM
2 Replies and 1579 Views EDI 10.0.5.8  1579  2 Started by  Chesca We are planning to upgrade from Lawson 9 to Lawson 10 and also upgrade EDI to the latest version. I have the release notes and EDI net change report and so far I only see changes to the POEDI data layout. Could somebody let me know if they encountered issues or if they know of other changes Thanks
2 1579
by  BasiaJump to last post
01/27/2017 12:57 PM
2 Replies and 2386 Views CB Mass Reconciliation upload template  2386  2 Started by  harold_c Hi, I am trying to create a CB reconciliation upload using form CB80 for the mass reconciliation I am currently doing via CB185, but encounters errors after the 1st line is successfully uploaded, and cannot figure out why, error is: This form action valid on open transactions only (_f51r0). Does anybody have a template/process they would like to share How do you do your reconciliation Thanks.
2 2386
by  harold_cJump to last post
01/23/2017 12:30 PM
2 Replies and 2206 Views AP out of balance due to data error.  2206  2 Started by  dorota34 Our AP has been out of balance with GL since 2013. I was able to identify old invoices back from 2013 that are matched , paid and journalized however they are not being picked up by AP reconciliation report. The problem is caused by mismatch between APINVOICE and APDISTRIB table. OBJ_id in AP Invoice table does not equal to api_obj_id in APDISTRIBUTION. All other tables ( match, gl etc) are correct ( they match Ap distribution table). I am assuming user somehow was able to delete invoice hea...
2 2206
by  dorota34Jump to last post
01/20/2017 8:14 AM
0 Replies and 621 Views GL20 Posting account activation  621  0 Started by  Deleted User Does anyone have an add-in upload that they will share to update GL20 posting accounts I thought one of the conversion programs allows you to mass add accounting unit account posting combinations. Is that GL167 Any input will be appreciated.
0 621
01/17/2017 5:32 PM
1 Replies and 1613 Views Intercompany GL165  1613  1 Started by  mcuser Does anyone know how to load a multi-company journal to GL165 that will use Lawson GL25 Intercompany relationships
1 1613
by  DeronJump to last post
01/13/2017 4:48 PM
4 Replies and 2043 Views MSCM Handhelds selection  2043  4 Started by  Chesca We are in the process of replacing MC70 HHs and Lawson provided us with a listing of MSCM compatible/supported versions. There are so many and we have short period of time to purchase and test the devices. Would anybody be willing to share their process on selecting devices or suggest what things to look for when selecting a new device
4 2043
by  JonAJump to last post
01/11/2017 10:22 AM
0 Replies and 412 Views Company Close Out  412  0 Started by  Boyd In a prior year a Company that was set up in Lawson was sold to a third party. When the assets were sold, we removed the assets from the company and as liabilities were resolved we removed the liabilities from the books of this company. As of 12/31 we were left with only intercompany receivables and equity. Now our tax department wants us to zero out the intercompany receivable balance and equity. Although these accounts have balances they don't zero out. How can we remove these balances wi...
0 412
01/09/2017 3:22 PM
2 Replies and 1950 Views Spreadsheet Server  1950  2 Started by  Boyd We are installing Spreadsheet Server and I was looking to see if anyone has any tips or tricks for setting it up. We are looking forward to streamlining our monthly financial statement distribution process.
2 1950
by  BoydJump to last post
12/21/2016 2:09 PM
0 Replies and 716 Views How to Post Gl65 Transactions with Different Journal Headers  716  0 Started by  emowry We are currently using GL65 and GL165 to post transactions from our revenue system into lawson. The transactions are all imported into GL65 with descriptions but when we post the transactions through GL165 the GLTRANS description only says 'upload'. Is there a way to change this so it maintains the description from the original GL65 entry
0 716
12/14/2016 10:12 AM
1 Replies and 1742 Views Who set up customer account?? (AR)  1742  1 Started by  jmihall Hi, where can I find who set up customer account. Or who update it etc.
1 1742
by  John HenleyJump to last post
12/05/2016 9:17 AM
2 Replies and 1789 Views Bank File  1789  2 Started by  Bev Edwards Where does the file reside on the Lawson server after the CB185 creates it and before the CB80 uploads it
2 1789
by  JimYJump to last post
11/15/2016 5:18 AM
2 Replies and 2394 Views GL20-Accounting Unit/Account Code Combinations  2394  2 Started by  Sami117 We have several accounting units that are mapped to various GL Account codes per GL20.2. We have one accounting unit for balance sheet transactions, but we discovered several income statement accounts with exists as 'yes' on the GL20.2 for the balance sheet unit. We don't want individuals accidently coding transactions improperly so we need to turn the exists from 'yes' to 'no.' We have shut off dynamic account generation to prevent the exists from being turned automatically to 'yes' if someo...
2 2394
by  Sami117Jump to last post
10/27/2016 11:19 AM
0 Replies and 585 Views CB260 calculation  585  0 Started by  IrvinB Im writing a report to have the same results as program CB260 using the CBTRANS , does anybody know how the calculation is for the calc fields, (Acctcurrencyissued-amt3, Void-amt-3, Net-effect-amt-3)
0 585
10/20/2016 7:45 AM
14 Replies and 3512 Views Ma540 sample  3512  14 Started by  Peter Griffen Hi everyone Does anyone have a sample ma540 file that would work for a three way match I'm am having some issues with the match and am having a hard time tracing the problem. Thanks
14 3512
by  Brian VeldhouseJump to last post
10/14/2016 10:06 AM
2 Replies and 1818 Views GL165 errors exist  1818  2 Started by  Chesca I just got a call from a user that runs the GL165 in report mode. We are having a problem with an account where the cost center would not be accepted but it was. It shouldn't allow to post to any accounting unit other than X account. GL165 is not a customized program so where is this validated and is there a Lawson screen that maps these to valid cost centers
2 1818
by  ChescaJump to last post
10/13/2016 3:41 PM
0 Replies and 653 Views Matched In Summary - Link to PO Lines  653  0 Started by  Jeremy Here's my issue: We are matching in summary so when we post to GL, there's no way to work our way back from a GL transaction to see which PO Lines were combined to make up that transaction. Has anyone been able to find a link through all the various tables (GLTRANS, MAINVDTL, APDISTRIB, etc...) to be able to create a report
0 653
10/13/2016 2:36 PM
0 Replies and 555 Views how we can differentiate Credit card and non credit card payments in AR..?  555  0 Started by  kencha Hello All , Can any one tell me where we can set up '' pay types we set up for Payments and credit card payments '' ..in AR From ARPAYMENT table any ways to identify whether the payment received is from Credit card or non credit card payments If we need to define any pay codes for Credit card payments where we can define them in AR..
0 555
10/13/2016 10:20 AM
0 Replies and 693 Views Attributes for accounts  693  0 Started by  SM Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
0 693
10/08/2016 10:57 AM
0 Replies and 549 Views Attributes for accounts  549  0 Started by  SM Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
0 549
10/08/2016 10:57 AM
0 Replies and 687 Views MA540 Vendor Agreements  687  0 Started by  chadT When entering Vendor Agreement Invoices manually into Lawson, you can add Line distribution detail on MA43.7 (from Ma43.6) by clicking the 'Enable' button. Is there a way to accomplish this through the MA540 interface adding multiple distributions with the same line number is not supported through MA540 so I was wondering if there was another way to override while also still matching against the PO25 Vendor Agreement through MA540. The use case is that there is a Vendor Agreement setup with...
0 687
10/07/2016 12:55 PM
3 Replies and 1775 Views GL165 entries  1775  3 Started by  Chesca How do I get transactions to show in GL after posting transactions in GL165 Is there a batch program my user would need to run
3 1775
by  harold_cJump to last post
10/06/2016 10:25 AM
3 Replies and 2077 Views 856 Adv Ship notices  2077  3 Started by  Chesca This morning we got the 856 Adv Ship notices file from GHX and were received in with no errors. However, my users told me that 5 Pos, the back-orders weren't cancelled. I am assuming they are supposed to be cancelled by an automated job GHX has these PO's are partially shipped so some items shipped and the others are back orders. What program should have killed/cancelled these orders Any feedback or suggestions would be greatly appreciated, thanks in advance.
3 2077
by  Kat VJump to last post
09/15/2016 9:08 AM
2 Replies and 1974 Views GTIN  1974  2 Started by  Chesca Is anybody already using GTIN If yes, could you please help me determine how these are assigned We are planning to start using GTIN's.
2 1974
by  ChescaJump to last post
09/13/2016 4:06 PM
2 Replies and 1958 Views fill & kill order  1958  2 Started by  Chesca I noticed we send a PO to GHX on 8/23 that is still in waiting on confirmation status. The user says that it should not be because it was cancelled. It is a fill and kill order. Could someone please enlighten me of what this means Every time I ask this user, she tells me she knows nothing about our batch jobs.
2 1958
by  ChescaJump to last post
09/12/2016 9:25 AM
4 Replies and 2621 Views How do I create a payment for an invoice without a vendor ID  2621  4 Started by  Celia Morris Obviously we don't want to set up all patients as vendors but that scenario potentially exists. How do others handle this
4 2621
by  Sharri TJump to last post
09/01/2016 6:35 AM
2 Replies and 1825 Views Kill/cancel EDI orders  1825  2 Started by  Chesca We don't have a SME for shipping/receiving so it's hard to understand what jobs need to be changed. I got a call from a user that wants to change a job scheduled in recdef that automatically cancel/kill EDI bulk orders. I asked the user what job they are referring to and she has no idea. Any idea what to look for
2 1825
by  JonAJump to last post
08/31/2016 8:19 AM
0 Replies and 531 Views Move RW reports from One PL to another  531  0 Started by  xxxxxttysfh I was able to to upload all the required Files ,but I still do not see reports on RW100
0 531
08/24/2016 1:09 PM
3 Replies and 4577 Views Bank Rec Interface  4577  3 Started by  mcl A Lawson newbie, so be easy, please.&160; Thought easiest interface to tackle would be flat file .txt from bank to Lawson Bank Rec.&160; On LSF9 so I see two options--CB185 flat file&160; and&160; CBSTMTREC database file.&160; Any suggestions&160;&160;&160; With importdb, do I list all fields in header record, comma separated, or just the fields I want to upload&160; Would Add-Ins be a better upload option&160; Thanks
3 4577
by  SYEDJump to last post
08/22/2016 3:22 PM
1 Replies and 2087 Views Data Export from Lawson 9.0.1  2087  1 Started by  Lawson Beginner We are trying to migrate to a new financial system and hence need to export master and transactional data from Lawson. Can any one help understand the best way to approach this
1 2087
by  Lawson BeginnerJump to last post
08/16/2016 1:22 PM
1 Replies and 1706 Views AP155-check payments file overwritten  1706  1 Started by  Chesca My user accidentally rerun AP155 so it overlaid the check file, is there a way she can get recreate the same file
1 1706
by  Jimmy ChiuJump to last post
08/03/2016 4:08 PM
3 Replies and 2421 Views Add-Ins Upload to AP20.1 & Need Comments  2421  3 Started by  Kris We are mass uploading invoices to AP20.1 and would like to include Check Comments in the upload to get printed on the Cheques. Has anyone been successful in doing this Found this post, but don't know if anyone has been successful. https://www.lawsonguru.com/forums/financial/s3-financials/ap20-comments/ Any help would be greatly appreciated! Thanks Kris
3 2421
by  KrisJump to last post
07/21/2016 1:30 PM
0 Replies and 486 Views Multiple EFT email recipients  486  0 Started by  Todd Mitchell We are often asked to add more than one e-mail address to receive the EFT payment notifications. I know in the past Lawson has said no. We are getting increased requests and customers are frustrated at the lack of technology and ease of use for the notifications. Has anyone dealt with this situation and/or know of any possible solutions
0 486
07/14/2016 7:10 AM
4 Replies and 1887 Views GL165 entries  1887  4 Started by  Chesca Does anybody knows if there is a Lawson program that can allow me to delete entries from GL165 to prevent double posting the entries There are about 150 transactions in GLTRANSREL.
4 1887
by  ChescaJump to last post
07/12/2016 10:30 AM
0 Replies and 495 Views GL16.2 adding attributes  495  0 Started by  L G Might be a noob question. How does one add attributes in GL16.2. I mean how to setup attributes and how to navigate to GL16.2 to add them to individual accounts
0 495
07/05/2016 9:29 AM
0 Replies and 830 Views Partial Period Depreciation  830  0 Started by  Ron Swanson Client has iSeries 8.1 Lawson. With a transfer in investors a new company was created. The new company start date is mid period. They want to post Asset Depreciation for the partial period in the old company, and remaining in the new company and keep the Asset files and G/L in sync. Presently the Asset Period Calendar matches the Fiscal Calendar though they do not have to be. Tried changing the Asset Calendar would not let me with assets in place. Any ideas on how to handle this, sho...
0 830
06/16/2016 3:58 PM
5 Replies and 3098 Views Credit Card Processes  3098  5 Started by  toria1248 Hello, I was wondering if anyone had any suggestions on how to import credit card transactions We currently upload every credit card by month separately as a Journal Entry. And the more we grow, the more users receive credit cards and it came up in discussion - how do other companies handle their credit card purchases From what I've seen there's a P-card module We currently don't utilize it. How useful is the module Or does anyone use an external software to track their detail and up...
5 3098
by  facendaaJump to last post
06/01/2016 7:34 AM
2 Replies and 1849 Views MHC for check viewing / W2 etc  1849  2 Started by  Ronnie I have been with two companies who used MHC for check printing / viewing / w2 etc. Are there any other vendors who work with lawson who also offer the same I have been asked to investigate alternatives, but I have honestly not heard of any others.
2 1849
by  KellyJump to last post
05/31/2016 3:07 PM
2 Replies and 1685 Views Who owns the MA60 screen?  1685  2 Started by  Capital-Key Currently in our Lawson security, AP owns the MA60 screen, but doesn't like to use it. They believe that all invoices should match in AP20 perfectly. However, when they don't, they will not go to MA60 to release the payment unless they are instructed by Supply Chain. Otherwise it sits on our exceptions database in SharePoint. So I asked them why should AP own it if Supply Chain has to tell them when to use it I'm just curious .... Who owns the MA60 screen at your place of business
2 1685
by  JimYJump to last post
05/25/2016 11:30 AM
0 Replies and 702 Views Intercompany Payment Transfer  702  0 Started by  Magus ' How to transfer UNASSGINED cash sitting in one company to a customer belongs to differnt company' Can any one please help me on this in detail.. I tried to link companies using GL25 and created a National Account relation using AR12.1 . But while doing Payment transfer using AR29.1 am getting an error like ' TO COMPANY DOES NOT EXIST' Please help me on this.. Thanks
0 702
05/20/2016 1:35 AM
4 Replies and 1956 Views Vendor Payments  1956  4 Started by  brupp Hello - Let's say you have a multiple line PO, & when the invoice is applied, at least 1 line creates a PO cost message. Do you hold payment until the invoice can be paid in its entirety or do you pay on the matched lines per normal terms, then pay the discrepant line(s) at a later time once the cost message is resolved And is either direction dictated by a setting in Lawson Thanks.
4 1956
by  bruppJump to last post
05/17/2016 10:29 AM
3 Replies and 1794 Views PO Summary  1794  3 Started by  jaherb What is the easiest way to enter the PO and see the overall payments and overall remaining balance (money left on the PO) User is currently using PO64, but thinks there must be a better way Thank you Jim
3 1794
by  jaherbJump to last post
04/28/2016 5:02 PM
2 Replies and 2006 Views How to Kill a Job  2006  2 Started by  pops We are running Lawson 10 and have users who submit jobs & reports. Sometimes a user submits a job/report that runs for over a 1/2 hour. Is there a way in Lawson 10 to kill this job maybe through Print Manager or does it have to be done on the back end (maybe through LID) and what would be the command to do this. Thank you in advance! Allen
2 2006
by  pbelskyJump to last post
04/27/2016 11:59 AM
0 Replies and 659 Views Month end processes in AR..?  659  0 Started by  Magus What are the steps we follow in month end for AR.. i.e End of the month (EOM) processes we do in Accounts receivables to begin a new month as well as to close out previous open months. Please suggest me some of the , • guidelines to create new accounting periods, as well as closing out older accounting periods. • and for proper allocation of payments, and adjustments to the appropriate accounting period. What are the jobs names and steps we need to follow..Please enlighten me on thi...
0 659
04/22/2016 9:36 AM
4 Replies and 1400 Views SQL QUERY NODE outputData  1400  4 Started by  Magus Hello All, Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank.. Please anyone guide me to fetch the results of that query and send them to a directory..
4 1400
by  MagusJump to last post
04/22/2016 3:31 AM
1 Replies and 1520 Views AP175 GLTRANS R_DATE  1520  1 Started by  Randy I'm looking at APDISTRIB records and their linked (GLT_OBJ_ID) GLTRANS records. The GLTRANS records have AP / AP175, as the interface. What populates the R_DATE of the GLTRANS I was trying to determine if any distributions hit a prior month after statements were issued. Also most transactions are 'summarized' so I'm getting more detail at the AP level. However I see future (Years away) R_DATE in the GLTRANS record. I'll see GL POSTING_DATE of 2/29/2016 which I expect. But R_DATE anywhere from ...
1 1520
by  TracyOJump to last post
04/21/2016 3:20 PM
8 Replies and 2234 Views Essbase 11  2234  8 Started by  brooke We are on 9.0.1.10 and upgrading essbase to 11 - has anyone able to get the lawson api to work with 11 for the IA120 to still work
8 2234
by  brookeJump to last post
04/12/2016 3:22 PM
10 Replies and 5289 Views Lawson Certification of Essbase  5289  10 Started by  Vicki We are finally upgrading Essbase from Version 7 to Version 11 and have been told by Oracle that Lawson has only certified to Essbase version 9.3. We are using Lawson Analytic Architecture to feed our cubes and it is working well for us. Has anyone else using Analytic Architecture upgraded to Essbase Version 11 and if so, are you having any issues Have you ignored the lack of certification
10 5289
by  brookeJump to last post
04/12/2016 3:21 PM
4 Replies and 1718 Views Vendor Status PO Add Inactive  1718  4 Started by  ckmiller Our vendor master controller has inactivated a vendor due to a merger and now invoices coming in electronically are rejecting. I've seen other vendors with a status of PO Add Inactive, which I understand does not allow for new POs and that's all the definition I can find on it. Will this status allow invoices for POs already created to pass through electronically
4 1718
by  JonAJump to last post
03/30/2016 12:44 PM
1 Replies and 1292 Views Asset Management using Attributes  1292  1 Started by  Sami117 We have to complete several asset surveys each year. The surveys require us to group certain pieces of equipment in categories with ACES codes. These 3 digit codes are used to report out equipment like computers (code 311), Office equipment (312), medical equipment (317). In our old Sage Fixed Assets software we created a category that was required for each asset to be either NA (for building, land, leasehold improvements) or one of the 3 digit codes for moveable, fixed, and software. This w...
1 1292
by  Display NameJump to last post
03/25/2016 8:22 AM
1 Replies and 1100 Views AP Report  1100  1 Started by  Brad Wade Is there an AP report that shows the expense distribution of invoices on a check run This would be similar to the AP150, but with the expense distributions for the invoices as well. We are trying to find the easiest way to track where the expenses posted for each check run in a single report or job. Thanks.
1 1100
by  Display NameJump to last post
03/23/2016 9:53 AM
0 Replies and 731 Views CB50 Upload  731  0 Started by  harold_c Hi. I am trying to do CB50 upload for a transaction like this one below: dept A Sales Tax-Feb 500 dept B Sales Tax-Feb 200 Company 1 Sales Tax-Feb 700 When viewing in GL90, what field or fields should I use so that it would show in dept A account description as 'Dept A sales tax Feb', in dept b account description as 'dept b sales tax Feb', and on the corresponding cash account as 'Company 1 Sales Tax Feb' Thanks.
0 731
03/18/2016 11:56 AM
0 Replies and 758 Views Lawson Flat rate tax on certain income codes  758  0 Started by  dkester How do I set up a flat withholding rate for a specific income code If an employee chooses a flat percentage rate on their W-4, how does that impact the calculation on income codes wtih a fixed rate
0 758
03/10/2016 5:12 PM
4 Replies and 1190 Views Vendor's payments  1190  4 Started by  Chesca Could anybody help me out with writing an SQL statement to get total check amount for each vendor in a given period Here is my select statement but I still need to include vendor name, tax ID and address: select company,vendor, sum(check_chk_amt) from lawson.appayment where check_date BETWEEN to_date('1/1/15','MM/DD/YY') and to_date('12/31/15','MM/DD/YY') Group by company,vendor HAVING SUM(bank_chk_amt) >= 600.00 order by company,vendor;
4 1190
by  ChescaJump to last post
03/04/2016 8:07 AM
6 Replies and 1317 Views L_HACV and L_DACV environment tables  1317  6 Started by  Tom_gbmc We have a request from a user to modify one of our crystal reports, reporting on activities, to include the comments from AC10. Infor told me that this information is stored in L_HACV and L_DACV and that these are environment tables and not accessed in the same way as a 'typical' database table. Has anyone had any experience using these tables and is there a reasonable way to be able to access them as well as the other AC tables in one report Thanks
6 1317
by  John HenleyJump to last post
02/29/2016 9:45 AM
0 Replies and 697 Views linking external scheduler to infor lawson  697  0 Started by  UDAYKVM9 Hello All..I am new to INFOR Lawson.I have a requirement to link Infor Lawson scheduler with an external Quartz scheduler. Can any one let me know how to do this Please any one enlighten me of this process..Thanks much ! :)
0 697
02/24/2016 7:42 AM
0 Replies and 590 Views BL123 posting to multiple compaies  590  0 Started by  Brian Espe We are creating invoices via the BL520 interface program. Based on a custom table we need to distribute to multiple GL Companies. We are thinking of modifying the BL123 to accomplish this. Has anybody done this, or do you have another suggestion.
0 590
02/22/2016 3:52 PM
5 Replies and 948 Views Multi-threading batch AR cash applications  948  5 Started by  Todd Mitchell I am inquiring to see what solutions anyone has come up with for multi-threading batch AR Cash applications. We have been using AR575 (ARIPMT) for years and this has served us well. However, the larger we grow we are finding that the limitation to AR575 only allowing 1 user or 'process' at a time was becoming troublesome. We then went to using AR580 as well. In order for this to work I had to customize AR575 and AR580 because they were not addressing the Batch Nbr 'locking' correctly. This ...
5 948
by  John HenleyJump to last post
02/16/2016 4:01 PM
0 Replies and 1001 Views Grant reporting?  1001  0 Started by  JoeH …… Over the past year we have learned a lot of grant accounting and the audits that come with grant accounting. One thing we discovered that we are not doing is we are not accumulating all expenses and revenues associated with a grant in one dept. We have started doing this but have found it to be very difficult since sometimes the expenses fall into different service lines. We thought about using the activity module to achieve this requirement by assigning an activity number to each grant. ...
0 1001
02/16/2016 10:54 AM
2 Replies and 953 Views AP52 Process Level Incorrect from HR Payroll Garnishment  953  2 Started by  Gary Ronsman Employee Garnishments are setup in PR26 within HR/Payroll. When PR198 General Ledger Closing is performed invoices are created in AP52 for these garnishments. The problem is the Process Level in AP52 is always the default process level from AP00.4. I read the AP User Guide and can not find a way to set the process level based on the employee's HR11 screen. PR26 does not have a process level so I'm hoping to pull it from HR11. The same issue exits for deductions, like union dues, that do n...
2 953
by  Gary RonsmanJump to last post
02/11/2016 4:47 PM
2 Replies and 1219 Views Ap90.5  1219  2 Started by  SkippyScott Is there a Lawson report similar to the AP90.5, where I could generate an export for an end user
2 1219
by  SkippyScottJump to last post
02/11/2016 7:39 AM
1 Replies and 1194 Views AP10 Pay Terms vs Contract Pay Terms  1194  1 Started by  ckmiller Hello, Our Purchasing Director is asking about the hierarchy of the pay terms. For example: Vendor A has pay terms of 30 days on their profile on AP10, but we have a contract with them and some items on that contract have a pay term of 15 days. If a mix of items with pay terms of 15 days and other items that are not on contract are put onto a PO and an invoice comes in for all the items, what pay terms are used for calculating when the payment is made Is there a hierarchy somewhere in Laws...
1 1194
by  JonAJump to last post
02/10/2016 12:10 PM
0 Replies and 555 Views Vendor Diversity  555  0 Started by  Boyd I am looking for a report that includes vendor diversity code and coding (a/u and accounting) for transactions in a given year. I can't seem to find a report that would provide this information.
0 555
02/08/2016 5:37 PM
3 Replies and 1784 Views AP150  1784  3 Started by  Deleted User Hi , I 'm looking for query to pull out data from AP150 Report. I want to create Custom report for AP150 to include Invoice Date. Thanks
3 1784
by  Mark F. HardyJump to last post
02/08/2016 11:22 AM
0 Replies and 652 Views GL Distributions  652  0 Started by  Margie Gyurisin We have many, many PR23 records for every pay code and deduction code for each employee who needs to be distributed. I am wondering if there is a similar form in GL where they could say all transactions going to Dist co = 10 acctg unit 762 - distribute 10 to 10 762, 80 to 30 762 and 5 to 20 762 and 5 to 40 700 It would need to distribute both the hours and dollars that are being sent over from payroll. I appreciate any direction you can point me.
0 652
01/27/2016 12:37 PM
1 Replies and 1152 Views MHC Electronic Invoicing - OCR Performance  1152  1 Started by  Bob Canham We are working on implementing MHC's Image Express system to automate our AP processes. This uses an OCR product to start the process out. One hang-up we are having is with the performance of the OCR process. There is a database view that is used to live-validate the purchase order number during the verification step. This seems to take a very long time for us because it is checking for some of the line contents as well. Has anyone done this implementation and run into something similar
1 1152
by  Jamie KJump to last post
01/25/2016 3:56 PM
4 Replies and 1859 Views Lawson Screen CSV Export  1859  4 Started by  Chesca Our users do not have access to LID but they have an option on the GL90 screen to create a csv export that goes to /print/user/. I am able to see the csv because I do have LID access, I can probably ftp the file but is there another way the user can access this directory
4 1859
by  ChescaJump to last post
01/25/2016 2:50 PM
2 Replies and 1531 Views 1099 electronic file IRS interface  1531  2 Started by  Chesca My user wants to run AP146 to produce the 1099 electronic file and send to the IRS to insure that the files meet their standards. Does anybody run AP146 and send the file to IRS Do you FTP the file or upload it manually Is there a specific development department we should contact for testing the file I googled form 4419 and I think I got my answer. http://www.irs.gov/pub/irs-pdf/p1220.pdf Contact the IRS 1-866-455-7438 1-304-263-8700 (International) ...
2 1531
by  ChescaJump to last post
01/25/2016 2:48 PM
1 Replies and 1043 Views AP155 Cannot run, AP150 has not been run for this Process Group  1043  1 Started by  Chesca AP155(Payment Forms Creation) job has an error of Cannot run, AP150 has not been run for this process group and I don't know what would cause this. We ran the report in update mode We voided checks this morning but they were voided before the 150 was run.
1 1043
by  dcaianiJump to last post
01/22/2016 11:34 AM
2 Replies and 1354 Views Add-in for invoice upload?  1354  2 Started by  Donna Simkovic Has anyone had any success with building an add-in for uploading invoices I built a successful add-in for AP20, so I can build the invoice headers, but when it comes to MA43.1, I can't figure out what to do because the user has to click 'special actions - Create Detail'. So, I'm stumped because I don't know how to do that step with an add-in. Thanks in advance.
2 1354
by  dcaianiJump to last post
01/22/2016 11:28 AM
1 Replies and 802 Views AR Payment Interface  802  1 Started by  hybrid Hi, I'm looking for information regarding the Lawson AR570, AR575 & AR580 programs. Would love to hear stories on past lessons learned and what program everyone is using. We are looking at a lockbox interface so thinking AR570. Hybrid
1 802
by  Todd MitchellJump to last post
01/22/2016 7:47 AM
0 Replies and 893 Views AM20.4-Asset Book Does Not Exist  893  0 Started by  Sami117 We just started capitalizing assets from AC to AM. We had an activity project for a land purchase. The project was finished and we were able to process land through AC160 and AM115. It's now sitting in AM with an asset number. When we review the information on AM20.2, AM20.3 and AM20.4 the information appears identical to other 'land' we have recorded. Note that the other land was added as an upload to AM in July when we went live with the system. AM20.5 doesn't show any journal entry to r...
0 893
01/19/2016 1:25 PM
0 Replies and 727 Views Enter L_HWSC table  727  0 Started by  Tedd Nugent After running a verify found that I am missing L_HWSC table. What utility allows me to setup this table.
0 727
01/19/2016 10:41 AM
7 Replies and 1556 Views Tables referred by AP230  1556  7 Started by  Deleted User I'm trying to modify AP230 report. What all tables can I use
7 1556
by  pbelskyJump to last post
01/15/2016 12:14 PM
3 Replies and 1127 Views joining these 2 tables  1127  3 Started by  wally I am trying to join two tables, APINVOICE and APDISTRIB. Can you please help me understand the following below which is posted on https://www.lawsonguru.com/gurucontent/datadict/801/tables/APINVOICE.html Scroll down to the 'one to many relationships' then to the APDISTRIB part. Is that saying I need to join API-OBJ-ID to both APD-API-OBJ-ID and APD-DIST-SEQ-NBR or is it saying I have a choice between the two
3 1127
by  John HenleyJump to last post
01/13/2016 7:26 AM
0 Replies and 939 Views Date payment applied - AR  939  0 Started by  AnnePep Hello, I am working on a report that I want to show the date an invoice was paid or 'applied'. Is there any system time stamp anywhere in Lawson with this information The only dates I see are deposit_date and gl_date on the ARAPPLIED record. These are driven by user input I believe. We wanted to create a metric using the date an invoice was acutally marked 'Paid' in the system (order to cash KPI) Has anyone created this What tables are you using Thank you for any help in advance! Anne
0 939
12/15/2015 6:48 AM
3 Replies and 1681 Views AP45.3  1681  3 Started by  Chesca My users manually entered invoices using the AP45.3 screen, how could they verify the the amounts did not hit the GL
3 1681
by  Bob CanhamJump to last post
11/25/2015 2:37 PM
0 Replies and 849 Views Clearing Line 0 in MA236  849  0 Started by  Donna Simkovic Our AP staff is entering lines on AP20.4 when they find something on an invoice that does not appear or does not match the PO. These lines show up on the MA236 report as Line 0. The buyers then work the MA236 report and have to let AP know when the line has been manually added to the PO, or if that line matches an existing line on the PO. Then the AP staff has to delete that line and re-enter it. This is how I understand the process so far. For example: Vendor item 12345 is ordered on ...
0 849
11/24/2015 2:25 PM
0 Replies and 1094 Views import payments into Lawson  1094  0 Started by  Chesca We have made some payments to vendors via wire transfer that we normally pay out of Lawson with a check. We need to find out how we can get the payment made via wire transfer into Lawson so that we can issue a 1099 for the amount that we normally paid out of Lawson via check and for the amount we paid via wire combined. Basically is there a way to manually put into Lawson the wire payment
0 1094
11/19/2015 2:39 PM
0 Replies and 817 Views Disabled Veteran's business  817  0 Started by  Chesca The Division of Service-Disabled Veterans' Business Development (DSDVBD) have requested us to submit activity quarterly. Is anybody currently reporting this or planning to build a process Did you write custom code or a crystals to report Veteran Business activity The purchase manager wants to use a user field to flag Veteran's business, I am not sure what user field he is referring to as I am not familiar with purchasing tables, any feedback and ideas would be greatly appreciated.
0 817
11/17/2015 9:05 AM
1 Replies and 1043 Views MS-Addins CB50  1043  1 Started by  Tedd Nugent I keep reviewing the required fields and have linked them in my script but I keep getting Field is required and not knowing which field is miissing.
1 1043
by  The.Sam.GrovesJump to last post
11/12/2015 8:44 AM
0 Replies and 815 Views essbase api  815  0 Started by  brooke Does anyone have the essbase api for AIX
0 815
11/02/2015 9:49 AM
0 Replies and 767 Views Layouts/Tables  767  0 Started by  bharathi Hello All, I need to pass the Account Receivables information from INFOR to another Billing Engine.. What are the Table names or Layouts to get the information for BAL-CURR BAL-PAST-DUE LAST-PMT-DT LAST-PMT-AMT TOT-PMT-ON-ACCT -AR-TRAN-POST-DT ADJ-REFRNCE-NBR
0 767
11/02/2015 7:04 AM
0 Replies and 639 Views GP to LAW AP migration  639  0 Started by  Mark F. Hardy We are migrating our Great Plains AP to Lawson AP. Our Great Plains check print process uses MEKORMA MICR to format and print checks. But our Lawson check printing process uses Formspartner. The business is wondering if we can port the Lawson AP155 Check file over to MEKORMA MICR and use the already setup Check Templates in MEKORMA. Anyone encounter or hear of doing this before Thanks!
0 639
10/27/2015 11:46 AM
0 Replies and 785 Views Intercompany transaction descriptions  785  0 Started by  Chris Mackley My company has quite a few intercompany relationships defined within Lawson. Is there any way to provide visibility to the originating transaction description The auditors do not like seeing 'auto offset from...' and our accountants don't enjoy hunting down the original JE's for them... So we're trying to create a report that breaks down the intercompany transactions and pairs them with the original transaction's description. Thanks!
0 785
10/23/2015 7:29 PM
2 Replies and 1056 Views check numbers- CBTRANS FILE  1056  2 Started by  Chesca My GL user is testing a program and comparing the results to production results. The check number/transaction numbers are different in test/live. I am thinking this is a data issue or a missing step. I ran a query against the CBTRANS file and all the details match except for the check number. What would the check be different in each system though
2 1056
by  ChescaJump to last post
10/22/2015 9:40 AM
3 Replies and 1144 Views RQC - GL accounts  1144  3 Started by  Chesca Does anybody know how to customize rqc 10.6 so that the GL accounts displayed are limited to a certain range When you are searching, it should only show a limited range. RQC Shopping Accounting tab Account sub Account
3 1144
by  ChescaJump to last post
10/20/2015 1:24 PM
1 Replies and 1184 Views Merged Vendors  1184  1 Started by  lmckenn We have an issue with AP170 producing incorrect postings to the GL for payments written. We are told by our IT that is has something to do with 'Merged Vendors' and they are asking us to produce a report to show all Merged Vendors - does anyone know which report either from A/P itself or a qwery wizard - Thank you,
1 1184
by  SurvivorJump to last post
10/15/2015 12:55 PM
0 Replies and 1208 Views MA540 - Attempt to access item beyond bounds of memory Error  1208  0 Started by  Rabie K Hi all, I have a scenario where our Job MA540 fails and goes into 'Needs Recovery' when we do the matching on an Invoice that has taxes in MA54 and try to run MA540 it goes to 'Needs Recovery' with the following Generic Cobol message : \n Execution error : file 'D:\lawlsf\apps\lsfprod\obj\MA540.gnt' \n error code: 114, pc=0, call=1, seg=0 114 Attempt to access item beyond bounds of memory (Signal 11) I recompiled the program with trace on, and I see that it fails at th...
0 1208
10/09/2015 1:52 PM
0 Replies and 844 Views How to mark Transactions as as (having been extracted for billing)from INFOR  844  0 Started by  karanbk • What field would be best suited for marking the transactions as (having been extracted for billing)from AROITEMS , ARAPPLIED so that they are not extracted again this month..
0 844
10/03/2015 1:27 PM
1 Replies and 1246 Views Process Flow to take invoices off of hold  1246  1 Started by  AnnePep Anyone have any experience with a process flow to take invoices off of hold Would we automate the AGS call to ap30.1 Can we simply remove the record from APHLDINV Any help is appreciated - thanks!
1 1246
by  Tim CochraneJump to last post
09/25/2015 9:47 AM
5 Replies and 1925 Views IC527 - interface  1925  5 Started by  Chesca We are having such as difficult understanding understanding the IC527 interface program. Our users think the item cost is incorrect for certain items so they want me to customize the program. According to Lawson, The LAST-REC-COST on the ITEMLOC file is updated upon Match and is what the Lawson System will use for Last Cost defaulting for N items. Does “Match” mean match between item receipt and invoice or does Match mean match between PO and PO receipt Essentially, my users want the cost ...
5 1925
by  ChescaJump to last post
09/22/2015 2:05 PM
2 Replies and 944 Views AP155  944  2 Started by  Chesca My users are doing some testing and need to test if they can cut checks out of Document Express. Does AP155 creates an output file and if yes, where is this file located
2 944
by  ChescaJump to last post
09/21/2015 2:39 PM
0 Replies and 704 Views MA00 & MA01 Setup  704  0 Started by  jj2020 Can anyone share their set up of MA00 & MA01 with me I am working with the Reconciliation Message portion to help with Matched Not Received and PO135 issues. I am hoping to see how others are set up in this area. Thanks in advance!
0 704
09/17/2015 6:33 PM
2 Replies and 1265 Views 1099's using the AP146  1265  2 Started by  Chesca My users would like to process our 1099's this year using the AP146 (1099 tape creation) instead of the AP145(1099 forms creation) that we have used in previous years. I am not familiar with this process and what we need to do to prepare to do it this way. Do you know what we would need to process the 1099’s this way Any information that you could give me would be much appreciated. Thank You
2 1265
by  ChescaJump to last post
09/14/2015 8:46 AM
0 Replies and 1276 Views Version 10X db Schema with relations (user text)  1276  0 Started by  ttredwell I was able to pull our table definitions via the following lid cmds: dburf -pw -d D:\LSF\law\prod10\usertext PROD10 (PROD10 is my productline name) This will take a while once complete type in CD D:\LSF\law\prod10\usertext (remember your drive and prod line will be different) next enter the following commands one by one dbdoc -pw PROD10 AC dbdoc -pw PROD10 AD dbdoc -pw PROD10 AM dbdoc -pw PROD10 AP dbdoc -pw PROD10 AR dbdoc -pw PROD10 BL dbdoc -pw P...
0 1276
09/04/2015 12:17 PM
0 Replies and 910 Views RW100  910  0 Started by  Boyd We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report. Lawson support has not been any help.
0 910
09/02/2015 10:16 AM
0 Replies and 684 Views RW100  684  0 Started by  Boyd We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report.
0 684
09/02/2015 10:16 AM
2 Replies and 1100 Views AROITEMS - Open Amount???  1100  2 Started by  apalmer77 Could someone provide some insight on if whether or not the AROITEM_OPEN_AMOUNT derived field can still be used for calculation purposes, even though this field may not be viewable from within a Lawson Production Database I completely understand that no data is stored in this field. What is the purpose of this field being referenced on the LawsonGuru site and there is no way to reference or leverage it for invoice open amount identification purposes. :confused::confused: Any insight ...
2 1100
by  apalmer77Jump to last post
08/19/2015 2:49 PM
0 Replies and 756 Views Vendor Discounts  756  0 Started by  Boyd We are looking for a report that will show us vendor discounts taken and lost during the AP/Cash Disbursement process. Is there a report that will show this information Any help is appreciated.
0 756
08/18/2015 5:39 PM
2 Replies and 1147 Views AP10 asterisk meaning  1147  2 Started by  lars Can someone tell me what generates an asterisk in the 'PO Vendor' and 'Location' fields in AP10.1 Thank you.
2 1147
by  JonAJump to last post
08/10/2015 2:53 PM
3 Replies and 1010 Views MA531CSV file- Receiving Batch Update  1010  3 Started by  Chesca The MA531 is getting a CSV file not found error. I am not sure how the CSV input file is created, but I checked in the directory and the file is not in there so it seems like we are not getting the EDI file in the directory. Any idea how to fix this Error Log: ** Creating .prt and .dtl files Processing MA531 - Receiving Batch Update *** MA531CSV file not found in MA531CSV directory*** *** No Records Found For Company 0010
3 1010
by  JonAJump to last post
08/05/2015 7:27 AM
1 Replies and 1021 Views Different Process Levels on a PO25 Service Agreement  1021  1 Started by  lars Our A/P department receives a paper invoice from the vendor. The invoice is sent to the end-user where accounting information is entered on a label, the label is affixed to the invoice and approved by the manager. A/P receives the invoices, enters coding against a PO25 Service Agreement at the line level. The paper invoices are then forwarded to internal auditors for review online.. The paper invoices are then approved by the audit team, sent back to A/P, then A/P performs the match...
1 1021
by  JonAJump to last post
08/05/2015 7:23 AM
0 Replies and 1272 Views Account category ERROR(suspense) question  1272  0 Started by  IrvinB Ive been having this activities transactions end up with the account category error (suspense) and then hit a particular account, is there any place where an activity group is tied up to where (GL account) to post this ERROR category , Ive notice this varies from activity group to group. second, it supposed that this account category error is made when activity groups are set up to edit option 3(substitute-suspense), but I have em in option 4, but I still get transactions coming from B...
0 1272
07/28/2015 10:30 AM
3 Replies and 1372 Views Contracts and Purchase Orders  1372  3 Started by  Chesca Hello, hope someone can help me. NYS is requesting contracts and POs executed from x date to x date, what Lawson tables can I pull this data from Thanks in advance for your help!
3 1372
by  JonAJump to last post
07/06/2015 1:57 PM
4 Replies and 1470 Views AP vendors report  1470  4 Started by  Chesca I am trying to create a list of vendors including name, tax id, diverse code, phone number, class, and address. I joined the APVENMAST AND APVENADDR but I am getting multiple address per vendor. I think I'd like to get the maximum date or most current vendor's address from the file and I don't know how to. Any help would be greatly appreciated. Example: Vendor 1 MED PO box 1235 1/18/11 Vendor 1 MED PO box 3953 3/26/12
4 1470
by  ChescaJump to last post
07/03/2015 1:45 PM
6 Replies and 4006 Views Upload Assets to AM Module  4006  6 Started by  Melissa McGuire I am curious if we can do a mass upload of Asset information into Lawson, there was suppose to be a template on an invoice but it got matched, now we're left with manually entering all information in AM20.2
6 4006
by  Sal1988Jump to last post
06/30/2015 8:41 AM
4 Replies and 1651 Views IC99.2  1651  4 Started by  Chesca We upgraded the environment this weekend and we are seeing some weird data in IC99.2. We are fine in LID but not portal. I have attached an screenshot.
4 1651
by  ChescaJump to last post
06/23/2015 5:11 PM
4 Replies and 1460 Views APINVOICE  1460  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 1460
by  JonAJump to last post
06/22/2015 3:18 PM
2 Replies and 1348 Views Par Counts  1348  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 1348
by  ChescaJump to last post
06/17/2015 8:39 AM
2 Replies and 14406 Views GLAMOUNTS VS GLTRANS  14406  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 14406
by  AndreaCibaJump to last post
06/12/2015 9:08 AM
0 Replies and 860 Views Match exceptions  860  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 860
06/11/2015 9:52 AM
0 Replies and 841 Views Match exceptions  841  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 841
06/11/2015 9:52 AM
5 Replies and 1577 Views Posted transactions' time stamp  1577  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 1577
by  Lawson BeginnerJump to last post
06/09/2015 8:44 AM
1 Replies and 1106 Views GL Account Reconcilitation  1106  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 1106
by  TracyOJump to last post
06/08/2015 8:58 AM
0 Replies and 741 Views accrued expenses  741  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 741
06/04/2015 8:18 AM
0 Replies and 1041 Views Handling code on invoice  1041  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 1041
06/04/2015 7:57 AM
0 Replies and 996 Views Lawson EDI GTIN setup  996  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 996
06/03/2015 8:31 AM
0 Replies and 1134 Views Smart Reconciliation  1134  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 1134
06/02/2015 1:49 PM
2 Replies and 1298 Views Req- operator ID  1298  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 1298
by  ChescaJump to last post
05/28/2015 2:25 PM
2 Replies and 4724 Views cancel matched invoice that is out of balance  4724  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 4724
by  MaryannJump to last post
05/28/2015 11:42 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 512345 > >>


RSS Feed Available